Database backup allocation method and device

A database and backup technology, applied in the directions of database distribution/replication, structured data retrieval, electronic digital data processing, etc., can solve problems that affect the stability of business systems, complicate backup methods, and affect business systems, so as to improve backup efficiency, Solve the effect of unstable business system performance

Inactive Publication Date: 2018-06-05
BEIJING SOHU NEW MEDIA INFORMATION TECH
View PDF5 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The diversity of MySQL versions and plug-in engine management complicate the backup method. Manually modifying backup scripts, adjusting system scheduling time and scheduling tasks is only suitable for a small number of database operation and maintenance environments. Relying on manual deployment and modification in large-scale data operation and maintenance makes the backup efficiency low; while the backup configuration provided by the central control scheduling backup is not rich, generally only provides backup methods and storage strategies, and then the scheduling system polls to initiate the backup. Backups will be initiated during business peak hours, which will affect the business system
It can be seen that the existing database backup deployment method will cause low backup efficiency and affect the stability of the business system

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0040] see figure 1 It is a schematic flowchart of a database backup deployment method provided in Embodiment 1 of the present invention, and the method may include the following steps:

[0041] S11. Generate a backup strategy according to the IP information of the server to be backed up and the version information of the database to be backed up;

[0042] Specifically, the version and engine information of the database are obtained by reading the back-end database, and at the same time, a backup strategy is generated based on the IP (Internet Protocol, a protocol for interconnection between networks) information of the server to be deployed. The backup strategy includes the backup data storage server, the backup data storage strategy, whether to encrypt, the backup type, the role selection of the database where the backup is located, etc., and is deployed to the server where the database is located through the scheduling system. That is, the final backup strategy is deployed...

Embodiment 2

[0062] Corresponding to the database backup deployment method disclosed in Embodiment 1 of the present invention, Embodiment 2 of the present invention also provides a database backup deployment device, see figure 2 , the device consists of:

[0063] Generating module 1, is used for generating backup policy according to the IP information of the deployment server to be backed up and the version information of the database to be backed up;

[0064] The judging module 2 is used to analyze the type of the database to be backed up, and judge whether to perform backup in the backup database according to the backup strategy, and if so, perform backup in the database to be backed up;

[0065] The backup module 3 is used to judge whether the load of the server to be deployed for backup meets the preset backup threshold, if so, back up the data of the database to be backed up according to the backup strategy, and store the obtained backup data to store.

[0066] Correspondingly, it ...

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 allocation method and a database backup allocation device. The method includes steps of generating a backup strategy according to IP information of a to-be-backup allocation server and to-be-backup database edition information; analyzing the type of the to-be-backup database and judging if the backup is performed in the backup database according to the backup strategy; if it is, performing backup at the to-be-backup database; judging if the server load of the to-be-backup allocation server can meet the preset backup threshold value; if it is, performing backup on the data of the to-be-backup database according to the backup strategy, and storing the acquired backup data. Through the method and the device, the database backup efficiency is improvedand the stability of a business system is guaranteed.

Description

technical field [0001] The invention relates to the technical field of backup, in particular to a database backup deployment method and device. Background technique [0002] The open source databases currently used by Internet companies are MySQL and the corresponding branch versions Percona or MariaDB. MySQL is a relational database management system. It adopts a dual authorization policy and is divided into community edition and commercial edition. Due to its small size, fast speed and low total cost of ownership, especially the open source feature, it is generally recommended for small and medium-sized websites. The development chooses MySQL as the website database. There are multiple branch versions of MySQL, such as Percona and MariaDB. MySQL supports multiple storage engines, which is also one of the key advantages of the MySQL architecture, but using different database versions and using different storage engines will bring about the complexity of backup, and there ...

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): G06F17/30G06F11/14
CPCG06F11/1458G06F16/27
Inventor 李志新
Owner BEIJING SOHU NEW MEDIA INFORMATION TECH
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