Distributed table lock application methods, apparatuses, storage media, and electronic devices

A computer-implemented method, comprising:

• receiving and storing, by a slave node in a distributed database, a log synchronized by a master node in the distributed database, wherein the log comprises lock status information, the lock status information is generated after the master node performs, by using a table lock, a lock operation on a data table that to-be-processed data are located in, the table lock is generated for the data table based on a type of an operation on the data table in response to a data processing request indicating the operation on the data table and after a determination of the type of the operation indicated by the data processing request is one of a data definition language (DDL) operation and a data manipulation language (DML) operation, the table lock comprises a table-level lock when the operation is determined to be a DDL operation or a partition-level lock when the operation is determined to be a DML operation, the table-level lock is configured to lock the data table after responding to a DDL operation, and the partition-level lock is configured to lock a partition of the data table after responding to a DML operation;
• and
• in response to receiving a log acquisition request from the master node, sending the log to the master node for the master node to restore the lock operation on the data table based on the lock status information recorded in the log, wherein the log acquisition request is received by the slave node in response to that the master node determines, after completion of restart, that the log is not locally stored.

A computer-implemented system for a distributed database, comprising:

• a master node and a slave node,
• wherein the master node is configured to:
• receive a data processing request, wherein the data processing request indicates an operation on a data table that to-be-processed data corresponding to the data processing request are located in;
• determine the data table based on the data processing request;
• determine a type of the operation indicated by the data processing request, wherein the type of the operation is one of a data definition language (DDL) operation and a data manipulation language (DML) operation;
• generate a table lock for the data table based on the type of the operation, wherein the table lock comprises a table-level lock when the operation is determined to be a DDL operation or a partition-level lock when the operation is determined to be a DML operation, the table-level lock is configured to lock the data table after responding to a DDL operation, and the partition-level lock is configured to lock a partition of the data table after responding to a DML operation;
• perform a lock operation on the data table by using the table lock;
• generate lock status information corresponding to the data table;
• write the lock status information into a log of the master node;
• and
• synchronizing the log to the slave node;
• after the master node restarts, determine whether the master node stores the log;
• and
• in response to that the master node stores the log, restore the lock operation on the data table based on the lock status information recorded in the log;
• and
• wherein the slave node is configured to:
• receive and store the log synchronized by the master node, wherein the log comprises the lock status information.