CN106294016A - Data base's real-time protection method under a kind of disaster tolerance system - Google Patents
Data base's real-time protection method under a kind of disaster tolerance system Download PDFInfo
- Publication number
- CN106294016A CN106294016A CN201610655084.1A CN201610655084A CN106294016A CN 106294016 A CN106294016 A CN 106294016A CN 201610655084 A CN201610655084 A CN 201610655084A CN 106294016 A CN106294016 A CN 106294016A
- Authority
- CN
- China
- Prior art keywords
- data base
- data
- local source
- storehouse
- data storehouse
- 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; 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/1464—Management of the backup or restore process for networked environments
Abstract
The present invention be more particularly directed to data base's real-time protection method under a kind of disaster tolerance system.Data base's real-time protection method under this disaster tolerance system; local source data storehouse synchronizes mastery routine; find when there is amendment SQL in local source data storehouse; hang up local source data storehouse current thread; stoping data base's feedback to upper layer application, the amendment to data base simultaneously is compressed packing and uploads to remote target data base；After remote target data base receives data, synchronize the amendment to data base, and feed back local source data storehouse；Local source data storehouse, after receiving target database feedback, is cancelled local source data storehouse current thread suspended state, is fed back upper layer application.Data base's real-time protection method under this disaster tolerance system; by local data base and remote data storehouse source/target database each other; thus realize two data base's dual-actives and backup each other; carry out real-time data backup protection; can effectively reduce RTO Yu the RPO value in disaster tolerance system, improve the redundancy ability of data base.
Description
Technical field
The present invention relates to data-base remote back up in realtime technical field, real-time particularly to data base under a kind of disaster tolerance system
Guard method.
Background technology
Information age, data volume became geometric growth trend along with the development of the technology such as big data, cloud computing.The biggest
Under data volume, data base provides market environment analysis intuitively for enterprise, defines enterprise efficiency, market orientation, an industry
Develop organic information network, facilitate enterprise to formulate rational management direction.But data base is in individual data mostly at present
In intracardiac backup, lack the disaster-tolerant backup between data center, the most whole data center breaks down and whole answers use by making
In stopped status, affect the sound development of whole enterprise.
Based on the problems referred to above, the present invention proposes data base's real-time protection method under a kind of disaster tolerance system.It is intended that data
Backing up in realtime mutually of central database, when preventing the fault of data center's rank, data base can switch the most in real time, no
The normal use of impact application.
Summary of the invention
The present invention is in order to make up the defect of prior art, it is provided that under a kind of simple efficient disaster tolerance system, data base is real-time
Guard method.
The present invention is achieved through the following technical solutions:
Data base's real-time protection method under a kind of disaster tolerance system, it is characterised in that comprise the following steps:
(1) data center arranging two source/target databases each other is in dual-active state；
(2) local source data storehouse synchronizes mastery routine, finds, when there is amendment SQL in local source data storehouse, to create sub-line journey；
(3) realize in sub-line journey, hang up local source data storehouse current thread, stop data base's feedback to upper layer application, with
Time the amendment of data base be compressed packing upload to remote target data base, sub-line journey is waited for；
(4) after remote target data base receives data, create sub-line journey and decompress, synchronize the amendment to data base, release
Sub-line journey, simultaneously feedback local source data storehouse；
(5) local source data storehouse is after receiving target database feedback, activates sub-line journey, cancels current to local source data storehouse
Thread suspended state, feeds back upper layer application, discharges sub-line journey.
When remote data storehouse is as local source data storehouse, when local data base is as remote target data base, perform described
Step (2) and step (3) can realize backing up in realtime remote data storehouse.
The amendment of data base is compressed packing while submitting affairs to and is uploaded to remote target by local source data storehouse
Data base, remote target data base performs database command, in local source data storehouse and remote target after unpacking data
After data base two end data is carried out successfully, just feedback upper layer application writes successfully.
The invention has the beneficial effects as follows: data base's real-time protection method under this disaster tolerance system, by local data base with remote
Client database source/target database each other, thus realize two data base's dual-actives and backup each other, carry out real-time data backup and protect
Protect, it is possible to effectively reduce RTO Yu the RPO value in disaster tolerance system, improve the redundancy ability of data base.
Accompanying drawing explanation
Accompanying drawing 1 is data base's real-time protection method using method schematic diagram under disaster tolerance system of the present invention.
Detailed description of the invention
In order to make the technical problem to be solved, technical scheme and beneficial effect clearer, below tie
Closing drawings and Examples, the present invention will be described in detail.It should be noted that, specific embodiment described herein is only used
To explain the present invention, it is not intended to limit the present invention.
Data base's real-time protection method under this disaster tolerance system, comprises the following steps:
(1) data center arranging two source/target databases each other is in dual-active state；
(2) local source data storehouse synchronizes mastery routine, finds, when there is amendment SQL in local source data storehouse, to create sub-line journey；
(3) realize in sub-line journey, hang up local source data storehouse current thread, stop data base's feedback to upper layer application, with
Time the amendment of data base be compressed packing upload to remote target data base, sub-line journey is waited for；
(4) after remote target data base receives data, create sub-line journey and decompress, synchronize the amendment to data base, release
Sub-line journey, simultaneously feedback local source data storehouse；
(5) local source data storehouse is after receiving target database feedback, activates sub-line journey, cancels current to local source data storehouse
Thread suspended state, feeds back upper layer application, discharges sub-line journey.
When remote data storehouse is as local source data storehouse, when local data base is as remote target data base, perform described
Step (2) and step (3) can realize backing up in realtime remote data storehouse.
The amendment of data base is compressed packing while submitting affairs to and is uploaded to remote target by local source data storehouse
Data base, remote target data base performs database command, in local source data storehouse and remote target after unpacking data
After data base two end data is carried out successfully, just feedback upper layer application writes successfully.
Data base's real-time protection method under this disaster tolerance system, by local data base and remote data storehouse source/target each other
Data base, thus realize two data base's dual-actives and backup each other, carry out real-time data backup protection, it is possible to effectively reduce disaster tolerance
RTO Yu RPO value in system, improves the redundancy ability of data base.
Claims (3)
1. data base's real-time protection method under a disaster tolerance system, it is characterised in that comprise the following steps:
(1) data center arranging two source/target databases each other is in dual-active state；
(2) local source data storehouse synchronizes mastery routine, finds, when there is amendment SQL in local source data storehouse, to create sub-line journey；
(3) realize in sub-line journey, hang up local source data storehouse current thread, stop data base's feedback to upper layer application, with
Time the amendment of data base be compressed packing upload to remote target data base, sub-line journey is waited for；
(4) after remote target data base receives data, create sub-line journey and decompress, synchronize the amendment to data base, release
Sub-line journey, simultaneously feedback local source data storehouse；
(5) local source data storehouse is after receiving target database feedback, activates sub-line journey, cancels current to local source data storehouse
Thread suspended state, feeds back upper layer application, discharges sub-line journey.
Data base's real-time protection method under disaster tolerance system the most according to claim 1, it is characterised in that: when remote data storehouse
As local source data storehouse, when local data base is as remote target data base, perform described step (2) and step (3)
Realize being backed up in realtime in remote data storehouse.
Data base's real-time protection method under disaster tolerance system the most according to claim 1, it is characterised in that: local source data storehouse
While submitting affairs to, the amendment of data base is compressed packing and is uploaded to remote target data base, remote target data base
Perform database command after data are unpacked, be carried out into remote target data base two end data in local source data storehouse
After merit, just feedback upper layer application writes successfully.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610655084.1A CN106294016A (en) | 2016-08-11 | 2016-08-11 | Data base's real-time protection method under a kind of disaster tolerance system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610655084.1A CN106294016A (en) | 2016-08-11 | 2016-08-11 | Data base's real-time protection method under a kind of disaster tolerance system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106294016A true CN106294016A (en) | 2017-01-04 |
Family
ID=57669850
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610655084.1A Pending CN106294016A (en) | 2016-08-11 | 2016-08-11 | Data base's real-time protection method under a kind of disaster tolerance system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106294016A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107770278A (en) * | 2017-10-30 | 2018-03-06 | 山东浪潮通软信息科技有限公司 | A kind of data transmission device and its method for transmitting data |
| CN108334578A (en) * | 2018-01-24 | 2018-07-27 | 广州江南科友科技股份有限公司 | A kind of database dual-active inspection method and device |
| CN109819004A (en) * | 2017-11-22 | 2019-05-28 | 中国人寿保险股份有限公司 | For disposing the method and system at more live data centers |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110035561A1 (en) * | 2009-08-10 | 2011-02-10 | Sun Microsystems, Inc. | Store queue with token to facilitate efficient thread synchronization |
| US20130132946A1 (en) * | 2011-11-17 | 2013-05-23 | Microsoft Corporation | Synchronized failover for active-passive applications |
| US20140067983A1 (en) * | 2012-08-29 | 2014-03-06 | International Business Machines Corporation | Bi-directional synchronization enabling active-active redundancy for load-balancing switches |
| CN103812929A (en) * | 2014-01-11 | 2014-05-21 | 浪潮电子信息产业股份有限公司 | Active-active method for cloud data center management platforms |
| US20140250071A1 (en) * | 2013-03-01 | 2014-09-04 | Oracle International Corporation | Active replication with generic conflict detection and resolution (cdr) |
-
2016
- 2016-08-11 CN CN201610655084.1A patent/CN106294016A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110035561A1 (en) * | 2009-08-10 | 2011-02-10 | Sun Microsystems, Inc. | Store queue with token to facilitate efficient thread synchronization |
| US20130132946A1 (en) * | 2011-11-17 | 2013-05-23 | Microsoft Corporation | Synchronized failover for active-passive applications |
| US20140067983A1 (en) * | 2012-08-29 | 2014-03-06 | International Business Machines Corporation | Bi-directional synchronization enabling active-active redundancy for load-balancing switches |
| US20140250071A1 (en) * | 2013-03-01 | 2014-09-04 | Oracle International Corporation | Active replication with generic conflict detection and resolution (cdr) |
| CN103812929A (en) * | 2014-01-11 | 2014-05-21 | 浪潮电子信息产业股份有限公司 | Active-active method for cloud data center management platforms |
Non-Patent Citations (1)
| Title |
|---|
| 中国存储网: "Oracle GoldenGate快速入门篇（详解GoldenGate概念到原理）", 《HTTP://WWW.W3.ORG/1999/XHTML》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107770278A (en) * | 2017-10-30 | 2018-03-06 | 山东浪潮通软信息科技有限公司 | A kind of data transmission device and its method for transmitting data |
| CN109819004A (en) * | 2017-11-22 | 2019-05-28 | 中国人寿保险股份有限公司 | For disposing the method and system at more live data centers |
| CN108334578A (en) * | 2018-01-24 | 2018-07-27 | 广州江南科友科技股份有限公司 | A kind of database dual-active inspection method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11573859B2 (en) | Content-independent and database management system-independent synthetic full backup of a database based on snapshot technology | |
| WO2019154394A1 (en) | Distributed database cluster system, data synchronization method and storage medium | |
| US20190310968A1 (en) | Managing deletions from a deduplication database | |
| CN107209704B (en) | Method, system and apparatus for database management | |
| CN102640151B (en) | Transformed data recording method and system | |
| CN106777270A (en) | A kind of Heterogeneous Database Replication parallel execution system and method based on submission point time line locking | |
| US8572051B1 (en) | Making parallel execution of structured query language statements fault-tolerant | |
| US9251008B2 (en) | Client object replication between a first backup server and a second backup server | |
| CN106294016A (en) | Data base's real-time protection method under a kind of disaster tolerance system | |
| US10216588B2 (en) | Database system recovery using preliminary and final slave node replay positions | |
| US20140172794A1 (en) | Replication Mechanisms for Database Environments | |
| US20150032695A1 (en) | Client and server integration for replicating data | |
| CN110651265A (en) | Data replication system | |
| TW200515140A (en) | System and method of relational configuration mirroring | |
| US20120150803A1 (en) | Replication resynchronization | |
| Moiz et al. | Database replication: A survey of open source and commercial tools | |
| US20150006485A1 (en) | High Scalability Data Management Techniques for Representing, Editing, and Accessing Data | |
| CN103345502A (en) | Transaction processing method and system of distributed type database | |
| US9892001B2 (en) | Customizing backup and restore of databases | |
| CN111367924A (en) | Data synchronization method and device, electronic equipment and storage medium | |
| CN107451104A (en) | A kind of file version information storage method and its special purpose device | |
| CN110196880A (en) | Synchronization of data in heterogeneous database method and apparatus, storage medium and electronic device | |
| US11256572B2 (en) | Systems and methods for processing data in security systems using parallelism, stateless queries, data slicing, or asynchronous pull mechanisms | |
| CN104462261A (en) | Method for making only MDF attached to restore database | |
| Gonzalez-Berges | The high-performance database archiver for the LHC experiments |
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 |
Application publication date: 20170104 |
|
| RJ01 | Rejection of invention patent application after publication |