A database replication method and system based on multi-active distributed architecture
A technology of distributed architecture and replication method, applied in the field of database replication method and system based on multi-active distributed architecture, can solve problems such as failure, difference in database object definition attributes, unfavorable application development and system maintenance, etc., to avoid taking value Repeat and ensure the effect of normal processing
Active Publication Date: 2021-08-06
THE PEOPLES BANK OF CHINA NAT CLEARING CENT
View PDF6 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0003] Although at the technical level, by setting the value range of the Sequence and Identity Column of the first data center or the self-growth method, data duplication in the two data centers can be avoided. For example, the first data center takes odd numbers (1, 3, 5, 7, ... ), and the second data center takes an even value (2, 4, 6, 8, ...), but this will lead to differences in the database object definition attributes of the first data center and the second data center, that is, to maintain two sets of application databases for a long time Object definition scripts are very unfavorable for application development and system maintenance, and there is a high possibility of production accidents where business processing fails after data center switching due to maintenance errors of the two sets of scripts
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0035] Next, the technical solutions in the embodiments of the present invention will be apparent from the embodiment of the present invention, and it is clearly described, and it is understood that the described embodiments are merely embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, there are all other embodiments obtained without making creative labor without making creative labor premises.
[0036] With regard to "first", "second", ..., etc., it is not particularly referred to as the order or in the order of the invention, and is not to be limited to the present invention, which is only the elements described in the same technique or operate.
[0037] Regarding the "included", "including", "has", "contains", etc., all of which are open, meaning but not limited thereto.
[0038] Without "and / or" as used herein, any or all of the combinations of the matter.
[0039] In view of the defects present in the prior a...
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
Login to View More Abstract
The present invention provides a database replication method and system based on a multi-active distributed architecture, including: creating a first database system backup table in a first data center, and creating a second database system backup table in a second data center; The first database system table of a data center is synchronized to the second database system backup table in real time; when the data center is switched from the first data center to the second data center, a database update script is generated according to the second database system backup table; the database is executed The update script updates the second database system table in the second data center, and synchronizes the second database system table to the first database system backup table in real time. This application enables the source data center and the target data center to deploy the same application script, and synchronizes the object information of the source data center to the database system backup table of the target data center in real time, which can ensure the normal processing of transactions after data center switching, reduce operation and maintenance costs and application Beneficial effects of developing risks.
Description
Technical field [0001] The present invention relates to the field of database technologies, and more particularly to a database replication method and system based on a multi-live distributed architecture. Background technique [0002] Based on the current Q-REP software, you can only implement customer service data synchronization, and in actual applications, the characteristics of Sequence, Identity Column, and application data are close, which is the only one for identifying business data or business packets. Sexual logo, record the DB2 metadata information of the sequence and the Identity Column database object, cannot be synchronized by Q-REP implementation, so the metadata information of the sequence and Identity Column database objects will result in different steps, such as the first data center. Values have been taken to 100, while the second data center value is 50, when the data center is switched from the first data center to the second data center, the value of SEQ...
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
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/27G06F11/14
CPCG06F11/1448
Inventor 不公告发明人
Owner THE PEOPLES BANK OF CHINA NAT CLEARING CENT