WO2012145963A1

WO2012145963A1 - Data management system and method

Info

Publication number: WO2012145963A1
Application number: PCT/CN2011/076322
Authority: WO
Inventors: 龚力
Original assignee: 中兴通讯股份有限公司
Priority date: 2011-04-28
Filing date: 2011-06-24
Publication date: 2012-11-01
Also published as: CN102761528A

Abstract

The present invention relates to a data management system and method. The system includes a main server and a standby server, the main server including a main database available for an internal user to perform data reading/writing operation, the standby server including a standby database only available for an external user to perform data read-only operation, and there is at least one switchable environment equivalent to the main database in the standby database for switching. The present invention can share the system burden, implement the high availability, and can also improve the economy of the system.

Description

Data management system and method

The present invention relates to the field of communications, and in particular, to a data management system and method. Background technique

In communication systems, it is often necessary to store and manage a large amount of user data. Especially in a large-capacity communication system, since the total amount of user data is very large, and there are many functions that need to be implemented, some even need to provide a user interface, which requires high security and robustness of the system. At the same time, different applications have different requirements on data. For example, traffic applications require the database to respond quickly to data, and the real-time requirements of the system are high, while the query statistics application requires high-level query and statistical efficiency of the database. Data applications are required to have both on-line transaction processing systems and online analytical processing systems.

In the existing data management system, in order to ensure the online time of the system and improve the user experience, a dual server is often used to achieve high availability, wherein one standby server is in a standby state, and when the primary server is down, the standby server will Take over the business.

This kind of technology can improve the high availability of data system services to a certain extent, but in this method, external users and internal users operate on the main server, which does not realize physical read and write separation of data, which reduces system security. Sex, and the standby server spends a lot of time in standby, not putting it into use, and wasting system resources. Summary of the invention

It is a primary object of the present invention to provide a data management system and method for reducing resource waste.

In order to achieve the above object, the present invention provides a data management system, the system comprising: Server and standby server;

The primary server includes a primary database for internal users to read and write data; the standby server includes a standby database for external data read-only operations, and at least one of the standby databases is equivalent to the primary database. Switch the environment for switching.

Preferably, the primary server is provided with a synchronization module for transmitting redo logs to the standby server for synchronizing data between the standby database and the primary database.

Preferably, both the primary server and the standby server use Real Application Cluster (RAC) technology, and each RAC node shares a cache. When one of the nodes is down, the other node takes over the load.

Preferably, the system further includes a plurality of sub-standby servers, the sub-standby servers including sub-standby databases, and only for read-only services of external users.

Preferably, the primary server and the secondary server are divided into different network segments, separated by a firewall.

Preferably, the primary server is provided with a user identification module for verifying identity information of the user. Preferably, the primary server and the standby server are respectively disposed at different locations, and the two are separated by a safe distance.

The invention also proposes a data management method, the method comprising the following steps:

Configuring a primary database for internal users to read and write data to the primary server; configuring a standby database for the standby server to perform read-only operations only for external users, and at least one of the standby databases is equivalent to the primary database. Switch the environment for switching.

Preferably, after performing all the steps, the primary server transmits the redo log to the standby server for synchronizing the data between the standby database and the primary database.

Preferably, both the primary server and the standby server use the real application cluster RAC technology, and each RAC node shares a cache. When one node is down, the other nodes take over the load. The data management system and method proposed by the present invention, through the design of the database architecture, the main number The database provides read and write permissions for internal users. Multiple standby databases only provide read-only access to external users to achieve read-write separation of data, improve security, and multiple standby servers share system load and achieve high availability. , the effective use of system resources, because of the lower cost of read-only database construction, but also improve the economics of the system.

DRAWINGS

1 is a schematic structural diagram of a data management system according to an embodiment of the present invention;

2 is a schematic flow chart of a data management method according to an embodiment of the present invention. In order to make the technical solutions of the present invention clearer and clearer, the following will be further described in detail with reference to the accompanying drawings.

detailed description

It is understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.

1 is a schematic structural diagram of a data management system according to an embodiment of the present invention. As shown in FIG. 1, the system includes a primary server 1 and a standby server 2, wherein the primary server 1 runs a primary database 11, and the standby server 2 runs a set of standby databases 21, and the standby database 21 has a primary database 11 In a peer-to-peer switchable environment, when the primary database 11 fails, the service can be switched to the standby server 2 to ensure the security of the system. The main server 1 and the standby server 2 can be located in different places far apart from each other, and separated by a safe distance, respectively, two or more sets of IT systems with the same function can be established, and health status monitoring and function switching can be performed between each other. When the system stops working unexpectedly, the entire database system can be switched to another location, so that the system function can continue to work normally to achieve disaster tolerance. The primary server 1 and the secondary server 2 may be composed of a plurality of sub-server clusters, and the databases in each server adopt real application cluster (RAC) technology to achieve high availability.

Further, each node in the RAC shares a cache. When one of the nodes is down, several other nodes take over the load, providing parallel processing capability and load sharing of the server runtime, and performing fault tolerance when one of the nodes fails. Recovery processing, can achieve node failover, to ensure that the database 7 * 24 hours of operation.

In the embodiment of the present invention, the standby database 21 provides a read-only interface to the external user, so that the external user can be in standby, because the backup server 2 is in a standby state and is not in use, and the system resources are wasted. Server 2 queries and implements various capabilities such as data mining and statistics. At the same time, since only the read-only interface is provided to the external user, the access area is limited to the standby server 2, which does not affect the operation of the main server 1, and reduces the possibility of the user accessing the main server 1 tampering with the data, thereby improving the security of the system.

Since the main database 11 provides the read/write interface of the internal user, the user can have read and write permissions to the main server 1 for data update and maintenance. In an embodiment, in order to ensure data security, the main server 1 is provided. A user identification module, configured to verify the identity information of the user. For example, the identification module can provide a login window and a login account to verify whether the user is an internal user. In addition, the primary server 1 can be divided into internal network segments to provide read and write permissions for internal users, and the secondary server 2 can be divided into external network segments. Only external users can read-only permissions, and internal network segments and external network segments can be used as firewalls. Separated to achieve read-write separation, since the external user does not directly operate the main server 1, but accesses through the standby server 2, thereby improving the security of the system.

The main server 1 is provided with a synchronization module for transmitting redo logs to the standby server 2 for synchronizing data between the standby database 21 and the main database 11. The database in the primary server 1 and the secondary server 2 supports the application of redo logs in a read-only state, so that the standby database 21 and the primary data can be implemented. The synchronization of the library 11 allows external users to indirectly access the data of the primary database 11 by accessing the standby database 21.

In this embodiment, the system further includes a plurality of sub-backup servers 3 that are not equal to the main server 1. In the sub-backup server 3, there are a plurality of sub-standby databases 31 that are not equal to the main server 1 in the standby environment. The standby database 31 is synchronized with the primary database 11 data on the primary server 1, but only provides read-only services to external users, and no handover is provided. As shown in FIG. 1, the distributed sub-backup servers 31 provide only read-only permissions to external users without function switching with the primary server 1. Therefore, the sub-standby server 3 can be lower in configuration and performance requirements than the primary server 1. Moreover, read-only database construction costs are lower, thus reducing the cost of the entire system. As shown in FIG. 2, it is a flowchart of a data management method according to an embodiment of the present invention, and the method includes the following steps:

Step S1: Configure a primary database for internal users to perform data read and write operations on the primary server; for example, an identity module may be set by a software program to distinguish different users. Specifically, the login window and the login account can be set. When the user logs in successfully, the user is identified as an internal user, and the data in the primary database can be maintained or modified to improve data security.

Step S2: Configure an alternate database for the standby server to perform data read-only operations only for the external server, and the standby database has at least one switchable environment that is equivalent to the primary database for switching.

In this step, for the standby server, a read-only interface can be configured or the standby server can be set to read-only through a software program, and maintenance or modification cannot be performed.

In addition, the primary server can be divided into internal network segments to provide read and write permissions for internal users. The standby server is divided into external network segments, and only external users are allowed read-only permissions. The internal network segment is separated from the external network segment by a firewall. In order to achieve read-write separation, the external user does not directly operate on the primary server, but accesses through the standby server, thereby improving the security of the system.

To further secure data, you can also set the primary and standby servers to be in Two or more sets of IT systems with the same function are separated from each other in different places separated by a long distance. Health status monitoring and function switching can be performed between each other. When a system stops working due to an accident, the whole The database system can be switched to another location so that the system functions can continue to work properly to achieve disaster tolerance.

The above-mentioned primary server and standby server can also be composed of several sub-server clusters, and the database in each server uses RAC (Real Application Clusters) technology for high availability. It is also possible to further set a shared cache between each node in the RAC. When one of the nodes is down, several other nodes take over the load, provide parallel processing capability and load sharing of the server runtime, and perform fault tolerance when one of the nodes fails. And recovery processing, can achieve node failover, to ensure that the database 7 * 24 hours of operation.

The standby server provides a large amount of time in the standby state, is not put into use, and wastes system resources. In order to make full use of the resources of the standby server, the embodiment of the present invention provides a read-only standby database to the external user read-only interface, so that the external user can The standby server queries and implements various capabilities such as data mining and statistics. At the same time, the external user only provides a read-only interface, and the accessed area is limited to the standby server, without affecting the operation of the primary server.

The embodiment further includes transmitting the redo log to the standby server by setting the synchronization module on the primary server to synchronize the data between the standby database and the primary database. The database in the primary server and the standby server supports the application of redo logs in the read-only state, so that the synchronization between the standby database and the primary database can be realized, so that external users can indirectly access the data of the primary database by accessing the standby database.

The method for data management in this embodiment further includes configuring a plurality of sub-backup servers that are not equal to the primary server, and the server synchronizes with the sub-standby server data. In the sub-standby server, the standby environment has multiple sub-standby databases that are not equal to the primary server. They only provide read-only services to external users, and do not provide switching. As shown in Figure 1, the distributed sub-backup servers 3 only provide read-only access to external users without function switching with the primary server 1, therefore, Alternate service The configuration and performance requirements of the device 3 can be lower than that of the primary server 1, and the read-only database construction cost is lower, thereby reducing the cost of the entire system.

In summary, the present invention provides a data management system and method, which implements functions such as cluster computing, active/standby switchover, disaster tolerance, read and write separation, etc., and fully utilizes spare resources to ensure high availability of the system 7*24 hours. Capabilities, while providing the system's high economy and high security.

The above is only a preferred embodiment of the present invention, and is not intended to limit the scope of the present invention, and equivalent structural or process changes made by the present specification and drawings may be directly or indirectly applied to other related technical fields. The same is included in the scope of patent protection of the present invention.

Claims

Claim

A data management system, the system comprising: a primary server and a standby server; wherein

a primary server, including a primary database for internal users to perform data read and write operations; an alternate server including a standby database for external data read-only operations, wherein at least one of the standby databases is peered with the primary database Switchable environment.

2. The data management system according to claim 1, wherein the primary server is provided with a synchronization module for transmitting redo logs to the standby server for synchronizing data between the standby database and the primary database.

3. The data management system according to claim 1 or 2, wherein the primary server and the standby server both use a real application cluster (RAC) technology, and each of the RAC nodes shares a cache, and one of the nodes 宕Machine, taking over the load by other nodes.

4. The data management system according to claim 3, wherein the system further comprises a plurality of sub-backup servers, the sub-standby servers comprising sub-standby databases, and only for read-only services of external users.

The data management system according to claim 4, wherein the primary server and the standby server are divided into different network segments and are separated by a firewall.

The data management system according to claim 5, wherein the main server is provided with a user identification module for verifying identity information of the user.

7. The data management system according to claim 6, wherein the primary server and the standby server are respectively disposed at different locations, and the two are separated by a safe distance.

8. A data management method, characterized in that the method comprises the steps of: configuring a primary database for an internal user to perform data read and write operations on the primary server; and configuring the standby server for an external user only for data read-only operations. a database, wherein at least one switchable environment that is peered with the primary database exists in the standby database.

9. The data management method according to claim 8, wherein after performing all the steps, the method further comprises: the primary server transmitting the redo log to the standby server, and synchronizing the data with the standby database and the primary database.

10. The data management method according to claim 8, wherein the primary server and the standby server both use a real application cluster RAC technology, and each of the RAC nodes shares a cache, and when one of the nodes is down, the other The node takes over the load.