Patent ID: 9740582
Date: 2017-08-22
CPC Classifications: G06F

Claim:
1. A computer-implemented method comprising: receiving, by a first node of a plurality of nodes in a distributed database system on a shared disk cluster infrastructure, a transaction request to perform a user database transaction on one or more data items in a user database on a shared disk on the shared disk cluster infrastructure, the user database transaction comprising one or more database write operations for the one or more data items in the user database, and the shared disk being accessible by the plurality of nodes; acquiring, by the first node, a corresponding transaction lock for each one of the one or more data items of the user database transaction; storing, by at least one processor, a lock file for the user database transaction in a lock information database on the shared disk, the lock information database being a node-local database of the first node, the first node being the only node in the plurality of nodes able to write to the lock information database, the plurality of nodes other than the first node being able to read from the lock information database during a failover event for the first node, the lock file comprising corresponding lock information for each transaction lock of the user database transaction and an indication of a status of the user database transaction, and the corresponding lock information comprising an identification of a location of the corresponding data item for each corresponding transaction lock; and storing, by the at least one processor, a transaction record of the user database transaction in a transaction log in the user database on the shared disk subsequent to the storing of the lock file in the lock information database on the shared disk.