CN103309772A - Database file backup method and system based on cloud storage - Google Patents

Database file backup method and system based on cloud storage Download PDF

Info

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
Application number
CN201310275053XA
Other languages
Chinese (zh)
Inventor
陈飞
何牧君
曹振南
王勇
刘冠川
张新凤
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Dawning Information Industry Beijing Co Ltd
Original Assignee
Dawning Information Industry Beijing Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Dawning Information Industry Beijing Co Ltd filed Critical Dawning Information Industry Beijing Co Ltd
Priority to CN201310275053XA priority Critical patent/CN103309772A/en
Publication of CN103309772A publication Critical patent/CN103309772A/en
Pending legal-status Critical Current

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

A kind of Backup of database files method and standby system based on the cloud storage
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.
CN201310275053XA 2013-07-02 2013-07-02 Database file backup method and system based on cloud storage Pending CN103309772A (en)

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)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
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

Patent Citations (3)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
Title
一啸倾城: "今天你同步了吗? 个人数据同步方案", 《电脑迷》, 15 April 2011 (2011-04-15) *
浛博: "惊奇! 网盘竟能这样用", 《电脑爱好者》, no. 16, 15 August 2012 (2012-08-15) *

Cited By (20)

* Cited by examiner, † Cited by third party
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