Locking protocol for partitioned and distributed tables

摘要

Systems, methods and computer program product embodiments for providing a locking protocol for partitioned and distributed database tables are disclosed herein. A locking method includes executing, by at least one processor, a first database transaction on a second node, attempting to acquire and acquiring a lock on the second node in intentional exclusive mode, executing, by the at least one processor, a second database transaction on a first node, acquiring a lock on the first node in exclusive mode and waiting to acquire a lock on the second node in exclusive mode, routing, by the at least one processor, the first database transaction to the first node and unsuccessfully trying to acquire a lock on the first node and committing, by the at least one processor, the first database transaction.

主权项

1. A method, comprising:
beginning, by at least one processor, execution of a first database transaction on a second node, acquiring a lock on the second node in intentional exclusive mode to perform operations required by the first database transaction; beginning, by the at least one processor, a second database transaction on a first node, acquiring a lock on the first node in exclusive mode and waiting to acquire a lock on the second node in exclusive mode to perform operations required by the second database transaction; routing, by the at least one processor, the first database transaction from the second node to the first node to perform operations required by the first database transaction; in response to determining that the lock is acquired on the second node, determining that lock acquisition on the first node is not necessary to process the first database transaction on the first node; and committing, by the at least one processor, the first database transaction.