Database backup method and device

A database and backup technology, applied in the Internet field, can solve problems such as database performance degradation and mutual influence, and achieve the effect of preventing mutual conflicts and improving performance

Active Publication Date: 2019-07-23
BEIJING GRIDSUM TECH CO LTD
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The embodiment of the present invention provides a database backup method and device to at least solve the problem in the related art that the database backup operation cannot be interrupted once the database backup operation starts and the database backup operation and normal read and write operations will affect each other, resulting in a decline in database performance. technical issues

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
  • Database backup method and device
  • Database backup method and device
  • Database backup method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0023] According to an embodiment of the present invention, a method embodiment of a database backup method 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, and , although a logical order is shown in the flowcharts, in some cases the steps shown or described may be performed in an order different from that shown or described herein.

[0024] figure 1 is a flow chart of a database backup method according to an embodiment of the present invention, such as figure 1 As shown, the method includes the following steps:

[0025] Step S102, detecting the usage of the database at the current moment, and obtaining the detection result of the usage of the database;

[0026] Step S104, selecting a corresponding database backup method according to the obtained detection result of the database usage;

[0027] In step S106, the database is backed up acc...

Embodiment 2

[0054] According to an embodiment of the present invention, a device embodiment of a database backup device is provided.

[0055] figure 2 is a schematic diagram of an optional database backup device according to an embodiment of the present invention, such as figure 2 As shown, the device includes: a first detection unit 202, configured to detect the usage status of the database at the current moment, and obtain the database usage detection result; a selection unit 204, used to select the corresponding database according to the obtained database usage detection result Backup mode: the first backup unit 206 is configured to back up the database according to the selected corresponding database backup mode.

[0056] The usage of the database mainly includes: the busy state when the database is frequently used, and the idle state when the database is basically not used. Further, the idle state may further include: random events use a random state of the database. In the rand...

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 database backup method and device. The method comprises the steps of detecting use condition of a database at a current moment, thereby obtaining a database use condition detection result; selecting a corresponding database backup mode according to the obtained database use condition detection result; and backing up the database according to the selected corresponding database backup mode. According to the method and the device, the technical problem that in related technologies, a backup operation and a normal read / write operation of the database are influenced mutually, thereby reducing the performance of the database, due to the fact that the database backup operation cannot be interrupted once the operation is started is solved.

Description

technical field [0001] The invention relates to the field of the Internet, in particular to a database backup method and device. Background technique [0002] Industries such as the Internet and finance have high requirements for data reliability. If data is lost due to unexpected downtime, the loss will be very heavy. For this reason, database administrators need to formulate detailed database backup strategies according to specific business requirements. [0003] In the related art, a technical solution for periodically performing a complete backup operation (ie, a full backup operation) on a database is provided. For example, a weekly or monthly full backup of the database. Usually, each full backup is a full copy of all data and applications in the database starting from a certain point in time. In practical applications, a disk is generally used to fully back up the entire system, including the backup system itself and all data. The biggest advantage of this backup ...

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/27G06F11/14
CPCG06F11/1448G06F16/27
Inventor 刘凯
Owner BEIJING GRIDSUM 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

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