Database transaction keeping method and system, equipment, program and storage medium

A database and transaction technology, applied in the database field, can solve problems such as high application program dependence and difficulty in improving database processing efficiency, and achieve the effects of improving efficiency, reducing development costs, reducing time costs and resource costs

A database and transaction technology, applied in the database field, can solve problems such as high application program dependence and difficulty in improving database processing efficiency, and achieve the effects of improving efficiency, reducing development costs, reducing time costs and resource costs

CN113254425AActive Publication Date: 2021-08-13ALIBABA CLOUD COMPUTING LTD
9 Cites 4 Cited by

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Database transaction keeping method and system, equipment, program and storage medium
  • Database transaction keeping method and system, equipment, program and storage medium
  • Database transaction keeping method and system, equipment, program and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment approach

[0049] Based on this implementation method, the last successfully executed database statement before the database restart can be used as a rollback node, and the transaction can be restored to the state after the end of the last successfully executed database statement, and the rollback node can be re-executed without success The database statement executed. Therefore, resource waste caused by rolling back the entire target transaction is avoided, and at the same time, the client 10 does not need to repeatedly send database statements, reducing the dependence on the user side.

[0050] After receiving the database statement resent by the proxy server 20, the database server 30 may execute the resent database statement, so as to maintain the target transaction.

[0051] Based on this implementation, after the database instance ends the abnormal state, the proxy server 20 assists the database server 30 to restore the data of the target transaction to the correct version before t...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The embodiment of the invention provides a database transaction keeping method and system, equipment, a program and a storage medium. When a database instance is abnormal, if an unsubmitted transaction exists, a proxy server can assist the database instance in recovering the unsubmitted transaction after the database instance finishes the abnormal state, and roll back data of the unsubmitted transaction to a data version corresponding to a specified rollback node. After the transaction is recovered and the data is fallback, the proxy server can send a database statement after the fallback node, and the database server can execute the database statement after the fallback node in a correct state. Furthermore, after the database ends the abnormal state, the maintenance of the unsubmitted transaction can be realized under the condition that a user does not perceive, the dependency of the transaction maintenance on a client is reduced, the data of the transaction can be accurately returned to a certain version based on the rollback node, the time cost and the resources cost required for recovering the transaction are reduced. And the transaction maintenance efficiency is improved.

Description

technical field [0001] The present application relates to the technical field of databases, and in particular to a database transaction maintenance method, device, system, program and storage medium. Background technique [0002] When an abnormality occurs in a traditional database, such as a master-standby switchover or restart of a database instance, the database instance will disconnect from the user side, and then the application on the user side can sense the abnormality of the database. In order to cope with the "disturbance" that may occur at any time caused by database exceptions, the application needs to have a mechanism for reconnecting and retrying transactions. However, this method relies heavily on the application program on the user side, and it is not easy to improve the processing efficiency of database exceptions. Therefore, a new solution remains to be proposed. Contents of the invention [0003] Multiple aspects of the present application provide a met...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
13 Aug 2021
Publication
CN113254425A
IPC
G06F16/21; G06F11/14; G06F9/46
CPC
G06F16/219; G06F9/466; G06F11/1458
Inventors
王宇辉; 李飞飞