Transaction completion in a synchronous replication environment

Patent metadata

Field	Value
Publication number	US-9910733-B2
Application number	US-201414444904-A
Country	US
Kind code	B2
Filing date	Jul 28, 2014
Priority date	Jun 26, 2014
Publication date	Mar 6, 2018
Grant date	Mar 6, 2018

Abstract

Systems and methods are presented for completing transactions in a synchronous replication environment. In some embodiments, a computer-implemented method can include generating in a database server, an identifier to identify a database transaction. The method can also include transmitting the identifier to a replication server; receiving acknowledgement that the identifier is acknowledged by the replication server; storing the transaction in the database server; and executing the transaction after receiving acknowledgement from the replication server and after determining the transaction is stored in the database server; wherein transmitting the identifier to the replication server occurs in parallel with storing the transaction in the database server.

First claim

What is claimed is:

1. A computer implemented method comprising:
generating in a database server, an identifier to identify a database task;
transmitting the identifier to a replication server;
receiving acknowledgement that the identifier is acknowledged by the replication server;
in parallel to transmitting the identifier to the replication server, committing a first portion of the database task in a computer-readable storage medium of the database server and placing a second portion of the database task in a waiting state, the first portion of the database task comprising at least a portion of a transaction and the second portion of the database task comprising one or more post-commit instructions; and
executing the one or more post-commit instructions of the database task in response to receiving acknowledgement from the replication server and determining the first portion of the database task is committed in the computer-readable storage medium of the database server, wherein the acknowledgement indicates the replication server committed the first portion of the database task.

2. The method of claim 1 , wherein the identifier comprises an origin queue identifier (OQID).

3. The method of claim 1 , further comprising instructing the transaction to sleep prior to receiving acknowledgement from the replication server and prior to storing the transaction in the database server.

4. The method of claim 1 , further comprising transitioning from an asynchronous replication mode to a synchronous replication mode.

5. The method of claim 4 , wherein the transitioning occurs automatically.

6. The method of claim 1 , further comprising sending the transaction to a component interface library within the database server in parallel to storing the transaction in the database server.

7. The method of claim 1 further comprising:
determining the first portion of the transaction is committed in the database server; and
in response to determining the first portion of the transaction is committed, placing the second portion of the transaction in a processing queue for execution of the one or more post-commit instructions.

8. The method of claim 1 further comprising:
determining the first portion of the transaction is committed in the database server;
determining receipt of the acknowledgement from the replication server; and
in response to committing the first portion and receipt of the acknowledgement, placing the second portion of the transaction in a processing queue for execution of the one or more post-commit instructions.

9. A system comprising:
a first memory coupled to a first processor configured to execute a database server; and
a second memory coupled to a second processor configured to execute a replication server;
wherein the database server is configured to:
generate an identifier to identify a database task;
transmit the identifier to the replication server;
receive acknowledgement that the identifier is acknowledged by the replication server;
in parallel to transmitting the identifier to the replication server, commit a first portion of the database task in a computer-readable storage medium of the database server and placing a second portion of the database task in a waiting state, the first portion of the database task comprising at least a portion of a transaction and the second portion of the database task comprising one or more post-commit instructions; and
execute the one or more post-commit instructions of the database task in response to receiving acknowledgement from the replication server and determining the first portion of the database task is committed in the computer-readable storage medium of the database server, wherein the acknowledgement indicates the replication server committed the first portion of the database task.

10. The system of claim 9 , wherein the identifier comprises an origin queue identifier (OQID).

11. The system of claim 9 , wherein the database server is further configured to instruct the transaction to sleep prior to receiving acknowledgement from the replication server and prior to storing the transaction in the database server.

12. The system of claim 9 , wherein the database server is further configured to transition from an asynchronous replication mode to a synchronous replication mode.

13. The system of claim 12 , wherein the transitioning occurs automatically.

14. The method of claim 9 , wherein the database server is further configured to send the transaction to a component interface library within the database server in parallel to storing the transaction in the database server.

15. The system of claim 9 , wherein the database server is further configured to:
determine the first portion of the transaction is committed in the database server; and
in response to determining the first portion of the transaction is committed, place the second portion of the transaction in a processing queue for execution of the one or more post-commit instructions.

16. The system of claim 9 , wherein the database server is further configured to:
determine the first portion of the transaction is committed in the database server;
determine receipt of the acknowledgement from the replication server; and
in response to committing the first portion and receipt of the acknowledgement, place the second portion of the transaction in a processing queue for execution of the one or more post-commit instructions.

17. A non-transitory machine-readable medium embodying instructions that, when executed by a processor perform operations comprising:
generating in a database server, an identifier to identify a database task;
transmitting the identifier to a replication server;
receiving acknowledgement that the identifier is acknowledged by the replication server;
in parallel to transmitting the identifier to the replication server, committing a first portion of the database task in a computer-readable storage medium of the database server and placing a second portion of the database task in a waiting state, the first portion of the database task comprising at least a portion of a transaction and the second portion of the database task comprising one or more post-commit instructions; and
executing the one or more post-commit instructions of the database task in response to receiving acknowledgement from the replication server and determining the first portion of the database task is committed in the computer-readable storage medium of the database server, wherein the acknowledgement indicates the replication server committed the first portion of the database task.

18. The non-transitory machine-readable medium of claim 17 , wherein the identifier comprises an origin queue identifier (OQID).

19. The non-transitory machine-readable medium of claim 17 , wherein the operations further comprise instructing the transaction to sleep prior to receiving acknowledgement from the replication server and prior to storing the transaction in the database server.

20. The non-transitory machine-readable medium of claim 17 , wherein the operations further comprise transitioning from an asynchronous replication mode to a synchronous replication mode.

21. The non-transitory machine-readable medium of claim 20 , wherein the transitioning occurs automatically.

22. The non-transitory machine-readable medium of claim 17 , wherein the operations further comprise sending the transaction to a component interface library within the database server in parallel to

Assignees

• Quakkelaar Rene
• Lora Gallardo Elena
• Rank Christopher H
• Sybase Inc

Inventors

• Quakkelaar Rene
• Lora Gallardo Elena
• Rank Christopher H

Classifications

• G06F2201/80

  Database-specific techniques · CPC title

• G06F16/275

  Synchronous replication · CPC title

• G06F11/2097

  maintaining the standby controller/processing unit updated (initialisation or re-synchronisation thereof G06F11/1658 and subgroups) · CPC title

• G06F11/1402 Primary

  Saving, restoring, recovering or retrying · CPC title

• G06F11/2038

  with a single idle spare processing component · CPC title