CN105204960A - Method for regularly and remotely duplicating database by utilizing linux time pool - Google Patents
Method for regularly and remotely duplicating database by utilizing linux time pool Download PDFInfo
- Publication number
- CN105204960A CN105204960A CN201510596199.3A CN201510596199A CN105204960A CN 105204960 A CN105204960 A CN 105204960A CN 201510596199 A CN201510596199 A CN 201510596199A CN 105204960 A CN105204960 A CN 105204960A
- Authority
- CN
- China
- Prior art keywords
- backup
- database
- file
- linux
- backup file
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method for regularly and remotely duplicating a database by utilizing a linux time pool, and belongs to the technical field of the management of a database. The method comprises the steps: creating a timing task by utilizing a linux system time pool, executing a script file of a backup database, generating a database backup file, and transmitting the backup file to a remote server by virtue of a remote transmission protocol. By adopting the method, the cost is low, the timed remote backup of the database can be realized, the fault safety of an application program can be guaranteed, and a relatively high disaster restoration capacity grade can be achieved.
Description
Technical field
The present invention discloses a kind of method of remote backup database, belongs to database management technology field, specifically a kind of method utilizing linux time pond timing remote backup database.
Background technology
Data backup is the basis of disaster tolerance, refers to as anti-locking system occurs that misoperation or the system failure cause loss of data, and all or part of data acquisition is copied to the process of other storage medium from the hard disk of applied host machine or array.Traditional data backup mainly adopts internal or external magnetic tape station to carry out cold standby.But this mode can only prevent the man-made faults such as misoperation, and its release time is also very long.Along with the development of technology, the magnanimity of data increases, and many enterprises start to adopt network backup.Network backup is generally realized in conjunction with corresponding hardware and memory device by the data storage management software of specialty.The backup of database is a long-term process, and recovers only to carry out after having an accident, and recover the inverse process that can be regarded as backup, the quality of the degree of recovery depends on the situation quality of backup to a great extent.Existing backup method is effective for reaching backup, disaster recovery capability grade degree is high, often need to drop into a large amount of man power and material to realize, and the invention provides a kind of method utilizing linux time pond timing remote backup database, the time pond utilizing Linux system to carry, perform timed backup script, generate the backup data files of database, and use the method regularly to be backed up by database, and backup file can be transferred on the server in multiple stage this locality or strange land, when home server or several backup servers break down, also the recovery of data can be ensured timely and effectively.Not only cost drops into little, and achieves the timing remote backup of database, has ensured the fail safe of application program, can reach relatively high disaster recovery capability grade.
Summary of the invention
The present invention is directed to as reaching backup effective, existing strange land database backup method needs the problem dropping into a large amount of man power and material to realize, a kind of method utilizing linux time pond timing remote backup database is provided, cost drops into little, and achieve the timing remote backup of database, ensure the fail safe of application program, relatively high disaster recovery capability grade can have been reached.
The concrete scheme that the present invention proposes is:
A kind of method utilizing linux time pond timing remote backup database, utilize Linux system time pond, create timed task, perform the script file of backup database, generate database backup file, by remote transfer protocol, backup file is transferred on the server of strange land.Oracle, mysql etc. are the script file of database.
The setting in described Linux system time pond, by utilizing order crontab-e, adding timing fill order, arranging which sky that execution cycle time section comprises the number of minutes, hourage, a middle of the month.
Described generation database backup file, is transferred to backup file on the server of strange land by nfs or ssh remote transfer protocol.
When backup file be transferred in the server process of strange land occur data-transmission interruptions or transmission information imperfect time, check field is set backup file information integrity is verified, more again upload this backup file.
Utilize a system for linux time pond timing remote backup database, comprise timer module, backup module, transport module;
Timer module is responsible for utilizing Linux system time pond, creates timed task, reaches the timing function of DB Backup;
Backup module is responsible for the script file performing backup database, generates database backup file;
Transport module is responsible for being transferred on the server of strange land by backup file by remote transfer protocol.
Described timer module, by utilizing order crontab-e, adding timing fill order, arranging which sky that execution cycle time section comprises the number of minutes, hourage, a middle of the month.
Backup file is transferred on the server of strange land by nfs or ssh remote transfer protocol by described transport module.
Described system also comprises correction verification module, be responsible for when backup file be transferred in the server process of strange land occur data-transmission interruptions or transmission information imperfect time, arrange check field to verify backup file information integrity, then call transport module and again upload this backup file.
Usefulness of the present invention is: the present invention utilizes Linux system time pond, create timed task, perform the script file of backup database, generate database backup file, be transferred on the server of strange land by remote transfer protocol by backup file, cost drops into little, and achieves the timing remote backup of database, ensure the fail safe of application program, relatively high disaster recovery capability grade can have been reached.And when home server or several backup servers break down, the recovery of data also can be ensured timely and effectively.
Accompanying drawing explanation
Fig. 1 long-distance data backup schematic flow sheet of the present invention;
Fig. 2 strange land of the present invention data network environment schematic diagram.
Embodiment
A kind of method utilizing linux time pond timing remote backup database, utilize Linux system time pond, create timed task, perform the script file of backup database, generate database backup file, by remote transfer protocol, backup file is transferred on the server of strange land.
Utilize a system for linux time pond timing remote backup database, comprise timer module, backup module, transport module;
Timer module is responsible for utilizing Linux system time pond, creates timed task, reaches the timing function of DB Backup;
Backup module is responsible for the script file performing backup database, generates database backup file;
Transport module is responsible for being transferred on the server of strange land by backup file by remote transfer protocol.
Utilize said method and system, the present invention will be further described by reference to the accompanying drawings.
For database mysql file:
Utilize Linux system time pond, create timed task, utilize order crontab-e, interpolation timing fill order is as follows:
11***/root/mysql_dump/mysql_back.sh。
The execution cycle time section of crontab, wherein first is the number of minutes, and second is hourage, and the 3rd is which sky in a middle of the month.All can dispatch every day if * just represents.
Perform the script file of backup database, generate database backup file, under/root/mysql_dump/ catalogue, create mysql_back.sh, realize the DB Backup function of mysql, and be that title produces backup file with time.
Generate database backup file, by nfs or ssh remote transfer protocol, backup file is transferred on the server of multiple stage strange land.
When backup file be transferred in the server process of strange land occur data-transmission interruptions or transmission information imperfect time, check field is set backup file information integrity is verified, more again upload this backup file.
Wherein correspondingly a kind ofly utilize in the system of linux time pond timing remote backup database,
Timer module:
Utilize the time pond under Linux system, utilize order crontab-e, add timing fill order following (herein for mysql): 11***/root/mysql_dump/mysql_back.sh.
The execution cycle time section of crontab, wherein first is the number of minutes, and second is hourage, and the 3rd is which sky in a middle of the month.All can dispatch every day if * just represents.
Create timing script execution command wherein, reach the timing function of DB Backup.
Backup module:
Under/root/mysql_dump/ catalogue, create mysql_back.sh, realize the DB Backup function of mysql, and be that title produces backup file with time.
Transport module:
By nfs or ssh agreement, realization is interconnected with remote backup server, is transferred on the multiple stage remote backup server of specifying by the backup file that backup module produces.
System also can comprise correction verification module, be responsible for when backup file be transferred in the server process of strange land occur data-transmission interruptions or transmission information imperfect time, arrange check field to verify backup file information integrity, then call transport module and again upload this backup file.
Claims (8)
1. one kind utilizes the method for linux time pond timing remote backup database, it is characterized in that utilizing Linux system time pond, create timed task, perform the script file of backup database, generate database backup file, by remote transfer protocol, backup file is transferred on the server of strange land.
2. a kind of method utilizing linux time pond timing remote backup database according to claim 1, it is characterized in that the setting in described Linux system time pond, by utilizing order crontab-e, add timing fill order, which sky that execution cycle time section comprises the number of minutes, hourage, a middle of the month is set.
3. a kind of method utilizing linux time pond timing remote backup database according to claim 1 and 2, be is characterized in that described generation database backup file, is transferred on the server of strange land by backup file by nfs or ssh remote transfer protocol.
4. a kind of method utilizing linux time pond timing remote backup database according to claim 3, it is characterized in that when backup file be transferred in the server process of strange land occur data-transmission interruptions or transmission information imperfect time, arrange check field to verify backup file information integrity, more again upload this backup file.
5. utilize a system for linux time pond timing remote backup database, it is characterized in that comprising timer module, backup module, transport module;
Timer module is responsible for utilizing Linux system time pond, creates timed task, reaches the timing function of DB Backup;
Backup module is responsible for the script file performing backup database, generates database backup file;
Transport module is responsible for being transferred on the server of strange land by backup file by remote transfer protocol.
6. a kind of system utilizing linux time pond timing remote backup database according to claim 5, it is characterized in that described timer module, by utilizing order crontab-e, add timing fill order, which sky that execution cycle time section comprises the number of minutes, hourage, a middle of the month is set.
7. a kind of system utilizing linux time pond timing remote backup database according to claim 6, is characterized in that backup file is transferred on the server of strange land by nfs or ssh remote transfer protocol by described transport module.
8. a kind of system utilizing linux time pond timing remote backup database according to claim 5 or 7, it is characterized in that described system also comprises correction verification module, be responsible for when backup file be transferred in the server process of strange land occur data-transmission interruptions or transmission information imperfect time, arrange check field to verify backup file information integrity, then call transport module and again upload this backup file.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510596199.3A CN105204960A (en) | 2015-09-18 | 2015-09-18 | Method for regularly and remotely duplicating database by utilizing linux time pool |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510596199.3A CN105204960A (en) | 2015-09-18 | 2015-09-18 | Method for regularly and remotely duplicating database by utilizing linux time pool |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105204960A true CN105204960A (en) | 2015-12-30 |
Family
ID=54952655
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510596199.3A Pending CN105204960A (en) | 2015-09-18 | 2015-09-18 | Method for regularly and remotely duplicating database by utilizing linux time pool |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105204960A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106844093A (en) * | 2016-12-14 | 2017-06-13 | 国网北京市电力公司 | The method and device of Backup Data |
| CN108090345A (en) * | 2016-11-21 | 2018-05-29 | 腾讯科技（深圳）有限公司 | Linux system external command performs method and device |
| CN108829545A (en) * | 2018-07-02 | 2018-11-16 | 山东汇贸电子口岸有限公司 | A method of realizing distributed data library backup |
| CN112596958A (en) * | 2020-12-30 | 2021-04-02 | 浪潮电子信息产业股份有限公司 | Database backup method, device, equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101667147A (en) * | 2009-07-27 | 2010-03-10 | 浪潮电子信息产业股份有限公司 | Multitasking controllable automatic snapshot method |
| CN102111301A (en) * | 2011-03-28 | 2011-06-29 | 上海云高软件科技有限公司 | General file transmission system and implementation method thereof |
| EP2434401A1 (en) * | 2009-06-30 | 2012-03-28 | ZTE Corporation | Method and system for managing thread pool |
| CN102622426A (en) * | 2012-02-27 | 2012-08-01 | 杭州闪亮科技有限公司 | Database writing system and database writing method |
-
2015
- 2015-09-18 CN CN201510596199.3A patent/CN105204960A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP2434401A1 (en) * | 2009-06-30 | 2012-03-28 | ZTE Corporation | Method and system for managing thread pool |
| CN101667147A (en) * | 2009-07-27 | 2010-03-10 | 浪潮电子信息产业股份有限公司 | Multitasking controllable automatic snapshot method |
| CN102111301A (en) * | 2011-03-28 | 2011-06-29 | 上海云高软件科技有限公司 | General file transmission system and implementation method thereof |
| CN102622426A (en) * | 2012-02-27 | 2012-08-01 | 杭州闪亮科技有限公司 | Database writing system and database writing method |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108090345A (en) * | 2016-11-21 | 2018-05-29 | 腾讯科技（深圳）有限公司 | Linux system external command performs method and device |
| CN108090345B (en) * | 2016-11-21 | 2021-08-17 | 腾讯科技（深圳）有限公司 | Linux system external command execution method and device |
| CN106844093A (en) * | 2016-12-14 | 2017-06-13 | 国网北京市电力公司 | The method and device of Backup Data |
| CN108829545A (en) * | 2018-07-02 | 2018-11-16 | 山东汇贸电子口岸有限公司 | A method of realizing distributed data library backup |
| CN108829545B (en) * | 2018-07-02 | 2021-08-10 | 上海浪潮云计算服务有限公司 | Method for realizing distributed database backup |
| CN112596958A (en) * | 2020-12-30 | 2021-04-02 | 浪潮电子信息产业股份有限公司 | Database backup method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108255641B (en) | CDP disaster recovery method based on cloud platform | |
| CN105204960A (en) | Method for regularly and remotely duplicating database by utilizing linux time pool | |
| CN102306114B (en) | Regular data backup and recovery method based on cloud storage | |
| CN102521083B (en) | Backup method and system of virtual machine in cloud computing system | |
| US9588858B2 (en) | Periodic data replication | |
| CN105955836B (en) | A kind of automatic rehearsal multifunction system of cold and hot backup | |
| CN101833486A (en) | Method for designing remote backup and recovery system | |
| CN104063447A (en) | Monitoring video file restoring method | |
| CN103051681B (en) | Collaborative type log system facing to distribution-type file system | |
| CN103488546A (en) | Backup and recovery method capable of supporting online concurrency of multi-level data and database | |
| CN105487940A (en) | Disaster recovery side, production side and data recovery method between disaster recovery side and production side | |
| CN103327085A (en) | Distributed data processing method, data center and distributed data system | |
| CN104572355A (en) | Asynchronous remote data copying method and device | |
| CN105376329A (en) | Remote online backup method for virtual machine | |
| WO2024103594A1 (en) | Container disaster recovery method, system, apparatus and device, and computer-readable storage medium | |
| CN108804248B (en) | Automatic verification method for real-time protection data of volume | |
| CN112948484A (en) | Distributed database system and data disaster recovery drilling method | |
| CN109101842B (en) | Safe cloud backup system and method | |
| CN104850628A (en) | Data synchronization method and apparatus in database | |
| CN103853827A (en) | Database backup method capable of guaranteeing data consistency | |
| CN104636082A (en) | Disk array RAID control method and device | |
| CN103929455A (en) | Asynchronous file transmission system and method comprising network storage equipment | |
| CN105446830A (en) | Data backup method based on NDMP (Network Data Management Protocol) disk-to-disk replication technology | |
| CN107066355A (en) | The backup server system and its building method of a kind of High Availabitity | |
| CN116560908B (en) | Data recovery method of industrial control system and related equipment thereof |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20151230 |
|
| RJ01 | Rejection of invention patent application after publication |