Method for setting database backup strategy by autonomous learning
A backup strategy, self-learning technology, applied in the redundant operation of data error detection, digital data processing, response to error generation, etc., can solve the problem of increasing the complexity of database backup and the high technical requirements of operation and maintenance personnel. , high requirements for operators, to achieve the effect of easy deployment, avoid system resource occupation, and improve flexibility
Active Publication Date: 2020-10-09
厦门靠谱云股份有限公司
View PDF15 Cites 3 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0003] At present, there are many types of databases involved, including common relational databases, cache databases, and many non-relational databases, such as document databases, sequential databases, etc. The backup methods used by each type of database are also different. It increases the complexity of database backup, and has higher requirements for operators.
[0004] Each type of database backup strategy is different, and most backup strategy settings can only be set based on the experience of operation and maintenance personnel, which requires high technical requirements for operation and maintenance personnel, complicated operations, and poor applicability
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0027] The present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.
[0028] The invention provides a method for self-learning and setting database backup strategy, such as figure 1 shown, including the following steps:
[0029] S1) Backup strategy initialization: the operation and maintenance platform pushes the backup client program and the initial backup strategy to the target device; the backup client program is deployed on the target device, and the initial backup strategy is the default backup strategy for database backup.
[0030] The initial backup policy file is as follows:
[0031] [backup]
[0032] gid = 61dkvrfx # Group number, operation and maintenance platform identification
[0033] start_at = 00:01 # Backup default start time
[0034] cpu_limit = 35 # cpu usage
[0035] memory_limit = 45 # memory usage
[0036] diskio_limit = 55 # disk iops usage
[0037] qps_limit = 65 # QPS utiliz...
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
Login to View More Abstract
The invention relates to a method for setting a database backup strategy through autonomous learning. The method comprises the following steps: S1) an operation and maintenance platform pushes a backup client program and an initial backup strategy to target equipment, the backup client program is deployed on the target equipment, and the initial backup strategy serves as a default backup strategyof database backup; S2) the backup client program collects monitoring data of load parameters of the target equipment, calculates load parameter control values at different time points through a ruleengine, then obtains an optimal backup time point and a load parameter control value thereof in a backup period, further optimizes a backup strategy, and takes the backup strategy as a default backupstrategy for database backup at the next backup time point; and S3) the backup client program uploads the optimized backup strategy and the real-time monitoring data to an operation and maintenance platform so as to provide a reference basis for a database administrator to intervene the backup strategy manually. The method is beneficial to the automatic adjustment and optimization of the databasebackup strategy according to different target equipment.
Description
technical field [0001] The invention belongs to the technical field of database backup, and in particular relates to a method for autonomously learning and setting a database backup strategy. Background technique [0002] The database stores the company's massive core data, and generally requires regular backups. Database backup generally has two purposes: one is to take into account the security of the database system, and when the database system fails, use the backup data to restore; the other is to archive historical data and provide original data for subsequent data analysis or audit requirements. data. [0003] At present, there are many types of databases involved, including common relational databases, cache databases, and many non-relational databases, such as document databases, sequential databases, etc. The backup methods used by each type of database are also different. This increases the complexity of database backup, and has higher requirements for operators...
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
Login to View More Patent Type & Authority Applications(China)
IPC IPC(8): G06F11/14
CPCG06F11/1448
Inventor 刘佛福李辉林友钦
Owner 厦门靠谱云股份有限公司