CN107229540A - A kind of database restoring method and system based on time point - Google Patents
A kind of database restoring method and system based on time point Download PDFInfo
- Publication number
- CN107229540A CN107229540A CN201710438577.4A CN201710438577A CN107229540A CN 107229540 A CN107229540 A CN 107229540A CN 201710438577 A CN201710438577 A CN 201710438577A CN 107229540 A CN107229540 A CN 107229540A
- Authority
- CN
- China
- Prior art keywords
- time point
- snapshot
- database
- collection
- data
- 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
- G06F11/1451—Management of the data involved in backup or backup restore by selection of backup contents
-
- 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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
- G06F2201/80—Database-specific techniques
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
- G06F2201/84—Using snapshots, i.e. a logical point-in-time copy of the data
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 a kind of database restoring method based on time point and system, methods described includes：Set up the snapshot collection of database；The delta data in the database is caught, and the delta data is stored into change file；Auxiliary information is added in the change file；The change file is associated with the snapshot collection, is formed and recovers collection；Recover to collect according to described, by the database recovery to seclected time point.The present invention adds in recovery process required auxiliary information by being able to ensure that delta data is stored.
Description
Technical field
The present invention relates to database technical field, more particularly to a kind of database recovery technical field.
Background technology
Enterprise collect data volume increase with surprising rapidity, many databases can occur damaging or some systems therefore
Recover data after barrier and rebuild, and some can not.Even if database can be reconstructed, performance is also very low, it may be necessary to a couple of days
Or several weeks complete, this depends on the data volume to be reduced.
In order to alleviate this problem, enterprise generally creates multiple Database Replicas by replicating or copying data, with true
Guarantor will not cause data unavailable because of any one server failure.This is for server failure, natural disaster, power-off etc.
It is good method for situation.But in some cases, stood intact on database physical, but mistake has had influence on number
According to, and compensating operation can not be easily passed through to correct.Generally this be due to artificial operating mistake, or in application program it is hidden
Hide undiscovered misprogrammed and cause.So if database can return to a time point specified, in this time
The state of point data base is good, and this will be particularly useful.
Database recovery to specified time mainly there are into two kinds of mechanism at present：1) some databases are by using write-ahead log
(WAL), audit reforms or cancelled to support this function.2) some other database allow to use data snapshot as one substantially
Starting point, then completed using above-mentioned audit playback mechanism this operation.Both the above mechanism exists following not enough：It is first
First, both mechanism are required for ensureing that WAL can use in data recovery, it is therefore desirable to be integrated into inside storage engines, to ensure
WAL files will not be deleted prematurely.And WAL files then can not be directly controlled for the application system independently of storage engines, enter
And can not also ensure that the delta data in WAL files can be stored without being deleted.Secondly, in some write-ahead logs WAL
Cause not including all data needed for playback wherein because auxiliary information can not be added, for example, for institute on an independent table
The snapshot change of the particular version done, or specific catalog change or metadata operation, usual WAL is all without having such as
Such associated ancillary information.
Accordingly, it would be desirable to which a kind of restoration methods, make also to can guarantee that the change to be played back in the case of independently of storage engines
Data are stored, it is necessary to which a kind of can add the file of auxiliary information so that required all data can be included in file, so as to
Preferably database can be recovered.
The content of the invention
For defect of the prior art, the present invention provides a kind of database restoring method and system based on time point,
Write-ahead log WAL files are substituted using the change file unrelated with storage engines, it can be ensured that what is do not controlled by storage engines
In the case of, it also can be stored delta data, and required auxiliary information can be added in recovery process.
In a first aspect, the invention provides a kind of database restoring method based on time point, methods described includes：
Set up the snapshot collection of database；
The delta data in the database is caught, and the delta data is stored into change file；
Auxiliary information is added in the change file；
The change file is associated with the snapshot collection, is formed and recovers collection；
Recover to collect according to described, by the database recovery to seclected time point.
Further, the snapshot collection includes corresponding first snapshot of first time point.
Further, it is described to associate the change file with the snapshot collection, formed and recover collection, specifically included：By institute
State change file to associate with first snapshot, formed and recover collection.
Further, it is described to recover to collect according to described, by the database recovery to seclected time point, specifically include：Profit
With first snapshot, by the database recovery to the first time point；The first change in the playback change file
Data；Wherein, first delta data changes in file from the first time point to the seclected time point to be described
The delta data produced within time range.
Further, the snapshot collection includes：Corresponding first snapshot of first time point, multiple middle time points are right respectively
The multiple center section snapshots answered；Wherein, the middle time point is the first time point to building between current point in time
A time point of snapshot is stood.
Further, it is described to associate the change file with the snapshot collection, formed and recover collection, specifically included：
Search the second time point corresponding second snapshot；Wherein, second time point is before the seclected time point
The middle time point nearest apart from the seclected time point, second snapshot is second time point corresponding center section
Snapshot；
The change file is associated with second snapshot, is formed and recovers collection.
Further, it is described to recover to collect according to described, by the database recovery to seclected time point, specifically include：
Using second snapshot, by the database recovery to second time point；
The second delta data in the playback change file；Wherein, second delta data is the change file
In from second time point to the time range of the seclected time point within the delta data that produces.
Second aspect, present invention also offers a kind of present in database recovery system based on time point, the system includes：Number
According to backup module, change capture module, information add module, data association module, data recovery module；Wherein, the data
Backup module is connected with the change capture module, and the change capture module is connected with described information add module, the letter
Add module and the data association module are ceased, the data association module is connected with the data recovery module；
The data backup module, the snapshot collection for creating database；
The change capture module, is stored for catching the delta data in the database, and by the delta data
Into change file；
Described information add module, for adding auxiliary information in change file；Wherein, the auxiliary information includes text
Part storage format, file store path；
The data association module, for the change file to be associated with the snapshot collection, forms and recovers collection；
The data recovery module, for recovering to collect according to described, by database recovery to seclected time point.
Further, the snapshot collection includes corresponding first snapshot of first time point.
Further, the data association module, specifically for：The change file is associated with first snapshot,
Formed and recover collection.
As shown from the above technical solution, the present invention provides a kind of database restoring method and system based on time point, adopts
Write-ahead log WAL files are substituted with the change file unrelated with storage engines, it can be ensured that in the feelings not controlled by storage engines
It under condition, also can be stored delta data, and required auxiliary information can be added in recovery process, and then can be preferably
By database recovery to any one seclected time point.
Brief description of the drawings
The schematic flow sheet for the database restoring method based on time point that Fig. 1 provides for the present invention.
The example schematic for the database restoring method based on time point that Fig. 2 provides for the present invention.
The structural representation for the present in database recovery system based on time point that Fig. 3 provides for the present invention.
Embodiment
The embodiment of technical solution of the present invention is described in detail below in conjunction with accompanying drawing.Following examples are only used for
Clearly illustrate technical scheme, therefore be intended only as example, and the protection of the present invention can not be limited with this
Scope.
Embodiment one
Fig. 1 shows the schematic flow sheet for the database restoring method based on time point that the embodiment of the present invention one is provided.
As shown in figure 1, a kind of database restoring method based on time point, including：
Step S1, sets up the snapshot collection of database；
Step S2, catches the delta data in the database, and the delta data is stored into change file；
Step S3, auxiliary information is added in the change file；
Step S4, the change file is associated with the snapshot collection, is formed and recovers collection；
Step S5, recovers to collect, by the database recovery to seclected time point according to described.
The concrete technical scheme of the present embodiment is as follows：
Step S1, sets up the snapshot collection of database.
By setting up the snapshot collection of database, to realize the backup to the database, one can be done to the data set
Secondary backup, now the snapshot collection is only including corresponding first snapshot of first time point；The database can also be done repeatedly
Back up or periodic backups, now the snapshot collection includes：Corresponding first snapshot of first time point, and multiple interludes
The corresponding multiple center section snapshots of point difference.Wherein, the middle time point is the first time point to current point in time
Between set up time point of snapshot, the time for not setting up snapshot is not admitted to middle time point of the present invention
Concept field.By repeatedly backing up and periodic backups, the recovery based on any time point need not all play back too many change
Change data, be generally reverted to a complete backup or snapshot, the state after a complete backup or snapshot soon, than extensive
The state arrived again after a large amount of change operations is faster.
Step S2, catches the delta data in the database, and the delta data is stored into change file.
After snapshot collection is set up, the delta data that each DML operations are produced such as insertion, modification, deletes the change number produced
According to, all write-in accumulation layer before be captured, and be stored to change file in.
Each change file includes a variety of data messages, in order to judge for a given recovery operation, which number
It is believed that breath needs to be played.Change file is independently of storage engines presence, can be by the control of product and the text safeguarded
Part, without being controlled by local resource manager, can be avoided by too early deletion.Local WAL files are replaced using this document, this
Ground WAL files are then no longer used, so as to reduce disk space, even and if to local WAL structures or agreement not very
Solution also ensures that data variation is stored.
Each change file only includes the delta data of specific resources (such as physical table), while each resource is independent
And the change file that has oneself, therefore recovery operation can be performed to different resource simultaneously, be independent of each other, can also be according to certain
Order successively perform recovery operation, for the selection of sequencing can reach that optimum performance is defined.
Step S3, auxiliary information is added in the change file.
Wherein, the auxiliary information includes the relevant information of application program, such as file memory format, file store path
Deng.By adding above-mentioned auxiliary information in the change file, make to include in file more more than usually used WAL files
Data so that allow application program by one change file be associated with corresponding snapshot, it can be ensured that can be more square during playback
Just the delta data that processing is stored therein, this is that local WAL files can not be realized.
Step S4, the change file is associated with the snapshot collection, is formed and recovers collection.
Alternatively, when the snapshot set only includes the first snapshot, step S4 is specifically included：By it is described change file with
The first snapshot association, forms and recovers collection.
Alternatively, when the snapshot set includes the first snapshot and multiple center section snapshots, step S4 is specially：Look into
Look for the second time point corresponding second snapshot；The change file is associated with second snapshot, is formed and recovers collection.Wherein,
Second time point is the nearest middle time point of the front distance seclected time point of seclected time point, and second snapshot is institute
State the second time point corresponding center section snapshot.
Change file is associated with corresponding snapshot, then recovered, can be avoided in recovery operation, by a change
Change file to be applied on the snapshot version of mistake.
Step S5, recovers to collect, by the database recovery to seclected time point according to described.
Recover after collection formation, you can recover to collect according to described, recovery operation is carried out to database.
Alternatively, when the snapshot set only includes the first snapshot, step S5 is specifically included：It is fast using described first
According to by the database recovery to first time point；The first delta data in the playback change file.Wherein, described
One delta data in the change file from first time point to the time range of seclected time point within the change number that produces
According to.
For different resource, it can be recovered through the above way, for example, for physical table, using described first
Snapshot, the corresponding version of first time point is returned to by the physical table of the database, specifically, can delete existing in database
Table, replaced with the first snapshot recovered in collection, using the version as baseline version, first be successively read in change file becomes
Change data, first delta data is applied in database, order of first delta data in database is with it in change
Order in file is identical.
Alternatively, when the snapshot set includes the first snapshot and multiple center section snapshots, step S5 is specifically included：
Using second snapshot, by the database recovery to the second time point；The second change number in the playback change file
According to.Wherein, second delta data for time range from the second time point to seclected time point in the change file with
The delta data of interior generation.
For different resource, it can be recovered through the above way, for example, for physical table, using described second
Snapshot, the second time point corresponding version is returned to by the physical table of the database, specifically, can delete existing in database
Table, replaced with the second snapshot recovered in collection, using the version as baseline version, second be successively read in change file becomes
Change data, first delta data is applied in database, order of second delta data in database is with it in change
Order in file is identical.
By the above method, recover collection with after seclected time point determining, any database can accurately be gone back
Original arrives the state of seclected time point.
Illustrate with reference to Fig. 2 concrete examples, Fig. 2 represents different physical tables with different horizontal lines：Table 1, table 2, table 3,
Table 4 and table 5, different snapshots corresponding time point is represented with vertical line, represented with the position of vertical line some snapshot specifically which
The corresponding snapshot of physical table, the DML done to data place is represented with broken line and is operated, and each DML operations can produce corresponding change
Change data, and be stored in change file.Specifically, shown in Fig. 2 on time shaft 10:00 is first time point, 10:00 is corresponding
Vertical line represents the first snapshot；11:00 and 12:30 be two middle time points, 11:00 and 12:30 corresponding vertical lines are represented respectively
Table 2 is 11:Corresponding center section snapshot, table 4 are 12 at 00:Corresponding center section snapshot at 30.
If selecting 12:00 is seclected time point, is also intended to the time point recovered, then for table 1,12:Before 00 only
There is the first snapshot, the first snapshot is recovered into collection with change file association formation.When being recovered according to recovery operation, first by table
1 returns to 10 using the first snapshot:State where 00, then from 10:00 starts to play back delta data, until being played back to 12:
00, that is, the whole recovery operation to table 1 is completed, this part delta data played back is the first delta data.
For table 2,12:There are two snapshots before 00, be 10 respectively:00 the first snapshot and 11:00 centre
Part snapshot, wherein, 11:00 center section snapshot is also 12:The nearest snapshot of the 00 front distance seclected time point, i.e.,
Second snapshot, collection is recovered by the second snapshot with change file association formation.When being recovered according to recovery operation, first by table 2
11 are returned to using the second snapshot:State where 00, then from 11:00 starts to play back delta data, until being played back to 12:
00, that is, the whole recovery operation to table 1 is completed, this part delta data played back is the second delta data.
For table 3, table 4, table 5, the mode of its recovery operation is identical with table 1, wherein, table 4 is 12:Although there is centre when 30
Part snapshot, but this impinges upon selected time point 12 soon:After 00, therefore it cannot function as the second snapshot and use, meanwhile, 12:00
Later delta data can not be used because being produced after seclected time point in recovery operation.
Based on above content, the technique effect that the embodiment of the present invention one can be realized is：Using unrelated with storage engines
Change file and substitute write-ahead log WAL files, it can be ensured that in the case of not by storage engines control, can also make delta data
Stored, and required auxiliary information can be added in recovery process, and then can recover number consistent in affairs
According to storehouse to any one seclected time point.
Embodiment two
To the embodiment of the present invention one accordingly, Fig. 3 shows a kind of number based on time point provided in an embodiment of the present invention
According to the structural representation of storehouse recovery system.As shown in figure 3, the system includes：Data backup module 101, change capture module
102, information add module 103, data association module 104, data recovery module 105.The data backup module 101 with it is described
Change capture module 102 is connected, and the change capture module 102 is connected with described information add module 103, described information addition
Module 103 and the data association module 104, the data association module 104 are connected with the data recovery module 105.
The data backup module 101, the snapshot collection for creating database, is backed up to the database；It is described
Data backup module 101 is backed up by creating the snapshot collection of database to realize to the database, wherein, it is described fast
It can only include corresponding first snapshot of first time point according to collection, multiple snapshots, i.e. first time point can also be included corresponding
First snapshot, and multiple middle time points distinguish corresponding multiple center section snapshots.
The change capture module 102, is deposited for catching the delta data in the database, and by the delta data
Storage is into change file.The change capture module 102 is captured before delta data is written into accumulation layer, and becomes described
Change data storage to changing file.
Described information add module 103, for adding auxiliary information in change file；Wherein, the auxiliary information bag
Include the relevant information of application program, such as file memory format, file store path.Using information add module 103 described
Above-mentioned auxiliary information is added in change file, makes in file to include than the usually used more data of WAL files, so as to permit
Perhaps a change file is associated by application program with corresponding snapshot, it can be ensured that can more easily handle and be stored in during playback
Delta data therein, this is that local WAL files can not be realized.
The data association module 104, for the change file to be associated with the snapshot collection, forms and recovers collection.Tool
Body is used for：When the snapshot collection includes the first snapshot, the change file is associated with first snapshot, is formed and recovered
Collection；When the snapshot set includes the first snapshot and multiple center section snapshots, searched for the second time point corresponding second fast
According to, by it is described change file associate with second snapshot, formed recovery collect.
The data recovery module 105, for recovering to collect according to described, by database recovery to seclected time point.Specifically
For：When the snapshot set only includes the first snapshot, using first snapshot, during by the database recovery to first
Between point, then play back it is described change file in the first delta data；In the snapshot set includes the first snapshot and is multiple
Between part snapshot when, using second snapshot, by the database recovery to the second time point, then play back it is described change text
The second delta data in part.
Preferably, the data recovery module 105 include recovery engine and playback engine, the recovery engine with described time
Engine connection is put, and is connected with the data association module 104.The recovery engine is used to perform recovery operation, specifically for
Using first snapshot, by the database recovery to first time point, or second snapshot is utilized, by the database
Returned to for the second time point.The playback engine is used to perform playback operation, specifically for：When the database is restored to
During one time point, the first delta data in the change file is played back, when the database was restored to for the second time point,
The second delta data in the playback change file.
Based on above content, what the embodiment of the present invention two can reach has the technical effect that：The system is used draws with storage
Hold up unrelated change file and substitute write-ahead log WAL files, it can be ensured that in the case of not by storage engines control, can also make
Delta data is stored, and can add in recovery process required auxiliary information, and then preferably can be recovered in affairs
Consistent database is to any one seclected time point.
Finally it should be noted that：Various embodiments above is merely illustrative of the technical solution of the present invention, rather than its limitations；To the greatest extent
The present invention is described in detail with reference to foregoing embodiments for pipe, it will be understood by those within the art that：Its according to
The technical scheme described in foregoing embodiments can so be modified, or which part or all technical characteristic are entered
Row equivalent substitution；And these modifications or replacement, the essence of appropriate technical solution is departed from various embodiments of the present invention technology
The scope of scheme, it all should cover among the claim of the present invention and the scope of specification.
Claims (10)
1. a kind of database restoring method based on time point, it is characterised in that methods described includes：
Set up the snapshot collection of database；
The delta data in the database is caught, and the delta data is stored into change file；
Auxiliary information is added in the change file；
The change file is associated with the snapshot collection, is formed and recovers collection；
Recover to collect according to described, by the database recovery to seclected time point.
2. the database restoring method according to claim 1 based on time point, it is characterised in that the snapshot collection includes
Corresponding first snapshot of first time point.
3. the database restoring method according to claim 2 based on time point, it is characterised in that described by the change
File is associated with the snapshot collection, is formed and is recovered collection, specifically included：
The change file is associated with first snapshot, is formed and recovers collection.
4. the database restoring method according to claim 3 based on time point, it is characterised in that described according to described extensive
Multiple collection, by the database recovery to seclected time point, is specifically included：
Using first snapshot, by the database recovery to the first time point；
The first delta data in the playback change file；Wherein, first delta data for it is described change file in from
The delta data produced within the first time point to the time range of the seclected time point.
5. the database restoring method according to claim 1 based on time point, it is characterised in that the snapshot Ji Bao
Include：Corresponding first snapshot of first time point, multiple middle time points distinguish corresponding multiple center section snapshots；Wherein, institute
It is the first time point to the time point for establishing snapshot between current point in time to state middle time point.
6. the database restoring method according to claim 5 based on time point, it is characterised in that described by the change
File is associated with the snapshot collection, is formed and is recovered collection, specifically included：
Search the second time point corresponding second snapshot；Wherein, second time point is the front distance of the seclected time point
The nearest middle time point of the seclected time point, second snapshot is fast for second time point corresponding center section
According to；
The change file is associated with second snapshot, is formed and recovers collection.
7. the database restoring method according to claim 6 based on time point, it is characterised in that described according to described extensive
Multiple collection, by the database recovery to seclected time point, is specifically included：
Using second snapshot, by the database recovery to second time point；
The second delta data in the playback change file；Wherein, second delta data for it is described change file in from
The delta data produced within second time point to the time range of the seclected time point.
8. a kind of present in database recovery system based on time point, it is characterised in that the system includes：Data backup module, becomes
Change capture module, information add module, data association module, data recovery module；Wherein, the data backup module with it is described
Change capture module is connected, and the change capture module is connected with described information add module, described information add module and institute
Data association module is stated, the data association module is connected with the data recovery module；
The data backup module, the snapshot collection for creating database；
The change capture module, is stored to change for catching the delta data in the database, and by the delta data
Change in file；
Described information add module, for adding auxiliary information in change file；Wherein, the auxiliary information is deposited including file
Store up form, file store path；
The data association module, for the change file to be associated with the snapshot collection, forms and recovers collection；
The data recovery module, for recovering to collect according to described, by database recovery to seclected time point.
9. the present in database recovery system according to claim 8 based on time point, it is characterised in that the snapshot collection includes
Corresponding first snapshot of first time point.
10. the present in database recovery system according to claim 8 based on time point, it is characterised in that the data correlation
Module, specifically for：The change file is associated with first snapshot, is formed and recovers collection.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710438577.4A CN107229540A (en) | 2017-06-06 | 2017-06-06 | A kind of database restoring method and system based on time point |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710438577.4A CN107229540A (en) | 2017-06-06 | 2017-06-06 | A kind of database restoring method and system based on time point |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107229540A true CN107229540A (en) | 2017-10-03 |
Family
ID=59936268
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710438577.4A Pending CN107229540A (en) | 2017-06-06 | 2017-06-06 | A kind of database restoring method and system based on time point |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107229540A (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108664359A (en) * | 2018-05-23 | 2018-10-16 | 上海达梦数据库有限公司 | A kind of database restoring method, device, equipment and storage medium |
| CN109086333A (en) * | 2018-07-04 | 2018-12-25 | 联想(北京)有限公司 | Processing method and system for data block |
| CN112214471A (en) * | 2019-07-09 | 2021-01-12 | 浙江宇视科技有限公司 | Database management method and device, computer readable storage medium and electronic device |
| CN112256481A (en) * | 2020-10-26 | 2021-01-22 | 华泰证券股份有限公司 | Data recovery method and system in agile development |
| CN112463447A (en) * | 2020-11-25 | 2021-03-09 | 浪潮云信息技术股份公司 | Optimization method for realizing physical backup based on distributed database |
| CN112988469A (en) * | 2021-04-27 | 2021-06-18 | 支付宝(杭州)信息技术有限公司 | State backup method and device in alliance chain and electronic equipment |
| CN115510144A (en) * | 2022-11-17 | 2022-12-23 | 北京滴普科技有限公司 | Method and system for capturing real-time change data of database |
| WO2023146472A3 (en) * | 2022-01-29 | 2023-10-12 | 脸萌有限公司 | Reset command configuration method and apparatus, and device and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101216843A (en) * | 2008-01-17 | 2008-07-09 | 四川大学 | Multi-point multi-level data real time backup method |
| US9075814B2 (en) * | 2007-03-20 | 2015-07-07 | Micron Technology, Inc. | Memory device, electronic system, and methods associated with modifying data and a file of a memory device |
| CN105389230A (en) * | 2015-10-21 | 2016-03-09 | 上海爱数信息技术股份有限公司 | Continuous data protection system and method combining with snapshot technology |
| CN105446828A (en) * | 2014-09-30 | 2016-03-30 | 北京金山云网络技术有限公司 | Database backup and recovery method, apparatus and system |
| CN105808381A (en) * | 2016-03-05 | 2016-07-27 | 成都云祺科技有限公司 | Instant recovery method of virtual machine |
-
2017
- 2017-06-06 CN CN201710438577.4A patent/CN107229540A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9075814B2 (en) * | 2007-03-20 | 2015-07-07 | Micron Technology, Inc. | Memory device, electronic system, and methods associated with modifying data and a file of a memory device |
| CN101216843A (en) * | 2008-01-17 | 2008-07-09 | 四川大学 | Multi-point multi-level data real time backup method |
| CN105446828A (en) * | 2014-09-30 | 2016-03-30 | 北京金山云网络技术有限公司 | Database backup and recovery method, apparatus and system |
| CN105389230A (en) * | 2015-10-21 | 2016-03-09 | 上海爱数信息技术股份有限公司 | Continuous data protection system and method combining with snapshot technology |
| CN105808381A (en) * | 2016-03-05 | 2016-07-27 | 成都云祺科技有限公司 | Instant recovery method of virtual machine |
Non-Patent Citations (1)
| Title |
|---|
| 王玉稳，等: "多点多跳的数据表实时备份方法", 《计算机工程与设计》 * |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108664359A (en) * | 2018-05-23 | 2018-10-16 | 上海达梦数据库有限公司 | A kind of database restoring method, device, equipment and storage medium |
| CN108664359B (en) * | 2018-05-23 | 2020-12-29 | 上海达梦数据库有限公司 | Database recovery method, device, equipment and storage medium |
| CN109086333A (en) * | 2018-07-04 | 2018-12-25 | 联想(北京)有限公司 | Processing method and system for data block |
| CN109086333B (en) * | 2018-07-04 | 2022-03-25 | 联想(北京)有限公司 | Processing method and system for data block |
| CN112214471A (en) * | 2019-07-09 | 2021-01-12 | 浙江宇视科技有限公司 | Database management method and device, computer readable storage medium and electronic device |
| CN112214471B (en) * | 2019-07-09 | 2024-04-05 | 浙江宇视科技有限公司 | Database management method, device, computer readable storage medium and electronic equipment |
| CN112256481A (en) * | 2020-10-26 | 2021-01-22 | 华泰证券股份有限公司 | Data recovery method and system in agile development |
| CN112463447A (en) * | 2020-11-25 | 2021-03-09 | 浪潮云信息技术股份公司 | Optimization method for realizing physical backup based on distributed database |
| CN112988469A (en) * | 2021-04-27 | 2021-06-18 | 支付宝(杭州)信息技术有限公司 | State backup method and device in alliance chain and electronic equipment |
| WO2023146472A3 (en) * | 2022-01-29 | 2023-10-12 | 脸萌有限公司 | Reset command configuration method and apparatus, and device and storage medium |
| US11914584B2 (en) | 2022-01-29 | 2024-02-27 | Lemon Inc. | Method and apparatus for reset command configuration, device and storage medium |
| CN115510144A (en) * | 2022-11-17 | 2022-12-23 | 北京滴普科技有限公司 | Method and system for capturing real-time change data of database |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107229540A (en) | A kind of database restoring method and system based on time point | |
| CN108376109B (en) | Apparatus and method for copying volume of source array to target array, storage medium | |
| US7330859B2 (en) | Database backup system using data and user-defined routines replicators for maintaining a copy of database on a secondary server | |
| US10503616B2 (en) | Periodic data replication | |
| CN105574187B (en) | A kind of Heterogeneous Database Replication transaction consistency support method and system | |
| CA2626227C (en) | Apparatus and method for creating a real time database replica | |
| US7987158B2 (en) | Method, system and article of manufacture for metadata replication and restoration | |
| US9218377B2 (en) | Failure recovery and error correction techniques for data loading in information warehouses | |
| JP5039891B2 (en) | Apparatus and method for generating a replica of a database | |
| TWI222562B (en) | Dynamic links to file system snapshots | |
| CN105843702B (en) | A kind of method and device for data backup | |
| US20190163765A1 (en) | Continuous data management system and operating method thereof | |
| CN109522290B (en) | HBase data block recovery and data record extraction method | |
| CN103761165B (en) | Log backup method and device | |
| CN110543386B (en) | Data storage method, device, equipment and storage medium | |
| CN108255638B (en) | Snapshot rollback method and device | |
| JP2006525599A (en) | Flashback database | |
| CN112099989A (en) | Disaster recovery, migration and recovery method for Kubernetes cloud native application | |
| CN102388369B (en) | Be derived from the life cycle of the granularity application data of single backup | |
| US8762347B1 (en) | Method and apparatus for processing transactional file system operations to enable point in time consistent file data recreation | |
| CN103617277A (en) | Method for restoring data table content deleted mistakenly | |
| CN106155838B (en) | A kind of database back-up data restoration methods and device | |
| CN106155832A (en) | Method, device and the Android device that a kind of data are recovered | |
| CN112286730A (en) | Method for performing remote full backup and recovery on HDFS file | |
| CN110825546A (en) | Recovery method, system and equipment terminal for high-availability database cluster |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20171003 |