Database system update method and related apparatus

Patent metadata

Field	Value
Publication number	US-12450213-B2
Application number	US-202418756014-A
Country	US
Kind code	B2
Filing date	Jun 27, 2024
Priority date	Dec 31, 2021
Publication date	Oct 21, 2025
Grant date	Oct 21, 2025

Abstract

This application discloses a database system update method, applied to a database including a first node, a second node, and a shared storage device. The method includes: The first node sends a first instruction to the second node, where the first instruction is used to request storage location information of first data in the shared storage device, and the first data is data transferred by the second node to the first node for processing; and the first node obtains first information sent by the second node, and obtains mapping information from the shared storage device based on the first information, where the mapping information indicates a storage location of the first data in the shared storage device. The method is used to improve update efficiency of the database system, and ensure that different nodes can simultaneously process different data in a shared storage device.

First claim

What is claimed is:

1. A method for updating a database system, comprising:
sending, by a first node, a first instruction to a second node, wherein the first instruction is used to request storage location information of first data in a shared storage device, and responsibility of processing the first data is transferred from the second node to the first node;
obtaining, by the first node, first information sent by the second node, wherein the first information indicates mapping information stored in the shared storage device, and the mapping information indicates a storage location of the first data in the shared storage device;
obtaining, by the first node, the mapping information from the shared storage device based on the first information; and
processing, by the first node, the first data in the shared storage device based on the mapping information.

2. The method of claim 1 , wherein the first node is a newly added node in the database system.

3. The method of claim 1 , wherein the second node is a to-be-deleted node in the database system.

4. The method of claim 1 , wherein the shared storage device comprises a plurality of slices respectively used to store different data, the mapping information comprises a first mapping table and a second mapping table, the first mapping table indicates a target slice in which the first data is stored in the shared storage device, and the second mapping table indicates a storage location of the first data in the target slice.

5. The method of claim 1 , further comprising:
obtaining, by the first node, an incremental log from the shared storage device, wherein the incremental log is generated by the second node in a period in which the first node obtains the mapping information, and the incremental log is used to record data update information in the shared storage device; and
updating, by the first node, the mapping information based on the incremental log.

6. The method of claim 5 , wherein the shared storage device comprises a plurality of slices respectively used to store different data, the incremental log comprises a plurality of pieces of log data respectively used to record data update information on different slices.

7. The method of claim 1 , further comprising:
storing, by the first node, the mapping information in a first zone in the shared storage device, wherein the first zone is in the shared storage device used to store data related to the first node; and
generating, by the first node, second information based on the first zone, wherein the second information indicates a storage location of the mapping information.

8. The method of claim 1 , wherein after the obtaining the mapping information from the shared storage device based on the first information, the method further comprises:
sending, by the first node, a second instruction to the second node, wherein the second instruction instructs the second node to delete mapping information related to the first data from the second node.

9. A first node, comprising:
a memory and a processor, wherein the memory stores instructions, which when executed by the processor, cause the processor to:
send a first instruction to a second node, wherein the first instruction is used to request storage location information of first data in a shared storage device, and responsibility of processing the first data is transferred from the second node to the first node;
obtain first information sent by the second node, wherein the first information indicates mapping information stored in the shared storage device, and the mapping information indicates a storage location of the first data in the shared storage device;
obtain the mapping information from the shared storage device based on the first information; and
process the first data in the shared storage device based on the mapping information.

10. The first node of claim 9 , wherein the first node is a newly added node in a database system.

11. The first node of claim 9 , wherein the second node is a to-be-deleted node in a database system.

12. The first node of claim 9 , wherein the shared storage device comprises a plurality of slices, the plurality of slices are respectively used to store different data, the mapping information comprises a first mapping table and a second mapping table, the first mapping table indicates a target slice in which the first data is stored in the shared storage device, and the second mapping table indicates a storage location of the first data in the target slice.

13. The first node of claim 9 , wherein the instructions, when executed, further cause the processor to:
obtain an incremental log from the shared storage device, wherein the incremental log is generated by the second node in a period in which the first node obtains the mapping information, and the incremental log is used to record data update information in the shared storage device; and
update the mapping information based on the incremental log.

14. The first node of claim 13 , wherein the shared storage device comprises a plurality of slices, the plurality of slices are respectively used to store different data, the incremental log comprises a plurality of pieces of log data, and the plurality of pieces of log data are respectively used to record data update information on different slices.

15. The first node of claim 9 , wherein the instructions, when executed, further cause the processor to:
store the mapping information in a first zone in the shared storage device, wherein the first zone is a zone that is in the shared storage device and that is used to store data related to the first node; and
generate second information based on the first zone, wherein the second information indicates a storage location of the mapping information.

16. The first node of claim 9 , wherein the instructions, when executed, method further cause the processor to:
send a second instruction to the second node, wherein the second instruction instructs the second node to delete mapping information related to the first data from the second node.

17. A non-transitory machine-readable storage medium storing instructions, which when executed by a first node, the first node is enabled to:
send a first instruction to a second node, wherein the first instruction is used to request storage location information of first data in a shared storage device, and responsibility of processing the first data is transferred from the second node to the first node;
obtain first information sent by the second node, wherein the first information indicates mapping information stored in the shared storage device, and the mapping information indicates a storage location of the first data in the shared storage device;
obtain the mapping information from the shared storage device based on the first information; and
process the first data in the shared storage device based on the mapping information.

18. The non-transitory machine-readable storage medium of claim 17 , wherein the first node is a newly added node in a database system.

19. The non-transitory machine-readable storage medium of claim 17 , wherein the second node is a to-be-deleted node in a database system.

20. The non-transitory machine-readable storage medium of claim 17 , wherein the shared storage device comprises a plurality of slices respectively used to store different data, the mapping information comprises a first mapping table and a second mapping table, the first mapping table indicates a target slice in which the first data is store

Assignees

• Huawei Tech Co Ltd

Inventors

• Zhang Qiong
• Cheng Wei
• Wang Biao
• Zhou Hanchen
• Li Xuli
• Chen Lening
• Li Lin
• Ma Chao
• Song Yihao

Classifications

• G06F16/278

  Data partitioning, e.g. horizontal or vertical partitioning · CPC title

• G06F16/2379

  Updates performed during online database operations; commit processing · CPC title

• G06F16/2358

  Change logging, detection, and notification (replication G06F16/27) · CPC title

• G06F16/214 Primary

  Database migration support · CPC title

• G06F16/176 Primary

  Support for shared access to files; File sharing support · CPC title