CN108664356A - A kind of database backup method and device, Database Systems - Google Patents
A kind of database backup method and device, Database Systems Download PDFInfo
- Publication number
- CN108664356A CN108664356A CN201810414538.5A CN201810414538A CN108664356A CN 108664356 A CN108664356 A CN 108664356A CN 201810414538 A CN201810414538 A CN 201810414538A CN 108664356 A CN108664356 A CN 108664356A
- Authority
- CN
- China
- Prior art keywords
- database
- disk
- backup
- snapshot
- master
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1448—Management of the data involved in backup or backup restore
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1458—Management of the backup or restore process
- G06F11/1469—Backup restoration techniques
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
A kind of database backup method of present invention offer and device, Database Systems, being created on master disk has primary database, the primary database is the service database of real time execution, namely for the database of the real time execution of production environment, the data in the master disk are generated from disk completely using synchronous or snapshot, to in the backup database for obtaining primary database from disk.In the method, it is the synchronization between disk or snapshot storage, it is the backup in the physical store level of database, when disconnecting synchronous or progress snapshot, can be got from disk in a short period of time and identical data on master disk, backup rate is fast, meanwhile the time point that synchronous time point is completion backup is disconnected, the time point that snapshot terminates is the time point backed up and completed, in this way, the time point of DB Backup completion can be accurately controlled.
Description
Technical field
The present invention relates to database technical field more particularly to a kind of database backup methods and device, Database Systems.
Background technology
Core of the database as information system, play the role of it is vital, very high to data reliability requirement
Industry, the exception of such as bank's industry, data can cause heavy loss.
Normally, in the Database Systems of banking, including primary database and from two sets of data library of database, master data
Library is the real time traffic data library of production environment, and as the backup database of primary database and statistical to be used for from database
The offline database for analysing class report, by the data schedule backup in primary database extremely from database, when primary database occurs
When failure, it can switch to and work on from database, and various statistics, analysis, audit can be carried out using from database
Equal work.
Currently, each large database concept manufacturer is all provided with the scheme of DB Backup, mainly by will be in primary database
All database objects such as user's table, system table, index are completely backed up, and are then restored in other environments,
Obtain backup database.However, being continuously increased with data volume, the time of Backup and Restore is also increasingly longer, this can influence to lead
The normal use of database, further, since operational demand, needed to be the specific time from the time point of DB Backup
Point, for example, every month the last one workaday 24 when etc., time point of the backup is the time point that DB Backup is completed, and
The time point that backup is completed can not accurately control, this can cause to utilize the inaccuracy for carrying out data analysis from database.
Invention content
In view of this, the purpose of the present invention is to provide a kind of database backup method, device, Database Systems, pass through
The physical storage layer of database carries out the backup of database, and BACKUP TIME is fast, and easily controllable BACKUP TIME point.
To achieve the above object, the present invention has following technical solution：
A kind of database backup method, the backup of database is carried out based on timing disk group, and the timing disk group includes
It master disk and is created from disk, the master disk and has a primary database, the primary database is the service database of real time execution；
The method includes：
Keep the master disk and the synchronous regime from disk；
In preset time point, the master disk and the synchronous regime from disk are disconnected, to be obtained from disk described
The backup database of the primary database is obtained, the backup database is for carrying out data processing.
Optionally, further include：
After data processing completion, restore the master disk and the synchronous regime from disk.
Optionally, the master disk and it is described from disk be different storage mediums.
A kind of database backup method, the method includes：
In preset time point, snapshot is carried out to master disk and is created on the master disk with generating the snapshot data of master disk
It is the service database of real time execution to have primary database, the primary database, and the snapshot data includes the primary database
Backup database, the backup database is for carrying out data processing.
Optionally, described in preset time point, snapshot is carried out to master disk, to generate the snapshot data of master disk, including：
Multiple Snapshot time points are preset, in each Snapshot time point, snapshot are carried out to master disk respectively, when generating different
Between the snapshot data of master disk put, each snapshot data includes the backup database of the primary database of different time points,
The backup database of the different time points is used to carry out data processing in different moments.
A kind of DB Backup device, described device include：
Synchronization unit, for keeping the master disk and the synchronous regime from disk, the master disk and it is described from
Disk is timing disk group, and being created on the master disk has primary database, and the primary database is the business datum of real time execution
Library；
Switching units, in preset time point, the master disk and the synchronous regime from disk being disconnected, in institute
The backup database that the primary database is obtained from disk is stated, the backup database is for carrying out data processing.
Optionally, further include：
Recovery unit, for after data processing completion, restoring the master disk with described from the synchronous of disk
State.
A kind of DB Backup device, including：
Snapshot unit, in preset time point, snapshot being carried out to master disk, to generate the snapshot data of master disk, institute
It states to create on master disk and has primary database, the primary database is the service database of real time execution, is wrapped in the snapshot data
Include the backup database of the primary database.
Optionally, described in preset time point in the snapshot unit, snapshot is carried out to master disk, to generate master disk
Snapshot data, including：
Multiple Snapshot time points are preset, in each Snapshot time point, snapshot are carried out to master disk respectively, when generating different
Between the snapshot data of master disk put, each snapshot data includes the backup database of the primary database of different time points,
The backup database of the different time points is used to carry out data processing in different moments.
A kind of Database Systems, including be provided with the master server of master disk and be provided with the slave server from disk,
Wherein：
The master disk and it is described from disk be timing disk group, creating on the master disk has primary database, the master
Database is the service database of real time execution；
The master server described also sets any of the above-described DB Backup device from server；
It is described to be additionally operable to carry out data processing using backup database from server.
Database backup method provided in an embodiment of the present invention and device, Database Systems, creating on master disk has main number
According to library, which is the service database of real time execution, namely for the database of the real time execution of production environment, profit
The data in the master disk are generated from disk completely with synchronous or snapshot, to obtain primary database from disk
Backup database.In the method, it is synchronization between disk or snapshot storage, is in the physical store level of database
Backup, it is synchronous or when carrying out snapshot disconnecting, can be got from disk in a short period of time on master disk completely
Identical data, backup rate is fast, meanwhile, disconnect synchronous time point be complete backup time point, snapshot terminate when
Between point be backup complete time point, in this way, can be accurately controlled DB Backup completion time point.
Description of the drawings
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below
There is attached drawing needed in technology description to be briefly described, it should be apparent that, the accompanying drawings in the following description is the present invention
Some embodiments for those of ordinary skill in the art without creative efforts, can also basis
These attached drawings obtain other attached drawings.
Fig. 1 shows the flow diagram of database backup method according to an embodiment of the invention；
Fig. 2 shows the flow diagrams of database backup method according to another embodiment of the present invention；
Fig. 3 shows the structural schematic diagram of DB Backup device according to an embodiment of the invention.
Specific implementation mode
In order to make the foregoing objectives, features and advantages of the present invention clearer and more comprehensible, below in conjunction with the accompanying drawings to the present invention
Specific implementation mode be described in detail.
Many details are elaborated in the following description to facilitate a thorough understanding of the present invention, still the present invention can be with
Implemented different from other manner described here using other, those skilled in the art can be without prejudice to intension of the present invention
In the case of do similar popularization, therefore the present invention is not limited by following public specific embodiment.
As the description in background technology, in the industry high to data reliability requirement, such as bank's industry, in database
Include primary database and from two sets of data library of database, primary database is the real time traffic data of production environment in system
Library, from the backup database that database is primary database, backup database is offline database, is broken down in primary database
When, it can switch to and work on from database, it is also possible to be used for making various analysis classes reports.
Currently, each large database concept manufacturer is all provided with the scheme of DB Backup, mainly by will be in primary database
All database objects such as user's table, system table, index are completely backed up, and are then restored in other environments,
Obtain backup database.However, being continuously increased with data volume, the time of Backup and Restore is also increasingly longer, this can influence to lead
The normal use of database.In addition, for from database, it is additionally operable to make various analysis classes reports, these business are to database
There is special requirement at the time point of middle data cut-off, such as when the statistical report form of making financial category, it is desirable to the deadline of data
Point be the end of month the last one workaday 24 when, the data cut-off time point be DB Backup complete time point, and
The time point that DB Backup is completed can not accurately control, in this way, can lead to the data in being applied from database data
Inaccuracy.
For this purpose, being created present applicant proposes a kind of database backup method, on master disk has primary database, the primary database
It will using synchronous or snapshot namely for the database of the real time execution of production environment for the service database of real time execution
Data in the master disk are generated from disk completely, in the backup database for obtaining primary database from disk.At this
In method, it is the synchronization between disk or snapshot storage, is the backup in the physical store level of database, is synchronized disconnecting
Or when carrying out snapshot, it can be got from disk in a short period of time and identical data on master disk, backup
Speed is fast, meanwhile, it is the time point for completing backup to disconnect synchronous time point, and the time point that snapshot terminates is to complete backup
Time point, in this way, can be accurately controlled DB Backup completion time point.
Technical solution for a better understanding of the present invention and technique effect carry out detailed below with reference to different embodiments
Thin explanation.
Embodiment one
In the present embodiment, by where primary database master disk with it is another from disk it is synchronous be timing disk group, utilize
Data on master disk are synchronized to from disk by synchronization, in the backup database for obtaining primary database from disk.
In the present embodiment, it is the backup of the database carried out based on timing disk group, timing disk group includes master disk
There is primary database with being created from disk, master disk, primary database is the service database of real time execution.
Timing disk group is that two disks are synchronized the disk group that storage operation is constituted later using simultaneous techniques, together
It is data source to walk the master disk in disk group, from the disk that disk is Backup Data, is made as together in master disk and from disk
Walk disk group after, as long as the two be in synchronous regime, all data on master disk by real-time synchronization extremely from disk, from magnetic
Acquisition and the identical mirror image data of master disk on disk, that is, in storage level, by each file backup on master disk
To from disk.
In specific application, master disk and from disk can be the different zones in same storage medium, for example, can be with
For the different subregions on same hard disk.In view of backup database is also used as the disaster recovery database of primary database, more preferably,
It can be able to be different storage mediums by master disk and from disk, such as can be hard-disc storage Jie on different server
Matter.
It is understood that before being backed up, master disk and simultaneously operating was carried out from disk, that is,
Through constituting timing disk group, and primary database is created on master disk, which is mainly used for placing primary database,
It is, of course, also possible to store other data, these other data can also be backed up to from disk together when synchronous.
Primary database is the service database of real time execution, that is, applied to the database of production environment, the database
Within the service time, it is constantly in operating status, the state of database can also change therewith, and due to where database
It is timing disk from disk and its, by the data of real-time update database from disk, to obtain the backup number of primary database
According to.
In master disk with after disk establishes synchronized relation, DB Backup can be carried out, specifically, with reference to 1 institute of figure
Show, in step S101, keeps master disk and the synchronous regime from disk.
During keeping master disk and from the synchronous regime of disk, that is, using the data on master disk as source number
According to, real-time synchronization to the process from disk so that become the mirror image data disk of master disk from disk, and due to number based on master disk
According to the storage dish in library, in this way, primary database can be backed up in realtime to from disk, just there are primary databases in real time from disk
Backup database.
The master disk and the synchronous regime from disk are disconnected, in preset time point with described in step S102
The backup database of the primary database is obtained from disk, the backup database is for carrying out data processing.
The preset time point is the particular point in time being arranged according to business demand, which is BACKUP TIME
Point, the time point also ended for data backup in backup database.
In the preset time point, master disk and the synchronous regime from disk are disconnected, that is to say, that in that for disconnecting synchronization
A moment no longer carries out master disk with from the synchronous of disk, and the deadline from the data in database present on disk is
For the time point for disconnecting synchronous, it is the time point for completing backup to disconnect synchronous time point, in this way, passing through preset time point
The deadline point for being accurately controlled Backup Data is realized in setting.
The backup database is offline database, is started when needed, after disconnecting synchronous, from disk
The data for just obtaining the database of required stop time point start this from the backup database on disk, then can carry out phase
The data processing of pass, according to different business demands, which can be different data manipulation, such as can be the moon
Degree, the analysis of annual data, extraction or audit etc..
The above primary database can with real time execution on master server, the data processing of backup database may operate in from
On server, master server and from server can be same or different server.
Then, in step S103, after completing the data processing, restore the master disk with described from the synchronous of disk
State.
After completing above-mentioned required data processing business, master disk and the synchronous regime from disk can be restored, this
Sample, the data on master disk will continue real-time synchronization to from disk.
In specific application, after the business for being carried out data processing using backup database is completed, control can be passed through
The modes such as processing procedure sequence or activity chain, which execute, restores master disk and the operation from disk synchronous regime.
The present embodiment in order to better understand below specifically illustrates one using example.In banking system
It in system, needs to handle the data in system after end day, this data processing is mainly the data point of various dimensions
Analysis, since the expense to database is very big, can influence the operation of regular traffic, therefore, the data processing after end day is usual
It will not be placed in primary database and carry out, in this way, more particularly suitable into guild using backup database.And this requires backup databases
In data stop time point be to terminate beam time point day, the backup of common database can not be accurately controlled Backup end
Time point.And the method for using the present embodiment, it can in advance will be where the master disk and backup database where primary database
Synchronize setting from disk, before day terminating beam time point, keep master disk with from the synchronous of disk so that from disk
Data and master disk on data it is always consistent, and when day terminating beam time point, the synchronization both disconnected, in this way,
It is to terminate beam time point day from the data deadline in the backup database in disk, realizes the DB Backup deadline
Point accurately controls, it is thus possible to carry out more accurate data processing using the backup database.
In the present embodiment, it is generated from disk completely using the data in the simultaneous techniques master disk, to from magnetic
The backup database of primary database is obtained on disk.This method is the backup in the physical store level of database, in synchronous shape
It under state, is updated the data in real time from master disk from disk, it is the time point backed up and completed to disconnect synchronous time point, is not necessarily to
The additional time carries out the backup of primary database mass data on master disk, meanwhile, it is complete DB Backup can be accurately controlled
At time point.
Embodiment two
What is different from the first embodiment is that in the present embodiment, by master disk progress snapshot, obtaining from disk, thus,
Primary database on master disk is backuped to from disk, in the backup database for obtaining primary database from disk.
In the present embodiment, it is the backup of the database carried out based on snapshot, being created on master disk has primary database, main number
According to library be real time execution service database, that is, applied to production environment database, the database within the service time,
It is constantly in operating status, the state of database can also change therewith.
Refering to what is shown in Fig. 2, in specific backed up, master disk is carried out fast in preset time point in step S201
According to generate the snapshot data of master disk, the snapshot data includes the backup database of the primary database, the backup number
According to library for carrying out data processing.
The preset time point is the particular point in time being arranged according to business demand, which is BACKUP TIME
Point, or it is desirable that the time point that data backup ends in backup database.
To master disk carry out snapshot after, then form the snapshot data of master disk, the snapshot data can be stored in from
In disk, in this way, the time point of snapshot is rested on from the data on disk, that is, the preset time point, and due to main magnetic
Disk is the storage dish of primary database, is backed up to from disk in this way, primary database can be snapshotted, master data has been there is from disk
The backup database in library, and the stop time point of data is the time point of snapshot in backup database, in this way, passing through preset time
The deadline point for being accurately controlled Backup Data is realized in the setting of point.
In specific application, master disk and from disk can be the different zones in same storage medium, for example, can be with
For the different subregions on same hard disk.In view of backup database is also used as the disaster recovery database of primary database, more preferably,
It can be able to be different storage mediums by master disk and from disk, such as can be hard-disc storage Jie on different server
Matter.
The backup database is offline database, after completing snapshot, just when foring data cut-off from disk
Between for Snapshot time point primary database backup database, start the backup database when needed, then can carry out
Relevant data processing, according to different business demands, which can be different data manipulation, such as can be the moon
Degree, the analysis of annual data, extraction or audit etc..
The above primary database can with real time execution on master server, the data processing of backup database may operate in from
On server, master server and from server can be same or different server.
In some applications it is desirable to carry out multi-period business datum analysis, in order to reduce the expense of primary database, avoid
Influence to regular traffic operation, this analysis would generally be carried out using backup database, meanwhile, it needs complete with faster speed
At.And multiple backup databases are obtained by the way of snapshot, by starting the backup database at multiple and different time points, promoted
The speed of data analysis meets the situation that the data at multiple time points use.
Specifically, presetting multiple Snapshot time points, in each Snapshot time point, snapshot is carried out to master disk respectively, with life
At the snapshot data of the master disk of different time points, each snapshot data includes the backup of the primary database of different time points
Database, the backup database of the different time points are used to carry out data processing in different moments.
It at one in application example, such as needs to analyze business datum hourly, while every with the history same period
It carries out comparison and Conjoint Analysis with the business datum of period, in addition, the analysis possibly can not be completed within 1 hour, when
Between it is of high cost.It adopts with the aforedescribed process, then can obtain integral point moment corresponding snapshot data, such as at 8 points at each integral point moment
Snapshot data and 9 points of snapshot data can utilize 8 points of Backup Data therein after obtaining 8 points of snapshot data
Library carries out data processing, if at 9 points and not completing data processing and can be continued to execute after obtaining 9 points of snapshot data
The data processing of 8 points of backup database, meanwhile, start the data processing of 9 snapshot datas, that is, utilizes 9 points of Backup Data
Library carries out data processing, in this way, the backup database by starting multiple and different time points, promotes the speed of data analysis.
In the present embodiment, it is backed up completely using the data in the snapping technique master disk, to obtain primary database
Backup database.This method is the backup in the physical store level of database, and the time point that snapshot terminates is to have backed up
At time point, the backup of primary database mass data on master disk is carried out without additional time, meanwhile, can accurately control
The time point that DB Backup processed is completed.
Embodiment three
The database backup method of the above embodiment of the present invention is described in detail, in addition, present invention also provides
The corresponding DB Backup device of above-described embodiment corresponds to embodiment one, refering to what is shown in Fig. 3, the DB Backup device
Including：
Synchronization unit 300, for keeping the master disk and the synchronous regime from disk, the master disk and described
It is timing disk group from disk, being created on the master disk has primary database, and the primary database is the business number of real time execution
According to library；
Switching units 310, in preset time point, disconnecting the master disk and the synchronous regime from disk, with
In the backup database for obtaining the primary database from disk, the backup database is for carrying out data processing.
Further, further include：Recovery unit 320, for after data processing completion, restoring the master disk
With the synchronous regime from disk.
In addition, the application also proposed a kind of Database Systems, including it is provided with master server and the setting of master disk
There is the slave server from disk, wherein：
The master disk and it is described from disk be timing disk group, creating on the master disk has primary database, the master
Database is the service database of real time execution；
The master server described is additionally provided with any of the above-described DB Backup device from server；
It is described to be additionally operable to carry out data processing using backup database from server.
That is, back-up device can be set to master server or from server, to realize number by synchronous control
According to library backup.
Example IV
Corresponding to embodiment two, the DB Backup device includes：
Snapshot unit, in preset time point, snapshot being carried out to master disk, to generate the snapshot data of master disk, institute
It states to create on master disk and has primary database, the primary database is the service database of real time execution, is wrapped in the snapshot data
Include the backup database of the primary database.
Further, described in preset time point in the snapshot unit, snapshot is carried out to master disk, to generate main magnetic
The snapshot data of disk, including：
Multiple Snapshot time points are preset, in each Snapshot time point, snapshot are carried out to master disk respectively, when generating different
Between the snapshot data of master disk put, each snapshot data includes the backup database of the primary database of different time points,
The backup database of the different time points is used to carry out data processing in different moments.
In addition, the application also proposed a kind of Database Systems, including it is provided with master server and the setting of master disk
There is the slave server from disk, wherein：
Being created on the master disk has primary database, and the primary database is the service database of real time execution；
The master server described is additionally provided with any of the above-described DB Backup facility database backup from server
Device；
It is described to be additionally operable to carry out data processing using backup database from server.
That is, back-up device can be set to master server or from server, to realize database by snapshot
Backup.
The above is only a preferred embodiment of the present invention, although the present invention has been disclosed in the preferred embodiments as above, so
And it is not limited to the present invention.Any technical person familiar with the field is not departing from technical solution of the present invention ambit
Under, many possible changes and modifications all are made to technical solution of the present invention using the methods and technical content of the disclosure above,
Or it is revised as the equivalent embodiment of equivalent variations.Therefore, every content without departing from technical solution of the present invention, according to the present invention
Technical spirit any simple modification, equivalent variation and modification made to the above embodiment, still fall within the technology of the present invention side
In the range of case protection.
Claims (11)
1. a kind of database backup method, which is characterized in that carry out the backup of database, the synchronous magnetic based on timing disk group
Disk group includes master disk and is created from disk, the master disk and have a primary database, and the primary database is the industry of real time execution
Business database；The method includes：
Keep the master disk and the synchronous regime from disk；
In preset time point, the master disk and the synchronous regime from disk are disconnected, to obtain institute from disk described
The backup database of primary database is stated, the backup database is for carrying out data processing.
2. backup method according to claim 1, which is characterized in that further include：
After data processing completion, restore the master disk and the synchronous regime from disk.
3. backup method according to claim 1 or 2, which is characterized in that the master disk and it is described from disk be difference
Storage medium.
4. a kind of database backup method, which is characterized in that the method includes：
In preset time point, snapshot is carried out to master disk, to generate the snapshot data of master disk, being created on the master disk has master
Database, the primary database are the service database of real time execution, and the snapshot data includes the standby of the primary database
Part database, the backup database is for carrying out data processing.
5. according to the method described in claim 4, it is characterized in that, described in preset time point, snapshot is carried out to master disk, with
The snapshot data of master disk is generated, including：
Multiple Snapshot time points are preset, in each Snapshot time point, snapshot are carried out to master disk respectively, to generate different time points
Master disk snapshot data, each snapshot data includes the backup database of the primary database of different time points, described
The backup database of different time points is used to carry out data processing in different moments.
6. a kind of DB Backup device, which is characterized in that described device includes：
Synchronization unit, for keeping the master disk and the synchronous regime from disk, the master disk and described from disk
Being created for timing disk group, on the master disk has primary database, and the primary database is the service database of real time execution；
Switching units disconnect the master disk and the synchronous regime from disk in preset time point, with it is described from
The backup database of the primary database is obtained on disk, the backup database is for carrying out data processing.
7. device according to claim 6, which is characterized in that further include：
Recovery unit, for after data processing completion, restoring the master disk and the synchronous regime from disk.
8. a kind of DB Backup device, which is characterized in that including：
Snapshot unit, in preset time point, snapshot being carried out to master disk, to generate the snapshot data of master disk, the master
Being created on disk has primary database, and the primary database is the service database of real time execution, and the snapshot data includes institute
State the backup database of primary database.
9. device according to claim 8, which is characterized in that it is described in preset time point in the snapshot unit, to master
Disk carries out snapshot, to generate the snapshot data of master disk, including：
Multiple Snapshot time points are preset, in each Snapshot time point, snapshot are carried out to master disk respectively, to generate different time points
Master disk snapshot data, each snapshot data includes the backup database of the primary database of different time points, described
The backup database of different time points is used to carry out data processing in different moments.
10. a kind of Database Systems, which is characterized in that including being provided with the master server of master disk and being provided with from disk
From server, wherein：
The master disk and it is described from disk be timing disk group, creating on the master disk has primary database, the master data
Library is the service database of real time execution；
The master server described is additionally provided with DB Backup device as claimed in claims 6 or 7 from server；
It is described to be additionally operable to carry out data processing using backup database from server.
11. a kind of Database Systems, which is characterized in that including being provided with the master server of master disk and being provided with from disk
From server, wherein：
Being created on the master disk has primary database, and the primary database is the service database of real time execution；
The master server described is additionally provided with DB Backup device as claimed in claim 8 or 9 from server；
It is described to be additionally operable to carry out data processing using backup database from server.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810414538.5A CN108664356A (en) | 2018-05-03 | 2018-05-03 | A kind of database backup method and device, Database Systems |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810414538.5A CN108664356A (en) | 2018-05-03 | 2018-05-03 | A kind of database backup method and device, Database Systems |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108664356A true CN108664356A (en) | 2018-10-16 |
Family
ID=63781816
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810414538.5A Pending CN108664356A (en) | 2018-05-03 | 2018-05-03 | A kind of database backup method and device, Database Systems |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108664356A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110362622A (en) * | 2019-07-22 | 2019-10-22 | 江苏满运软件科技有限公司 | Real-time stream processing system, method, equipment and storage medium based on real-time number storehouse |
| CN110427423A (en) * | 2019-06-28 | 2019-11-08 | 苏州浪潮智能科技有限公司 | A kind of method, equipment and readable medium for avoiding database session from interrupting |
| CN110489300A (en) * | 2019-08-20 | 2019-11-22 | 北京市燃气集团有限责任公司 | Backup Data statistical method and device |
| CN111190765A (en) * | 2018-11-14 | 2020-05-22 | 深圳市茁壮网络股份有限公司 | Data backup method and system |
| CN112416884A (en) * | 2020-11-23 | 2021-02-26 | 中国移动通信集团江苏有限公司 | Data synchronization method and system |
| CN113285942A (en) * | 2021-05-19 | 2021-08-20 | 广东电网有限责任公司 | Data sharing method and device for transformer substation, electronic equipment and storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101261597A (en) * | 2007-03-08 | 2008-09-10 | 张成君 | Data instant rejuvenation system and its method |
| US7454591B2 (en) * | 2003-06-02 | 2008-11-18 | Hitachi, Ltd. | Storage system control method, storage system, and storage apparatus storing information relating a first logical unit number (LUN) used to access a volume by a host computer and a second LUN used to access the volume by another storage system with remote copy procedure |
| CN102368267A (en) * | 2011-10-25 | 2012-03-07 | 曙光信息产业(北京)有限公司 | Method for keeping consistency of copies in distributed system |
| CN105677673A (en) * | 2014-11-20 | 2016-06-15 | 阿里巴巴集团控股有限公司 | Business processing method, device and system |
| CN105988893A (en) * | 2015-02-10 | 2016-10-05 | 北京中科同向信息技术有限公司 | Technique based on data replication |
| CN106452864A (en) * | 2016-09-30 | 2017-02-22 | 北京悦畅科技有限公司 | Parking lot fault protection method, apparatus and system thereof |
-
2018
- 2018-05-03 CN CN201810414538.5A patent/CN108664356A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7454591B2 (en) * | 2003-06-02 | 2008-11-18 | Hitachi, Ltd. | Storage system control method, storage system, and storage apparatus storing information relating a first logical unit number (LUN) used to access a volume by a host computer and a second LUN used to access the volume by another storage system with remote copy procedure |
| CN101261597A (en) * | 2007-03-08 | 2008-09-10 | 张成君 | Data instant rejuvenation system and its method |
| CN102368267A (en) * | 2011-10-25 | 2012-03-07 | 曙光信息产业(北京)有限公司 | Method for keeping consistency of copies in distributed system |
| CN105677673A (en) * | 2014-11-20 | 2016-06-15 | 阿里巴巴集团控股有限公司 | Business processing method, device and system |
| CN105988893A (en) * | 2015-02-10 | 2016-10-05 | 北京中科同向信息技术有限公司 | Technique based on data replication |
| CN106452864A (en) * | 2016-09-30 | 2017-02-22 | 北京悦畅科技有限公司 | Parking lot fault protection method, apparatus and system thereof |
Non-Patent Citations (1)
| Title |
|---|
| 李晓会: "《网络安全与云计算》", 31 December 2017 * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111190765A (en) * | 2018-11-14 | 2020-05-22 | 深圳市茁壮网络股份有限公司 | Data backup method and system |
| CN110427423A (en) * | 2019-06-28 | 2019-11-08 | 苏州浪潮智能科技有限公司 | A kind of method, equipment and readable medium for avoiding database session from interrupting |
| CN110362622A (en) * | 2019-07-22 | 2019-10-22 | 江苏满运软件科技有限公司 | Real-time stream processing system, method, equipment and storage medium based on real-time number storehouse |
| CN110362622B (en) * | 2019-07-22 | 2022-06-10 | 江苏满运软件科技有限公司 | Real-time streaming processing system, method, device and storage medium based on real-time warehouse |
| CN110489300A (en) * | 2019-08-20 | 2019-11-22 | 北京市燃气集团有限责任公司 | Backup Data statistical method and device |
| CN112416884A (en) * | 2020-11-23 | 2021-02-26 | 中国移动通信集团江苏有限公司 | Data synchronization method and system |
| CN113285942A (en) * | 2021-05-19 | 2021-08-20 | 广东电网有限责任公司 | Data sharing method and device for transformer substation, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108664356A (en) | A kind of database backup method and device, Database Systems | |
| US11243847B2 (en) | Managing remote data replication | |
| US10078557B2 (en) | Use of replicated copies to improve database backup performance | |
| CN106610876B (en) | Data snapshot recovery method and device | |
| CN100476747C (en) | Storage system and data management method | |
| US6643671B2 (en) | System and method for synchronizing a data copy using an accumulation remote copy trio consistency group | |
| US8090917B2 (en) | Managing storage and migration of backup data | |
| US7747830B2 (en) | Backup system with continuous data protection | |
| US10146633B2 (en) | Data recovery from multiple data backup technologies | |
| US10365978B1 (en) | Synchronization of snapshots in a distributed consistency group | |
| CN107145403A (en) | The relevant database data retrogressive method of web oriented development environment | |
| US11917005B2 (en) | Clustered storage system synchronization | |
| CN111488243B (en) | Backup and recovery method and device for MongoDB database, electronic equipment and storage medium | |
| US10067836B1 (en) | Configuration based intelligent protection modeling | |
| US20200034051A1 (en) | Providing data protection to destination storage objects on remote arrays in response to assignment of data protection to corresponding source storage objects on local arrays | |
| CN104765651B (en) | A kind of data processing method and device | |
| CN107451172A (en) | Method of data synchronization and equipment for edition management system | |
| US11599427B2 (en) | Distributed recovery of server information | |
| CN104615511A (en) | Host batch recovery processing method and device based on double centers | |
| CN105224422A (en) | A kind of data back up method and equipment | |
| US20200034041A1 (en) | Utilizing groups of data protection policies that are assignable to storage objects | |
| CN110321386A (en) | Setting, data reconstruction method and the system of data synchronous architecture | |
| CN106484560B (en) | Method of data synchronization and device | |
| CN103218256A (en) | Batch backspacing method and system of host | |
| US11762688B2 (en) | Systems and methods for batch job execution in clustered environments using execution timestamp granularity between service instances having different system times |
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: 20181016 |