Distributed transaction processing method and system

Abstract

The invention provides a distributed transaction processing method. The method comprises the following steps: distributing a distributed transaction into a plurality of sub-transactions by a main business system; then respectively transmitting commands for executing the sub-transactions to the various corresponding secondary business systems; carrying out corresponding operations by the secondary business systems from secondary business front tables according to the commands for executing sub-transactions; after all the sub-transactions are executed successfully, simultaneously synchronizing operations in the secondary business front tables to secondary business main tables, so that consistency of the sub-transactions is realized; and when execution of at least one sub-transaction fails, rolling back all the sub-transactions in the secondary business front tables. A transaction table is added in a database of each business system, consumption of network flow can be reduced, transaction processing efficiency can be improved, single point of failure is avoided, and certain fault tolerance is achieved. In addition, the invention provides a distributed transaction processing system.

Description

technical field [0001] The invention relates to the field of computer processing, in particular to a distributed transaction processing method and system. Background technique [0002] Transaction (Transaction) is a reliable and independent unit of work composed of a set of operations, in which all operations either succeed or fail. Transactions have four basic characteristics: atomicity, consistency, isolation, and durability, also referred to as the ACID characteristics of transactions. In the era of microservices, after a large number of business splits, the problem of data consistency in distributed transactions follows, especially the distributed transactions between different systems involving transactions. In order to ensure the data consistency of distributed transactions, the operation status of each transaction or sub-transaction is recorded through the transaction table. The management of the traditional transaction table is to uniformly manage the operation stat...

AI Technical Summary

Problems solved by technology

In order to ensure the data consistency of distributed transactions, the operation status of each transaction or sub-transaction is recorded through the transaction table. The management of the traditional transaction table is to uniformly manage the operation status of each transaction through a separate service system, so that each business All systems need to establish a network connection with the service system, which not only consumes network traffic, but also because each business system needs to interact with the service system, all operation records are recorded in the same transaction table, which not only increases the burden on the transaction table, but also It leads to low operating efficiency, and if the service system fails, it will cause the entire business system to be paralyzed, that is, there is a single point of failure

Images