Distributed transaction processing method and device based on improved one-phase commit

Abstract

The invention provides a distributed transaction processing method and device based on improved one-phase commit. The method comprises the steps of carrying out SQL (Structured Query Language) operations of application transactions on databases; resolving the SQL operations, thereby determining transaction correlated SQL operations; when it is determined that any two transaction correlated SQL operations belong to different databases, generating insert statements of distributed transaction locks, and inserting the insert statements of the distributed transaction locks into the application transactions; carrying out the SQL operations, after the SQL operations are carried out successfully, calling commit operations; after the commit operations are carried out successfully, triggering release operations of the distributed transaction locks; and after the commit operations are carried out unsuccessfully, carrying out re-commit operations of the preset retry times on the unsuccessful commit operations. According to the method and the device, the consistency of the distributed transactions is realized, the commit states of the distributed transactions can be obtained, the unsuccessful transactions are recovered, and a commit rate of the one-phase commit is ensured.

Description

technical field [0001] The invention relates to the technical field of the Internet, in particular to a method and device for processing distributed transactions based on an improved one-phase commit. Background technique [0002] With the development of Internet technology, there are more and more business scenarios with high concurrent access and massive data processing. Distributed transaction processing methods can be used to process data. Distributed transactions refer to transaction participants, servers supporting transactions, and resources. Servers and transaction managers are located on different nodes of the distributed system. [0003] In the existing technology, the two-phase commit method is a blocking protocol, which has poor performance and cannot be used in high-concurrency scenarios; the traditional one-phase commit method executes each database transaction operation independently, and cannot be rolled back when a database operation fails Other database tr...

AI Technical Summary

Problems solved by technology

[0006] The present invention provides a distributed transaction processing method and device based on improved one-phase commit, which is used to solve the poor efficiency of two-stage commit in the prior art, traditional one-stage commit cannot support distributed transactions, best effort one-stage commit Inconsistencies in distributed transactions due to infrastructure failures

Images