Unlock instant, AI-driven research and patent intelligence for your innovation.

Method and system for realizing free recovery of MySQL data

A data-free technology, applied in the blockchain field, can solve problems such as difficulty, complex binlog, time-consuming, etc., to achieve the effect of free recovery, fast and efficient data recovery

Pending Publication Date: 2021-09-03
SHANGHAI WANXIANG BLOCK CHAIN CO LTD
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The pain point of this traditional solution is that if the user only wants to restore the data of the specified database within the specified time period, and discard some unnecessary databases, it will be very difficult and time-consuming
[0004] There are too many libraries in a database, and the user data is too complicated. During the data restoration process, when you only want to quickly restore the data of some libraries, it is too complicated to use the traditional binlog

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
  • Method and system for realizing free recovery of MySQL data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0035] According to a kind of method that realizes the free recovery of MySQL data provided by the present invention, comprising:

[0036] Step S1: use canal as the slave database to read the binlog log of the master database in real time;

[0037] Step S2: Write the data read by canal into the message queue kafka;

[0038] Step S3: Read the data in the message queue kafka and write it into the text database mongodb to avoid data loss caused by excessive data flow or downtime of the main database;

[0039] Step S4: By using the text database mongodb, you can freely choose the database you want to restore, and freely restore the data in the specified time period.

[0040] The text database mongodb is a full amount of data, which can restore all or part of the data.

[0041] There are too many libraries in a database, and the user data is too complex. During the data restoration process, when you only want to quickly restore the data of some libraries, it is too complicated to...

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 provides a method and a system for realizing free recovery of MySQL data. The method comprises the following steps: S1, reading a binlog of a master database in real time by taking a canal as a slave database; s2, writing the data read by the canal into a message queue kafka; s3, reading data in the message queue kafka and writing the data into a text type database mongodb; and S4, recovering the data in the preset time period and / or the preset database by utilizing the text database mongodb. According to the method, the data backup service is combined with the use of a data recovery tool, so that the data which the user wants to recover can be quickly, efficiently, conveniently and freely recovered in the data recovery process.

Description

technical field [0001] The present invention relates to the technical field of blockchain, in particular, to a method and system for realizing free recovery of MySQL data, and more specifically, to a method for realizing free recovery of MySQL data based on canal, kafka, and MongoDB. Background technique [0002] The traditional method of restoring MySQL data through binlog requires a full backup of the database and the binlog logs generated after the full backup, which are also fully restored during the database recovery process. [0003] The pain point of this traditional solution is that if the user only wants to restore the data of the specified database within a specified period of time, and discard some unnecessary databases, it will be very difficult and time-consuming. [0004] There are too many libraries in a database, and the user data is too complex. During the data restoration process, when you only want to quickly restore the data of some libraries, it is too c...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F11/14G06F16/28
CPCG06F11/1448G06F11/1458G06F16/284
Inventor 李桂林蒋威畅威威张凡
Owner SHANGHAI WANXIANG BLOCK CHAIN CO LTD