Unlock instant, AI-driven research and patent intelligence for your innovation.

Data synchronization method based on master-slave asynchronous replication architecture of relational database

An asynchronous replication and database technology, applied in relational databases, database distribution/replication, database models, etc., can solve the problems of data synchronization delay time increase, increase, synchronization time increase, etc., to achieve the effect of reducing delay time and improving efficiency

Active Publication Date: 2022-03-01
SICHUAN CHANGHONG ELECTRIC CO LTD
View PDF9 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In this context, in the master-slave asynchronous replication architecture for relational databases, the synchronization time for the large-scale data changes generated by the submitted transactions in the master node database to other slave database nodes is gradually increasing, and the delay time caused by data synchronization is increasing day by day , can no longer meet people's requirements for real-time synchronization of data changes to each node in terms of speed, that is, the data changes generated by the transaction on the master node will not start to be synchronized on the slave node until the transaction on the master node is committed, resulting in a synchronization delay. Synchronization time increases as the amount of data changes generated by the same database transaction increases

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
  • Data synchronization method based on master-slave asynchronous replication architecture of relational database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0031] like figure 1 As shown, a data synchronization method based on the master-slave asynchronous replication architecture of the relational database, on the basis of not affecting the data consistency and integrity between the master-slave database nodes of the relational database, through the log of the data change in the same transaction The record is divided into multiple segments according to the multiple of the data page size, and a section point segment point is generated in the log of the master node data change. When a segment of data in the entire transaction is changed to the marked segment point, the segment of data will be Changes are copied to the log of the slave database node until the master node transaction commits and all data changes are completed, and the slave node also starts to complete the last part of the segmented data copy until the commit, thus saving the asynchronous replication architecture, which must be submitted at the master node The time t...

Embodiment 2

[0050] like figure 1As shown, a data synchronization method based on a relational database master-slave asynchronous replication architecture specifically includes:

[0051] 1. The deployment function obtains the data change size x of the master database node in the master-slave asynchronous replication architecture of the relational database, in bytes;

[0052] 2. The deployment function obtains the current database data page size of the master database node in the master-slave asynchronous replication architecture of the relational database, in bytes, and the default database page size is 16384 bytes;

[0053] 3. The deployment function obtains whether the data change generated by the database transaction in the master-slave asynchronous replication architecture of the relational database meets the volume size standard of the segment. If not, the traditional asynchronous replication is performed directly. If it meets the segmented data body quantity standard, get the number...

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 data synchronization method based on a master-slave asynchronous replication architecture of a relational database, which includes: acquiring the size of the current data change of the master database node; acquiring the current database data page size of the master database node; acquiring the data generated by the database transaction Whether the size of the data change meets the volume size standard of the segment, if it meets the data volume standard of the segment, obtain the number of segments to be copied by segment; according to the number of segments and the size of the database data page, the segment point Setting; according to the setting of the segmentation point, the batch data changes generated by the segmentation replication transaction; the invention improves the efficiency of data synchronization between the master-slave asynchronous replication architecture, and reduces the delay time of data synchronization.

Description

technical field [0001] The invention relates to the technical field of data synchronization, in particular to a data synchronization method based on a master-slave asynchronous replication architecture of a relational database. Background technique [0002] Relational database master-slave asynchronous replication architecture is a commonly used database topology, which is often used as a data architecture for data read and write separation, high availability of database master database and standby database, and is applied to various businesses such as enterprise user information data, industrial data, and financial data. In the data structure of the scene. Data replication is used to achieve the purpose of data node storage and meet people's production needs for data read and write performance and data security. However, with the explosive development of enterprise business, user information, business, financial and other business data are increasing in large quantities, a...

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 Patents(China)
IPC IPC(8): G06F16/27G06F16/28
CPCG06F16/273G06F16/284
Inventor 周文龙唐军
Owner SICHUAN CHANGHONG ELECTRIC CO LTD