CN110263095A - Backup and recovery method, apparatus, computer equipment and storage medium - Google Patents
Backup and recovery method, apparatus, computer equipment and storage medium Download PDFInfo
- Publication number
- CN110263095A CN110263095A CN201910469106.9A CN201910469106A CN110263095A CN 110263095 A CN110263095 A CN 110263095A CN 201910469106 A CN201910469106 A CN 201910469106A CN 110263095 A CN110263095 A CN 110263095A
- Authority
- CN
- China
- Prior art keywords
- database
- data
- backup
- backup database
- primary
- 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.)
- Granted
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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Abstract
The invention discloses a kind of backup and recovery method, apparatus, computer equipment and storage mediums, belong to technical field of data processing.Method include: when carrying out data backup to primary database, by the data of the primary database at various time intervals Lag synchronization to multiple backup databases;When the primary database when the error occurs, determined in the multiple backup database for the primary database carry out data recovery target backup database;Data recovery is carried out to the data of the primary database using the data of the target backup database, it is compared to data reconstruction method in the prior art, the present invention being capable of fast quick-recovery primary database, failure recovery time can be obviously shortened, and can fail to avoid fault recovery, improve the overall usability of Database Systems.
Description
Technical field
The present invention relates to technical field of data processing more particularly to a kind of backup and recovery method, apparatus, computer
Equipment and storage medium.
Background technique
DB Backup usually has cold standby and hot standby two kinds of normal methods at present, and cold standby refers to by DBA (data base administration
Member) or system manager regularly export data manually from Production database to local preservation, it is hot standby refer to do not need DBA or
Person system manager manually executes, and is automatically carried out by system and backs up such as leader follower replication, main duplication etc., at present mainstream company
Using be all full backup+incremental backup by the way of, such as carry out within one month the full dose export an of Production database, daily into
The increase derivation of Production database of row.
Either hot standby or cold standby, if Production database once is caused to delete full library by artificial maloperation, often
The data reconstruction method seen is typically all the full backup data file for finding out the beginning of the month, and then every daily increment after finding out is standby
Part file, then all binlog journal files that database is deleted the same day of point are found, it then in turn executes, Zhi Daosuo
There are data file and binlog journal file to be finished, that is, complete the recovery of database data, such scheme is potential
Problem is to need to be implemented all daily increment file and binlog journal file, and data reparation is slower, if encounter the end of the month
Situation, the daily increment file needed to be implemented is more, and it is slower to restore data.
Summary of the invention
In order to solve the problems, such as at least one mentioned in above-mentioned background technique, the present invention provides a kind of data backup with it is extensive
Multiple method, apparatus, computer equipment and storage medium.
Specific technical solution provided in an embodiment of the present invention is as follows:
In a first aspect, the present invention provides a kind of backup and recovery method, which comprises
When carrying out data backup to primary database, the data of the primary database are postponed at various time intervals same
It walks to multiple backup databases;
When the primary database when the error occurs, determined in the multiple backup database for the master data
The target backup database of library progress data recovery;
Data recovery is carried out to the data of the primary database using the data of the target backup database.
In a preferred embodiment, described when mistake occurs in the primary database, in the multiple backup database
Determine the target backup database for carrying out data recovery to the primary database, comprising:
Determine the faulty operation for causing the primary database mistake occur;
A backup database for being not carried out the faulty operation in the multiple backup database is determined as described
Target backup database.
In a preferred embodiment, be not carried out the faulty operation one by the multiple backup database
A backup database is determined as the target backup database
In the backup database for being not carried out the faulty operation, the smallest backup database of time interval is determined as institute
State target backup database.
In a preferred embodiment, number of the data using the target backup database to the primary database
According to progress data recovery, comprising:
In the operation log of the primary database, searches the target backup database last time and complete to synchronize up to described
All operation notes between when faulty operation occurs;
Each operation note is executed, successively on the target backup database to update the target backup database
Data;
Data recovery is carried out using data of the updated data of target backup database to the primary database.
In a preferred embodiment, the operation log of the primary database includes at least binary log binlog.
Second aspect, provides a kind of backup and recovery device, and described device includes:
Data backup module is used for when carrying out data backup to primary database, by the data of the primary database with not
With time interval Lag synchronization to multiple backup databases;
Data recovery module determines in the multiple backup database for working as the primary database when the error occurs
Out for carrying out the target backup database of data recovery to the primary database, the data of the target backup database are used
Data recovery is carried out to the data of the primary database.
In a preferred embodiment, the data recovery module is specifically used for:
Determine the faulty operation for causing the primary database mistake occur;
A backup database for being not carried out the faulty operation in the multiple backup database is determined as described
Target backup database.
In a preferred embodiment, the data recovery module is specifically also used to:
In the backup database for being not carried out the faulty operation, the smallest backup database of time interval is determined as institute
State target backup database.
In a preferred embodiment, the data recovery module is specifically also used to:
In the operation log of the primary database, searches the target backup database last time and complete to synchronize up to described
All operation notes between when faulty operation occurs;
Each operation note is executed, successively on the target backup database to update the target backup database
Data;
Data recovery is carried out using data of the updated data of target backup database to the primary database.
In a preferred embodiment, the operation log of the primary database includes at least binary log binlog.
The third aspect provides a kind of computer equipment, comprising:
One or more processors;
Storage device, for storing one or more programs;
When one or more of programs are executed by one or more of processors, so that one or more of processing
Device realizes the method as described in first aspect is any.
Fourth aspect provides a kind of computer readable storage medium, is stored thereon with computer program, described program quilt
The method as described in first aspect is any is realized when processor executes.
The embodiment of the invention provides a kind of backup and recovery method, apparatus, computer equipment and storage mediums, lead to
It crosses when carrying out data backup to primary database, by the data of the primary database, Lag synchronization is at most at various time intervals
A backup database;When the primary database when the error occurs, determine in the multiple backup database for described
The target backup database of primary database progress data recovery;Using the data of the target backup database to the master data
The data in library carry out data recovery, are compared to data reconstruction method in the prior art, and the present invention being capable of the main number of fast quick-recovery
According to library, it can be obviously shortened failure recovery time, and can be failed to avoid fault recovery, the entirety for improving Database Systems can
The property used.
Detailed description of the invention
To describe the technical solutions in the embodiments of the present invention more clearly, make required in being described below to embodiment
Attached drawing is briefly described, it should be apparent that, drawings in the following description are only some embodiments of the invention, for
For those of ordinary skill in the art, without creative efforts, it can also be obtained according to these attached drawings other
Attached drawing.
Fig. 1 is the application environment schematic diagram of backup and recovery method provided in an embodiment of the present invention;
Fig. 2 is a kind of flow diagram of backup and recovery method provided in an embodiment of the present invention;
Fig. 3 is a kind of structural schematic diagram of backup and recovery device provided in an embodiment of the present invention.
Specific embodiment
To make the object, technical solutions and advantages of the present invention clearer, below in conjunction with attached in the embodiment of the present invention
Figure, technical scheme in the embodiment of the invention is clearly and completely described, it is clear that described embodiment is only this
Invention a part of the embodiment, instead of all the embodiments.Based on the embodiments of the present invention, those of ordinary skill in the art exist
Every other embodiment obtained under the premise of creative work is not made, shall fall within the protection scope of the present invention.
Backup and recovery method provided in an embodiment of the present invention, can be applied in application environment as shown in Figure 1,
Wherein, it is communicated between primary database 1 and two backup databases 2 by network, it is to be understood that backup database
Quantity can be two or more.Primary database 1 can be the database program being mounted on one or more servers, backup number
It equally can be the database program being mounted on one or more servers according to library 2.Above-mentioned database program may include
MySQL, SQL Server and Oracle etc..It, can be using MySQL as database program in the embodiment of the present invention.
Embodiment one
Referring to shown in Fig. 2, the embodiment of the present invention provides a kind of backup and recovery method, and the method comprising the steps of:
S1, to primary database carry out data backup when, the data of the primary database are prolonged at various time intervals
It is synchronized to multiple backup databases late.
In the present embodiment, there are master-slave relationships between primary database and backup database, if execution pair in primary database
The operation of a certain data records the data operating record to the data, data manipulation in primary database operation log accordingly
Record includes Data Identification, store path, operational order and the operating time of data, in Lag synchronization, is grasped from primary database
Make the data operating record for getting the data in log, and according to the data operating record of data, is held on backup database
The same operation gone to the data, and then it is synchronous to complete the data between primary database and backup database.
In the present embodiment, different time intervals is arranged to primary database and carries out Lag synchronization to different Backup Datas
Library, different time intervals correspond to different backup databases, and specific time interval can be according to the quantity of backup database
It is configured.For example, when the quantity of backup database is two, it can be by the corresponding time interval of first backup database
It is set as 1 hour, the corresponding time interval of second backup database is set as 1.5 hours.That is, at interval of 1 hour
To the data Lag synchronization of primary database to first backup database, postpone at interval of 1.5 hours data by primary database
It is synchronized to the second backup database.In another example when the quantity of backup database is three, it can be by first backup database
Corresponding time interval is set as 1 hour, and the corresponding time interval of second backup database is set as 1.5 hours, third
The corresponding time interval of backup database is set as 2 hours.Quantity of the embodiment of the present invention to time interval and backup database
It is not especially limited.
In the embodiment of the present invention, when carrying out data backup to primary database, by the data of the primary database with difference
Time interval Lag synchronization to multiple backup databases, due to not being by the real time data synchronization of primary database to multiple backups
It is standby due to also causing to delete while artificial maloperation deletion primary database thus, it is possible to avoid to a certain extent in database
Part database, wants the communication network between primary database and backup database in addition it is also possible to reduce to a certain extent
It asks, reduces the pressure to primary database and backup database.
S2, when the primary database when the error occurs, determined in the multiple backup database for the master
The target backup database of database progress data recovery.
Specifically, the realization process of step S2 may include steps of:
Step S21, the faulty operation for causing the primary database mistake occur is determined.
Wherein, faulty operation can be the operations such as mistake deletion, bug patch or mistake increase.
In the present embodiment, the operation log of primary database can be parsed using log analytical tool such as analytical function etc., from
The faulty operation for causing primary database mistake occur is parsed in primary database operation log.
Step S22, the backup database for being not carried out the faulty operation in the multiple backup database is true
It is set to the target backup database.
Specifically, which may include:
The time difference between current time and the time of origin of faulty operation is determined, by the time difference and each Backup Data
The corresponding time interval in library is compared, and according to comparison result, determines being not carried out in the multiple backup database
The backup database of the faulty operation chooses a backup database for being not carried out the faulty operation as to main number
The target backup database of data recovery is carried out according to library.
Wherein, if the comparison result instruction time difference is less than time interval, it is determined that in the corresponding backup number of the time interval
According to faulty operation is not carried out on library, otherwise, it is determined that executed faulty operation on the corresponding backup database of the time interval.
Wherein, described that a backup database for being not carried out the faulty operation in the multiple backup database is true
It is set to the target backup database, comprising:
In the backup database for being not carried out the faulty operation, the smallest backup database of time interval is determined as institute
State target backup database.
In the present embodiment, when the primary database when the error occurs, determine the mistake for causing the primary database mistake occur
Maloperation, and the backup database for being not carried out the faulty operation in the multiple backup database is determined as described
Target backup database carries out data recovery to primary database using the backup database for being not carried out faulty operation convenient for subsequent,
Thus an only backup database and primary database are solved and carries out Lag synchronization, if primary database perform faulty operation can
The backup database can be will lead to and also execute faulty operation, and the backup database is unable to complete that carry out data to primary database extensive
Multiple technological deficiency.
S3, data recovery is carried out to the data of the primary database using the data of the target backup database.
Specifically, the realization process of step S3 may include step:
S31, in the operation log of the primary database, search target backup database last time complete it is synchronous up to
All operation notes between when the faulty operation occurs.
Wherein, the operation log of the primary database includes at least binary log binlog.
S32, each operation note is successively executed on the target backup database, to update the target backup number
According to the data in library.
S33, to carry out data to the data of the primary database using the updated data of target backup database extensive
It is multiple.
In the present embodiment, completed by successively executing target backup database last time on the target backup database
All operation notes between when the faulty operation occurs are synchronized, the data of the target backup database are updated, and
Data recovery is carried out using data of the updated data of target backup database to the primary database, realizes logarithm
It is lost according to the fast quick-recovery in library, and caused by reducing when database occurs abnormal to the maximum extent.
In the embodiment of the present invention, by primary database carry out data backup when, by the data of the primary database with
Different time interval Lag synchronizations is to multiple backup databases;When the primary database when the error occurs, the multiple standby
The target backup database for carrying out data recovery to the primary database is determined in part database;It is standby using the target
The data of part database carry out data recovery to the data of the primary database, are compared to data recovery side in the prior art
Method, the present invention can fast quick-recovery primary database, failure recovery time can be obviously shortened, and can lose to avoid fault recovery
It loses, improves the overall usability of Database Systems.
Embodiment two
As the realization to the backup and recovery method in embodiment one, the embodiment of the present invention also provides a kind of data
Backup and recovery device, referring to shown in Fig. 3, which includes:
Data backup module 31, for primary database carry out data backup when, by the data of the primary database with
Different time interval Lag synchronizations is to multiple backup databases;
Data recovery module 32, for working as the primary database when the error occurs, in the multiple backup database really
The target backup database for carrying out data recovery to the primary database is made, the number of the target backup database is used
Data recovery is carried out according to the data to the primary database.
In a preferred embodiment, the data recovery module 32 is specifically used for:
Determine the faulty operation for causing the primary database mistake occur;
A backup database for being not carried out the faulty operation in the multiple backup database is determined as described
Target backup database.
In a preferred embodiment, the data recovery mould 32 is specifically also used to:
In the backup database for being not carried out the faulty operation, the smallest backup database of time interval is determined as institute
State target backup database.
In a preferred embodiment, the data recovery module 32 is specifically also used to:
In the operation log of the primary database, searches the target backup database last time and complete to synchronize up to described
All operation notes between when faulty operation occurs;
Each operation note is executed, successively on the target backup database to update the target backup database
Data;
Data recovery is carried out using data of the updated data of target backup database to the primary database.
In a preferred embodiment, the operation log of the primary database includes at least binary log binlog.
The embodiment of the invention provides a kind of backup and recovery devices, by carrying out data backup to primary database
When, by the data of the primary database at various time intervals Lag synchronization to multiple backup databases;When the master data
When the error occurs, the target for carrying out data recovery to the primary database is determined in the multiple backup database in library
Backup database;Data recovery is carried out to the data of the primary database using the data of the target backup database, is compared
Compared with data reconstruction method in the prior art, the present invention can fast quick-recovery primary database, fault recovery can be obviously shortened
Time, and can fail to avoid fault recovery, improve the overall usability of Database Systems.
It should be noted that about backup and recovery device it is specific restriction may refer to it is standby above for data
The restriction of part and restoration methods, details are not described herein.Modules in above-mentioned backup and recovery device can whole or portion
Divide and is realized by software, hardware and combinations thereof.Above-mentioned each module can be embedded in the form of hardware or independently of computer equipment
In processor in, can also be stored in a software form in the memory in computer equipment, in order to processor calling hold
The corresponding operation of the above modules of row.
In addition, the embodiment of the invention also provides a kind of computer equipments, comprising:
One or more processors;
Storage device, for storing one or more programs;
When one or more of programs are executed by one or more of processors, so that one or more of processing
Device realizes the backup and recovery method as described in embodiment one.
In addition, it is stored thereon with computer program the embodiment of the invention also provides a kind of computer readable storage medium,
The backup and recovery method as described in embodiment one is realized when described program is executed by processor.
It should be understood by those skilled in the art that, the embodiment in the embodiment of the present invention can provide as method, system or meter
Calculation machine program product.Therefore, complete hardware embodiment, complete software embodiment can be used in the embodiment of the present invention or combine soft
The form of the embodiment of part and hardware aspect.Moreover, being can be used in the embodiment of the present invention in one or more wherein includes meter
Computer-usable storage medium (including but not limited to magnetic disk storage, CD-ROM, the optical memory of calculation machine usable program code
Deng) on the form of computer program product implemented.
It is referring to the method for middle embodiment, equipment (system) according to embodiments of the present invention and to calculate in the embodiment of the present invention
The flowchart and/or the block diagram of machine program product describes.It should be understood that can be realized by computer program instructions flow chart and/or
The combination of the process and/or box in each flow and/or block and flowchart and/or the block diagram in block diagram.It can mention
For the processing of these computer program instructions to general purpose computer, special purpose computer, Embedded Processor or other programmable datas
The processor of equipment is to generate a machine, so that being executed by computer or the processor of other programmable data processing devices
Instruction generation refer to for realizing in one or more flows of the flowchart and/or one or more blocks of the block diagram
The device of fixed function.
These computer program instructions, which may also be stored in, is able to guide computer or other programmable data processing devices with spy
Determine in the computer-readable memory that mode works, so that it includes referring to that instruction stored in the computer readable memory, which generates,
Enable the manufacture of device, the command device realize in one box of one or more flows of the flowchart and/or block diagram or
The function of being specified in multiple boxes.
These computer program instructions also can be loaded onto a computer or other programmable data processing device, so that counting
Series of operation steps are executed on calculation machine or other programmable devices to generate computer implemented processing, thus in computer or
The instruction executed on other programmable devices is provided for realizing in one or more flows of the flowchart and/or block diagram one
The step of function of being specified in a box or multiple boxes.
Although the preferred embodiment in the embodiment of the present invention has been described, once a person skilled in the art knows
Basic creative concept, then additional changes and modifications may be made to these embodiments.So appended claims are intended to explain
Being includes preferred embodiment and all change and modification for falling into range in the embodiment of the present invention.
Obviously, various changes and modifications can be made to the invention without departing from essence of the invention by those skilled in the art
Mind and range.In this way, if these modifications and changes of the present invention belongs to the range of the claims in the present invention and its equivalent technologies
Within, then the present invention is also intended to include these modifications and variations.
Claims (12)
1. a kind of backup and recovery method, which is characterized in that the described method includes:
When carrying out data backup to primary database, by the data of the primary database, Lag synchronization is extremely at various time intervals
Multiple backup databases;
When the primary database when the error occurs, determined in the multiple backup database for the primary database into
The target backup database that row data are restored;
Data recovery is carried out to the data of the primary database using the data of the target backup database.
2. the method according to claim 1, wherein described there is mistake when the primary database, described more
The target backup database for carrying out data recovery to the primary database is determined in a backup database, comprising:
Determine the faulty operation for causing the primary database mistake occur;
A backup database for being not carried out the faulty operation in the multiple backup database is determined as the target
Backup database.
3. according to the method described in claim 2, it is characterized in that, described will be not carried out institute in the multiple backup database
A backup database for stating faulty operation is determined as the target backup database and includes:
In the backup database for being not carried out the faulty operation, the smallest backup database of time interval is determined as the mesh
Mark backup database.
4. according to claim 1 to method described in 3 any one, which is characterized in that described to use the target Backup Data
The data in library carry out data recovery to the data of the primary database, comprising:
In the operation log of the primary database, searches the target backup database last time and complete to synchronize up to the mistake
All operation notes between when operation occurs;
Each operation note is executed, successively on the target backup database to update the number of the target backup database
According to;
Data recovery is carried out using data of the updated data of target backup database to the primary database.
5. according to the method described in claim 4, it is characterized in that, the operation log of the primary database includes at least binary system
Log binlog.
6. a kind of backup and recovery device, which is characterized in that described device includes:
Data backup module is used for when carrying out data backup to primary database, by the data of the primary database with different
Time interval Lag synchronization is to multiple backup databases;
Data recovery module is determined to use for working as the primary database when the error occurs in the multiple backup database
In the target backup database for carrying out data recovery to the primary database, using the data of the target backup database to institute
The data for stating primary database carry out data recovery.
7. device according to claim 6, which is characterized in that the data recovery module is specifically used for:
Determine the faulty operation for causing the primary database mistake occur;
A backup database for being not carried out the faulty operation in the multiple backup database is determined as the target
Backup database.
8. device according to claim 7, which is characterized in that the data recovery module is specifically also used to:
In the backup database for being not carried out the faulty operation, the smallest backup database of time interval is determined as the mesh
Mark backup database.
9. according to device described in claim 6 to 8 any one, which is characterized in that the data recovery module is specifically also used
In:
In the operation log of the primary database, searches the target backup database last time and complete to synchronize up to the mistake
All operation notes between when operation occurs;
Each operation note is executed, successively on the target backup database to update the number of the target backup database
According to;
Data recovery is carried out using data of the updated data of target backup database to the primary database.
10. device according to claim 9, which is characterized in that the operation log of the primary database include at least two into
Log binlog processed.
11. a kind of computer equipment characterized by comprising
One or more processors;
Storage device, for storing one or more programs;
When one or more of programs are executed by one or more of processors, so that one or more of processors are real
Now method as claimed in any one of claims 1 to 5, wherein.
12. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that described program is processed
Device realizes method as claimed in any one of claims 1 to 5, wherein when executing.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910469106.9A CN110263095B (en) | 2019-05-31 | 2019-05-31 | Data backup and recovery method and device, computer equipment and storage medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910469106.9A CN110263095B (en) | 2019-05-31 | 2019-05-31 | Data backup and recovery method and device, computer equipment and storage medium |
Publications (2)
Publication Number | Publication Date |
---|---|
CN110263095A true CN110263095A (en) | 2019-09-20 |
CN110263095B CN110263095B (en) | 2021-10-01 |
Family
ID=67916341
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910469106.9A Active CN110263095B (en) | 2019-05-31 | 2019-05-31 | Data backup and recovery method and device, computer equipment and storage medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110263095B (en) |
Cited By (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110716828A (en) * | 2019-10-09 | 2020-01-21 | 苏州听风见雨网络科技有限公司 | Real-time database backup method |
CN110737545A (en) * | 2019-09-24 | 2020-01-31 | 华青融天(北京)软件股份有限公司 | data processing method, device, electronic equipment and storage medium |
CN113792340A (en) * | 2021-09-09 | 2021-12-14 | 烽火通信科技股份有限公司 | Method and device for auditing logical logs of database |
CN116541407A (en) * | 2023-07-07 | 2023-08-04 | 之江实验室 | Data processing method and device, storage medium and electronic equipment |
CN117369338A (en) * | 2023-11-15 | 2024-01-09 | 广州飞数工业软件有限公司 | Operation and maintenance management system and method for industrial manufacturing equipment |
Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20020152396A1 (en) * | 2001-04-11 | 2002-10-17 | Fox Michael S. | Method for secure restoration of a database stroring non-secure content |
US8352430B1 (en) * | 2009-11-06 | 2013-01-08 | Carbonite, Inc. | File storage system to support high data rates |
CN105045678A (en) * | 2015-07-09 | 2015-11-11 | 小米科技有限责任公司 | Database recovery method and apparatus |
CN105446828A (en) * | 2014-09-30 | 2016-03-30 | 北京金山云网络技术有限公司 | Database backup and recovery method, apparatus and system |
CN108089942A (en) * | 2016-11-21 | 2018-05-29 | 中移(苏州)软件技术有限公司 | A kind of data backup, restoration methods and device |
CN109032849A (en) * | 2018-08-30 | 2018-12-18 | 百度在线网络技术(北京)有限公司 | Hot backup system, heat backup method and computer equipment |
-
2019
- 2019-05-31 CN CN201910469106.9A patent/CN110263095B/en active Active
Patent Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20020152396A1 (en) * | 2001-04-11 | 2002-10-17 | Fox Michael S. | Method for secure restoration of a database stroring non-secure content |
US8352430B1 (en) * | 2009-11-06 | 2013-01-08 | Carbonite, Inc. | File storage system to support high data rates |
CN105446828A (en) * | 2014-09-30 | 2016-03-30 | 北京金山云网络技术有限公司 | Database backup and recovery method, apparatus and system |
CN105045678A (en) * | 2015-07-09 | 2015-11-11 | 小米科技有限责任公司 | Database recovery method and apparatus |
CN108089942A (en) * | 2016-11-21 | 2018-05-29 | 中移(苏州)软件技术有限公司 | A kind of data backup, restoration methods and device |
CN109032849A (en) * | 2018-08-30 | 2018-12-18 | 百度在线网络技术(北京)有限公司 | Hot backup system, heat backup method and computer equipment |
Cited By (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110737545A (en) * | 2019-09-24 | 2020-01-31 | 华青融天(北京)软件股份有限公司 | data processing method, device, electronic equipment and storage medium |
CN110737545B (en) * | 2019-09-24 | 2021-12-17 | 华青融天(北京)软件股份有限公司 | Data processing method and device, electronic equipment and storage medium |
CN110716828A (en) * | 2019-10-09 | 2020-01-21 | 苏州听风见雨网络科技有限公司 | Real-time database backup method |
CN110716828B (en) * | 2019-10-09 | 2023-05-23 | 宏为物联网科技(苏州)有限公司 | Database real-time backup method |
CN113792340A (en) * | 2021-09-09 | 2021-12-14 | 烽火通信科技股份有限公司 | Method and device for auditing logical logs of database |
CN113792340B (en) * | 2021-09-09 | 2023-09-05 | 烽火通信科技股份有限公司 | Method and device for auditing logical logs of database |
CN116541407A (en) * | 2023-07-07 | 2023-08-04 | 之江实验室 | Data processing method and device, storage medium and electronic equipment |
CN116541407B (en) * | 2023-07-07 | 2023-10-10 | 之江实验室 | Data processing method and device, storage medium and electronic equipment |
CN117369338A (en) * | 2023-11-15 | 2024-01-09 | 广州飞数工业软件有限公司 | Operation and maintenance management system and method for industrial manufacturing equipment |
Also Published As
Publication number | Publication date |
---|---|
CN110263095B (en) | 2021-10-01 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN110263095A (en) | Backup and recovery method, apparatus, computer equipment and storage medium | |
US11740974B2 (en) | Restoring a database using a fully hydrated backup | |
US20210224166A1 (en) | Database snapshot and backup management with recoverable chains | |
WO2019154394A1 (en) | Distributed database cluster system, data synchronization method and storage medium | |
US9582520B1 (en) | Transaction model for data stores using distributed file systems | |
US9367598B2 (en) | Merging an out of synchronization indicator and a change recording indicator in response to a failure in consistency group formation | |
US10628270B1 (en) | Point-in-time database restoration using a reduced dataset | |
US9251230B2 (en) | Exchanging locations of an out of synchronization indicator and a change recording indicator via pointers | |
US10216589B2 (en) | Smart data replication recoverer | |
WO2014169142A1 (en) | Partition level backup and restore of a massively parallel processing database | |
CN107256182A (en) | A kind of method and apparatus of database restoration | |
EP3796174B1 (en) | Restoring a database using a fully hydrated backup | |
US10146633B2 (en) | Data recovery from multiple data backup technologies | |
CN103455557A (en) | Log based structured data synchronization method | |
WO2017014814A1 (en) | Replicating memory volumes | |
CN116490855A (en) | Efficient backup after restore operations | |
CN106155838B (en) | A kind of database back-up data restoration methods and device | |
US11494271B2 (en) | Dynamically updating database archive log dependency and backup copy recoverability | |
US10664361B1 (en) | Transactionally consistent backup of partitioned storage | |
US11372838B2 (en) | Parallel processing of changes in a distributed system | |
JP2014170352A (en) | Information system and database restoration method | |
US11966297B2 (en) | Identifying database archive log dependency and backup copy recoverability | |
US20220121524A1 (en) | Identifying database archive log dependency and backup copy recoverability | |
CN115756960A (en) | Misoperation data recovery method and device, computer equipment and storage medium | |
CN115454725A (en) | Database backup method and device, electronic equipment and storage 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 | ||
GR01 | Patent grant | ||
GR01 | Patent grant |