# US 2019/0317872 A1 · Database cluster architecture based on dual port solid state disk

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

- Number: US 2019/0317872 A1
- Document ID: US20190317872A1
- Status: Published application
- Kind: A1
- Application number: 16/455,087
- Filed: 2019-06-27
- Published: 2019-10-17
- Earliest claimed: 2014-05-30
- Assignees: Huawei Technologies Co., Ltd.
- Applicants: Huawei Technologies Co., Ltd.
- Inventors: Wei YU; Huijun LIU
- Web page: https://patentgrep.com/patent/US20190317872A1

## CPC

- G06F 11/2094: {Redundant storage or storage space (G06F11/2056 takes precedence)}
- G06F 3/0619: {in relation to data integrity, e.g. data losses, bit errors}
- G06F 3/064: {Management of blocks}
- G06F 3/065: {Replication mechanisms}
- G06F 3/067: {Distributed or networked storage systems, e.g. storage area networks [SAN], network attached storage [NAS]}
- G06F 3/0688: {Non-volatile semiconductor memory arrays}
- G06F 11/202: {where processing functionality is redundant (redundant communication control functionality G06F11/2005, redundant storage control functionality G06F11/2089)}
- G06F 11/2023: {Failover techniques}
- G06F 11/2046: {where the redundant components share persistent storage (G06F11/2043 takes precedence)}
- G06F 16/00: Information retrieval; Database structures therefor; File system structures therefor
- G06F 16/113: {Details of archiving (lifecycle management in storage systems G06F3/0649; point-in-time backing up or restoration of persistent data G06F11/1446)}
- G06F 16/1734: {Details of monitoring file system events, e.g. by the use of hooks, filter drivers, logs}
- G06F 11/1471: involving logging of persistent data for recovery
- G06F 2201/80: Database-specific techniques
- G06F 2201/805: Real-time
- G06F 2201/82: Solving problems relating to consistency
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A database cluster architecture based on dual port solid state disk (SSD) is disclosed. The database cluster including a plurality of nodes and a plurality of dual port solid state disks (SSDs). Each dual port SSD of the plurality of dual port SSDs is connected to a unique pair of nodes and each node in the unique pair of nodes is connected to a unique pair of dual port SSDs. A first node of the plurality of nodes writes a transaction log to a first dual port SSD, a second node connected to the first dual port SSD acquires the transaction log from the first dual port SSD and operates a database process to recover data according to the transaction log when the first node crashes.

## Claims

### Claim 1

A data management method for a database cluster comprising a plurality of nodes, wherein the method comprises:
writing, by a first node of the plurality of nodes, a transaction log to a first dual port SSD of a plurality of dual port solid state disks (SSDs), wherein each dual port SSD of the plurality of dual port SSDs is connected to a unique pair of nodes and each node in the unique pair of nodes is connected to a unique pair of dual port SSDs;
acquiring, by a second node, the transaction log from the first dual port SSD when the first node crashes, wherein one port of the first dual port SSD is connected to the first node, and another port of the first dual port SSD is connect to the second node;
operating, by the second node, a database process to recover data according to the transaction log, the recovered data is data stored in the first node before the first node crashes.

### Claim 2 (depends on 1)

The method of claim 1, wherein the transaction log stores data generated by a first database process at the first node after a checkpoint.

### Claim 3 (depends on 1)

The method of claim 1, wherein the method further comprises:
acquiring, by the first node in a preset period, a transaction log that is after a checkpoint of the first dual port SSD, and archiving, into a shared disk array, the transaction log that is after the checkpoint.

### Claim 4 (depends on 3)

The method of claim 3, wherein at least one port in the first dual port SSD is a PCIE port.

### Claim 5 (depends on 1)

The method of claim 1, wherein the database process at the second node is independent of an original database process at the second node.

### Claim 6

A data management method for a database cluster comprising a plurality of nodes, wherein the method comprises:
writing, by a first node of the plurality of nodes, a transaction log to a first dual port SSD of a plurality of dual port solid state disks (SSDs), wherein each dual port SSD of the plurality of dual port SSDs is connected to a unique pair of nodes and each node in the unique pair of nodes is connected to a unique pair of dual port SSDs;
acquiring, by a second node, the transaction log from the first dual port SSD when the first node crashes, wherein one port of the first dual port SSD is connected to the first node, and another port of the first dual port SSD is connect to the second node;
sending, by the second node, the transaction log to a third node connected to a second dual port SSD, wherein one port of the second dual port SSD is connected to the second node, and another port of the second dual port SSD is connect to the third node;
operating, by the third node, a database process to recover data according to the transaction log, the recovered data is data stored in the first node before the first node crashes.

### Claim 7 (depends on 6)

The method of claim 6, wherein the transaction log stores data generated by a first database process at the first node after a checkpoint.

### Claim 8 (depends on 6)

The method of claim 6, wherein the method further comprises:
acquiring, by the first node in a preset period, a transaction log that is after a checkpoint of the first dual port SSD, and archiving, into a shared disk array, the transaction log that is after the checkpoint.

### Claim 9 (depends on 6)

The method of claim 6, wherein at least one port in the first dual port SSD is a PCIE port, and at least one port in the second dual port SSD is a PCIE port.

### Claim 10 (depends on 6)

The method of claim 6, wherein the database process at the third node is independent of an original database process at the third node.

### Claim 11

A data management system, comprising: a plurality of nodes and a plurality of dual port solid state disks (SSDs), wherein each dual port SSD of the plurality of dual port SSDs is connected to a unique pair of nodes and each node in the unique pair of nodes is connected to a unique pair of dual port SSDs;
wherein a first node of the plurality of nodes is configured to write a transaction log to a first dual port SSD of a plurality of dual port SSDs;
a second node of the plurality of nodes is configured to acquire the transaction log from the first dual port SSD when the first node crashes, and operate a database process to recover data according to the transaction log, wherein one port of the first dual port SSD is connected to the first node, and another port of the first dual port SSD is connect to the second node, and wherein the recovered data is data stored in the first node before the first node crashes.

### Claim 12 (depends on 11)

The system of claim 11, wherein the transaction log stores data generated by a first database process at the first node after a checkpoint.

### Claim 13 (depends on 11)

The system of claim 11, wherein the first node is further configured to:
acquire, in a preset period, a transaction log that is after a checkpoint of the first dual port SSD; and
archive, into a shared disk array, the transaction log that is after the checkpoint.

### Claim 14 (depends on 13)

The system of claim 13, wherein the first node is further configured to:
directly perform data transmission with the second node by using the first dual port SSD.

### Claim 15 (depends on 14)

The system of claim 14, wherein at least one port in the first dual port SSD is a PCIE port.

### Claim 16 (depends on 11)

The system of claim 11, wherein the database process at the second node is independent of an original database process at the second node.

### Claim 17 (depends on 13)

The system of claim 13, wherein a third node of the plurality of nodes is configured to obtain the transaction log from the second node, and operate a database process to recover data according to the transaction log, wherein one port of a second dual port SSD is connected to the second node, and another port of the second dual port SSD is connect to the third node.
