CN111190769A - Disaster recovery technology for automatic drilling - Google Patents
Disaster recovery technology for automatic drilling Download PDFInfo
- Publication number
- CN111190769A CN111190769A CN201911380335.XA CN201911380335A CN111190769A CN 111190769 A CN111190769 A CN 111190769A CN 201911380335 A CN201911380335 A CN 201911380335A CN 111190769 A CN111190769 A CN 111190769A
- Authority
- CN
- China
- Prior art keywords
- data
- disaster recovery
- drilling
- automatic drilling
- disaster
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000011084 recovery Methods 0.000 title claims abstract description 105
- 238000005553 drilling Methods 0.000 title claims abstract description 101
- 238000005516 engineering process Methods 0.000 title claims abstract description 16
- 238000000034 method Methods 0.000 claims abstract description 54
- 230000008569 process Effects 0.000 claims abstract description 41
- 238000004088 simulation Methods 0.000 claims abstract description 26
- 238000010276 construction Methods 0.000 claims description 5
- 238000012790 confirmation Methods 0.000 claims description 3
- 238000001514 detection method Methods 0.000 claims description 3
- 239000013589 supplement Substances 0.000 claims description 3
- 238000012937 correction Methods 0.000 claims description 2
- 238000012545 processing Methods 0.000 abstract description 5
- 238000012423 maintenance Methods 0.000 abstract description 3
- 238000004458 analytical method Methods 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 2
- 238000007405 data analysis Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000008676 import Effects 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 230000001502 supplementing effect Effects 0.000 description 2
- 230000004075 alteration Effects 0.000 description 1
- 238000013475 authorization Methods 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000002474 experimental method Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000009469 supplementation Effects 0.000 description 1
- 230000009897 systematic effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1448—Management of the data involved in backup or backup restore
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1458—Management of the backup or restore process
- G06F11/1469—Backup restoration techniques
Abstract
The invention relates to the technical field of disaster recovery drilling, and discloses a disaster recovery technology for automatic drilling, wherein an actual disaster recovery system is started to realize system and service recovery, a drilling plan is verified by adopting simulation data and simulation service system operation, and the specific process of automatic drilling of disaster recovery is required to be determined before data disaster recovery. According to the disaster recovery technology for automatic drilling, through mutual copying of data, two computers are adopted, mutual influence among the data is reduced, the fact that the recovered data are imported into a brand-new database is guaranteed, accuracy of the data is guaranteed, error conditions caused by data residue problems to disaster recovery drilling are avoided, the disaster recovery drilling has a higher reference value, the processing process of the drilling is a processing process which is highly close to that when a real disaster occurs, the disaster recovery drilling is guaranteed to be capable of playing a role in work, and therefore the disaster recovery automatic drilling plays a reference role in data maintenance.
Description
Technical Field
The invention relates to the technical field of disaster recovery drilling, in particular to a disaster recovery technology for automatic drilling.
Background
After the disaster recovery system is constructed, the encountered disasters are not limited to three levels, namely a data level, an application system level and a disaster recovery center level, so that all drills are performed based on a specific scene in the three levels, the disaster scenes are different, and the technical processes of the drills are different, namely, a systematic data emergency mode is established in advance by using scientific technical means and methods to deal with the occurrence of the disasters, and the contents of the data emergency mode comprise data backup and system backup, continuous service planning, personnel architecture, communication guarantee and crisis public relations, disaster recovery planning, service recovery planning, emergency response, third-party cooperation institutions, supply chain crisis management and the like.
According to the database disaster recovery method, device and system provided by CN 201810430380.0 in the chinese authorization, the method, device and system have the advantages that the first disaster recovery engine device can search the routing table of the database to complete data reading, so that the middleware of the main center can be specially used for processing the access of the service to the database, and further improve the access performance of the database, but the traditional disaster recovery technology for automatic drilling mainly uses one server for drilling during drilling, so that a deviation is easy to occur during drilling, or the accuracy of data recovery is affected by incomplete initialized data, and the analysis on the drilling process after the drilling is completed is less, and the specific reason of the disaster recovery of the data cannot be known from the drilling, so that the disaster recovery technology for automatic drilling is provided.
Disclosure of Invention
Technical problem to be solved
Aiming at the defects of the prior art, the invention provides a disaster recovery technology for automatic drilling, which has the advantages of strong data accuracy, accurate data analysis and the like, and solves the problems that the traditional disaster recovery technology for automatic drilling adopts one server for drilling when drilling, so that deviation is easy to occur in the drilling process, or the accuracy of data recovery is affected due to incomplete initialized data, and the analysis to the drilling process is less after the drilling is finished, so that the specific reason of the disaster recovery of the data cannot be known from the game.
(II) technical scheme
In order to achieve the purposes of strong data accuracy and accurate data analysis, the invention provides the following technical scheme: a disaster recovery technique for automatic drilling, comprising the steps of:
1) the actual disaster recovery system is started to realize system and service recovery, the exercise plans are verified by adopting simulation data and simulation service system operation, a new database is created, and data in the database is initialized;
2) restoring the latest full backup, restoring the sql file of the newly restored data, restoring the data after the full backup through the binlog, copying the binlog to a restoring machine, generating an sql script by using a mysql inllog, importing the sql script generated by the binlog, and then determining the accuracy of the data;
3) determining the starting restoration time and the binlog file according to the backup file name, confirming that the rollback sql is correct, executing the rollback language, logging in sql for confirmation, and confirming that the data rollback is successful after the completion of the rollback;
4) listing the tasks to be completed after the exercise result and conclusion are determined, proving that the exercise is finally the best service continuity, and completing the disaster recovery plan and related programs thereof;
5) the drilling result is corrected, supplemented and perfected to provide a theoretical basis and data indexes for the upgrading construction of the disaster recovery system.
Preferably, the specific process of automatic disaster recovery drilling needs to be determined before data disaster recovery is performed, and the simulation data and the simulation service are expected to be pre-actual service based on time data.
Preferably, the database is initialized after creation, and the simulation data or the simulation service is input into the database, and the data after input needs to be backed up once.
Preferably, the recovery machine and the backup machine are two different computers, and the sql script is sent to the recovery machine through a local area network.
Preferably, the time spent on the recovery needs to be accurately recorded, the rollback data needs to be repeatedly compared with the original data when the rollback data is absent, and the data needs to be called out for detection after the rollback is completed.
Preferably, after the specific process of disaster recovery automatic drilling is determined, the specific process needs to be compared with a disaster recovery automatic drilling process made in advance, so as to complete the process of data disaster recovery automatic drilling, and after the disaster recovery automatic drilling is summarized, corrected, completed and supplemented, archiving is needed, and the reason why the data has a problem needs to be found out, so as to upgrade the database.
(III) advantageous effects
Compared with the prior art, the invention provides a disaster recovery technology for automatic drilling, which has the following beneficial effects:
1. the disaster recovery technology for automatic drilling adopts two different servers connected with a local area network during data disaster recovery drilling through mutual copying of data, inputs simulation data or simulation business needing drilling to the server after initialization is completed, backs up the data on the server, simulates the condition of data loss or damage on the server, recovers the data after full backup through binlog, copies the data replied by the binlog to another server, generates sql script by mysql script on the server, imports the sql script generated by the binlog, determines the accuracy of the data, completes the data recovery process of the automatic drilling, adopts two computers, reduces the mutual influence between the data, ensures that the data after recovery is imported into a brand new database, the method and the device can ensure the accuracy of data, avoid the error condition caused by the data residue problem to the disaster recovery drilling, and enable the disaster recovery drilling to have more reference value.
2. The disaster recovery technology for automatic drilling comprises the steps of correcting, supplementing and perfecting a drilling result, recording the process of disaster recovery drilling after the disaster recovery drilling is finished, comparing the process with the process established before the disaster recovery drilling, finding out the entrance and exit between two schemes, perfecting and archiving the process of disaster recovery drilling, perfecting a disaster recovery plan, providing a theoretical basis and data indexes for the upgrading construction of a disaster recovery system, determining the accuracy of data for many times by workers in the process, perfecting or supplementing the problems occurring in the process of data disaster recovery drilling, finding out the reasons of data loss or damage, upgrading or perfecting a database, verifying the drilling plan by adopting simulation data and simulation service system operation, and completely providing a disaster recovery center starting function without influencing the existing production system and disaster recovery system, therefore, a real disaster preparation system starting environment can be obtained at any time in the disaster preparation center, each module of the application system can be applied in the environment, and the processing process of the drilling is highly close to that of the real disaster, so that the work can be ensured to be acted by the disaster preparation drilling, and the automatic disaster preparation drilling can play a reference role in data maintenance.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Example (b): a disaster recovery technique for automatic drilling, comprising the steps of:
1) starting an actual disaster recovery system to realize system and service recovery, and verifying a exercise plan by adopting simulation data and simulation service system operation, wherein a specific process of automatic exercise of disaster recovery is required to be determined before data disaster recovery, a new database is created by the simulation data and the simulation service based on time data pre-actual service, data in the database is initialized, the simulation data or the simulation service is input into a value database after the database is created and initialized, and the input data is required to be backed up once;
2) restoring the latest full backup, restoring the sql file of the newly restored data, restoring the data after the full backup through the binlog, copying the binlog to a restoring machine, wherein the restoring machine and the backup machine are two different computers, the sql script is sent to the restoring machine through a local area network, the mysql script is used for generating the sql script, the sql script generated by the binlog is imported, and then the accuracy of the data is determined;
3) determining the starting restoration time and the binlog file according to the backup file name, confirming that the rollback sql is correct, executing the rollback language, logging in sql for confirmation, and confirming that the data rollback is successful after the completion of the rollback;
4) listing tasks to be completed after the exercise result and conclusion are determined, proving that the exercise is finally optimal service continuity, completing a disaster recovery plan and related programs thereof, wherein the time spent on recovery needs to be accurately recorded, the rollback data needs to repeatedly compare the original data when the rollback data is lacked, and the data needs to be called for detection after the rollback is completed;
5) the drilling result is corrected, supplemented and improved, a theoretical basis and data indexes are provided for the upgrading construction of the disaster recovery system, the specific process of the disaster recovery automatic drilling needs to be compared with the disaster recovery automatic drilling process which is made in advance after the specific process of the disaster recovery automatic drilling is determined, the process of the data disaster recovery automatic drilling is improved, the data disaster recovery automatic drilling needs to be archived after the automatic drilling summary, the correction, the improvement and the supplementation are completed, and the reason why the data has problems needs to be found out is used for upgrading the database.
After experiments, the disaster recovery automatic drilling is carried out by the method, the obtained drilling data are more accurate, the mutual influence between the two servers is small, and large errors cannot occur between the data, so that the disaster recovery automatic drilling has more practical reference value, the process is perfected when the disaster recovery automatic drilling is completed, the database is analyzed after the perfecting process, and the database is perfected by referring to the process of the disaster recovery automatic drilling.
The invention has the beneficial effects that: the disaster recovery technology for automatic drilling adopts two different servers connected with a local area network during data disaster recovery drilling through mutual copying of data, inputs simulation data or simulation business needing drilling to the server after initialization is completed, backs up the data on the server, simulates the condition of data loss or damage on the server, recovers the data after full backup through binlog, copies the data replied by the binlog to another server, generates sql script by mysql script on the server, imports the sql script generated by the binlog, determines the accuracy of the data, completes the data recovery process of the automatic drilling, adopts two computers, reduces the mutual influence between the data, ensures that the data after recovery is imported into a brand new database, the method ensures the accuracy of data, avoids the error condition caused by the data residual problem to the disaster-preparation drilling, ensures that the disaster-preparation drilling has more reference value, corrects, supplements and perfects the drilling result, records the process of the disaster-preparation drilling after the completion of the disaster-preparation drilling, compares the process with the process established before the disaster-preparation drilling, finds out the discrepancy between the two schemes, perfects and files the process of the disaster-preparation drilling, perfects the disaster-preparation recovery plan and provides theoretical basis and data indexes for the upgrading construction of the disaster-preparation system, in the process, a worker needs to determine the accuracy of the data for many times, perfects or supplements the problems occurring in the data disaster-preparation drilling process, thereby finding out the reasons of data loss or damage, upgrades or perfects the database, and verifies the drilling plan by adopting the operation of analog data and analog business system, the disaster recovery technology can completely provide the disaster recovery center starting function without influencing the existing production system and disaster recovery system, therefore, a real disaster preparation system starting environment can be obtained at any time in the disaster preparation center, each module of the application system can be applied in the environment, the processing process of the drilling is highly close to that of the real disaster, the work can be ensured to be played by the disaster preparation drilling, thereby the disaster recovery automatic drilling plays a reference role in data maintenance, and the problem that the traditional disaster recovery technology of automatic drilling adopts one server for drilling when in drilling, so that deviation is easy to occur in the drilling process, or the initialized data is incomplete, so that the accuracy of data recovery is influenced, the analysis on the drilling process is less after the drilling is finished, and the specific reason of the data with disaster recovery cannot be known from the games.
Although embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that changes, modifications, substitutions and alterations can be made in these embodiments without departing from the principles and spirit of the invention, the scope of which is defined in the appended claims and their equivalents.
Claims (6)
1. A disaster recovery technology for automatic drilling is characterized by comprising the following steps:
1) the actual disaster recovery system is started to realize system and service recovery, the exercise plans are verified by adopting simulation data and simulation service system operation, a new database is created, and data in the database is initialized;
2) restoring the latest full backup, restoring the sql file of the newly restored data, restoring the data after the full backup through the binlog, copying the binlog to a restoring machine, generating an sql script by using a mysql inllog, importing the sql script generated by the binlog, and then determining the accuracy of the data;
3) determining the starting restoration time and the binlog file according to the backup file name, confirming that the rollback sql is correct, executing the rollback language, logging in sql for confirmation, and confirming that the data rollback is successful after the completion of the rollback;
4) listing the tasks to be completed after the exercise result and conclusion are determined, proving that the exercise is finally the best service continuity, and completing the disaster recovery plan and related programs thereof;
5) the drilling result is corrected, supplemented and perfected to provide a theoretical basis and data indexes for the upgrading construction of the disaster recovery system.
2. The disaster recovery technique for automatic drilling according to claim 1, wherein: the specific process of automatic disaster recovery drilling needs to be determined before data disaster recovery, and the simulation data and the simulation service are expected to be pre-actual service based on time data.
3. The disaster recovery technique for automatic drilling according to claim 1, wherein: after the database is established and initialized, the simulation data or the simulation service is input into the database, and the data after the input needs to be backed up once.
4. The disaster recovery technique for automatic drilling according to claim 1, wherein: the recovery machine and the backup machine are two different computers, and the sql script is sent to the recovery machine through the local area network.
5. The disaster recovery technique for automatic drilling according to claim 1, wherein: the time spent on the recovery needs to be accurately recorded, the rollback data needs to be repeatedly compared with the original data when the rollback data is absent, and the data needs to be called out for detection after the rollback is completed.
6. The disaster recovery technique for automatic drilling according to claim 1, wherein: after the specific process of disaster recovery automatic drilling is determined, the specific process needs to be compared with a disaster recovery automatic drilling process made in advance, the process of data disaster recovery automatic drilling is completed, after the conclusion, correction, completion and supplement of disaster recovery automatic drilling are completed, archiving is needed, and the reason why the data has problems needs to be found out to upgrade the database.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201911380335.XA CN111190769A (en) | 2019-12-27 | 2019-12-27 | Disaster recovery technology for automatic drilling |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201911380335.XA CN111190769A (en) | 2019-12-27 | 2019-12-27 | Disaster recovery technology for automatic drilling |
Publications (1)
Publication Number | Publication Date |
---|---|
CN111190769A true CN111190769A (en) | 2020-05-22 |
Family
ID=70707688
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201911380335.XA Pending CN111190769A (en) | 2019-12-27 | 2019-12-27 | Disaster recovery technology for automatic drilling |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN111190769A (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN114205210A (en) * | 2021-12-14 | 2022-03-18 | 北京字节跳动网络技术有限公司 | Fault drilling method and device, electronic equipment and storage medium |
WO2022126910A1 (en) * | 2020-12-18 | 2022-06-23 | 平安科技(深圳)有限公司 | Data recovery drill method and apparatus for database, and storage medium |
CN116185723A (en) * | 2023-04-28 | 2023-05-30 | 杭州美创科技股份有限公司 | Database disaster recovery switching exercise method, device, computer equipment and storage medium |
Citations (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103473112A (en) * | 2013-09-03 | 2013-12-25 | 北京邮电大学 | Disaster backup information system simulation method based on two places and three centers |
-
2019
- 2019-12-27 CN CN201911380335.XA patent/CN111190769A/en active Pending
Patent Citations (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103473112A (en) * | 2013-09-03 | 2013-12-25 | 北京邮电大学 | Disaster backup information system simulation method based on two places and three centers |
Non-Patent Citations (2)
Title |
---|
许福忠: "银行交易系统灾备技术研究与应用" * |
马金辉: "虚拟存储技术在税务行业省级数据容灾备份中的应用研究" * |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2022126910A1 (en) * | 2020-12-18 | 2022-06-23 | 平安科技(深圳)有限公司 | Data recovery drill method and apparatus for database, and storage medium |
CN114205210A (en) * | 2021-12-14 | 2022-03-18 | 北京字节跳动网络技术有限公司 | Fault drilling method and device, electronic equipment and storage medium |
CN116185723A (en) * | 2023-04-28 | 2023-05-30 | 杭州美创科技股份有限公司 | Database disaster recovery switching exercise method, device, computer equipment and storage medium |
CN116185723B (en) * | 2023-04-28 | 2023-08-08 | 杭州美创科技股份有限公司 | Database disaster recovery switching exercise method, device, computer equipment and storage medium |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN111190769A (en) | Disaster recovery technology for automatic drilling | |
CN107609188B (en) | Data synchronization verification method based on golden gate | |
US7437609B2 (en) | Reliable standby database failover | |
US9513894B2 (en) | Database software upgrade using specify-validate-execute protocol | |
WO2018001200A1 (en) | Data processing method, cluster manager, resource manager and data processing system | |
CN110263095B (en) | Data backup and recovery method and device, computer equipment and storage medium | |
CN110008129B (en) | Reliability test method, device and equipment for storage timing snapshot | |
CN104765652B (en) | A kind of data backup and data reconstruction method and device | |
Sarmah | Data migration | |
CN111240980A (en) | Automatic regression testing method based on cloud pipe platform | |
CN103984309A (en) | Cigarette production system with disaster tolerance function and disaster tolerance exercise method thereof | |
CN111400267A (en) | Method and device for recording log | |
CN110825413A (en) | Database upgrading method and device and application deployment upgrading method and device | |
CN107316176A (en) | The control method and device of declaration form processing | |
CN108984337A (en) | A kind of restorative procedure of data synchronous abnormality, prosthetic device, medium and calculate equipment | |
CN109271199B (en) | Method and system for database continuous integration and script file management | |
CN111198920B (en) | Method and device for determining comparison table snapshot based on database synchronization | |
CN106326041A (en) | Second-level recovery method for database | |
CN115599600A (en) | Disaster recovery switching method and device, storage medium and electronic equipment | |
CN115391464A (en) | Distributed database disaster recovery testing method and system and computer equipment | |
CN112925676A (en) | Method for realizing recovery of distributed database cluster at any time point based on WAL | |
US20030126159A1 (en) | Method and system for rollback of software system upgrade | |
CN112230888A (en) | Method for quickly making software flow | |
US20050235017A1 (en) | System and method for high availability of data in a disaster recovery system | |
CN117118986B (en) | Block chain-based fault tolerance verification method, device, equipment and medium |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200522 |
|
RJ01 | Rejection of invention patent application after publication |