Beijing Oceanbase Technology Co., Ltd.

Ant Financial (hang Zhou) Network Technology Co., Ltd.

Ant Financial Network Technology Co., Ltd.

Fusheng Han

Zhenkun Yang

Jinliang Xiao

Hao Liu

Fanyu Kong

Shanyan Gao

Chuanhui Yang

Yingying Yao

Bin Jade

Xuwang Teng

Yuchen Wei

Yixin Luo

A computer-implemented method for a database constraint relationship check, includes performing a data manipulation language (DML) operation of a first transaction for a target data table in the database. A submission stage is entered. A corresponding current transaction version number is determined for a target data record obtained and each latest related data record visible to the first transaction is read from the target data table or an associated data table of the target data table. A mutual limitation relationship exists between field values corresponding to a target field in the target data record and each related data record. A constraint relationship check is performed on a target field value corresponding to the target field in the target data record based on each related data record. The first transaction is submitted if the constraint relationship check succeeds or the first transaction is rolled back otherwise.

Constraint relationship check methods and apparatuses for database

Implementations of this specification provide methods and apparatuses for replaying logs. One method includes: classifying a plurality of logs to be replayed into log queues, sending the log queues to a global replay queue, allocating one or more replay threads to the log queues based on rankings of the log queues in the global replay queue, wherein the one or more replay threads are configured to replay one or more current log queues of the log queues, and in response to identifying an error of a current log queue of the one or more current log queues in a replay process, allocating a replay thread of the one or more replay threads allocated to the current log queue to a log queue that immediately follows the current log queue in the global replay queue.

Log replay methods and apparatuses, data recovery methods and apparatuses, and electronic devices

Methods, systems, electronic devices and computer-readable media for database transaction processing are provided. In an example, after determining to perform primary-secondary switching of a copy, a first server records a context of a database transaction that is currently being executed, sends the context to a second server, and switches a primary copy stored in the first server to a secondary copy. The second server switches a secondary copy stored in the second server to a primary copy, and continues execution of the database transaction based on the context after completing the switching.

Methods, systems, electronic devices, and storage media for database transaction processing

Lease transfer between master and slave replicas is described. A master replicator determines that an initial master replica lease takes effect. On determining that a master replica transfer needs to be performed, sending a transfer preparation message to a target replicator prior to expiration of a current master replica lease. The target replicator locally starts and calculates a new master replica lease and returns a readiness response to the master replicator. The master replicator sends a lease extension message to remaining slave replicators to extend local corresponding leases. After receiving lease extension success responses of a majority of the slave replicators, the master replicator terminates the local master replica lease of the master replicator in advance, and sends a transfer confirmation message to the target replicator. The target replicator validates the new master replica lease to make the target replicator a new master replicator.

Methods, apparatuses, and devices for lease transfer between master and slave replicas

Embodiments of the present specification provide a method for updating a database by using a two-phase commit distributed transaction. The method is applied to a coordinator, and includes: sending a first-phase prepare request message to each participant to end a current transaction, the current transaction being configured to update a target database record; and after receiving write lock advance release requests sent by all participants, returning a write lock advance release response to each participant to instruct each participant to unlock a target database record of the participant, the write lock advance release requests being sent by the participants after the participants successfully write a log of an update operation of the current transaction to a log buffer.

Method and apparatus for updating database by using two-phase commit distributed transaction

A data modification request for modifying data in a primary database is received at the primary database. Based on the data modification request, second data in the primary database is modified to first data. Based on the data modification request, a first log and a second log are generated, where the first log is a simplified log including the first data and the second log is a complete log including the second data. Persistence processing is performed on the first log. A modification result that corresponds to the data modification request is returned.

Growing community of inventors

Hangzhou, China

Fusheng Han