A read-write separation method and device based on a database double cluster

Abstract

The application provides a read-write separation method and device based on a database double cluster, which comprises the following steps: dispatching a query transaction to a read cluster and inserting the query transaction into an application log; synchronously writing a database system log of a local and another site in the same city when submitting the query transaction, so as to realize the synchronization in the same city; and replicating the update records of the read cluster and the write cluster to each other, so as to ensure the consistency of the data in the read cluster and the write cluster. The application realizes the protection of the table and the data of the read cluster by controlling the user rights; the single number is taken from the read cluster and the double number is taken from the read-write cluster by introducing a serial number generator, so as to prevent the repetition of the key values of the records on both sides; the synchronous writing of the database system log of the double cluster in the same city is realized, so as to ensure that the update data is not lost under the failure of any one of the two clusters; and the logical replication of the database with conditions is realized, so as to ensure the final consistency of the data, run the batch report in the master database, and realize the complete audit and report functions.

Images