Data page management method and device, electronic equipment and storage medium

A data page and database technology, applied in the computer field, can solve problems such as reducing the efficiency of fault processing and large invalid IO

Pending Publication Date: 2021-02-23
SHANGHAI DAMENG DATABASE
View PDF5 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the method of directly reading the data pages in the disk and comparing the LSN may generate a large number of invalid IOs and reduce the efficiency of fault handling.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Data page management method and device, electronic equipment and storage medium
  • Data page management method and device, electronic equipment and storage medium
  • Data page management method and device, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0046] figure 1 It is a flow chart of a data page management method provided by Embodiment 1 of the present invention. This embodiment is applicable to situations where data pages in the remaining active nodes need to be managed when a node in a shared storage database cluster fails. The method can It is executed by a data page management device, which can be implemented in a software / hardware manner, and can be specifically inherited from an electronic device with storage and computing capabilities for data page management.

[0047] Such as figure 1 As shown, a data page management method is provided, which is applied to an active node in a shared storage database cluster, and the method specifically includes the following steps:

[0048] Step S110, write the first local data page information in the current active node that cannot be determined valid according to the external global array and the external local array into the first undetermined array, the external global arr...

Embodiment 2

[0086] figure 2 It is a flowchart of a data page management method provided by Embodiment 2 of the present invention. The technical solution of this embodiment is further refined on the basis of the above-mentioned technical solution, and specifically mainly includes the following steps:

[0087] Step S210, write the first local data page information in the current active node that cannot be determined valid according to the external global array and the external local array into the first undetermined array, the external global array is the global data page information of other active nodes, so The external local array is the local data page information of other active nodes, until the first undetermined array of all active nodes is obtained;

[0088] In the embodiment of the present invention, when the validity of the first local data page information in the current active node cannot be determined according to the external global array and the external local array, the fi...

Embodiment 3

[0096] image 3 It is a flowchart of a data page management method provided by Embodiment 2 of the present invention. The technical solution of this embodiment is further refined on the basis of the above-mentioned technical solution, and specifically mainly includes the following steps:

[0097] Step S310, write the first local data page information in the current active node that cannot be determined valid according to the external global array and the external local array into the first undetermined array, the external global array is the global data page information of other active nodes, so The external local array is the local data page information of other active nodes, until the first undetermined array of all active nodes is obtained;

[0098] Step S320, correspondingly select the data page information corresponding to the latest log sequence number greater than the latest log sequence number of the first local data page information in the current active node from th...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a data page management method and device, electronic equipment and a storage medium. The method and the device are applied to active nodes in a shared storage database cluster,and the method comprises the steps of writing first local data page information which cannot be determined to be effective according to an external global array and an external local array in currentactive nodes into a first to-be-determined array until the first to-be-determined array of all the active nodes is obtained; according to the first to-be-determined arrays of the other active nodes,determining a data page which is modified in the first to-be-determined array of the current active node and of which the latest data page serial number is greater than or equal to a data page log serial number in a disk of a shared storage database cluster as a target local data page of the current active node; and the destination local data page of each active node responding to the instance program access of the shared storage database cluster. According to the embodiment of the invention, a large number of invalid IOs in the process of determining whether the data page in the active node cache is latest are reduced, and the fault processing efficiency is improved.

Description

technical field [0001] Embodiments of the present invention relate to data management technologies in the field of computer technology, and in particular, to a data page management method, device, electronic equipment, and storage medium. Background technique [0002] In a shared storage database cluster environment, the same data page may be distributed in the caches of different database instance nodes, and there is no guarantee that the content of the data page in the caches of each node is exactly the same. The latest data is only stored in the caches of some nodes, and other nodes What is stored in the cache is a historical version of the data page. The shared storage database cluster environment uses Global Buffer Server (GBS) and Local Buffer Server (LBS) to complete access control to data pages. REDO log is an important means to deal with system failure recovery in database management system. The log sequence number (Log Sequence Number, LSN) is an incremental valu...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F11/20G06F16/21G06F16/27
CPCG06F11/2035G06F11/2023G06F16/21G06F16/27G06F2201/80Y02D10/00
Inventor 韩朱忠王巍
Owner SHANGHAI DAMENG DATABASE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap