# US 2023/0409599 A1 · Scale-out of database systems in cloud computing environments

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

- Number: US 2023/0409599 A1
- Document ID: US20230409599A1
- Status: Published application
- Kind: A1
- Application number: 17/747,123
- Filed: 2022-05-18
- Published: 2023-12-21
- Earliest claimed: 2022-05-18
- Assignees: Sap SE
- Applicants: Sap SE
- Inventors: De-Li Xu; Zhi-peng Dong
- Web page: https://patentgrep.com/patent/US20230409599A1

## CPC

- G06F 16/273: {Asynchronous replication or reconciliation}
- G06F 16/2379: {Updates performed during online database operations; commit processing}
- H04L 67/1097: for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS]
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- H04L: TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION (arrangements common to telegraphic and telephonic communication H04M)

## Abstract

Methods, systems, and computer-readable storage media for providing a first instance of a database system within the cloud computing environment, determining that scale out of the database system is to be executed, and in response, providing a second instance of the database system within the cloud computing environment, the first instance and the second instance collectively defining a cluster, establish a remote direct memory access (RDMA) connection between the first instance and the second instance, copying data stored within the first instance to a data store of the second instance over the RDMA connection, and configuring the first instance to replicate a first transaction log to the second instance over the RDMA connection, and receiving, by each of the first instance and the second instance, requests from one or more client devices.

## Claims

### Claim 1

A computer-implemented method for scaling of a system executed within a cloud computing environment, the method being executed by one or more processors and comprising:
providing a first instance of a database system within the cloud computing environment;
determining that scale out of the database system is to be executed, and in response:
providing a second instance of the database system within the cloud computing environment, the first instance and the second instance collectively defining a cluster,
establish a remote direct memory access (RDMA) connection between the first instance and the second instance,
copying data stored within the first instance to a data store of the second instance over the RDMA connection, and
configuring the first instance to replicate a first transaction log to the second instance over the RDMA connection; and
receiving, by each of the first instance and the second instance, requests from one or more client devices.

### Claim 2 (depends on 1)

The method of claim 1, wherein the first instance replicates the first transaction log to the second instance in response to completion of a transaction within the first instance.

### Claim 3 (depends on 2)

The method of claim 2, wherein the transaction comprises at least one write operation.

### Claim 4 (depends on 1)

The method of claim 1, further comprising configuring the second instance to replicate a second transaction log to the first instance over the RDMA connection.

### Claim 5 (depends on 1)

The method of claim 1, further comprising:
determining that scale in of the database system is to be executed, and in response:
setting the second instance to an offline status,
completing one or more transactions,
migrating one or more connections of one or more client devices from the second instance to the first instance, and
executing a shutdown of the second instance.

### Claim 6 (depends on 5)

The method of claim 5, further comprising stopping replication of the first transaction log to the second instance.

### Claim 7 (depends on 5)

The method of claim 5, further comprising replicating a second transaction log of the second instance to the first instance after completion of the one or more transactions.

### Claim 8

A non-transitory computer-readable storage medium coupled to one or more processors and having instructions stored thereon which, when executed by the one or more processors, cause the one or more processors to perform operations for scaling of a system executed within a cloud computing environment, the operations comprising:
providing a first instance of a database system within the cloud computing environment;
determining that scale out of the database system is to be executed, and in response:
providing a second instance of the database system within the cloud computing environment, the first instance and the second instance collectively defining a cluster,
establish a remote direct memory access (RDMA) connection between the first instance and the second instance,
copying data stored within the first instance to a data store of the second instance over the RDMA connection, and
configuring the first instance to replicate a first transaction log to the second instance over the RDMA connection; and
receiving, by each of the first instance and the second instance, requests from one or more client devices.

### Claim 9 (depends on 8)

The non-transitory computer-readable storage medium of claim 8, wherein the first instance replicates the first transaction log to the second instance in response to completion of a transaction within the first instance.

### Claim 10 (depends on 9)

The non-transitory computer-readable storage medium of claim 9, wherein the transaction comprises at least one write operation.

### Claim 11 (depends on 8)

The non-transitory computer-readable storage medium of claim 8, wherein operations further comprise configuring the second instance to replicate a second transaction log to the first instance over the RDMA connection.

### Claim 12 (depends on 8)

The non-transitory computer-readable storage medium of claim 8, wherein operations further comprise:
determining that scale in of the database system is to be executed, and in response:
setting the second instance to an offline status,
completing one or more transactions,
migrating one or more connections of one or more client devices from the second instance to the first instance, and
executing a shutdown of the second instance.

### Claim 13 (depends on 12)

The non-transitory computer-readable storage medium of claim 12, wherein operations further comprise stopping replication of the first transaction log to the second instance.

### Claim 14 (depends on 12)

The non-transitory computer-readable storage medium of claim 12, wherein operations further comprise replicating a second transaction log of the second instance to the first instance after completion of the one or more transactions.

### Claim 15

A system, comprising:
a computing device; and
a computer-readable storage device coupled to the computing device and having instructions stored thereon which, when executed by the computing device, cause the computing device to perform operations for scaling of a system executed within a cloud computing environment, the operations comprising:
providing a first instance of a database system within the cloud computing environment;
determining that scale out of the database system is to be executed, and in response:
providing a second instance of the database system within the cloud computing environment, the first instance and the second instance collectively defining a cluster,
establish a remote direct memory access (RDMA) connection between the first instance and the second instance,
copying data stored within the first instance to a data store of the second instance over the RDMA connection, and
configuring the first instance to replicate a first transaction log to the second instance over the RDMA connection; and
receiving, by each of the first instance and the second instance, requests from one or more client devices.

### Claim 16 (depends on 15)

The system of claim 15, wherein the first instance replicates the first transaction log to the second instance in response to completion of a transaction within the first instance.

### Claim 17 (depends on 16)

The system of claim 16, wherein the transaction comprises at least one write operation.

### Claim 18 (depends on 15)

The system of claim 15, wherein operations further comprise configuring the second instance to replicate a second transaction log to the first instance over the RDMA connection.

### Claim 19 (depends on 15)

The system of claim 15, wherein operations further comprise:
determining that scale in of the database system is to be executed, and in response:
setting the second instance to an offline status,
completing one or more transactions,
migrating one or more connections of one or more client devices from the second instance to the first instance, and
executing a shutdown of the second instance.

### Claim 20 (depends on 19)

The system of claim 19, wherein operations further comprise stopping replication of the first transaction log to the second instance.
