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

A method and device for fast recovery of mysql data based on oracle

A data and database technology, applied in the information field, can solve the problems of time consumption, troublesome recovery, and no flashback function.

Active Publication Date: 2020-10-20
SUZHOU METABRAIN INTELLIGENT TECH CO LTD
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] During the operation of the MySQL database, if you accidentally delete a table or certain rows, because mysql does not have the flashback function, it is still troublesome to restore, you need to use the corresponding backup, and analyze the corresponding binary file on the basis of the backup Log files, until the data is restored to the time point before the accidental deletion operation, this process needs to judge the time point of backup and binlog, which will consume a lot of time and may cause certain data loss problems

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
  • A method and device for fast recovery of mysql data based on oracle
  • A method and device for fast recovery of mysql data based on oracle

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following will briefly introduce the accompanying drawings that need to be used in the embodiments. Obviously, the accompanying drawings in the following description are only some embodiments of the present invention. For Those of ordinary skill in the art can also obtain other drawings based on these drawings without making creative efforts.

[0035] see figure 1 , the present invention provides a device for realizing MySQL data recovery based on Oracle, such as figure 1 As shown, the device for implementing MySQL data recovery based on Oracle includes one or more master servers 1 , one or more slave servers 2 corresponding to the one or more master servers, and a data recovery server 3 .

[0036] Wherein, MySQL database 11 is correspondingly deployed on one or more master servers 1 for use by client application systems.

[0037]Wherein, one or more slave serv...

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 brings forward a method and device for quick recovery of MySQL Data based on Oracle. Thanks to the strong data flash-back function of the Oracle database, quick data recovery can be realized under the case of error in data due to mis-deletion or mis-operation of the MySQL database. The system configuration which comprises a main server and a data recovery server is simple; the data recovery flow is simple and easy to execute; for the construction of data management system, the development cost is saved and the use is simple, the operation is convenient. The data recovery system has strong stability and high security.

Description

technical field [0001] The invention relates to the field of information technology, in particular to a method and device for realizing rapid data recovery. Background technique [0002] Database (Database) is a warehouse that organizes, stores and manages data according to the data structure. It was produced more than 60 years ago. With the development of information technology and the market, especially after the 1990s, data management It is no longer just storing and managing data, but has transformed into various data management methods that users need. There are many types of databases, ranging from the simplest tables storing various data to large database systems capable of storing massive amounts of data, which have been widely used in various aspects. [0003] MySQL is an open source relational database management system (RDBMS). The MySQL database system uses the most commonly used database management language - Structured Query Language (SQL) for database managem...

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 Patents(China)
IPC IPC(8): G06F16/28G06F16/25
CPCG06F16/25G06F16/284
Inventor 范红飞
Owner SUZHOU METABRAIN INTELLIGENT TECH CO LTD