Operation request processing method, apparatus, device, readable storage medium, and system

An operation request processing apparatus, applied to a read-write node in a shared storage service cluster comprising at least one read-write node and at least one read-only node, the apparatus comprising:

• at least one processor;
• and
• a memory communicatively connected with the at least one processor,
• wherein the memory stores instructions executable by the at least one processor, and the instructions, when executed by the at least one processor, cause the at least one processor to perform operations of:
• performing a locking operation, for an operation request to a data table initiated by a requester, to the data table, and writing a log of locking the data table into a redo log file, and after writing status information of the log of locking into a status record, returning a request processing completion message to the requester, wherein the status information of the log of locking comprises an identification of the log of locking;
• and
• after monitoring, based on the status information of the log of locking in the status record, that all read-only nodes have played back to the log of locking in the redo log file, performing a corresponding operation on the data table based on the operation request, wherein monitoring whether all the read-only nodes have played back to the log of locking comprises:
• receiving an identification of a log that has been played back sent by the read-only node and determining whether all the read-only nodes have played back to the log of locking by comparing the identification of the log that has been played back with the identification of the log of locking.

A database system, comprising at least one read-write node, at least one read-only node and a shared storage node, wherein

• the shared storage node is configured for storing data, status file and log file;
• the read-only node is configured for playing back a log;
• the read-write node is configured for:
• performing a locking operation, for an operation request to a data table initiated by a requester, to the data table, and writing a log of locking the data table into a redo log file, and after writing status information of the log of locking into a status record, wherein the status information of the log of locking comprises an identification of the log of locking, returning a request processing completion message to the requester;
• and after monitoring, by a monitoring processing process based on the status information of the log of locking in the status record, that all read-only nodes have played back to the log of locking, performing a corresponding operation on the data table based on the operation request, wherein monitoring whether all the read-only nodes have played back to the log of locking comprises:
• receiving an identification of a log that has been played back sent by the read-only node and determining whether all the read-only nodes have played back to the log of locking by comparing the identification of the log that has been played back with the identification of the log of locking.