Continuous data protection method, system, device and medium for database

A data protection and database technology, applied in the database field, can solve problems such as slow recovery time and data loss, and achieve the effect of continuous data protection

Active Publication Date: 2021-08-06
UCLOUD TECH CO LTD
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the recovery time of this method is also slow, and only the database at a specific snapshot time can be retrieved, rather than the database before the failure, so it may cause unnecessary data loss for users

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
  • Continuous data protection method, system, device and medium for database
  • Continuous data protection method, system, device and medium for database
  • Continuous data protection method, system, device and medium for database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0046] In order to make the purpose and technical solutions of the embodiments of the present invention more clear, the technical solutions of the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings of the embodiments of the present invention. Apparently, the described embodiments are some, not all, embodiments of the present invention. Based on the described embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts shall fall within the protection scope of the present invention.

[0047] According to an embodiment of the present invention, an embodiment of a continuous data protection method for a database is provided. It should be noted that the steps shown in the flow chart of the accompanying drawings can be executed in a computer system such as a set of computer-executable instructions, Also, although a logical order is shown in the ...

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 particularly relates to a continuous data protection method, system, device and medium of a database. The database includes a first database and a second database, the first database is visible to users, the second database is invisible to users, the second database delays the replication of the first database, the first database is the first database at the first time, and the second database is The first database at the second time, the second time is delayed by a predetermined period of time than the first time, the method includes: receiving an instruction to retrieve the first database at the third time; according to the instruction to retrieve the first database at the third time, updating The second database, the updated second database is the first database at the third time, the third time is between the first time and the second time; switch the updated second database to be visible to users, or make the updated The second database of the database is switched to the new first database. The present invention can realize the purpose of continuous data protection under the scene of database misoperation or database damage.

Description

technical field [0001] The invention relates to the database field, in particular to a database continuous data protection method, system, equipment and medium. Background technique [0002] At present, in the case of database misoperation or database damage, in order to retrieve the previous database, the industry usually adopts the following three methods: [0003] The first is to perform a full cold backup of the database, combined with incremental logs, and retrieve the previous database through a rollback operation. However, this method needs to update the backup database from the full cold standby time to the time before the failure occurs, and the recovery time is relatively slow. [0004] The second is to flash back the database through the reverse operation to retrieve the previous database. However, this method has restrictions on the operation type of the database. For example, if the operation type of the database is a DDL operation, since the DDL operation doe...

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): G06F11/14
CPCG06F11/1448
Inventor 罗成对宋志强丁顺
Owner UCLOUD TECH CO LTD
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