Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data storage method, device and equipment and storage medium

A data storage and data backup technology, which is applied in digital data processing, redundancy in computing, data error detection, response error generation, etc. The database cannot be rejoined, etc., to prevent data storage inconsistency and improve robustness

Active Publication Date: 2019-12-06
SHANGHAI DAMENG DATABASE
View PDF8 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, when the primary database fails before sending redo logs to the backup database, the data in the faulty database is not synchronized to the backup database in time because the backup database is switched to the primary database. For data that does not exist in other databases in the read-write separation database cluster, the faulty primary database cannot be rejoined to the read-write separation database cluster, resulting in the splitting of the read-write separation cluster database

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 storage method, device and equipment and storage medium
  • Data storage method, device and equipment and storage medium
  • Data storage method, device and equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0027] figure 1 It is a flow chart of the steps of a data storage method provided by Embodiment 1 of the present invention. This embodiment is applicable to the case of data storage in a database cluster with read-write separation. The method can be executed by a data storage device, and the device can use hardware and / or software, see figure 1 , the embodiment of the present invention specifically includes the following steps:

[0028] Step 101. Send redo logs to the backup database, and determine the log sequence number of the redo logs, so that the backup database performs data backup based on the redo logs.

[0029] Among them, the backup database can be the backup database in the read-write separation database cluster. The backup database can back up data according to the log sent by the main database to maintain the consistency of the backup database and the main database data. The redo log can be the backup data for data backup. The redo log can include data operation...

Embodiment 2

[0043] figure 2 It is a flow chart of the steps of a data storage method provided by Embodiment 2 of the present invention. The embodiment of the present invention is based on the embodiment of the above invention. See figure 2 , the method of the embodiment of the present invention includes:

[0044] Step 201, sending the redo log to the backup database, and obtaining the record sequence number of each record information in the redo log.

[0045] Wherein, the record information can be the information of the operation record in the redo log, and the record information can specifically be the operation record formed by the data operation of the main database, the record number can be the sequence number of the corresponding operation record in the redo log, each The operation records can correspond to their respective record serial numbers.

[0046] Specifically, in the read-write separation database, the primary database can send redo logs to the backup database, and can r...

Embodiment 3

[0073] Figure 5It is a schematic structural diagram of a data storage device provided in Embodiment 3 of the present invention. The data storage device provided in the embodiment of the present invention can execute the data storage method provided in any embodiment of the present invention, and has corresponding functional modules and beneficial effects for executing the method . The device can be implemented by software and / or hardware, and specifically includes: a log sending module 301 , an information receiving module 302 and a data page brushing module 303 .

[0074] Wherein, the log sending module 301 is configured to send the redo log to the backup database, and determine the log sequence number of the redo log, so that the backup database performs data backup based on the redo log.

[0075] The information receiving module 302 is configured to receive execution feedback information after the backup database executes data backup.

[0076] The data page flush module ...

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 storage method, device and equipment and a storage medium. The method comprises the following steps: sending a redo log to a backup database, and determining a log serial number of the redo log, so that the backup database performs data backup based on the redo log; receiving execution feedback information after the backup database executes data backup; and refreshing the target data page corresponding to the log sequence number according to the execution feedback information. According to the technical scheme provided by the embodiment of the invention, after the backup database backs up the data according to the redo log, the main database writes the data page corresponding to the redo log, so that the data storage consistency of the main database and the backup database in the read-write separation database cluster is kept, the database storage safety is improved, and the robustness of the read-write separation database cluster can be improved.

Description

technical field [0001] The embodiments of the present invention relate to the field of computer application technologies, and in particular, to a data storage method, device, device, and storage medium. Background technique [0002] The execution times of read-only operations such as queries in database application systems are much higher than the execution times of data modification operations such as adding, deleting, and modifying. In order to improve the performance of the database system, a large number of database products have introduced read-write separation database clusters. The main database provides complete database functions, and the backup data provides read-only query operations. Through middleware or database interfaces, read-only operations are automatically distributed to the backup. Data execution, using the hardware resources of backup data to reduce the concurrent access pressure of the main database, thereby improving the data throughput of the databas...

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/14
CPCG06F11/1448G06F11/1471G06F11/1469
Inventor 王海龙蔡池池韩朱忠
Owner SHANGHAI DAMENG DATABASE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products