Method and device for verifying data between databases

A data verification and database technology, applied in the database field, can solve problems such as difficult manual operation, application service control, etc., to meet business needs and reduce time-consuming effects
CN109739831AInactive Publication Date: 2019-05-10NETSUNION CLEARING CORP
11 Cites 7 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
NETSUNION CLEARING CORP
Publication Date
2019-05-10
Estimated Expiration
Not applicable · inactive patent

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

Abstract

The invention provides a method and a device for verifying data between databases. The method comprises the following steps of: obtaining a first data table corresponding to the first database from apreset configuration library, and obtaining a first data table corresponding to the second database, calculating a first data sum of the first data table, calculating a second data sum of the second data table, and if the first data sum is consistent with the second data sum, generating a consistency verification report of the first database and the second database. The process does not depend onreplication between main data and standby data or between standby data, and the configuration information and the verification result of the preset configuration library can be independently stored and are not written into a production database. And data replication between different service libraries can be verified, so that the method is more flexible. And a concurrent mode can be adopted, so that the time consumption of the whole verification process is greatly reduced, and the business requirements can be well met through offline and production verification.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The invention relates to the technical field of databases, in particular to a method and device for checking data between databases. Background technique

[0002] At present, the platform OLTP (On-Line Transaction Processing, online transaction processing, online transaction processing process) business data storage mainly uses the MySQL database, which adopts the master-slave replication scheme to expand the architecture and redundant data (such as 1 master and 1 backup or 1 master and multiple backups) ), and the core financial business system requires the platform to achieve high database availability and strong data consistency.

[0003] However, master-slave replication is log-based logical replication. MySQL uses logical replication to play back transaction logs to synchronize changes in the master database, which can easily lead to data inconsistencies on the master and slave nodes. Therefore, the data consistency of the active and standby node...

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