CN106021019A - Automatic recovery method for databases - Google Patents
Automatic recovery method for databases Download PDFInfo
- Publication number
- CN106021019A CN106021019A CN201610311877.1A CN201610311877A CN106021019A CN 106021019 A CN106021019 A CN 106021019A CN 201610311877 A CN201610311877 A CN 201610311877A CN 106021019 A CN106021019 A CN 106021019A
- Authority
- CN
- China
- Prior art keywords
- mdl
- backup
- database
- former
- work
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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/1471—Saving, restoring, recovering or retrying involving logging of persistent data for recovery
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses an automatic recovery method for databases. The method has the advantages that two cluster hot backup systems are adopted to carry out backup of a master database at regular times, record data operation and save the recorded data operation to a work log; under the circumstances of a database breakdown, downtime and the like, a standby database is immediately enabled, and the working status is recovered back to the working status at the occurrence of the breakdown according to the work log, so that the operations of the databases can be connected in a seamless manner, and the system stability is ensured.
Description
Technical field
The present invention relates to database field, in particular it relates to a kind of data base's automatic recovery method.
Background technology
At present; data base in information technology in occupation of consequence; high speed development along with information technology; data base is in routine work; business activity; even extremely important effect is all played in the life of people; but computer system is due to the restriction of himself operation principle; the fault of portion's similar terms often occur, Database Systems are no exception, often there will be data deadlock; server crash is delayed the problems such as machine; and the emergency processing that once neither one is good prepares, then can cause various problem, bring heavy losses.
Summary of the invention
It is an object of the invention to, for the problems referred to above, propose a kind of data base's automatic recovery method, the advantage solved in time during to realize database failure.
For achieving the above object, the technical solution used in the present invention is:
A kind of data base's automatic recovery method uses two groups of clustered database system, and one group is MDL, and another is then hot backup data storehouse, and two groups of Database Systems are separately mounted in different data storage servers, comprise the following steps:
A., when MDL normally works, every the set time, MDL backed up to completely backup database；
B. after backup, MDL work according to sequence of event daily record of work and is stored；
C. monitor database working, when monitoring master data bank system collapse, enable backup database, and this backup database is transferred to new MDL, and according to daily record of work, the execution of new MDL is all resubmited in the work after backup for the last time.
Further, after step C further comprising the steps of: D. restarts former MDL, and from former backup database, last Backup Data is imported completely, and according to daily record of work, the execution of former MDL is all resubmited in the work after backup for the last time, if former MDL can be properly functioning, transfer former MDL to new backup database, as former MDL is not normally functioning, then send alarm, remind and overhaul former MDL.
Technical scheme has the advantages that
Data base's automatic recovery method of various embodiments of the present invention, owing to including two sets of data storehouse clusters, can switch when there is database failure in time；Thus ensure the stability of Database Systems, with the advantage realizing safe and stable operation.
Below by embodiment, technical scheme is described in further detail.
Detailed description of the invention
Hereinafter the preferred embodiments of the present invention are illustrated, it will be appreciated that preferred embodiment described herein is merely to illustrate and explains the present invention, is not intended to limit the present invention.
A kind of data base's automatic recovery method uses two groups of clustered database system, and one group is MDL, and another is then hot backup data storehouse, and two groups of Database Systems are separately mounted in different data storage servers, comprise the following steps:
A., when MDL normally works, every the set time, MDL backed up to completely backup database；
B. after backup, MDL work according to sequence of event daily record of work and is stored；
C. monitor database working, when monitoring master data bank system collapse, enable backup database, and this backup database is transferred to new MDL, and according to daily record of work, the execution of new MDL is all resubmited in the work after backup for the last time.
Backing up in realtime strategy if used, data transfer overhead is relatively big, thus day by day or by time backup, then record system running log, when there is system crash, even if turning backup database, and import operating process identical in daily record, can preferable restored data storehouse information, recover associative operation.
Also a solution is; first the Database Systems collapsed are restarted; detect whether it can normally work; if can normally work; this data base can be directly used to continue executing with associative operation; this needs system to have a scene protection mechanism when collapse, it is ensured that can return to the scene during collapse when restarting.
When using backup server recovery operation, further, after step C further comprising the steps of: D. restarts former MDL, and imported completely by last Backup Data from former backup database, and according to daily record of work, the execution of former MDL is all resubmited in the work after backup for the last time, if former MDL can be properly functioning, transfer former MDL to new backup database, as former MDL is not normally functioning, then send alarm, remind and overhaul former MDL.
Last it is noted that the foregoing is only the preferred embodiments of the present invention, it is not limited to the present invention, although the present invention being described in detail with reference to previous embodiment, for a person skilled in the art, technical scheme described in foregoing embodiments still can be modified by it, or wherein portion of techniques feature is carried out equivalent.All within the spirit and principles in the present invention, any modification, equivalent substitution and improvement etc. made, should be included within the scope of the present invention.
Claims (2)
1. data base's automatic recovery method, it is characterised in that using two groups of clustered database system, a group is MDL, and another is then hot backup data storehouse, and two groups of Database Systems are separately mounted in different data storage servers, comprise the following steps:
A., when MDL normally works, every the set time, MDL backed up to completely backup database；
B. after backup, MDL work according to sequence of event daily record of work and is stored；
C. monitor database working, when monitoring MDL collapse, enables backup database, and this backup database transfers to new MDL, and according to daily record of work, the work after backup for the last time is all resubmited the execution of new MDL.
Data base's automatic recovery method the most according to claim 1, it is characterized in that, after step C further comprising the steps of: D. restarts former MDL, and from former backup database, last Backup Data is imported completely, and according to daily record of work, the execution of former MDL is all resubmited in the work after backup for the last time, if former MDL can be properly functioning, transfer former MDL to new backup database, as former MDL is not normally functioning, then send alarm, remind and overhaul former MDL.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610311877.1A CN106021019A (en) | 2016-05-12 | 2016-05-12 | Automatic recovery method for databases |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610311877.1A CN106021019A (en) | 2016-05-12 | 2016-05-12 | Automatic recovery method for databases |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106021019A true CN106021019A (en) | 2016-10-12 |
Family
ID=57099268
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610311877.1A Pending CN106021019A (en) | 2016-05-12 | 2016-05-12 | Automatic recovery method for databases |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106021019A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107729217A (en) * | 2017-10-30 | 2018-02-23 | 郑州云海信息技术有限公司 | A kind of database abnormality eliminating method and terminal |
| CN108628705A (en) * | 2018-04-10 | 2018-10-09 | 京信通信系统（中国）有限公司 | Database restoring method, device, computer equipment and storage medium |
| CN110019500A (en) * | 2017-08-21 | 2019-07-16 | 东软集团股份有限公司 | A kind of copy group method for monitoring state, device, equipment and storage medium |
| CN114721870A (en) * | 2022-03-30 | 2022-07-08 | 浙江大华技术股份有限公司 | Data recovery method and device, storage medium and electronic device |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080077636A1 (en) * | 2003-09-10 | 2008-03-27 | International Business Machines Corporation | Database backup system using data and user-defined routines replicators for maintaining a copy of database on a secondary server |
| CN103699548A (en) * | 2012-09-27 | 2014-04-02 | 阿里巴巴集团控股有限公司 | Method and equipment for recovering database data by using logs |
| CN104346479A (en) * | 2014-11-26 | 2015-02-11 | 北京奇虎科技有限公司 | Database synchronization method and database synchronization device |
| CN104536971A (en) * | 2014-12-02 | 2015-04-22 | 北京锐安科技有限公司 | High-availability database |
| CN105224637A (en) * | 2015-09-24 | 2016-01-06 | 珠海许继芝电网自动化有限公司 | A kind of based on PostgreSQL database active and standby/the comprehensive method of cluster application |
| CN105528368A (en) * | 2014-09-30 | 2016-04-27 | 北京金山云网络技术有限公司 | A database migration method and device |
-
2016
- 2016-05-12 CN CN201610311877.1A patent/CN106021019A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080077636A1 (en) * | 2003-09-10 | 2008-03-27 | International Business Machines Corporation | Database backup system using data and user-defined routines replicators for maintaining a copy of database on a secondary server |
| CN103699548A (en) * | 2012-09-27 | 2014-04-02 | 阿里巴巴集团控股有限公司 | Method and equipment for recovering database data by using logs |
| CN105528368A (en) * | 2014-09-30 | 2016-04-27 | 北京金山云网络技术有限公司 | A database migration method and device |
| CN104346479A (en) * | 2014-11-26 | 2015-02-11 | 北京奇虎科技有限公司 | Database synchronization method and database synchronization device |
| CN104536971A (en) * | 2014-12-02 | 2015-04-22 | 北京锐安科技有限公司 | High-availability database |
| CN105224637A (en) * | 2015-09-24 | 2016-01-06 | 珠海许继芝电网自动化有限公司 | A kind of based on PostgreSQL database active and standby/the comprehensive method of cluster application |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110019500A (en) * | 2017-08-21 | 2019-07-16 | 东软集团股份有限公司 | A kind of copy group method for monitoring state, device, equipment and storage medium |
| CN107729217A (en) * | 2017-10-30 | 2018-02-23 | 郑州云海信息技术有限公司 | A kind of database abnormality eliminating method and terminal |
| CN108628705A (en) * | 2018-04-10 | 2018-10-09 | 京信通信系统（中国）有限公司 | Database restoring method, device, computer equipment and storage medium |
| CN108628705B (en) * | 2018-04-10 | 2021-01-15 | 京信通信系统（中国）有限公司 | Database recovery method and device, computer equipment and storage medium |
| CN114721870A (en) * | 2022-03-30 | 2022-07-08 | 浙江大华技术股份有限公司 | Data recovery method and device, storage medium and electronic device |
| CN114721870B (en) * | 2022-03-30 | 2025-08-15 | 浙江大华技术股份有限公司 | Data recovery method and device, storage medium and electronic device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN202798798U (en) | High availability system based on cloud computing technology | |
| CN104866395B (en) | Data back up method and system, main/standby switching method and system | |
| WO2017177941A1 (en) | Active/standby database switching method and apparatus | |
| CN101650741B (en) | A method and system for real-time updating of indexes for distributed full-text retrieval | |
| CN103500130B (en) | A kind of method that two-node cluster hot backup data are backed up in realtime | |
| CN106021019A (en) | Automatic recovery method for databases | |
| CN109189860A (en) | A kind of active and standby increment synchronization method of MySQL based on Kubernetes system | |
| CN106301938A (en) | A kind of high availability and the data base cluster system of strong consistency and node administration method thereof | |
| CN102938705B (en) | Method for managing and switching high availability multi-machine backup routing table | |
| CN103077242A (en) | Method for hot standby of dual database servers | |
| CN103532753B (en) | A kind of double hot standby method of synchronization of skipping based on internal memory | |
| CN103294787A (en) | Multi-copy storage method and multi-copy storage system for distributed database system | |
| CN106970861A (en) | A kind of virtual machine fault-tolerance approach and system | |
| CN101207512A (en) | A Redundant Disaster Backup and Switching Method for Database System | |
| CN103346903A (en) | Dual-machine backup method and device | |
| CN105607973B (en) | Method, device and system for processing equipment fault in virtual machine system | |
| CN103853622A (en) | Control method of dual redundancies capable of being backed up mutually | |
| CN113986450B (en) | Virtual machine backup method and device | |
| CN103618788A (en) | System high-availability method supporting B/S structure | |
| CN103257908A (en) | Software and hardware cooperative multi-controller disk array designing method | |
| CN101145946A (en) | A fault tolerance cluster system and method based on message log | |
| US8527454B2 (en) | Data replication using a shared resource | |
| CN103812674A (en) | Method for main and standby server replacement | |
| CN113297173B (en) | Distributed database cluster management method and device, electronic equipment | |
| CN105242988B (en) | The data back up method of distributed file system and distributed file system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20161012 |