Method and apparatus for synchronizing multiple databases

A data synchronization and database technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as inability to meet, incapable of database backup, inability to read records, etc., to achieve the effect of improving security

Active Publication Date: 2009-05-20
ZTE CORP
View PDF0 Cites 17 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the current database replication software usually has only one database driver
When the main and standby databases are of the same type, the master client system and the standby control terminal use the same database replication software for the database driver, so that the database driver of the standby control terminal can smoothly read the records sent by the However, when the types of the primary and standby databases are different, the key customer system will preferentially select the database replication software corresponding to the database driver and its own database type, resulting in the database driver of the standby control end being unable to read the records sent by the master control end , and then it cannot be written into the standby database to complete the database backup. In this way, it cannot meet the requirement of mutual backup between the key customer systems with different database types in the key customer system disaster recovery scheme

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and apparatus for synchronizing multiple databases
  • Method and apparatus for synchronizing multiple databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0042] The implementation process of the multi-database synchronization method in the embodiment of the present invention is as follows figure 1 shown, including the following steps:

[0043] Step 101: Obtain the database type on each server in the data synchronization system;

[0044] Here, the servers in the data synchronization system can generate a master control server through setting or competition, and the other servers are used as standby control servers, as the backup of the database of the master control server.

[0045] Specific methods for obtaining the database type include:

[0046] a. Each server in the data synchronization system reads its own database type;

[0047] Wherein, the database type is read from the configuration file of the database itself, or read from database characteristics such as environment variables of the database itself;

[0048] b. Send its own database type to other servers in the data synchronization system through handshake informat...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a multidatabase synchronization method, which comprises: acquiring database types on various servers in a data synchronization system, and loading database drives which correspond to various acquired database types respectively; determining primary databases of the data synchronization system, and generating attached objects of the primary databases including variation tables and variation recording tables; and setting query time slices at intervals, and synchronizing the primary databases and standby databases. The invention also discloses a multidatabase synchronizer, which realizes standby of the databases through a drive set unit, a primary competitive unit, an object generation unit and a data synchronization unit. By adoption of the method and the device, synchronization of different types of the databases can be realized.

Description

technical field [0001] The invention relates to database synchronization technology in the next generation network, in particular to a multi-database synchronization method and device. Background technique [0002] In the next generation network (NGN, Next Generation Network) application, the key customer system is oriented to large telecom users, providing services such as operator console, billing, statistics, and value-added services, and has its own independent database system, namely the main database. In order to realize data disaster recovery requirements, it is necessary to implement database backup in different places, that is, to set up a standby database, and the data between the active database and the standby database must be consistent, otherwise disaster recovery occurs, and some business functions may be lost after the switchover of the active and standby databases . [0003] In the current large customer system disaster recovery solution, in order to reduce...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 张海军周冬平
Owner ZTE CORP
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap