Method and system for synchronizing data base

Abstract

The invention discloses a database synchronization method, in which a synchronous table comprising a synchronous identification numbers and SQL statements is adopted to realize the data synchronization, a database synchronization system is disclosed also, which comprises a primary server having a backup unit, a synchronous table unit and a backup server having a request unit, an acquisition unit and a synchronization unit. The method and system realizes the synchronization of the database and simplifies the modification of the server configuration by use of a synchronous table, thereby the database can be implemented without the restriction of the operation system and the database system which results in an improved efficiency.

Description

technical field [0001] The invention relates to database technology, in particular to a database synchronization method and system. Background technique [0002] In the telecommunications management network, each network unit has an operation and maintenance unit (OMU, Operation & Maintenance Unit), which may specifically be a server installed with OMU software, which is responsible for providing the operation and maintenance function of the network unit. In order to maintain the normal operation of the network unit, telecom operators have very high requirements on the reliability of the operation and maintenance function of the network unit, generally more than 99.999%. Therefore, in order to ensure the reliability of OMU operation and maintenance functions, telecom equipment suppliers generally adopt a dual system (Dual System) backup mechanism for the OMU. The so-called dual-computer system is a system composed of two computers. Among them, the server corresponding to th...

AI Technical Summary

Problems solved by technology

[0016] 1. It must be based on the SQL Server database system. Correspondingly, the system must be installed on the WINDOWS operating system;

[0017] 2. The transaction replication relationship must be configured between the active and standby servers, and the transaction replication relationship needs to be reconfigured if the active and standby servers are switched

Because the transaction replication relationship is very complex, the configuration process of the database system is very complicated

[0018] 3. It takes a long time for the publisher and the subscriber to complete the initial database synchronization

This time is difficult for telecom operators to accept;

[0019] 4. This solution has many restrictions and impacts on the server

[0023] 1. It must be based on the Sql Server database system. Correspondingly, the system must be installed on the WINDOWS operating system;

[0024] 2. The real-time performance of log transmission is poor, and the real-time synchronization cycle is generally configured at 15 minutes, which is not suitable for servers with high real-time requirements;

[0025] 3. The reliability of log transfer is not as good as transactional replication, so it is not suitable for servers with high reliability requirements

Images