High-throughput distributed transaction management for globally consistent sharded oltp system and method of implementing

A computer implemented method for processing database transactions, comprising the steps of:

• receiving, at a coordinator node having one or more processors for executing instructions, a query for a transaction;
• determining if the transaction is a single shard transaction or a multi-shard transaction;
• when the transaction is determined to be a mutli-shard transaction:
• requesting a distributed transaction ID (DXID) for the transaction from a global transaction manager (GTM) having one or more processors for executing instructions,
• receiving the DXID for the transaction from the GTM at the coordinator node,
• sending the query and the DXID to two or more data nodes associated with the transaction;
• and
• when the transaction is determined to be a single shard transaction:
• sending the query to a single data node associated with the transaction without first requesting a DXID from the GTM.

A non-transitory computer-readable media storing computer instructions, that when executed by one or more processors, cause the one or more processors to perform the steps of:

• receiving a query at a coordinator node;
• determining if the transaction is a single shard transaction or a multi-shard transaction;
• when the transactions determined to be a mutli-shard transaction:
• requesting a distributed transaction ID (DXID) for the transaction from a global transaction manager (GTM),
• receiving the DXID for the transaction,
• sending the query and the DXID to two or more data nodes associated with the transaction;
• and
• when the transaction is determined to be a single shard transaction:
• sending the query to a single data node associated with the transaction without first requesting a DXID from the GTM.