CN107193687A - Database backup method and controlling equipment - Google Patents
Database backup method and controlling equipment Download PDFInfo
- Publication number
- CN107193687A CN107193687A CN201710254593.8A CN201710254593A CN107193687A CN 107193687 A CN107193687 A CN 107193687A CN 201710254593 A CN201710254593 A CN 201710254593A CN 107193687 A CN107193687 A CN 107193687A
- Authority
- CN
- China
- Prior art keywords
- backup
- user
- backed
- data
- database
- 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
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/602—Providing cryptographic facilities or services
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Health & Medical Sciences (AREA)
- Quality & Reliability (AREA)
- Bioethics (AREA)
- General Health & Medical Sciences (AREA)
- Computer Hardware Design (AREA)
- Computer Security & Cryptography (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the present application provides a kind of database backup method and controlling equipment.Wherein, method comprises the following steps：Controlling equipment displaying one customizes the page, so that user customizes backup policy；Controlling equipment is operated in response to customization of the user on the page is customized, and obtains the backup policy that user customizes；The backup policy that controlling equipment is customized according to user, the data treated in backup database are backed up；Wherein, controlling equipment is independently of database to be backed up.The method and controlling equipment that the embodiment of the present application is provided can allow the user to flexible customization Database Backup Strategy, improve backup efficiency.
Description
Technical field
The application is related to database technical field, more particularly to a kind of database backup method and controlling equipment.
Background technology
Database (Database) is the warehouse for coming tissue, storage and management data according to data structure.Database is frequent
There are various failures, DB Backup technology can be recovered after database failure with time as small as possible and cost
Database.
In the prior art, it is usually, in database local disposition backup script or task (such as cron), to perform backup
Script or task, according to the backup policy in backup script or task by the data backup in database into local disk.This
Backup policy in a little backup scripts or task is sufficiently complete, and flexibility is poor, it is often necessary to change script or task, cost compared with
Greatly, monolithic backup is less efficient.
The content of the invention
The many aspects of the application provide a kind of database backup method and controlling equipment, to improve backup policy customization
Flexibility, improve DB Backup efficiency.
The embodiment of the present application provides a kind of database backup method, including：
Controlling equipment displaying one customizes the page, so that user customizes backup policy；
The controlling equipment is operated in response to customization of the user on the customization page, obtains the user
The backup policy of customization；
The backup policy that the controlling equipment is customized according to the user, the data progress treated in backup database is standby
Part；Wherein, the controlling equipment is independently of the database to be backed up.
Alternatively, the backup policy that the controlling equipment is customized according to the user, treats the number in backup database
According to being backed up, including：
Data Identification to be backed up and backup ground in the backup policy that the controlling equipment is customized according to the user
Location, generates backup instruction；
BACKUP TIME in the backup policy that the controlling equipment is customized according to the user, to the data to be backed up
Storehouse sends the backup instruction, so that the database to be backed up performs the backup instruction by the Data Identification institute to be backed up
The data backup of mark is into the corresponding data backup device of the backup address.
Alternatively, the backup policy that the controlling equipment is customized according to the user, treats the number in backup database
According to being backed up, including：
Data in database to be backed up described in the controlling equipment automatic regular polling；
Marked when occurring Data Identification to be backed up in the backup policy that the user customizes in the database to be backed up
During the data of knowledge, the data that the Data Identification to be backed up is identified are read from the database to be backed up；
BACKUP TIME in the backup policy customized according to the user, the Data Identification to be backed up is identified
In the corresponding data backup device of backup address in the backup policy that data storage is customized to the user.
Alternatively, the backup policy that the user customizes also includes：Backup number and/or backup duration.
Alternatively, the page that customizes includes the backup policy that the user customizes the last time；
The controlling equipment is operated in response to customization of the user on the customization page, obtains the user
The backup policy of customization, including：
The controlling equipment is operated in response to modification of the user on the customization page, obtains described customize
The backup policy customized the last time by the amended backup policy of the user and the unmodified user on the page；
Or,
The controlling equipment is operated in response to re-personalization of the user on the customization page, is emptied described
Customize the backup policy for the user last time customization that the page includes and obtain the user in the customization page
The backup policy of upper re-personalization.
Alternatively, the backup policy that the controlling equipment is customized according to the user, treats the number in backup database
According to being backed up, including：
The controlling equipment sets up encrypted link with the database to be backed up using remote control tool；
The controlling equipment uses remote control tool, the backup policy customized according to the user, to number to be backed up
Backed up according to the data in storehouse.
Alternatively, methods described also includes：
The controlling equipment checks operation, acquisition pair in response to backup progress of the user on the customization page
Data in the database to be backed up carry out the progress msg of backup operation；
The controlling equipment shows the progress msg on the customization page.
The embodiment of the present application also provides a kind of controlling equipment, including：
Display module, for showing that one customizes the page, so that user customizes backup policy；
Acquisition module, for being operated in response to customization of the user on the customization page, obtains described use
The backup policy that family is customized；
Backup module, for the backup policy customized according to the user, the data treated in backup database are carried out
Backup；Wherein, the controlling equipment is independently of the database to be backed up.
Alternatively, the backup module specifically for：
Data Identification to be backed up and backup address in the backup policy customized according to the user, generation backup refer to
Order；
BACKUP TIME in the backup policy customized according to the user, sends described standby to the database to be backed up
Part instruction, for the database to be backed up, to perform the data that the backup instruction identified the Data Identification to be backed up standby
Part is into the corresponding data backup device of the backup address.
Alternatively, the backup module specifically for：
Data in database to be backed up described in automatic regular polling；
Marked when occurring Data Identification to be backed up in the backup policy that the user customizes in the database to be backed up
During the data of knowledge, the data that the Data Identification to be backed up is identified are read from the database to be backed up；
BACKUP TIME in the backup policy customized according to the user, the Data Identification to be backed up is identified
In the corresponding data backup device of backup address in the backup policy that data storage is customized to the user.
In the embodiment of the present application, controlling equipment can show a customization page so that user can customize page
Flexible customization backup policy on face, makes backup policy more comprehensively, completely；, can and controlling equipment is independently of database to be backed up
To be managed collectively and dispatch the backup policy of user's customization, backed up with the data treated in backup database, so as to improve
The efficiency of DB Backup.
Brief description of the drawings
Accompanying drawing described herein is used for providing further understanding of the present application, constitutes the part of the application, this Shen
Schematic description and description please is used to explain the application, does not constitute the improper restriction to the application.In the accompanying drawings：
The schematic flow sheet for the database backup method that Fig. 1 provides for the embodiment of the application one；
Step S103 schematic flow sheet in the database backup method that Fig. 2 provides for the another embodiment of the application；
Step S103 schematic flow sheet in the database backup method that Fig. 3 provides for the another embodiment of the application；
The function structure chart for the controlling equipment that Fig. 4 provides for the another embodiment of the application.
Embodiment
To make the purpose, technical scheme and advantage of the application clearer, below in conjunction with the application specific embodiment and
Technical scheme is clearly and completely described corresponding accompanying drawing.Obviously, described embodiment is only the application one
Section Example, rather than whole embodiments.Based on the embodiment in the application, those of ordinary skill in the art are not doing
Go out the every other embodiment obtained under the premise of creative work, belong to the scope of the application protection.
Below in conjunction with accompanying drawing, the technical scheme that each embodiment of the application is provided is described in detail.
The schematic flow sheet for the database backup method that Fig. 1 provides for the embodiment of the application one.As shown in figure 1, this method
Comprise the following steps：
S101：Controlling equipment displaying one customizes the page, so that user customizes backup policy.
S102：Controlling equipment is operated in response to customization of the user on the page is customized, and obtains the standby of user's customization
Part strategy.
S103：The backup policy that controlling equipment is customized according to user, the data treated in backup database are backed up；
Wherein, controlling equipment is independently of database to be backed up.
, it is necessary to backup policy be pre-set, so as to according to backup policy Backup Data during data in backup database
Data in storehouse.Backup policy can be the strategy for instructing backup operation, for example, the data in database A are backuped into this
In local disk.In the prior art, backup policy is configured in database, flexibility typically in the form of script or timed task
It is poor.In the embodiment of the present application, user can customize flexible page customization backup strategy by one.
When user needs customization backup strategy, it can be sent to controlling equipment and customize page request message.Alternatively,
Controlling equipment can be implemented as server, and user can send fixed by the user end to server on respective terminal device
Inhibition and generation page request message；Or controlling equipment can be implemented as application program, user can apply journey by starting this
Sequence, sends to application program and customizes page request message.
Controlling equipment customizes the page in response to customizing page request message to user's displaying one, and user can be fixed
Customization operation is carried out on the inhibition and generation page.Alternatively, the customization page can be shown on web page, web page
The corresponding option of backup policy and/or the text box that backup policy is inputted for user, user can select backup on web page
The corresponding discretionary choices of strategy, and/or input in text box backup policy.
Then, controlling equipment can be operated in response to customization of the user on the page is customized, and obtained user and customized
Backup policy.It is alternatively possible to whenever user is once customized operation on the page is customized, controlling equipment in response to
This time of the user on the page is customized customizes operation, obtains the backup policy of this customization of user.
In one example, the data in database A " are backuped to this by user's input on the page is customized in the very first time
In local disk ", then controlling equipment is operated in response to this customization, obtains backup policy " in the very first time by database A
Data are backuped in the database of local disk "；Then, user on the page is customized again input " in the second time by number
Backuped to according to the data in the B of storehouse in local disk ", then controlling equipment is operated in response to this customization, acquisition backup policy "
Second time backuped to the data in database B in local disk ".It is of course also possible to when user is on the page is customized
When customizing operation completion, submission operation is carried out, control is submitted in such as triggering；Controlling equipment is being customized in response to user
Submission operation on the page, obtains whole backup policy that user customizes.
Alternatively, the backup policy that controlling equipment is obtained can be stored in the memory space of controlling equipment, for example, dispatch
In the database of equipment association.
Then, the backup policy that controlling equipment can be customized according to user, the data treated in backup database are carried out
Backup.Wherein, controlling equipment independently of database to be backed up, i.e. controlling equipment not as backup script of the prior art or timing
Task is deployed in database to be backed up and locally realized like that, so more neatly can customize backup policy for user, more
Plus neatly realize data backup.In one example, if controlling equipment is implemented as where server, database to be backed up
Server from controlling equipment be different servers.If controlling equipment is implemented as application program, application program fortune
Row is on the miscellaneous equipment different from database to be backed up.
Alternatively, database to be backed up can be one or more.Wherein, multiple databases to be backed up can include position
In multiple databases on different server or multiple databases on same server.
In the embodiment of the present application, controlling equipment can show a customization page so that user can customize page
Flexible customization backup policy on face, makes backup policy more comprehensively, completely；, can and controlling equipment is independently of database to be backed up
To be managed collectively and dispatch the backup policy of user's customization, backed up with the data treated in backup database, so as to improve
The efficiency of DB Backup.
Alternatively, the backup policy customized in controlling equipment according to user, the data treated in backup database are carried out
It is different according to the flow of Database Backup operations during backup, following two optional embodiments can be included.The first
Embodiment, as shown in Fig. 2 comprising the following steps：
S1031：Data Identification to be backed up and backup address in the backup policy that controlling equipment is customized according to user,
Generate backup instruction.
S1032：BACKUP TIME in the backup policy that controlling equipment is customized according to user, sends to database to be backed up
Backup instruction, so that database to be backed up performs the backup instruction data backup that is identified Data Identification to be backed up to backing up ground
In the corresponding data backup device in location.
The backup policy that user customizes includes but is not limited to Data Identification to be backed up and backup address.Data to be backed up
Identifying needs the data of backup for unique mark.Alternatively, database to be backed up can enter according to database instance to data
Row management, the then data that backup is needed in database to be backed up are actually the data of each database instance.It is to be backed up based on this
Data Identification can include the IP address of database to be backed up and the mark of the affiliated database instance of data to be backed up.Due to one
Individual one database port of database instance correspondence, can be using mark of the port numbering as database instance.In an example
In, Data Identification to be backed up includes the IP address 180.97.33.107 and port numbers 3000 of database to be backed up.
Backup address indicates to be used for storing the address of the data backup device of Backup Data.Alternatively, backup address can be with
Be data backup device (such as other databases) address or database to be backed up local disk address.
Controlling equipment can generate backup instruction according to Data Identification to be backed up and backup address.The backup instruction
Data Identification to be backed up and backup address are carried, to the data for indicating to be identified Data Identification to be backed up, is backuped to standby
In the corresponding data backup device in part address.Wherein, data backup device includes but is not limited to different from database to be backed up
Other databases, or database to be backed up local disk.
In general, the importance for the data that Data Identification to be backed up is identified is different, its BACKUP TIME should difference.It is based on
This, can also include BACKUP TIME, that is, perform the time of backup operation in the backup policy that user customizes.
Alternatively, BACKUP TIME can be the specific moment of all previous execution backup operation；Can also be from current time,
Institute's interlude between each backup operation.For example, BACKUP TIME can be from current time, carried out every a hour
Backup operation；Or, BACKUP TIME can be daily 01:00、12:00 and 24:00.
When then, at the time of being characterized by BACKUP TIME at current time, controlling equipment sends standby to database to be backed up
Part instruction, that is, indicate that database to be backed up performs backup instruction at current time.Wherein, controlling equipment can be to be backed up
The IP address of database to be backed up is obtained in Data Identification, and then controlling equipment is according to the IP address of acquisition, to data to be backed up
Storehouse sends backup instruction.
Database to be backed up is received after backup instruction, is immediately performed backup instruction, and Data Identification to be backed up is identified
Data backup into the corresponding data backup device of backup address.It is alternatively possible to first be performed in database to be backed up standby
Part operation, then Backup Data is clipped in the corresponding data backup device of backup address.
Alternatively, the backup policy that user customizes can also include backup number and/or backup duration.Based on this, have
Body includes following three kinds of situations：
The first situation：User customize backup policy include backup duration, backup duration refer to from back up completion when
Time between being carved at the time of deleting Backup Data, that is, the duration that Backup Data is present.Based on this, controlling equipment according to
Data Identification to be backed up, backup address and backup duration in the backup policy that user customizes, generate backup instruction；Scheduling
BACKUP TIME in the backup policy that equipment is customized according to user, backup instruction is sent to database to be backed up, standby for treating
Part database performs backup instruction, the data backup that Data Identification to be backed up is identified to the corresponding data backup of backup address
In equipment, and from back up complete at the time of, during more than backup duration, deletion data backup device in Backup Data.
Second of situation：The backup policy that user customizes includes backup number.Based on this, controlling equipment is fixed according to user
Data Identification to be backed up, backup address and backup number in the backup policy of inhibition and generation, generate backup instruction；Controlling equipment root
BACKUP TIME in the backup policy customized according to user, sends backup instruction, for data to be backed up to database to be backed up
Storehouse performs backup instruction, and the data that Data Identification to be backed up is identified back up to backup address corresponding according to backup number
In data backup device.
The third situation：The backup policy that user customizes can also include backup number and backup duration.Based on this, adjust
Data Identification to be backed up, backup address, backup number in the backup policy that degree equipment is customized according to user and when backing up
It is long, generate backup instruction；BACKUP TIME in the backup policy that controlling equipment is customized according to user, sends out to database to be backed up
Backup instruction is sent, so that database to be backed up performs backup instruction, the data that Data Identification to be backed up is identified, according to backup
Number is backed up in the corresponding data backup device of backup address, and from back up complete at the time of, during more than backup duration,
Delete the Backup Data in data backup device.
Alternatively, when the backup policy that user customizes does not include backup number, backup number is default value, is, for example,
1 part；When the backup policy that user customizes does not include backup duration, a length of default value during backup, for example, 30 days.
, first, can be flexible by customizing Backup Data mark, backup address and BACKUP TIME in the present embodiment
The data of customization backup, the time granularity backup of backup and the address backuped to；And pass through customization backup number and backup
Time, further increase the flexibility of customization backup strategy.Secondly, the present embodiment can be BACKUP TIME table at current time
At the time of levying, indicate that database to be backed up performs backup operation, BACKUP TIME is recognized without database to be backed up；Moreover, treating standby
The data backup that part database directly can be identified Data Identification to be backed up is to the corresponding data backup device of backup address
In, without other equipment transfer, backup flow is simplified, backup efficiency is improved.
Second of embodiment, as shown in figure 3, comprising the following steps：
S1033：Data in automatic regular polling database to be backed up.
S1034：When Data Identification to be backed up is identified in the backup policy for occurring user's customization in database to be backed up
Data when, the data that Data Identification to be backed up is identified are read from database to be backed up.
S1035：BACKUP TIME in the backup policy customized according to user, the number that Data Identification to be backed up is identified
In the corresponding data backup device of backup address in the backup policy customized according to storing to user.
In the present embodiment, user customize backup policy include but is not limited to Data Identification to be backed up, BACKUP TIME with
And backup address.
It is alternatively possible to process when presetting in controlling equipment, for the data in automatic regular polling database to be backed up.
It is alternatively possible to the data identified by Data Identification to be backed up in timing process automatic regular polling database to be backed up.It is described
Data Identification to be backed up is identical with the Data Identification to be backed up in above-mentioned embodiment.
When occurring Backup Data in database to be backed up and identifying identified data, that is, when in database to be backed up
Data Identification and Backup Data mark when being consistent, the data that Data Identification to be backed up is identified can be read from database.
It is alternatively possible to which the digital independent that Data Identification to be backed up is identified is into the memory space of controlling equipment, so as to will treat standby
The data " backup " that part Data Identification is identified arrive controlling equipment.
, can be by the number to be backed up in controlling equipment memory space when at the time of being characterized by BACKUP TIME at current time
According to identified data are identified, store into the corresponding data backup device of backup address.Alternatively, in the same of storage operation
When, the data that the Data Identification to be backed up in controlling equipment memory space is identified can be deleted.
Similar with the first above-mentioned embodiment, in the present embodiment, the backup policy that user customizes can also include standby
Part number and/or backup duration.Based on this, following three kinds of situations are specifically included：
The first situation：The backup policy that user customizes includes backup duration.Based on this, controlling equipment can be with timing wheel
Ask the data in database to be backed up；When data mark to be backed up in the backup policy for occurring user's customization in database to be backed up
When knowing identified data, the data that Data Identification to be backed up is identified are read from database to be backed up；Customized according to user
BACKUP TIME in the backup policy of change, the backup plan that the data storage that Data Identification to be backed up is identified to user is customized
In the corresponding data backup device of backup address in slightly；At the time of completion is backed up, the backup plan customized more than user
During backup duration in slightly, the Backup Data in data backup device is deleted.
Second of situation：The backup policy that user customizes includes backup number.Based on this, controlling equipment can be with timing wheel
Ask the data in database to be backed up；When data mark to be backed up in the backup policy for occurring user's customization in database to be backed up
When knowing identified data, the data that the Data Identification to be backed up of backup number is identified are read from database to be backed up；Root
BACKUP TIME in the backup policy customized according to user, the data that the Data Identification to be backed up of the backup number is identified
Store in the corresponding data backup device of backup address in the backup policy customized to user.
The third situation：The backup policy that user customizes can also include backup number and backup duration.Based on this, adjust
Spending equipment can be with the data in automatic regular polling database to be backed up；When the backup plan for occurring user's customization in database to be backed up
During the data that Data Identification to be backed up is identified in slightly, the Data Identification to be backed up of backup number is read from database to be backed up
The data identified；BACKUP TIME in the backup policy customized according to user, by the data to be backed up of the backup number
In the corresponding data backup device of backup address in the backup policy that the identified data storage of mark is customized to user；From
Backup complete at the time of from, more than user customize backup policy in backup duration when, delete data backup device in
Backup Data.
In the present embodiment, " backup " behaviour can be performed when the data that Data Identification to be backed up is identified occur
Make, when then being arrived at the time of BACKUP TIME is characterized, directly " will back up " good data storage to data backup device
In, the time of data backup is saved, and then improve data backup efficiency.
Alternatively, the backup policy of the customization page of controlling equipment displaying can be sky, that is, customize the text of the page
Frame is unselected for the corresponding option of backup policy that the empty or customization page is provided, and can now be customized by user complete
Backup policy.Alternatively, the backup policy that user customizes the last time can also be included by customizing the page, so that user refers to
The backup policy customized before, carries out the customization of this backup policy.Include user's last time customization when customizing the page
Backup policy when, controlling equipment can in response to user customize the page on customization operate, obtain user customize
Backup policy the step of, including any one following embodiment.
The first embodiment：Controlling equipment is operated in response to modification of the user on the page is customized, and is obtained and is customized
The backup policy customized the last time by the amended backup policy of user and unmodified user on the page.
Wherein, modification operation includes the operations such as increase, deletion, replacement.In the present embodiment, user is on customized web page
Modification operation can include the operation that any one backup policy is increased, deleted or replaced.For example, user is in customization
Modification operation on the page can, by backup policy " by database instance A 3 parts of data backup ", increase BACKUP TIME " 2
My god "；BACKUP TIME " 2 days " in backup policy " interval 2 days, by database instance A 3 parts of data backup " can also be deleted
Remove or replace with the backup number in backup policy " by database instance A 3 parts of data backup " " 2 parts ".
In view of user modifies on the basis of the upper backup policy once customized, controlling equipment can in response to
Modification operation of the family on the page is customized, obtains to customize and passes through the amended backup policy of user on the page and unmodified
User last time customize backup policy, to obtain complete backup policy.
What deserves to be explained is, if user only needs to controlling equipment according to the backup after increase operation and/or replacement operation
Strategy execution is backed up, and can delete other backup policy, is operated and/or is replaced by increase in operation pages to obtain user
Change the backup policy of operation.If the backup policy modification customized the last time to user is local more, it can use following
Second of embodiment, obtains the backup policy that user customizes.
Second of embodiment：Controlling equipment is operated in response to re-personalization of the user on the page is customized, and is emptied
Customize the backup policy for user's last time customization that the page includes and obtain user's re-personalization on the page is customized
Backup policy.
Alternatively, re-personalization operation of the user on the page is customized includes user on the page is customized to again
The trigger action of custom control, and the backup policy shown in controlling equipment are that backup plan is customized on the empty customization page
Operation slightly.
Specifically, a custom control again can be provided by customizing on the page, user can trigger custom control again,
To ask re-personalization backup policy.Triggering of the controlling equipment in response to user on the page is customized to custom control again
Operation, empties the backup policy for customizing user's last time customization that the page includes, to show user ID strategy as sky
The customization page.
Then, user can input backup policy in the text box on customizing the page, and/or, customizing the page
Selected in the corresponding option of backup policy of offer and customize strategy.Controlling equipment is defeated on the page is customized in response to user
Enter the operation of backup policy and/or selected backup policy, obtain user input and selected backup policy on the page is customized.
In the present embodiment, customizing the page includes the backup policy that user customizes the last time, and then user can be upper
Modify and operate or re-personalization operation on the basis of the backup policy once customized, facilitate user's customization backup plan
Slightly.
In above-described embodiment or following embodiments, when controlling equipment from database to be backed up positioned at different physical equipments
When upper, controlling equipment can perform data backup with remote control database to be backed up.
Alternatively, the backup policy that controlling equipment is customized according to user, the data progress treated in backup database is standby
The step of part, specifically include：Controlling equipment sets up encrypted link with database to be backed up using remote control tool；Controlling equipment
Using remote control tool, the backup policy customized according to user, the data treated in backup database are backed up.
Wherein, remote control tool can be SSH (secure shell " safe shell "), and SSH can be by a series of
Encryption technology, encryption connection is set up between the two endpoints.When between controlling equipment and database to be backed up use SSH
Set up after encrypted link, controlling equipment can use SSH, the backup policy customized according to user is treated in backup database
Data backed up.
When being carried out data transmission between controlling equipment and database to be backed up using SSH, data are through overcompression, institute
It is very fast with the speed ratio of data transfer, be conducive to improving the efficiency backed up, while also improving the security of data backup.
In an optional embodiment, the backup policy customized in controlling equipment according to user treats backup database
In data when being backed up, controlling equipment may also respond to backup progress of the user on the page is customized and check operation,
Obtain the progress msg that the data treated in backup database carry out backup operation；Controlling equipment is on the page is customized, displaying
Progress msg.
Alternatively, backup progress checks that operation can be the trigger action that control is checked to backup progress.Customize the page
On a backup progress can be provided check control, when user needs to check backup progress, can trigger on the customization page
Backup progress checks control.
Controlling equipment checks the trigger action of control in response to user to backup progress, and acquisition is treated in backup database
Data carry out the progress msg of backup operation.The progress msg includes backing up successful database reality in database to be backed up
Example, the database instance of backup failure, the real-time progress of database instance backed up etc..
Alternatively, controlling equipment can periodically be obtained the data treated in backup database and entered by a time-of-the-day order
The progress msg of row backup operation.Then, controlling equipment shows progress msg on the page is customized.It is alternatively possible to fixed
The peripheral region of the corresponding database instance of backup policy customized on the inhibition and generation page, the backup of displaying associated databases example is entered
Spend information.
Certainly, controlling equipment can also check operation in response to the backup progress of user, and the newly-built progress display page is used
To show that the data treated in backup database carry out the progress msg of backup operation.
In the present embodiment, the data in database to be backed up can be carried out to the progress msg of backup operation, to visualize
Form show user, so as to user understand backup progress, be conducive in time find backup in produced problem, improve number
According to the security of backup.
The embodiment of the present application additionally provides a kind of controlling equipment 200, including display module 210, acquisition module 220 and standby
Part module 230.
Wherein, display module 210, for showing that one customizes the page, so that user customizes backup policy.
Acquisition module 220, for being grasped in response to user in the customization customized on the page that display module 210 is shown
Make, obtain the backup policy that user customizes.
Backup module 230, the backup policy that the user for being obtained according to acquisition module 220 customizes, to number to be backed up
Backed up according to the data in storehouse；Wherein, controlling equipment is independently of database to be backed up.
In the embodiment of the present application, controlling equipment can show a customization page so that user can customize page
Flexible customization backup policy on face, makes backup policy more comprehensively, completely；, can and controlling equipment is independently of database to be backed up
To be managed collectively and dispatch the backup policy of user's customization, backed up with the data treated in backup database, so as to improve
The efficiency of DB Backup.
Alternatively, the backup policy that backup module 230 is customized in the user obtained according to acquisition module 220, treats standby
When data in part database are backed up, specifically for：Backup Data mark in the backup policy customized according to user
And backup address, generate backup instruction；BACKUP TIME in the backup policy customized according to user, to database to be backed up
The backup instruction is sent, so that database to be backed up performs what the backup instruction was identified the Data Identification to be backed up
Data backup is into the corresponding data backup device of backup address.
In the present embodiment, first, identified by customizing Backup Data, backup address and BACKUP TIME so that can be with
Flexible customization backs up which data, the address backed up and backuped to different time granularities；Secondly, the present embodiment can be
At the time of current time is that BACKUP TIME is characterized, indicates that database to be backed up performs backup operation, know without database to be backed up
Other BACKUP TIME；Moreover, the database to be backed up directly data backup that is identified Data Identification to be backed up is to backup address pair
In the data backup device answered, without other equipment transfer, backup flow is simplified, backup efficiency is improved.
Alternatively, the backup policy that user customizes also includes：Backup number and/or backup duration.Pass through customization backup
Number and BACKUP TIME, further increase the flexibility of customization backup strategy.
Alternatively, the backup policy that backup module 230 is customized in the user obtained according to acquisition module 220, treats standby
When data in part database are backed up, specifically it is additionally operable to：Data in automatic regular polling database to be backed up；When number to be backed up
According to occur in storehouse user customization backup policy in Data Identification to be backed up identified data when, from database to be backed up
Read the data that Data Identification to be backed up is identified；BACKUP TIME in the backup policy customized according to user, will be to be backed up
The corresponding data backup device of backup address in the backup policy that the data storage that Data Identification is identified is customized to user
In.
In the present embodiment, " backup " behaviour can be performed when the data that Data Identification to be backed up is identified occur
Make, when then being arrived at the time of BACKUP TIME is characterized, directly " will back up " good data storage to data backup device
In, the time of data backup is saved, and then improve data backup efficiency.
Alternatively, customizing the page includes the backup policy that user customizes the last time；Based on this, acquisition module 220 exists
In response to customization operation of the user on the page is customized, the backup policy that user customizes is obtained, including：In response to user
Modification operation on the customization page, obtains to customize and passes through the amended backup policy of user on the page and do not repair
The backup policy that the user changed customizes the last time；Or,
In response to re-personalization operation of the user on the page is customized, empty and customize the user upper one that the page includes
The backup policy of secondary customization and the backup policy for obtaining user's re-personalization on the page is customized.
In the present embodiment, customizing the page includes the backup policy that user customizes the last time, and then user can be upper
Modify and operate or re-personalization operation on the basis of the backup policy once customized, facilitate user's customization backup plan
Slightly.
Alternatively, backup module 230 is in the backup policy customized according to user, and the data treated in backup database are entered
During row backup, specifically for：Encrypted link is set up using remote control tool with database to be backed up；Using remote control work
Tool, the backup policy customized according to user, the data treated in backup database are backed up.
In the present embodiment, the speed ratio of data transfer is very fast, is conducive to improving the efficiency backed up, while also improving data
The security of backup.
Alternatively, display module 210 is additionally operable to：Backup progress in response to user checks operation, obtains to number to be backed up
The progress msg of backup operation is carried out according to the data in storehouse；On the page is customized, progress msg is shown.
In the present embodiment, the data in database to be backed up can be carried out to the progress msg of backup operation, to visualize
Form show user, so as to user understand backup progress, be conducive in time find backup in produced problem, improve number
According to the security of backup.
The controlling equipment is corresponding with foregoing method flow description, and weak point refers to the narration of above method flow,
No longer repeat one by one.
It should be understood by those skilled in the art that, embodiments of the invention can be provided as method, system or computer program
Product.Therefore, the present invention can be using the reality in terms of complete hardware embodiment, complete software embodiment or combination software and hardware
Apply the form of example.Moreover, the present invention can be used in one or more computers for wherein including computer usable program code
The computer program production that usable storage medium is implemented on (including but is not limited to magnetic disk storage, CD-ROM, optical memory etc.)
The form of product.
It should also be noted that, term " comprising ", "comprising" or its any other variant are intended to nonexcludability
Comprising so that process, method, commodity or equipment including a series of key elements are not only including those key elements, but also wrap
Include other key elements being not expressly set out, or also include for this process, method, commodity or equipment intrinsic want
Element.In the absence of more restrictions, the key element limited by sentence "including a ...", it is not excluded that wanted including described
Also there is other identical element in process, method, commodity or the equipment of element.
It will be understood by those skilled in the art that embodiments herein can be provided as method, system or computer program product.
Therefore, the application can be using the embodiment in terms of complete hardware embodiment, complete software embodiment or combination software and hardware
Form.Deposited moreover, the application can use to can use in one or more computers for wherein including computer usable program code
The shape for the computer program product that storage media is implemented on (including but is not limited to magnetic disk storage, CD-ROM, optical memory etc.)
Formula.
Embodiments herein is the foregoing is only, the application is not limited to.For those skilled in the art
For, the application can have various modifications and variations.It is all any modifications made within spirit herein and principle, equivalent
Replace, improve etc., it should be included within the scope of claims hereof.
Claims (10)
1. a kind of database backup method, it is characterised in that including：
Controlling equipment displaying one customizes the page, so that user customizes backup policy；
The controlling equipment is operated in response to customization of the user on the customization page, obtains user's customization
The backup policy of change；
The backup policy that the controlling equipment is customized according to the user, the data treated in backup database are backed up；
Wherein, the controlling equipment is independently of the database to be backed up.
2. according to the method described in claim 1, it is characterised in that the backup that the controlling equipment is customized according to the user
Strategy, the data treated in backup database are backed up, including：
Data Identification to be backed up and backup address in the backup policy that the controlling equipment is customized according to the user, it is raw
Into backup instruction；
BACKUP TIME in the backup policy that the controlling equipment is customized according to the user, sends out to the database to be backed up
The backup instruction is sent, the Data Identification to be backed up is identified so that the database to be backed up performs the backup instruction
Data backup into the corresponding data backup device of the backup address.
3. according to the method described in claim 1, it is characterised in that the backup that the controlling equipment is customized according to the user
Strategy, the data treated in backup database are backed up, including：
Data in database to be backed up described in the controlling equipment automatic regular polling；
When occurring what Data Identification to be backed up in the backup policy that the user customizes was identified in the database to be backed up
During data, the data that the Data Identification to be backed up is identified are read from the database to be backed up；
BACKUP TIME in the backup policy customized according to the user, the data that the Data Identification to be backed up is identified
Store in the corresponding data backup device of backup address in the backup policy customized to the user.
4. according to the method in claim 2 or 3, it is characterised in that the backup policy that the user customizes also includes：It is standby
Part number and/or backup duration.
5. the method according to claim any one of 1-3, it is characterised in that the customization page is included on the user
The backup policy once customized；
The controlling equipment is operated in response to customization of the user on the customization page, obtains user's customization
The backup policy of change, including：
The controlling equipment is operated in response to modification of the user on the customization page, obtains the customization page
It is upper to pass through the amended backup policy of the user and the backup policy of unmodified user last time customization；Or
Person,
The controlling equipment is operated in response to re-personalization of the user on the customization page, empties the customization
Change the backup policy for the user last time customization that the page includes and obtain user weight on the customization page
The backup policy newly customized.
6. according to the method described in claim 1, it is characterised in that the backup that the controlling equipment is customized according to the user
Strategy, the data treated in backup database are backed up, including：
The controlling equipment sets up encrypted link with the database to be backed up using remote control tool；
The controlling equipment uses the remote control tool, the backup policy customized according to the user, treats standby to described
Data in part database are backed up.
7. according to the method described in claim 1, it is characterised in that methods described also includes：
The controlling equipment checks operation in response to backup progress of the user on the customization page, obtains to described
Data in database to be backed up carry out the progress msg of backup operation；
The controlling equipment shows the progress msg on the customization page.
8. a kind of controlling equipment, it is characterised in that including：
Display module, for showing that one customizes the page, so that user customizes backup policy；
Acquisition module, for being operated in response to customization of the user on the customization page, obtains the user and determines
The backup policy of inhibition and generation；
Backup module, for the backup policy customized according to the user, the data treated in backup database are backed up；
Wherein, the controlling equipment is independently of the database to be backed up.
9. controlling equipment according to claim 8, it is characterised in that the backup module specifically for：
Data Identification to be backed up and backup address in the backup policy customized according to the user, generate backup instruction；
BACKUP TIME in the backup policy customized according to the user, sends the backup to the database to be backed up and refers to
Order, so that the database to be backed up performs data backup that the backup instruction identified the Data Identification to be backed up extremely
In the corresponding data backup device of the backup address.
10. controlling equipment according to claim 8, it is characterised in that the backup module specifically for：
Data in database to be backed up described in automatic regular polling；
When occurring what Data Identification to be backed up in the backup policy that the user customizes was identified in the database to be backed up
During data, the data that the Data Identification to be backed up is identified are read from the database to be backed up；
BACKUP TIME in the backup policy customized according to the user, the data that the Data Identification to be backed up is identified
Store in the corresponding data backup device of backup address in the backup policy customized to the user.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710254593.8A CN107193687A (en) | 2017-04-18 | 2017-04-18 | Database backup method and controlling equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710254593.8A CN107193687A (en) | 2017-04-18 | 2017-04-18 | Database backup method and controlling equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107193687A true CN107193687A (en) | 2017-09-22 |
Family
ID=59872064
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710254593.8A Pending CN107193687A (en) | 2017-04-18 | 2017-04-18 | Database backup method and controlling equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107193687A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107977288A (en) * | 2017-12-15 | 2018-05-01 | 安徽长泰信息安全服务有限公司 | A kind of high efficiency incremental backup system and method easy to recover |
| CN109542680A (en) * | 2018-11-12 | 2019-03-29 | 上海碳蓝网络科技有限公司 | A kind of method of file backup, equipment and computer storage medium |
| CN110008066A (en) * | 2019-04-11 | 2019-07-12 | 苏州浪潮智能科技有限公司 | A kind of database backup method, system and electronic equipment and storage medium |
| CN110399250A (en) * | 2019-06-26 | 2019-11-01 | 苏州浪潮智能科技有限公司 | A kind of OpenStack cloud hard disk automatic backup method and system based on customized strategy |
| CN110413438A (en) * | 2019-07-26 | 2019-11-05 | 中国工商银行股份有限公司 | The treating method and apparatus to report an error for backup |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101887388A (en) * | 2010-06-18 | 2010-11-17 | 中兴通讯股份有限公司 | Data backup system and method based on memory database |
| CN102541694A (en) * | 2012-01-18 | 2012-07-04 | 浪潮(北京)电子信息产业有限公司 | Method and device for database backup |
| CN104765651A (en) * | 2014-01-06 | 2015-07-08 | 中国移动通信集团福建有限公司 | Data processing method and device |
| US20150278034A1 (en) * | 2010-03-02 | 2015-10-01 | Storagecraft Technology Corporation | Restoration of a backup of a first volume to a second volume on physical media |
| US20160350189A1 (en) * | 2014-04-02 | 2016-12-01 | International Business Machines Corporation | Increasing disaster resiliency by having a pod backed up to other peer pods in a site or beyond |
-
2017
- 2017-04-18 CN CN201710254593.8A patent/CN107193687A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20150278034A1 (en) * | 2010-03-02 | 2015-10-01 | Storagecraft Technology Corporation | Restoration of a backup of a first volume to a second volume on physical media |
| CN101887388A (en) * | 2010-06-18 | 2010-11-17 | 中兴通讯股份有限公司 | Data backup system and method based on memory database |
| CN102541694A (en) * | 2012-01-18 | 2012-07-04 | 浪潮(北京)电子信息产业有限公司 | Method and device for database backup |
| CN104765651A (en) * | 2014-01-06 | 2015-07-08 | 中国移动通信集团福建有限公司 | Data processing method and device |
| US20160350189A1 (en) * | 2014-04-02 | 2016-12-01 | International Business Machines Corporation | Increasing disaster resiliency by having a pod backed up to other peer pods in a site or beyond |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107977288A (en) * | 2017-12-15 | 2018-05-01 | 安徽长泰信息安全服务有限公司 | A kind of high efficiency incremental backup system and method easy to recover |
| CN109542680A (en) * | 2018-11-12 | 2019-03-29 | 上海碳蓝网络科技有限公司 | A kind of method of file backup, equipment and computer storage medium |
| CN110008066A (en) * | 2019-04-11 | 2019-07-12 | 苏州浪潮智能科技有限公司 | A kind of database backup method, system and electronic equipment and storage medium |
| CN110399250A (en) * | 2019-06-26 | 2019-11-01 | 苏州浪潮智能科技有限公司 | A kind of OpenStack cloud hard disk automatic backup method and system based on customized strategy |
| CN110413438A (en) * | 2019-07-26 | 2019-11-05 | 中国工商银行股份有限公司 | The treating method and apparatus to report an error for backup |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107193687A (en) | Database backup method and controlling equipment | |
| US10678787B2 (en) | Computer assisted completion of hyperlink command segments | |
| CN107111636A (en) | Optimize the volume level redundancy encoding technology of storage device for sequential delivery | |
| CN107924338A (en) | Optimal storage device and workload in geographically distributed clusters system are placed and high resiliency | |
| EP3610440A1 (en) | Blockchain partial ledgers | |
| CN102763102A (en) | Self-service configuration for data environment | |
| CN107239928B (en) | The flow generation method and device of a kind of resource allocation | |
| CN107179879A (en) | Method and apparatus for the Data Migration of storage device | |
| WO2020222917A1 (en) | Organizational-based language model generation | |
| CN102591700A (en) | Providing a persona-based application experience | |
| CN106899648A (en) | A kind of data processing method and equipment | |
| CN107147724A (en) | A kind of information push method, server and computer-readable recording medium | |
| US9495253B2 (en) | Virtual snapshot system and method | |
| US11228486B2 (en) | Methods for managing storage virtual machine configuration changes in a distributed storage system and devices thereof | |
| CN113204598B (en) | Data synchronization method, system and storage medium | |
| CN112313629B (en) | Backup and restore verification | |
| CN103677913A (en) | Business processing method and device based on business process management (BPM) | |
| CN107145547A (en) | A kind of acquisition methods of abnormal data, equipment and computer-readable recording medium | |
| US10142415B2 (en) | Data migration | |
| CN108121774A (en) | A kind of tables of data backup method and terminal device | |
| CN107179965A (en) | Database restoring method and device | |
| CN106776120A (en) | The method and device of data recovery | |
| CN106339176A (en) | Intermediate file processing method, client, server and system | |
| CN112036579A (en) | Self-learning online updating method, system and device for multi-classification model | |
| KR20010086547A (en) | Web drive system |
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: 20170922 |