Method for synchronizing data of database in active/standby server

A data synchronization, master server technology, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as dirty data and incomplete database data on standby servers, so as to reduce performance impact, improve integrity and improve performance. The effect of reliability

Inactive Publication Date: 2010-05-12
上海世范软件技术有限公司
View PDF0 Cites 42 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

If the data in the synchronization table is not a complete user-oriented transaction, the data in the standby server database will be incomplete or there will be more dirty data

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 for synchronizing data of database in active/standby server
  • Method for synchronizing data of database in active/standby server
  • Method for synchronizing data of database in active/standby server

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] The present invention will be further described below in conjunction with the accompanying drawings and embodiments.

[0026] figure 2 It is a schematic diagram of using application program unit to realize database data synchronization in the present invention.

[0027] See figure 2 , the database synchronous method that the present invention provides, comprises the following steps: on the primary and secondary servers, set up the transaction information collection table by the data collection unit, on the primary server, the data collection unit intercepts scattered business data by monitoring the database write operation, and forms user transaction information Record and back up to the transaction information collection table; on the primary server, the data synchronization replication unit synchronizes the user transaction information collection table to the standby server; on the primary server, the data transfer unit transfers the synchronized user transaction i...

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 method for synchronizing data of a database in an active / standby server, wherein the method comprises the following steps: establishing a transaction information acquisition list by a data acquisition unit in the active / standby server; forming a user transaction information record and backing up the record to the transaction information acquisition list through monitoring the database to write operation and intercept scattered service data by the data acquisition unit in the active server; synchronizing the user transaction information acquisition list with the standby service by a data synchronous replication unit in the active server; and transferring the synchronized user transaction information acquisition list by a data transferring unit in the active server. The method for synchronizing the data of the database provided by the invention utilizes the data acquisition unit, the data synchronous replication unit and the data transferring unit in an application layer to separate data acquisition and synchronization operations, reduces the performance influence on a database server and uses an newly added user transaction information record as a minimal synchronization unit to improve the integrality and reliability of the data synchronization.

Description

technical field [0001] The invention relates to a database data synchronization method, in particular to a method for realizing database data synchronization on primary and secondary servers by using an application program. Background technique [0002] With the continuous development of computer information technology, people rely more and more on information systems, and people have higher and higher requirements for database stability and security. Many enterprises, such as banks, securities, insurance and other database servers, use active and standby dual servers to ensure the security of data storage. When the primary database server fails, switch the backup server to the primary server in time to ensure the security of the information system database and the stable operation of the system, and greatly shorten the service interruption time caused by the database. At the same time, the active and standby dual server mode can safely back up user system business data to ...

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 上海世范软件技术有限公司
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