Method and equipment for achieving transaction commit in active-standby synchronization mode

Abstract

The invention aims at providing a method and equipment for achieving transaction commit in an active-standby synchronization mode. Specifically, the method comprises the steps: sending a transaction number corresponding to a transaction and a former log number of a transaction commit request to a standby database when an active database receives the transaction commit request from a use; performing a transaction commit operation; detecting whether former log information corresponding to the transaction has been received by the standby database or not; sending a transaction commit finishing notification to the user if the former log information has been received. Compared with the prior art, the method and the equipment has the advantages that when the active database receives the transaction commit request from the user, the active database sends the transaction number corresponding to the transaction and the former log number of the transaction commit request to the corresponding standby database, performs the transaction commit operation, then, detects whether sent former log information has been received by the standby database or not and sends the transaction commit request finishing notification to the user if the former log information has been received by the standby database, so that the speed of transaction commit of databases and database performance are improved, and the user experience is optimized.

Description

technical field [0001] The present application relates to the computer field, and in particular to a technology for implementing transaction submission in a master-standby synchronization mode. Background technique [0002] With the advent of the era of big data, the surge in data processing has led to the development of databases. Generally, the primary database and the standby database are used to jointly ensure the high reliability of the database. Synchronous mode is used for data backup. In the prior art, when submitting a database transaction, the primary database server needs to send all logs of the transaction to the standby data server and the primary database server completes the database transaction submission only after the standby database server has received the feedback. and notify the user. [0003] However, in the prior art, when database transactions are submitted in the active-standby synchronization mode, there is often a network delay between the primar...

AI Technical Summary

Problems solved by technology

[0004] The purpose of this application is to provide a method and device for implementing transaction submission in the master-slave synchronization mode, so as to solve the problem that the transaction submission completion time is too long in the existing master-slave synchronization mode

[0005] In order to achieve the above purpose, according to one aspect of the present application, the present application provides a method for implementing transaction submission in the master-standby synchronization mode on the server side of the master database, which solves the problem of completing transaction submission in the existing master-standby synchronization mode. For too long issues, the method includes:

Images