CN103309772A - Database file backup method and system based on cloud storage - Google Patents
Database file backup method and system based on cloud storage Download PDFInfo
- Publication number
- CN103309772A CN103309772A CN201310275053XA CN201310275053A CN103309772A CN 103309772 A CN103309772 A CN 103309772A CN 201310275053X A CN201310275053X A CN 201310275053XA CN 201310275053 A CN201310275053 A CN 201310275053A CN 103309772 A CN103309772 A CN 103309772A
- Authority
- CN
- China
- Prior art keywords
- database
- directory
- backup
- under
- cloud dish
- 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
Images
Abstract
The invention discloses a database file backup method based on cloud storage. The method comprises the steps as follows: setting an automatic desktop synchronization mode for a cloud disk client, creating a local database directory in a local cloud storage directory of a cloud disk, storing a database file into the local database directory of the cloud disk, and automatically backuping the database file in the local database directory into a corresponding network database directory of the cloud disk in a preset backup way. The invention further discloses a database file backup system based on cloud storage. By adopting the method and the system, the data backup performance under excessively large data size can be improved.
Description
Technical field
The present invention relates to field of computer technology, more specifically, relate to a kind of Backup of database files method and standby system based on the cloud storage.
Background technology
Site databases generally all can leave on the disk array of the network storage or direct-connected storage (Direct-Attached Storage, DAS) on the domestic market.Although the possibility that disk array damages is lower, causes sometimes stuck phenomenon because data volume is excessive, and might cause the failure backed up.
In addition, generally all adopt installation desktop synchronizing software to realize in the present domestic desktop synchronization scenario synchronous for user's desktop, the user need to install specific sync client in advance when using desktop synchronous.Like this, in synchronizing process all belong to the thing of desktop all can be all synchronous, this can expend a large amount of time in the situation that the network of network environment is poor.
Summary of the invention
For the problem in the correlation technique, the present invention proposes a kind of Backup of database files method and standby system that can improve the data backup performance of data volume when excessive.
According to an aspect of the present invention, provide a kind of Backup of database files method based on the cloud storage, having comprised:
For cloud dish client, desktop automatic synchronization mode is set;
Under the local cloud storage directory of cloud dish, set up the local data library directory;
Database file is stored under the local data library directory of described cloud dish;
The backup mode that employing presets is deposited the database file automated back-up under the described local data library directory under the map network data base directory of described cloud dish.
In optional embodiment, adopt the backup mode that presets that the database file automated back-up under the described local data library directory is deposited under the map network data base directory of described cloud dish, comprising:
Adopt the back mechanism of database itself or the inside back mechanism of cloud dish that described database file is backed up in realtime, thereby store under the map network data base directory of described cloud dish; Perhaps,
Adopt the back mechanism of database itself or the inside back mechanism of cloud dish that described database file is carried out timed backup, thereby store under the map network data base directory of described cloud dish.
In optional embodiment, described database file is website DBMS library file.
In optional embodiment, in this Backup of database files method, for the website of using SQL Server Database Systems, the task that automatically performs is set; According to described automatically perform task with described Backup of database files under the local data library directory of described cloud dish, wherein, the described task that automatically performs comprises and backing up in realtime or timed backup.
In optional embodiment, in this Backup of database files method, for the website of using the Access Database Systems, the database file of frequent read-write is not stored under the cloud storage directory of cloud dish; Database file is stored under the described local data library directory comprises: copy under the local data library directory of described cloud dish according to the database file of the timing updating task that pre-sets with described frequent read-write.
According to a further aspect in the invention, also provide a kind of Backup of database files system based on the cloud storage, having comprised:
Cloud dish client-side management unit is used for desktop automatic synchronization mode is set, and behind the indication information that receives the building database catalogue, sets up the local data library directory under the local cloud storage directory of cloud dish;
The document storage management unit is used for database file is stored under the local data library directory of described cloud dish;
Data synchronisation unit is used for according to the backup mode that presets the database file automated back-up under the described local data library directory being deposited under the map network data base directory of described cloud dish.
In optional embodiment, data synchronisation unit is deposited the database file automated back-up under the described local data library directory according to the backup mode that presets under the map network data base directory of described cloud dish, comprise: according to the back mechanism of database itself or the inside back mechanism of cloud dish described database file is backed up in realtime, thereby store under the map network data base directory of described cloud dish; Perhaps, according to the back mechanism of database itself or the inside back mechanism of cloud dish described database file is carried out timed backup, thereby store under the map network data base directory of described cloud dish.
In optional embodiment, described database file is website DBMS library file.
In optional embodiment, described Backup of database files system also comprises data management by synchronization unit, is used for for the website of using SQL Server Database Systems the task that automatically performs being set, wherein, the described task that automatically performs comprises and backing up in realtime or timed backup; Described data synchronisation unit is used under the described triggering that automatically performs task, according to described automatically perform task with described Backup of database files under the local data library directory of described cloud dish.
In optional embodiment, described document storage management unit also is used for for the website of using the Access Database Systems, and the database file of the frequent read-write of indication is not stored under the local cloud storage directory of cloud dish; And, database file is stored under the local data library directory of described cloud dish and comprises: copy under the local data library directory of described cloud dish according to the database file of the timing updating task that pre-sets with described frequent read-write.
The embodiment of the invention is by under the local directory that database file is left in the cloud dish, then utilize the backup mode that presets with the database file automated back-up in the cloud storage networking.This synchronous cloud storage mode of desktop that utilizes can be realized the timing of this catalogue is upgraded or automatically upgraded, and can improve the data backup performance of data volume when excessive.
Description of drawings
Fig. 1 is according to an embodiment of the invention based on the schematic flow sheet of the DB Backup method of cloud storage.
Fig. 2 is according to another embodiment of the present invention based on the structured flowchart of the Backup of database files system of cloud storage.
Embodiment
Below in conjunction with accompanying drawing the present invention is described in further detail.
Fig. 1 is according to an embodiment of the invention based on the schematic flow sheet of the DB Backup method of cloud storage.As shown in Figure 1, the method comprises:
S101 for cloud dish client, arranges desktop automatic synchronization mode.
S102 sets up the local data library directory under the local cloud storage directory of cloud dish.
For example, when cloud dish client software is installed desktop being set is automatic synchronization, can when the desktop data change, in time be synchronized to high in the clouds like this.For example, if the cloud dish client of Windows system install rear path be d: sugon, so can be under this path newly-built database catalogue (be d: sugon database) and be set to automatic synchronization.
Alternatively, also can be after cloud dish client software to be installed, the application interface by cloud dish client arranges the desktop method of synchronization.
S103 is stored in database file under the described local data library directory.
S104 adopts the backup mode that presets that the database file automated back-up under the described local data library directory is deposited under the map network data base directory of described cloud dish.
In an optional embodiment, can be to adopt the back mechanism of database itself or the inside back mechanism of cloud dish that described database file is backed up in realtime, thereby be synchronized under the corresponding data library directory of described cloud dish.In another optional embodiment, can be to adopt the back mechanism of database itself or the inside back mechanism of cloud dish that described database file is carried out timed backup, thereby be saved under the corresponding data library directory of described cloud dish.
In embodiments of the present invention, described database file is website DBMS library file.
The embodiment of the invention is by under the local directory that database file is left in the cloud dish, then utilize the backup mode that presets the data library file is backed up in realtime or timed backup in the cloud storage networking.This synchronous cloud storage mode of desktop that utilizes can be realized the timing of this catalogue is upgraded or automatically upgraded, and can realize the transfer rate restriction to catalogue.
In an example, the website for using SQL Server Database Systems can arrange in described SQL Server Database Systems and automatically perform task.Every day automatically with the data database file backup under the local cloud storage directory under the map network data base directory of cloud dish.
In another example, for the website of using the Access Database Systems, the database file of frequent read-write should not directly be stored under the local cloud storage directory of cloud dish, but is stored in other places.Then, according to the timing updating task that pre-sets database file is regularly copied under the local data library directory of described cloud dish, thus can be with the Backup of database files under the local cloud storage directory under the map network data base directory of cloud dish.
For example, set up a BAT file, content is " xcopy " E: src_db " " d: sugon database "/s/e/y "
A newly-built plan target in " system tool-task scheduling ", select this autoexec, arrange and automatically perform morning every day, because computer system can timing automatic the database file under the src_db catalogue (even can be under the root directory of website file) is copied in the database file in the local cloud storage directory of cloud dish always.Then, computer system can be automatically with the file of website and DB Backup under the map network database of cloud dish.
The desktop synchronization mechanism based on the cloud service pattern that the embodiment of the invention adopts can realize that user's desktop differentiation is synchronous by the inside synchronization mechanism of cloud dish.The window client that the cloud dish of the embodiment of the invention is installed can realize that personal desktop's differentiation uploads, thereby all data of user's desktop all can be left among the cloud dish.The path that the user only need arrange desktop is one of them catalogue under the cloud dish.
Use the Backup of database files method of the embodiment of the invention, can realize the simple backup mode of site databases, solved the factor data amount large especially and cause stuck, thereby might cause the problem of backup failure.And owing to adopting the cloud memory technology, can need not to expend too much cost because buying the host stores space by medium-sized and small enterprises, this can reduce the maintenance cost of a lot of medium-sized and small enterprises portal website.
Fig. 2 is according to another embodiment of the present invention based on the structured flowchart of the Backup of database files system of cloud storage.As shown in Figure 2, this system comprises: cloud dish client-side management unit 10, and being used for desktop is set is automatic synchronization, and after the information of the building database catalogue that receives the application interface transmission, sets up the local data library directory under the local cloud storage directory of cloud dish; Document storage management unit 30 is used for database file is stored under the local data library directory of described cloud dish; And data synchronisation unit 50 is used for according to the backup mode that presets the database file automated back-up under the described local data library directory being deposited under the map network data base directory of described cloud dish.
In optional embodiment, data synchronisation unit 50 is deposited the database file automated back-up under the described local data library directory according to the backup mode that presets under the map network data base directory of described cloud dish, comprise: according to the back mechanism of database itself or the inside back mechanism of cloud dish described database file is backed up in realtime, thereby store under the map network data base directory of described cloud dish; Perhaps, according to the back mechanism of database itself or the inside back mechanism of cloud dish described database file is carried out timed backup, thereby store under the map network data base directory of described cloud dish.
In optional embodiment, described database file is website DBMS library file.
In an optional embodiment, described Backup of database files system also comprises data management by synchronization unit 70, is used for for the website of using SQL Server Database Systems the task that automatically performs being set, wherein, the described task that automatically performs comprises and backing up in realtime or timed backup.Data synchronisation unit 50 is used under the described triggering that automatically performs task, according to described automatically perform task with described Backup of database files under the local data library directory of described cloud dish.
In another optional embodiment, document storage management unit 30 also is used for for the website of using the Access Database Systems, and the database file of the frequent read-write of indication is not stored under the cloud storage directory of cloud dish; And, wherein, database file is stored under the local data library directory of described cloud dish and comprises: copy under the local data library directory of described cloud dish according to the database file of the timing updating task that pre-sets with described frequent read-write.
The above only is preferred embodiment of the present invention, and is in order to limit the present invention, within the spirit and principles in the present invention not all, any modification of doing, is equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. Backup of database files method based on cloud storage comprises:
For cloud dish client, desktop automatic synchronization mode is set;
Under the local cloud storage directory of cloud dish, set up the local data library directory;
Database file is stored under the local data library directory of described cloud dish;
The backup mode that employing presets is deposited the database file automated back-up under the described local data library directory under the map network data base directory of described cloud dish.
2. Backup of database files method according to claim 1 is characterized in that, adopts the backup mode that presets that the database file automated back-up under the described local data library directory is deposited under the map network data base directory of described cloud dish, comprising:
Adopt the back mechanism of database itself or the inside back mechanism of cloud dish that described database file is backed up in realtime, thereby store under the map network data base directory of described cloud dish; Perhaps,
Adopt the back mechanism of database itself or the inside back mechanism of cloud dish that described database file is carried out timed backup, thereby store under the map network data base directory of described cloud dish.
3. Backup of database files method according to claim 1 is characterized in that, described database file is website DBMS library file.
4. Backup of database files method according to claim 3 is characterized in that:
For the website of using SQL Server Database Systems, the task that automatically performs is set;
According to described automatically perform task with described Backup of database files under the local data library directory of described cloud dish, wherein, the described task that automatically performs comprises and backing up in realtime or timed backup.
5. Backup of database files method according to claim 3 is characterized in that:
For the website of using the Access Database Systems, the database file of frequent read-write is not stored under the cloud storage directory of cloud dish;
Database file is stored under the described local data library directory comprises: copy under the local data library directory of described cloud dish according to the database file of the timing updating task that pre-sets with described frequent read-write.
6. Backup of database files system based on cloud storage comprises:
Cloud dish client-side management unit is used for desktop automatic synchronization mode is set, and behind the indication information that receives the building database catalogue, sets up the local data library directory under the local cloud storage directory of cloud dish;
The document storage management unit is used for database file is stored under the local data library directory of described cloud dish;
Data synchronisation unit is used for according to the backup mode that presets the database file automated back-up under the described local data library directory being deposited under the map network data base directory of described cloud dish.
7. Backup of database files according to claim 6 system, it is characterized in that, data synchronisation unit is deposited the database file automated back-up under the described local data library directory according to the backup mode that presets under the map network data base directory of described cloud dish, comprising:
According to the back mechanism of database itself or the inside back mechanism of cloud dish described database file is backed up in realtime, thereby store under the map network data base directory of described cloud dish; Perhaps,
According to the back mechanism of database itself or the inside back mechanism of cloud dish described database file is carried out timed backup, thereby store under the map network data base directory of described cloud dish.
8. Backup of database files according to claim 6 system is characterized in that, described database file is website DBMS library file.
9. Backup of database files according to claim 8 system is characterized in that:
Described Backup of database files system also comprises data management by synchronization unit, is used for arranging and automatically performing task for the website of using SQL Server Database Systems, and wherein, the described task that automatically performs comprises and backing up in realtime or timed backup;
Described data synchronisation unit is used under the described triggering that automatically performs task, according to described automatically perform task with described Backup of database files under the local data library directory of described cloud dish.
10. Backup of database files according to claim 8 system is characterized in that:
Described document storage management unit also is used for for the website of using the Access Database Systems, and the database file of the frequent read-write of indication is not stored under the local cloud storage directory of cloud dish; And,
Wherein, database file is stored under the local data library directory of described cloud dish and comprises: copy under the local data library directory of described cloud dish according to the database file of the timing updating task that pre-sets with described frequent read-write.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201310275053XA CN103309772A (en) | 2013-07-02 | 2013-07-02 | Database file backup method and system based on cloud storage |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201310275053XA CN103309772A (en) | 2013-07-02 | 2013-07-02 | Database file backup method and system based on cloud storage |
Publications (1)
Publication Number | Publication Date |
---|---|
CN103309772A true CN103309772A (en) | 2013-09-18 |
Family
ID=49135024
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201310275053XA Pending CN103309772A (en) | 2013-07-02 | 2013-07-02 | Database file backup method and system based on cloud storage |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN103309772A (en) |
Cited By (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103761169A (en) * | 2014-01-27 | 2014-04-30 | 中国石油天然气股份有限公司 | Hot backup method and device of petroleum geology software database |
CN103761164A (en) * | 2014-01-14 | 2014-04-30 | 武汉噢易科技有限公司 | Disk protection reduction based file synchronization system and file synchronization method |
CN103780675A (en) * | 2013-12-11 | 2014-05-07 | 北京荣之联科技股份有限公司 | Cloud disc file synchronization method and apparatus |
CN103793663A (en) * | 2013-12-26 | 2014-05-14 | 北京奇虎科技有限公司 | Folder locking and unlocking methods and folder locking and unlocking devices |
CN104182302A (en) * | 2014-09-15 | 2014-12-03 | 北京国双科技有限公司 | Database backup method and device |
CN104580093A (en) * | 2013-10-21 | 2015-04-29 | 腾讯科技(深圳)有限公司 | Processing method, device and system for notification messages of websites |
WO2017016481A1 (en) * | 2015-07-28 | 2017-02-02 | Huawei Technologies Co., Ltd. | Apparatus and method for utilizing different data storage types to store primary and replicated database directories |
CN106648980A (en) * | 2016-12-12 | 2017-05-10 | 北京雷石天地电子技术有限公司 | Backup and recovery method and backup and recovery device for high-availability server databases in offline places |
CN107562579A (en) * | 2017-10-20 | 2018-01-09 | 郑州云海信息技术有限公司 | A kind of method and device of automatically backup data storehouse data |
CN108667809A (en) * | 2018-04-13 | 2018-10-16 | 三维通信股份有限公司 | A kind of implementation method of multisystem DAS WEB interfaces account information management by synchronization |
CN109491600A (en) * | 2018-10-29 | 2019-03-19 | 杭州电子科技大学 | Portable memory apparatus control method based on cloud storage |
CN112860493A (en) * | 2021-02-03 | 2021-05-28 | 广东中兴新支点技术有限公司 | Linux virtual machine cloud packing partition chain-breaking protection method, system and medium |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102316131A (en) * | 2010-07-02 | 2012-01-11 | 戴元顺 | Intelligent backing up of cloud platform system |
US20120059940A1 (en) * | 2010-09-02 | 2012-03-08 | Hon Hai Precision Industry Co., Ltd. | Terminal device and data synchronization method |
-
2013
- 2013-07-02 CN CN201310275053XA patent/CN103309772A/en active Pending
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102316131A (en) * | 2010-07-02 | 2012-01-11 | 戴元顺 | Intelligent backing up of cloud platform system |
US20120059940A1 (en) * | 2010-09-02 | 2012-03-08 | Hon Hai Precision Industry Co., Ltd. | Terminal device and data synchronization method |
CN102387167A (en) * | 2010-09-02 | 2012-03-21 | 国基电子(上海)有限公司 | Terminal equipment and data synchronization method thereof |
Non-Patent Citations (2)
Title |
---|
一啸倾城: "今天你同步了吗? 个人数据同步方案", 《电脑迷》, 15 April 2011 (2011-04-15) * |
浛博: "惊奇! 网盘竟能这样用", 《电脑爱好者》, no. 16, 15 August 2012 (2012-08-15) * |
Cited By (20)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104580093A (en) * | 2013-10-21 | 2015-04-29 | 腾讯科技(深圳)有限公司 | Processing method, device and system for notification messages of websites |
CN103780675B (en) * | 2013-12-11 | 2017-03-15 | 北京荣之联科技股份有限公司 | A kind of cloud disc file synchronous method and device |
CN103780675A (en) * | 2013-12-11 | 2014-05-07 | 北京荣之联科技股份有限公司 | Cloud disc file synchronization method and apparatus |
CN103793663A (en) * | 2013-12-26 | 2014-05-14 | 北京奇虎科技有限公司 | Folder locking and unlocking methods and folder locking and unlocking devices |
CN103761164A (en) * | 2014-01-14 | 2014-04-30 | 武汉噢易科技有限公司 | Disk protection reduction based file synchronization system and file synchronization method |
CN103761164B (en) * | 2014-01-14 | 2017-06-30 | 武汉噢易云计算股份有限公司 | File syn chronizing system and method based on disk protection reduction |
CN103761169B (en) * | 2014-01-27 | 2017-09-01 | 中国石油天然气股份有限公司 | The heat backup method and device of petroleum geology software database |
CN103761169A (en) * | 2014-01-27 | 2014-04-30 | 中国石油天然气股份有限公司 | Hot backup method and device of petroleum geology software database |
CN104182302A (en) * | 2014-09-15 | 2014-12-03 | 北京国双科技有限公司 | Database backup method and device |
US11030045B2 (en) | 2015-07-28 | 2021-06-08 | Futurewei Technologies, Inc. | Apparatus and method for utilizing different data storage types to store primary and replicated database directories |
CN107851127A (en) * | 2015-07-28 | 2018-03-27 | 华为技术有限公司 | Primary and replicate data library directory apparatus and method are stored using different pieces of information type of memory |
WO2017016481A1 (en) * | 2015-07-28 | 2017-02-02 | Huawei Technologies Co., Ltd. | Apparatus and method for utilizing different data storage types to store primary and replicated database directories |
CN106648980A (en) * | 2016-12-12 | 2017-05-10 | 北京雷石天地电子技术有限公司 | Backup and recovery method and backup and recovery device for high-availability server databases in offline places |
CN107562579A (en) * | 2017-10-20 | 2018-01-09 | 郑州云海信息技术有限公司 | A kind of method and device of automatically backup data storehouse data |
CN108667809A (en) * | 2018-04-13 | 2018-10-16 | 三维通信股份有限公司 | A kind of implementation method of multisystem DAS WEB interfaces account information management by synchronization |
US11265333B2 (en) | 2018-04-13 | 2022-03-01 | Sunwave Communications Co., Ltd. | Method of achieving synchronization management of account information of WEB interface in multi-system DAS |
CN109491600A (en) * | 2018-10-29 | 2019-03-19 | 杭州电子科技大学 | Portable memory apparatus control method based on cloud storage |
CN109491600B (en) * | 2018-10-29 | 2022-03-01 | 杭州电子科技大学 | Portable storage device control method based on cloud storage |
CN112860493A (en) * | 2021-02-03 | 2021-05-28 | 广东中兴新支点技术有限公司 | Linux virtual machine cloud packing partition chain-breaking protection method, system and medium |
CN112860493B (en) * | 2021-02-03 | 2022-09-27 | 广东中兴新支点技术有限公司 | Linux virtual machine cloud packing partition chain-breaking protection method, system and medium |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN103309772A (en) | Database file backup method and system based on cloud storage | |
RU2433457C2 (en) | Efficient creation of complete private backup copies for applications | |
US11080148B2 (en) | Method and system for star replication using multiple replication technologies | |
CN106354583B (en) | A kind of heat backup method and system of MySQL database | |
US9588858B2 (en) | Periodic data replication | |
CN105843702B (en) | A kind of method and device for data backup | |
CN103605585B (en) | Intelligent backup method based on data discovery | |
CN104239166A (en) | Method for realizing file backup for running virtual machine | |
CN104252485A (en) | Database management platform | |
CN101719165A (en) | Method for realizing high-efficiency rapid backup of database | |
US10983872B2 (en) | Systems and methods for data synchronization | |
CN103064927A (en) | Data access method and device of distributed file system | |
CN102821111A (en) | Real-time synchronizing method for file cloud storage | |
CN103167026A (en) | Processing method, system and device for cloud storage environmental data | |
US9830228B1 (en) | Intelligent backup model for snapshots | |
CN102981933A (en) | Method and system for data increment backup of sensing layer of Internet of Things | |
WO2012101674A1 (en) | Computer system and data de-duplication method | |
CN104462389A (en) | Method for implementing distributed file systems on basis of hierarchical storage | |
CN103902410A (en) | Data backup acceleration method for cloud storage system | |
US20150006485A1 (en) | High Scalability Data Management Techniques for Representing, Editing, and Accessing Data | |
CN104252397A (en) | Realizing method for supporting automatic backup of cloud platform user file | |
CN102495774A (en) | Method and system for realizing system recovery of computer | |
CN104021200A (en) | Data synchronizing method and device of database | |
CN105589887A (en) | Data processing method for distributed file system and distributed file system | |
CN105306581A (en) | Router and cloud disk based data synchronization method |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C12 | Rejection of a patent application after its publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20130918 |