CN106445738A - Database backup method and device - Google Patents
Database backup method and device Download PDFInfo
- Publication number
- CN106445738A CN106445738A CN201610821056.2A CN201610821056A CN106445738A CN 106445738 A CN106445738 A CN 106445738A CN 201610821056 A CN201610821056 A CN 201610821056A CN 106445738 A CN106445738 A CN 106445738A
- Authority
- CN
- China
- Prior art keywords
- backup
- historical data
- data
- database
- data table
- 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
- 238000000034 method Methods 0.000 title claims abstract description 38
- 230000001143 conditioned effect Effects 0.000 claims description 6
- 238000013144 data compression Methods 0.000 claims description 6
- 238000004140 cleaning Methods 0.000 claims description 3
- 238000011084 recovery Methods 0.000 abstract description 12
- 230000003247 decreasing effect Effects 0.000 abstract description 4
- 230000007423 decrease Effects 0.000 description 5
- 238000005192 partition Methods 0.000 description 5
- 230000008569 process Effects 0.000 description 5
- 238000005516 engineering process Methods 0.000 description 3
- 230000006870 function Effects 0.000 description 3
- 238000004422 calculation algorithm Methods 0.000 description 2
- 230000008859 change Effects 0.000 description 2
- 241000208340 Araliaceae Species 0.000 description 1
- 235000005035 Panax pseudoginseng ssp. pseudoginseng Nutrition 0.000 description 1
- 235000003140 Panax quinquefolius Nutrition 0.000 description 1
- 238000009795 derivation Methods 0.000 description 1
- 235000008434 ginseng Nutrition 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000003780 insertion Methods 0.000 description 1
- 230000037431 insertion Effects 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1448—Management of the data involved in backup or backup restore
- 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
- 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/22—Indexing; Data structures therefor; Storage structures
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Quality & Reliability (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a database backup method and device. Data tables in a database are classified into historical data tables and real-time service data tables; full-volume backup is conducted on the service data tables; incremental backup is conducted on the historical data tables; the backed-up service data tables and historical data tables are stored in a medium to complete backup of the database. Due to the fact that historical data in a large mysql database occupies a large amount of storage space and real-time service data is less, the historical data tables and the real-time service data tables are backed up in a separated mode, the data volume each time of backup can be decreased, the backup time and recovery time can be shortened, and the backup speed can be improved. It is thus clear that backup of the database in a large mysql database scene is rapidly achieved, the backup recovery time is decreased, backup file space occupation is decreased, and the backup recovery efficiency and the safety guarantee capability of the database are improved.
Description
Technical field
The present invention relates to DB Backup technical field, more particularly to a kind of database backup method and device.
Background technology
Data backup is the basis of disaster tolerance, refers to operational error for anti-locking system or the system failure leads to data to be lost
Lose, and all or part of data acquisition system is copied to the process of other storage mediums from applied host machine.Mysql is a kind of opening
The Relational DBMS (RDBMS) of source code, mysql Database Systems use the most frequently used data base administration language
Speech -- SQL (SQL) carries out data base administration, there is provided the community of mysql increases income version.The backup work providing
There is mysqldump, mysqlhotcopy, text backup.In community's version of increasing income, Mysqlhotcopy only supports that myisam draws
Hold up backup.Mysqldump order is the backup logic instrument that mysql carries, it is possible to achieve database level, the backup of table level, standby
During part, table structure and data dump are become sql to text.Mysqldump is provided that the control ginseng of data base consistency(-tance) backup
Number, enables the incremental backup of innodb engine table in conjunction with binlog file.
The feature of large database scene is that data volume is big, data volume substantially more than TB rank, current mysql data base
Generally adopt the innodb engine table of affairs type, adoptable instrument has mysql certainly when backing up mysql innodb engine table
Mysqldump, third party instrument xtrabackup of band etc..Because xtrabackup is to do database physical file backup, standby
The data set of part cannot compress, and needs transit space when backing up, when database server memory space is nervous, using this
Will there are a lot of problems in method.
Content of the invention
It is an object of the invention to provide a kind of database backup method and device, to solve existing mysql large database
Backup cycle length under scene, cycle length of recovering, backup file take up room big problem.
For solving above-mentioned technical problem, the present invention provides a kind of database backup method, including：
Tables of data in data base is classified, is divided into historical data table and real time traffic data table；
Full backup is carried out to described business datum table；
Incremental backup is carried out to described historical data table；
The described business datum table of backup and described historical data table are stored in medium, completes the standby of data base
Part.
Alternatively, described incremental backup is carried out to described historical data table include：
Determine same day data in described historical data table and newly-increased the next day historical data；
Respectively to described same day data and described newly-increased the next day historical data back up.
Alternatively, to described newly-increased the next day historical data backed up after also include：
According to default naming rule, backup file is named.
Alternatively, before the described described business datum table by backup and described historical data table store in medium
Also include：
Data compression is carried out to described business datum table and described historical data table.
Alternatively, also include：
When meeting pre-conditioned, stale data is cleared up.
Present invention also offers a kind of DB Backup device, including：
Sort module, for the tables of data in data base is classified, is divided into historical data table and real time business number
According to table；
Full backup module, for carrying out full backup to described business datum table；
Incremental backup module, for carrying out incremental backup to described historical data table；
Memory module, for storing in medium the described business datum table of backup and described historical data table, complete
Become the backup of data base.
Alternatively, described incremental backup module is specially：Determine the same day data in described historical data table and increase newly
The next day historical data；Respectively to described same day data and described newly-increased the next day module that backed up of historical data.
Alternatively, also include：
Name module, for described newly-increased the next day historical data back up after, according to default naming rule pair
Backup file is named.
Alternatively, also include：
Data compressing module, for storing medium by the described business datum table of backup and described historical data table
In before, data compression is carried out to described business datum table and described historical data table.
Alternatively, also include：
Cleaning modul, for when meeting pre-conditioned, clearing up to stale data.
Database backup method provided by the present invention and device, by the tables of data in data base is classified, point
For historical data table and real time traffic data table；Full backup is carried out to business datum table；Increment is carried out to historical data table
Backup；The business datum table of backup and historical data table are stored in medium, completes the backup of data base.Due to large-scale
In mysql data base, historical data takies substantial amounts of memory space, and real time traffic data is less, therefore by historical data table and reality
When traffic table separately back up, the data volume of each backup can be reduced, shorten BACKUP TIME and recovery time, accelerate backup speed
Degree.It can be seen that, the application quickly achieves the backup of data base under mysql large database scene, decrease the Backup and Restore time,
Decrease backup file space to take, improve the efficiency of Backup and Restore and the safety assurance ability of data base.
Brief description
For the technical scheme of the clearer explanation embodiment of the present invention or prior art, below will be to embodiment or existing
Technology description in required use accompanying drawing be briefly described it should be apparent that, drawings in the following description are only this
Some bright embodiments, for those of ordinary skill in the art, on the premise of not paying creative work, can also root
Obtain other accompanying drawings according to these accompanying drawings.
Fig. 1 is a kind of flow chart of specific embodiment of database backup method provided by the present invention；
Fig. 2 is the flow chart of another kind of specific embodiment of database backup method provided by the present invention；
Fig. 3 is the structured flowchart of DB Backup device provided in an embodiment of the present invention.
Specific embodiment
Generally produce the backup policy that the mysql data base of system use has formulated, but mysql large database scene
Lower data volume all ratios are larger, and the backup tool that mysql is provided that as PostgreSQL database is limited, when leading to DB Backup
Between long, backup file take up room greatly, affect for a long time the normal business operation of data base during backup.The core of the present invention is
There is provided a kind of database backup method and device, to improve backup efficiency.
In order that those skilled in the art more fully understand the present invention program, with reference to the accompanying drawings and detailed description
The present invention is described in further detail.Obviously, described embodiment is only a part of embodiment of the present invention, rather than
Whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art are not making creative work premise
Lower obtained every other embodiment, broadly falls into the scope of protection of the invention.
A kind of flow chart of specific embodiment of database backup method provided by the present invention is as shown in figure 1, the party
Method includes：
Step S101：Tables of data in data base is classified, is divided into historical data table and real time traffic data table；
Step S102：Full backup is carried out to described business datum table；
Step S103：Incremental backup is carried out to described historical data table；
Step S104：The described business datum table of backup and described historical data table are stored in medium, completes to count
Backup according to storehouse.
Database backup method provided by the present invention, by the tables of data in data base is classified, is divided into history
Tables of data and real time traffic data table；Full backup is carried out to business datum table；Incremental backup is carried out to historical data table；Will
The business datum table of backup and historical data table store in medium, complete the backup of data base.Due to large-scale mysql number
Take substantial amounts of memory space according to historical data in storehouse, real time traffic data is less, therefore by historical data table and real time business
Table separately backs up, and can reduce the data volume of each backup, shorten BACKUP TIME and recovery time, accelerate backup rate.Can
See, the application quickly achieves the backup of data base under mysql large database scene, decreases Backup and Restore time, minimizing
Backup file space takies, and improves the efficiency of Backup and Restore and the safety assurance ability of data base.
Tables of data in mysql data base is classified by the application, is divided into historical data table and business datum table.Generally exist
In large-scale mysql data base, historical data takies substantial amounts of memory space, and business real time data table is less on the contrary, in conjunction with
The stand-by program that mysqldump backup tool is realized completes the scheduling backed up, and input history lists, traffic table, backup condition etc. are certainly
Move and complete DB Backup.So historical data table and real time business table are separately backed up, the data of each backup can be reduced
Amount, to shorten backup and recovery time, accelerates the speed of backup.
On the basis of above-described embodiment, in database backup method provided by the present invention, described historical data table is entered
Row incremental backup can be specially：
Determine same day data in described historical data table and newly-increased the next day historical data；
Respectively to described same day data and described newly-increased the next day historical data back up.
Further, to described newly-increased the next day historical data backed up after also include：
According to default naming rule, backup file is named.
History lists in large database and traffic table are separately backed up, business datum table and historical data same day data are tied
Close mysql binlog and complete full dose and incremental backup, back up the historical data of history lists the next day independent, such as：No. 2 backups 7 of July
The history partition data of month No. 1, now the July data of No. 1 will not change, formed after backup and individually back up file, right
Backup file gives independent naming rule, to being put into (as tape library) in backup storage medium after compressing file, completes whole
Backup flow process.BACKUP TIME is substantially reduced according to the stand-by program that above-mentioned flow process is realized, improves the efficiency of backup.
On the basis of any of the above-described embodiment, database backup method provided by the present invention, described by backup
Described business datum table and described historical data table store in medium and can further include before：
Data compression is carried out to described business datum table and described historical data table.
Preferably, the present embodiment can also include：When meeting pre-conditioned, stale data is cleared up.
Realizing, myqldump enables to count the backup tool mysqldump that the present invention can specifically be carried using mysql
According to concordance derive, the file of derivation is text, enables largely to realize compressing, according to business scenario pair
Mysqldump enables the realization of database data quick backup strategy using different parameters.
Below backup procedure provided by the present invention is further elaborated on, number as provided by the present invention in Fig. 2
According to shown in the flow chart of another kind of specific embodiment of library backup method, the method includes：
Step S201：Determine the data base needing backup；Determine historical data table inventory；Determine that history lists builds table and data
Rule searching：Day table, menology, partition table etc.；Determine history lists data insertion rule；
Step S202：Tables of data in data base is classified, is divided into historical data table and real time traffic data table；
Step S203：Full backup is carried out to business datum table；
Real time business table data can be done full table backup and complete full dose incremental backup with reference to binlog file backup.
Step S204：Incremental backup is carried out to historical data table；
History lists historical data backs up, and independent history physical table can table backup, the by date table of range partition table/greatly entirely
Can be backed up with given query condition, in theory tables of data to be backed up or partition data will not change (using the next day back up plan
Slightly) it is possible to remove concordance backup condition, prevent specified requirementss backup from being to produce impact to table.
There is situation in 2 in history lists backup same day data backup：Independent history physical table can be simultaneously standby with real time business table
Part；The table such as range partition table/big table adds and (can not specify during multilist backup because mysqldump limits when condition derives by date
The condition of single table) therefore need individually to back up, bother very much when doing recovery operation.
Step S205：The described business datum table of backup and described historical data table are stored in medium, completes to count
Backup according to storehouse.
Below DB Backup device provided in an embodiment of the present invention is introduced, DB Backup dress described below
Putting can be mutually to should refer to database described above backup method.
Fig. 3 is the structured flowchart of DB Backup device provided in an embodiment of the present invention, with reference to Fig. 3 DB Backup device
Can include：
Sort module 100, for the tables of data in data base is classified, is divided into historical data table and real time business
Tables of data；
Full backup module 200, for carrying out full backup to described business datum table；
Incremental backup module 300, for carrying out incremental backup to described historical data table；
Memory module 400, for the described business datum table of backup and described historical data table are stored in medium,
Complete the backup of data base.
Above-described embodiment basic when, in DB Backup device provided by the present invention, described incremental backup module
It is specially：Determine same day data in described historical data table and newly-increased the next day historical data；Respectively to described same day data
And the module that the next day described newly-increased, historical data is backed up.
Further, the present embodiment can also include：
Name module, for described newly-increased the next day historical data back up after, according to default naming rule pair
Backup file is named.
On the basis of any of the above-described embodiment, DB Backup device provided by the present invention can also include：
Data compressing module, for storing medium by the described business datum table of backup and described historical data table
In before, data compression is carried out to described business datum table and described historical data table.
As a kind of specific embodiment, the present embodiment can further include：
Cleaning modul, for when meeting pre-conditioned, clearing up to stale data
Data backup device provided herein quickly achieves the standby of data base under mysql large database scene
Part, decrease the Backup and Restore time, decrease backup file space and take, improve the efficiency of Backup and Restore and data base
Safety assurance ability.
Taking detailed programs as a example, this project needs the annual capacity of data base of backup to be expected to be 2.5T, wherein traffic table
Data only has 5G, remaining all historical data, be computed the historical data that produces daily in 10G about it is assumed that entering
The full library backup of row, the file no space that backup speed about needs 5 hours for 500G/H and backs up out can be deposited；Standby using point table
The strategy of part only needs to not accomplish half an hour, time efficiency is obvious daily.By write script to each backup procedure process after
Realize automatization, backup command state modulator refines, can complete to back up on the premise of less on data base's impact, and corresponding
Database recovery process recover in advance it is also possible to realize business datum table, historical data can be in not traffic affecting situation
Lower follow-up slowly recovery is it is ensured that operation system is recovered normally to use as early as possible.
To sum up, traditional mysql DB Backup scheme is to carry out the backup in whole storehouse by instruments such as mysqldump, leads
Cause BACKUP TIME long, big problem is affected on data base, and the application is real after stand-by program is to the process of each backup procedure
Existing automatization, backup command state modulator refines, and can complete to back up on the premise of less on data base's impact.Meanwhile, originally
Application decreasing the recovery time of backup, reducing the space hold of backup file, thus improve the efficiency of backup.Additionally, it is right
The database recovery process answered can also be realized business datum table and recover in advance, and historical data can be in not traffic affecting situation
Lower follow-up slowly recovery is it is ensured that operation system is recovered normally to use as early as possible.
In this specification, each embodiment is described by the way of going forward one by one, and what each embodiment stressed is and other
The difference of embodiment, between each embodiment same or similar partly mutually referring to.Fill for disclosed in embodiment
For putting, because it corresponds to the method disclosed in Example, so description is fairly simple, referring to method part in place of correlation
Illustrate.
Professional further appreciates that, in conjunction with the unit of each example of the embodiments described herein description
And algorithm steps, can with electronic hardware, computer software or the two be implemented in combination in, in order to clearly demonstrate hardware and
The interchangeability of software, generally describes composition and the step of each example in the above description according to function.These
Function to be executed with hardware or software mode actually, the application-specific depending on technical scheme and design constraint.Specialty
Technical staff can use different methods to each specific application realize described function, but this realization should
Think beyond the scope of this invention.
The step of the method in conjunction with the embodiments described herein description or algorithm can directly be held with hardware, processor
The software module of row, or the combination of the two is implementing.Software module can be placed in random access memory (RAM), internal memory, read-only deposit
Reservoir (ROM), electrically programmable ROM, electrically erasable ROM, depositor, hard disk, moveable magnetic disc, CD-ROM or technology
In known any other form of storage medium in field.
Above database backup method provided by the present invention and device are described in detail.Used herein
Specific case is set forth to the principle of the present invention and embodiment, and the explanation of above example is only intended to help understand this
The method of invention and its core concept.It should be pointed out that for those skilled in the art, without departing from this
On the premise of bright principle, the present invention can also be carried out with some improvement and modify, these improve and modification also falls into present invention power
In the protection domain that profit requires.
Claims (10)
1. a kind of database backup method is it is characterised in that include：
Tables of data in data base is classified, is divided into historical data table and real time traffic data table；
Full backup is carried out to described business datum table；
Incremental backup is carried out to described historical data table；
The described business datum table of backup and described historical data table are stored in medium, completes the backup of data base.
2. database backup method as claimed in claim 1 is it is characterised in that described carry out increment to described historical data table
Backup includes：
Determine same day data in described historical data table and newly-increased the next day historical data；
Respectively to described same day data and described newly-increased the next day historical data back up.
3. database backup method as claimed in claim 2 it is characterised in that to described newly-increased the next day historical data carry out
Also include after backup：
According to default naming rule, backup file is named.
4. the database backup method as described in any one of claims 1 to 3 it is characterised in that described will backup as described in
Business datum table and described historical data table store in medium and also include before：
Data compression is carried out to described business datum table and described historical data table.
5. database backup method as claimed in claim 4 is it is characterised in that also include：
When meeting pre-conditioned, stale data is cleared up.
6. a kind of DB Backup device is it is characterised in that include：
Sort module, for the tables of data in data base is classified, is divided into historical data table and real time traffic data table；
Full backup module, for carrying out full backup to described business datum table；
Incremental backup module, for carrying out incremental backup to described historical data table；
Memory module, for storing the described business datum table of backup and described historical data table in medium, completes to count
Backup according to storehouse.
7. DB Backup device as claimed in claim 6 is it is characterised in that described incremental backup module is specially：Determine
Same day data in described historical data table and newly-increased the next day historical data；Respectively to described same day data and described newly-increased
The next day module that backed up of historical data.
8. DB Backup device as claimed in claim 7 is it is characterised in that also include：
Name module, for described newly-increased the next day historical data back up after, according to default naming rule to backup
File is named.
9. the DB Backup device as described in any one of claim 6 to 8 is it is characterised in that also include：
Data compressing module, for storing in medium it by the described business datum table of backup and described historical data table
Before, data compression is carried out to described business datum table and described historical data table.
10. DB Backup device as claimed in claim 9 is it is characterised in that also include：
Cleaning modul, for when meeting pre-conditioned, clearing up to stale data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610821056.2A CN106445738B (en) | 2016-09-13 | 2016-09-13 | Database backup method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610821056.2A CN106445738B (en) | 2016-09-13 | 2016-09-13 | Database backup method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106445738A true CN106445738A (en) | 2017-02-22 |
| CN106445738B CN106445738B (en) | 2020-10-16 |
Family
ID=58167964
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610821056.2A Active CN106445738B (en) | 2016-09-13 | 2016-09-13 | Database backup method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106445738B (en) |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107247639A (en) * | 2017-05-03 | 2017-10-13 | 上海动联信息技术股份有限公司 | A kind of efficient backup method of mysql databases |
| CN108491294A (en) * | 2018-03-15 | 2018-09-04 | 中国银行股份有限公司 | A kind of database backup method, apparatus and system |
| CN110019477A (en) * | 2017-12-27 | 2019-07-16 | 航天信息股份有限公司 | A kind of method and system carrying out big data processing using HIVE backup table |
| CN110209528A (en) * | 2018-11-30 | 2019-09-06 | 腾讯科技（深圳）有限公司 | Data back up method, device, server and storage medium |
| CN110597669A (en) * | 2019-09-20 | 2019-12-20 | 中国银行股份有限公司 | Bank historical data parameterized backup recovery method and device |
| CN110995723A (en) * | 2019-12-11 | 2020-04-10 | 深圳物讯科技有限公司 | Method for preventing loss of big data transmission data across public security boundary |
| CN111143365A (en) * | 2019-12-26 | 2020-05-12 | 深圳前海环融联易信息科技服务有限公司 | Data sub-table method and device, computer equipment and storage medium |
| CN111324485A (en) * | 2020-01-20 | 2020-06-23 | 杭州安恒信息技术股份有限公司 | Data information backup method, device, equipment and storage medium of data table |
| CN112131051A (en) * | 2020-09-29 | 2020-12-25 | 中国银行股份有限公司 | Data backup method and device based on parametric configuration |
| CN112650622A (en) * | 2020-12-24 | 2021-04-13 | 江苏云柜网络技术有限公司 | Data backup and recovery system and method suitable for intelligent express cabinet service |
| CN112925677A (en) * | 2021-03-10 | 2021-06-08 | 福建宁德核电有限公司 | Backup equipment, automatic backup system and method for non-safety-level DCS historical data |
| CN113377872A (en) * | 2021-06-25 | 2021-09-10 | 北京红山信息科技研究院有限公司 | Offline synchronization method, device and equipment of online system data in big data center |
| CN113515374A (en) * | 2021-05-18 | 2021-10-19 | 中国工商银行股份有限公司 | Data processing method and device, electronic equipment and computer readable storage medium |
| CN114020539A (en) * | 2022-01-05 | 2022-02-08 | 国家超级计算天津中心 | Block storage self-adaptive backup system based on cloud environment |
| CN114138554A (en) * | 2021-11-22 | 2022-03-04 | 深圳市远飞网络科技有限公司 | Wireless AP configuration information backup and system recovery control system |
| CN114328005A (en) * | 2021-09-08 | 2022-04-12 | 深圳市木浪云科技有限公司 | Method and system for incremental backup of container data |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101354713A (en) * | 2008-09-08 | 2009-01-28 | 大唐软件技术股份有限公司 | Method and system for storing data |
| CN101499070A (en) * | 2008-02-02 | 2009-08-05 | 北京城市学院 | History and real-time data access system and method based on open database interface |
| CN202134001U (en) * | 2011-03-07 | 2012-02-01 | 浪潮(北京)电子信息产业有限公司 | Executable file backup device |
| CN103885855A (en) * | 2012-12-20 | 2014-06-25 | 航天信息股份有限公司 | Data backup and recovery method and data backup and recovery device |
| CN104036001A (en) * | 2014-06-13 | 2014-09-10 | 上海新炬网络技术有限公司 | Dynamic hotlist priority scheduling based quick data cleaning method |
| CN104182295A (en) * | 2013-05-27 | 2014-12-03 | 阿里巴巴集团控股有限公司 | Data backup method and data backup device |
| CN104572867A (en) * | 2014-12-18 | 2015-04-29 | 上海新炬网络信息技术有限公司 | Data processing method based on Oracle |
| CN104850598A (en) * | 2015-04-28 | 2015-08-19 | 江苏瑞中数据股份有限公司 | Method for recovering backup of real-time database |
| CN105302667A (en) * | 2015-10-12 | 2016-02-03 | 国家计算机网络与信息安全管理中心 | Cluster architecture based high-reliability data backup and recovery method |
| CN105320576A (en) * | 2014-05-30 | 2016-02-10 | 中国电信股份有限公司 | Device and method for database backup |
-
2016
- 2016-09-13 CN CN201610821056.2A patent/CN106445738B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101499070A (en) * | 2008-02-02 | 2009-08-05 | 北京城市学院 | History and real-time data access system and method based on open database interface |
| CN101354713A (en) * | 2008-09-08 | 2009-01-28 | 大唐软件技术股份有限公司 | Method and system for storing data |
| CN202134001U (en) * | 2011-03-07 | 2012-02-01 | 浪潮(北京)电子信息产业有限公司 | Executable file backup device |
| CN103885855A (en) * | 2012-12-20 | 2014-06-25 | 航天信息股份有限公司 | Data backup and recovery method and data backup and recovery device |
| CN104182295A (en) * | 2013-05-27 | 2014-12-03 | 阿里巴巴集团控股有限公司 | Data backup method and data backup device |
| CN105320576A (en) * | 2014-05-30 | 2016-02-10 | 中国电信股份有限公司 | Device and method for database backup |
| CN104036001A (en) * | 2014-06-13 | 2014-09-10 | 上海新炬网络技术有限公司 | Dynamic hotlist priority scheduling based quick data cleaning method |
| CN104572867A (en) * | 2014-12-18 | 2015-04-29 | 上海新炬网络信息技术有限公司 | Data processing method based on Oracle |
| CN104850598A (en) * | 2015-04-28 | 2015-08-19 | 江苏瑞中数据股份有限公司 | Method for recovering backup of real-time database |
| CN105302667A (en) * | 2015-10-12 | 2016-02-03 | 国家计算机网络与信息安全管理中心 | Cluster architecture based high-reliability data backup and recovery method |
Cited By (24)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107247639A (en) * | 2017-05-03 | 2017-10-13 | 上海动联信息技术股份有限公司 | A kind of efficient backup method of mysql databases |
| CN110019477A (en) * | 2017-12-27 | 2019-07-16 | 航天信息股份有限公司 | A kind of method and system carrying out big data processing using HIVE backup table |
| CN108491294A (en) * | 2018-03-15 | 2018-09-04 | 中国银行股份有限公司 | A kind of database backup method, apparatus and system |
| CN110209528A (en) * | 2018-11-30 | 2019-09-06 | 腾讯科技（深圳）有限公司 | Data back up method, device, server and storage medium |
| CN110209528B (en) * | 2018-11-30 | 2022-10-28 | 腾讯科技（深圳）有限公司 | Data backup method, device, server and storage medium |
| CN110597669B (en) * | 2019-09-20 | 2022-10-11 | 中国银行股份有限公司 | Bank historical data parameterized backup recovery method and device |
| CN110597669A (en) * | 2019-09-20 | 2019-12-20 | 中国银行股份有限公司 | Bank historical data parameterized backup recovery method and device |
| CN110995723A (en) * | 2019-12-11 | 2020-04-10 | 深圳物讯科技有限公司 | Method for preventing loss of big data transmission data across public security boundary |
| CN111143365A (en) * | 2019-12-26 | 2020-05-12 | 深圳前海环融联易信息科技服务有限公司 | Data sub-table method and device, computer equipment and storage medium |
| CN111143365B (en) * | 2019-12-26 | 2023-08-18 | 深圳前海环融联易信息科技服务有限公司 | Data sub-table method, device, computer equipment and storage medium |
| CN111324485A (en) * | 2020-01-20 | 2020-06-23 | 杭州安恒信息技术股份有限公司 | Data information backup method, device, equipment and storage medium of data table |
| CN112131051A (en) * | 2020-09-29 | 2020-12-25 | 中国银行股份有限公司 | Data backup method and device based on parametric configuration |
| CN112131051B (en) * | 2020-09-29 | 2023-08-22 | 中国银行股份有限公司 | Data backup method and device based on parameterized configuration |
| CN112650622A (en) * | 2020-12-24 | 2021-04-13 | 江苏云柜网络技术有限公司 | Data backup and recovery system and method suitable for intelligent express cabinet service |
| CN112925677A (en) * | 2021-03-10 | 2021-06-08 | 福建宁德核电有限公司 | Backup equipment, automatic backup system and method for non-safety-level DCS historical data |
| CN113515374A (en) * | 2021-05-18 | 2021-10-19 | 中国工商银行股份有限公司 | Data processing method and device, electronic equipment and computer readable storage medium |
| CN113515374B (en) * | 2021-05-18 | 2024-02-27 | 中国工商银行股份有限公司 | Data processing method and device, electronic equipment and computer readable storage medium |
| CN113377872A (en) * | 2021-06-25 | 2021-09-10 | 北京红山信息科技研究院有限公司 | Offline synchronization method, device and equipment of online system data in big data center |
| CN113377872B (en) * | 2021-06-25 | 2024-02-27 | 北京红山信息科技研究院有限公司 | Offline synchronization method, device and equipment of online system data in big data center |
| CN114328005A (en) * | 2021-09-08 | 2022-04-12 | 深圳市木浪云科技有限公司 | Method and system for incremental backup of container data |
| CN114138554B (en) * | 2021-11-22 | 2022-08-09 | 深圳互信互通科技有限公司 | Wireless AP configuration information backup and system recovery control system |
| CN114138554A (en) * | 2021-11-22 | 2022-03-04 | 深圳市远飞网络科技有限公司 | Wireless AP configuration information backup and system recovery control system |
| CN114020539B (en) * | 2022-01-05 | 2022-03-18 | 国家超级计算天津中心 | Block storage self-adaptive backup system based on cloud environment |
| CN114020539A (en) * | 2022-01-05 | 2022-02-08 | 国家超级计算天津中心 | Block storage self-adaptive backup system based on cloud environment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106445738B (en) | 2020-10-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106445738A (en) | Database backup method and device | |
| US11003533B2 (en) | Data processing method, system, and apparatus | |
| US11468015B2 (en) | Storage and synchronization of metadata in a distributed storage system | |
| US20190065322A1 (en) | Restoring a database using a fully hydrated backup | |
| EP1859363B1 (en) | Apparatus and method for identifying asynchronous data in redundant data stores and for re-synchronizing same | |
| CN101777016B (en) | Snapshot storage and data recovery method of continuous data protection system | |
| CN100464334C (en) | Data incremental backup and recovery method applied to data bank | |
| US9542279B2 (en) | Shadow paging based log segment directory | |
| WO2014169142A1 (en) | Partition level backup and restore of a massively parallel processing database | |
| CN110502523A (en) | Business datum storage method, device, server and computer readable storage medium | |
| CN103268270B (en) | The management method of snapshot and device | |
| CN102955720A (en) | Method for improving stability of EXT (extended) file system | |
| CN107918620A (en) | Wiring method and device, the electronic equipment of a kind of database | |
| WO2021012868A1 (en) | Transaction rollback method and apparatus, database, system, and computer storage medium | |
| US11221983B1 (en) | Multi-level indexing of backup files | |
| CN105302667A (en) | Cluster architecture based high-reliability data backup and recovery method | |
| CN112612775B (en) | Data storage method, device, computer equipment and storage medium | |
| US11494271B2 (en) | Dynamically updating database archive log dependency and backup copy recoverability | |
| CN110555055A (en) | data mining method for redo log file of Oracle database | |
| CN110096509A (en) | Realize that historical data draws the system and method for storage of linked list modeling processing under big data environment | |
| CN111611108A (en) | Method and device for restoring virtual database | |
| CN107340971A (en) | A kind of data storage is with recovering framework and method | |
| CN109388525A (en) | A kind of database backup system | |
| CN116490855A (en) | Efficient backup after restore operations | |
| CN104573052A (en) | Method for replacing storage based on Oracle ASM |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20200916 Address after: 215100 No. 1 Guanpu Road, Guoxiang Street, Wuzhong Economic Development Zone, Suzhou City, Jiangsu Province Applicant after: SUZHOU LANGCHAO INTELLIGENT TECHNOLOGY Co.,Ltd. Address before: 450018 Henan province Zheng Dong New District of Zhengzhou City Xinyi Road No. 278 16 floor room 1601 Applicant before: ZHENGZHOU YUNHAI INFORMATION TECHNOLOGY Co.,Ltd. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |