# US 2018/0025068 A1 · Automatic mode switching in a synchronous replication environment

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2018/0025068 A1
- Document ID: US20180025068A1
- Status: Published application
- Kind: A1
- Application number: 15/720,897
- Filed: 2017-09-29
- Published: 2018-01-25
- Earliest claimed: 2014-06-26
- Assignees: Sybase, Inc.
- Applicants: Sybase, Inc.
- Inventors: Christopher H. Rank; Rene Quakkelaar; Elena Lora-Gallardo
- Web page: https://patentgrep.com/patent/US20180025068A1

## CPC

- G06F 16/275: {Synchronous replication}
- G06F 16/27: Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F 16/273: {Asynchronous replication or reconciliation}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Disclosed in some examples is a method of database replication, the method including at a Relational Database Management System (RDMS), determining a first replication mode; identifying a triggering event; determining that the triggering event indicates a change in the first replication mode; responsive to determining that the triggering event indicates a change in the first replication mode, determining a second replication mode, the second replication mode being a different replication mode than the first replication mode; identifying a database change made by one or more database tasks; and replicating the database change to an external replication component according to the second replication mode.

## Claims

### Claim 1

A method of database replication, the method comprising:
at a Relational Database Management System (RDMS), using one or more computer processors:
determining a first replication mode associated with a replication agent;
identifying a triggering event;
determining that the triggering event indicates a change in the first replication mode of the replication agent;
responsive to determining that the triggering event indicates a change in the first replication mode, determining a second replication mode, the second replication mode being a different replication mode than the first replication mode;
in response to determining the triggering event, identifying a set of database tasks being processed in parallel, one or more database tasks of the set of database tasks being associated with a database change;
determining a task replication mode for at least one of the one or more database tasks:
replicating the database change to an external replication component according to the second replication mode; and
passing a notification to the one or more database tasks of the set of database tasks associated with the database change, the notification simulating the first replication mode regardless of receipt of confirmation from the external replication component.

### Claim 2 (depends on 1)

The method of claim 1, wherein the second replication mode is an asynchronous replication mode and the first replication mode is a synchronous replication mode.

### Claim 3 (depends on 1)

The method of claim 1, wherein the triggering event is identified in response to a network condition of a communications network coupled to the RDMS.

### Claim 4 (depends on 3)

The method of claim 3, further comprising:
in response to identifying the triggering event, monitoring the network condition of the communications network;
determining a change in the network condition of the communications network; and
reverting from the second communications mode to the first communications mode.

### Claim 5 (depends on 1)

The method of claim 1, wherein identifying the triggering event further comprises:
detecting a shutdown process of the replication agent; and
in response to the shutdown process of the replication agent, determining the second replication mode as a replication mode for the RDMS.

### Claim 6 (depends on 1)

The method of claim 1, wherein the triggering event is a first triggering event and the second replication mode is associated with a second triggering event, the method further comprising:
detecting the second triggering event associated with the second replication mode; and
in response to the second triggering event, replicating the database change to the external replication component according to the second replication mode.

### Claim 7 (depends on 1)

The method of claim 1, wherein determining the second replication mode further comprises transmitting a notification of the second replication mode to the external replication component.

### Claim 8

A Relational Database Management System (RDMS) comprising:
one or more computer processors; and
a replication agent executed by the one or more computer processors to perform operations comprising:
determining a first replication mode associated with a replication agent;
identifying a triggering event;
determining that the triggering event indicates a change in the first replication mode of the replication agent;
responsive to determining that the triggering event indicates a change in the first replication mode, determining a second replication mode, the second replication mode being a different replication mode than the first replication mode;
in response to determining the triggering event, identifying a set of database tasks being processed in parallel, one or more database tasks of the set of database tasks being associated with a database change;
determining a task replication mode for at least one of the one or more database tasks,
replicating the database change to an external replication component according to the second replication mode; and
passing a notification to the one or more database tasks of the set of database tasks associated with the database change, the notification simulating the first replication mode regardless of receipt of confirmation from the external replication component.

### Claim 9 (depends on 8)

The RDMS of claim 8, wherein the second replication mode is an asynchronous replication mode and the first replication mode is a synchronous replication mode.

### Claim 10 (depends on 8)

The RDMS of claim 8, wherein the triggering event is identified in response to a network condition of a communications network coupled to the RDMS.

### Claim 11 (depends on 10)

The RDMS of claim 10, wherein the operations further comprise:
in response to identifying the triggering event, monitoring the network condition of the communications network;
determining a change in the network condition of the communications network; and
reverting from the second communications mode to the first communications mode.

### Claim 12 (depends on 8)

The RDMS of claim 8, wherein identifying the triggering event further comprises:
detecting a shutdown process of the replication agent; and
in response to the shutdown process of the replication agent, determining the second replication mode as a replication mode for the RDMS.

### Claim 13 (depends on 8)

The RDMS of claim 8, wherein the triggering event is a first triggering event and the second replication mode is associated with a second triggering event, the operations further comprising:
detecting the second triggering event associated with the second replication mode; and
in response to the second triggering event, replicating the database change to the external replication component according to the second replication mode.

### Claim 14 (depends on 8)

The RDMS of claim 8, wherein determining the second replication mode further comprises transmitting a notification of the second replication mode to the external replication component.

### Claim 15

A machine-readable medium that stores instructions which, when performed by one or more processors of a machine, cause the machine to perform operations comprising:
determining a first replication mode associated with a replication agent;
identifying a triggering event;
determining that the triggering event indicates a change in the first replication mode of the replication agent;
responsive to determining that the triggering event indicates a change in the first replication mode, determining a second replication mode, the second replication mode being a different replication mode than the first replication mode;
in response to determining the triggering event, identifying a set of database tasks being processed in parallel, one or more database tasks of the set of database tasks being associated with a database change;
determining a task replication mode for at least one of the one or more database tasks;
replicating the database change to an external replication component according to the second replication mode; and
passing a notification to the one or more database tasks of the set of database tasks associated with the database change, the notification simulating the first replication mode regardless of receipt of confirmation from the external replication component.

### Claim 16 (depends on 15)

The machine-readable medium of claim 15, wherein the triggering event is identified in response to a network condition of a communications network coupled to the RDMS.

### Claim 17 (depends on 16)

The machine-readable medium of claim 16, wherein the operations further comprise:
in response to identifying the triggering event, monitoring the network condition of the communications network;
determining a change in the network condition of the communications network; and
reverting from the second communications mode to the first communications mode.

### Claim 18 (depends on 15)

The machine-readable medium of claim 15, wherein identifying the triggering event further comprises:
detecting a shutdown process of the replication agent; and
in response to the shutdown process of the replication agent, determining the second replication mode as a replication mode for the RDMS.

### Claim 19 (depends on 15)

The machine-readable medium of claim 15, wherein the triggering event is a first triggering event and the second replication mode is associated with a second triggering event, the operations further comprising:
detecting the second triggering event associated with the second replication mode; and
in response to the second triggering event, replicating the database change to the external replication component according to the second replication mode.

### Claim 20 (depends on 15)

The machine-readable medium of claim 15, wherein determining the second replication mode further comprises transmitting a notification of the second replication mode to the external replication component.
