Business locking and unlocking method and device

Abstract

The invention provides a business locking and unlocking method and device which are applied to the technical field of data clusters. The business locking and unlocking method includes that: a local lock manager (LLM) receives a locking or unlocking request of a business; the LLM places the locking or unlocking request of the business into a batch message packet when determining that the locking or unlocking request of the business cannot be met locally, wherein the batch message packet is used for storing a plurality of locking or unlocking requests; and the LLM transmits the batch message packet to a general lock manger (GLM) when judging that batch messages meet batch conditions, so that the GLM can process the locking or unlocking request in the batch message packet conveniently. By adopting the business locking and unlocking method and device, the quantity of the locking or unlocking requests transmitted to the GLM by the LLM in a short time can be reduced, pressure of a channel between the LLM and the GLM is reduced, message delay is reduced, and linear scalability of the database clusters is improved.

Description

technical field [0001] The invention relates to the technical field of database clusters, in particular to a transaction locking and unlocking method and device. Background technique [0002] Database cluster technology is a technology that combines multiple servers to form a cluster to achieve better overall performance than a single large server. There are currently two mainstream database cluster architectures: Shared-Disk database cluster and Shared-Nothing database cluster. [0003] figure 1 Describes a shared disk database cluster architecture, including shared disks, member nodes and central nodes, where shared disks are responsible for data storage, so that data can be shared among member nodes, and member nodes are used to access and modify shared disks The central node is used to coordinate the concurrent access of the member nodes to the shared disk. [0004] Transaction is one of the important functions provided by the database system. The transaction is compo...

AI Technical Summary

Problems solved by technology

[0006] The inventors have found that the above prior art has at least the following technical problems: since a transaction contains one or more statements, when one or more statements in the transaction access different locks, the LLM needs to send a lock or unlock lock to the GLM every time. The request, for the unlock request, is sent to the GLM through the LLM almost at the same time as the transaction ends, which will cause great pressure on the message channel in a short time, resulting in a very large message delay, which has a great impact on the linear expansion of the database cluster. big impact

Images