Main and standby method and device between database clusters

Abstract

The invention relates to the field of databases, and particularly provides a main and standby method between database clusters, which comprises the following steps: S1, after a transaction is started, obtaining a unique transaction ID and returning the transaction ID to a client; s2, a user sends an SQL (Structured Query Language) sql1 to a connection node, the connection node forwards the received sql1 to a corresponding coordinator node for execution, responds to the connection node after execution is completed and returns the sql1 to the client, and meanwhile, an SQL statement or a dependency relationship between Key-Value data corresponding to the SQL statement and transactions is sent to a Merge module of a standby site; s3, the user sends a second SQL sql1, and the process is the same as that of the step S2; s4, the user sends commit / abort statements, and the transaction enters a submission stage; and S5, after receiving the commit, the Merge module of the standby site verifies whether the transaction is complete or not through the key span of the transaction record and the final version number of each range. Compared with the prior art, when the main database breaks down, the main database can be rapidly switched to the standby database, and the disaster recovery capacity of the database is improved.

Description

technical field [0001] The present invention relates to the technical field of databases, and in particular provides a method and a device for master / slave between database clusters. Background technique [0002] A database standby database is a standby database that creates, maintains, and monitors one or more primary databases to protect enterprise data structures from failures, disasters, errors, and crashes. Currently, database active and standby technologies are being widely used around the world. From 911 Since the incident, many companies have put remote disaster recovery at the forefront. The most valuable thing in the 21st century is data. As a basic IT software for storing data, traditional stand-alone databases are increasingly limited in the era of massive data. With poor scalability, smooth performance curve and high investment, distributed databases came into being. Distributed database breaks the performance bottleneck of traditional stand-alone database, can...

AI Technical Summary

Problems solved by technology

However, the data in each node in the standby site usually lags behind the primary site and does not have consistency

Therefore, if the primary site fails and all nodes fail, the standby site cannot take over directly, that is, it does not have disaster recovery capabilities

However, if the data is replicated to the standby site in synchronous mode, although it can ensure that the standby site has the ability to take over services at any time, it faces the increase of the geographical distance between the primary and secondary sites, and the synchronous replication mode will cause significant service performance at the primary site. decline, issues affecting business continuity operations

[0006] On the other hand, the mode of deploying a single cluster across sites still has the problem of high interdependence between nodes, and the possibility of mutual transmission of influence when a failure occurs, causing damage

Images