CN106354583A - Hot backup method and system for MySQL database - Google Patents
Hot backup method and system for MySQL database Download PDFInfo
- Publication number
- CN106354583A CN106354583A CN201610764307.8A CN201610764307A CN106354583A CN 106354583 A CN106354583 A CN 106354583A CN 201610764307 A CN201610764307 A CN 201610764307A CN 106354583 A CN106354583 A CN 106354583A
- Authority
- CN
- China
- Prior art keywords
- backup
- data base
- data
- mysql
- log
- 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.)
- Granted
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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (10)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610764307.8A CN106354583B (en) | 2016-08-30 | 2016-08-30 | A kind of heat backup method and system of MySQL database |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610764307.8A CN106354583B (en) | 2016-08-30 | 2016-08-30 | A kind of heat backup method and system of MySQL database |
Publications (2)
Publication Number | Publication Date |
---|---|
CN106354583A true CN106354583A (en) | 2017-01-25 |
CN106354583B CN106354583B (en) | 2019-09-17 |
Family
ID=57855981
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201610764307.8A Active CN106354583B (en) | 2016-08-30 | 2016-08-30 | A kind of heat backup method and system of MySQL database |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN106354583B (en) |
Cited By (13)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN108599982A (en) * | 2018-03-14 | 2018-09-28 | 华为技术有限公司 | Data reconstruction method and relevant device |
CN108874592A (en) * | 2018-06-20 | 2018-11-23 | 焦点科技股份有限公司 | A kind of data cold standby method and system for Log-structured storage engines |
CN108958972A (en) * | 2018-06-25 | 2018-12-07 | 郑州云海信息技术有限公司 | A kind of method of mysql DB Backup |
CN109144790A (en) * | 2018-09-30 | 2019-01-04 | 广州鼎甲计算机科技有限公司 | The synthesized backup method and device of MySQL database |
CN109241185A (en) * | 2018-08-27 | 2019-01-18 | 武汉达梦数据库有限公司 | A kind of method and data synchronization unit that data are synchronous |
CN109542682A (en) * | 2018-11-16 | 2019-03-29 | 上海达梦数据库有限公司 | A kind of data back up method, device, equipment and storage medium |
CN109947592A (en) * | 2017-12-20 | 2019-06-28 | 腾讯科技(深圳)有限公司 | A kind of method of data synchronization, device and relevant device |
CN110209527A (en) * | 2018-11-30 | 2019-09-06 | 腾讯科技(深圳)有限公司 | Data reconstruction method, device, server and storage medium |
CN111158958A (en) * | 2019-12-31 | 2020-05-15 | 广州鼎甲计算机科技有限公司 | Backup method, system, device and storage medium capable of quickly recovering data |
CN111240897A (en) * | 2020-01-07 | 2020-06-05 | 腾讯科技(深圳)有限公司 | Data processing method and related equipment |
CN111382012A (en) * | 2020-03-03 | 2020-07-07 | 广州鼎甲计算机科技有限公司 | Backup method and device for MySQL cloud database, computer equipment and storage medium |
CN111625397A (en) * | 2020-04-14 | 2020-09-04 | 北京捷通华声科技股份有限公司 | Service log backup method, cluster, device, electronic equipment and storage medium |
CN113434339A (en) * | 2021-06-29 | 2021-09-24 | 湖南方心科技股份有限公司 | Data encryption transmission system and method based on combined cycle backup for intelligent computing center |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102156720A (en) * | 2011-03-28 | 2011-08-17 | 中国人民解放军国防科学技术大学 | Method, device and system for restoring data |
US20140258223A1 (en) * | 2013-03-08 | 2014-09-11 | Oracle International Corporation | Adaptive high-performance database redo log synchronization |
-
2016
- 2016-08-30 CN CN201610764307.8A patent/CN106354583B/en active Active
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102156720A (en) * | 2011-03-28 | 2011-08-17 | 中国人民解放军国防科学技术大学 | Method, device and system for restoring data |
US20140258223A1 (en) * | 2013-03-08 | 2014-09-11 | Oracle International Corporation | Adaptive high-performance database redo log synchronization |
Non-Patent Citations (1)
Title |
---|
易剑等: "Oracle数据库备份策略研讨", 《科技广场》 * |
Cited By (21)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109947592A (en) * | 2017-12-20 | 2019-06-28 | 腾讯科技(深圳)有限公司 | A kind of method of data synchronization, device and relevant device |
CN109947592B (en) * | 2017-12-20 | 2022-11-18 | 腾讯科技(深圳)有限公司 | Data synchronization method, device and related equipment |
CN108599982B (en) * | 2018-03-14 | 2021-02-12 | 华为技术有限公司 | Data recovery method and related equipment |
CN108599982A (en) * | 2018-03-14 | 2018-09-28 | 华为技术有限公司 | Data reconstruction method and relevant device |
CN108874592A (en) * | 2018-06-20 | 2018-11-23 | 焦点科技股份有限公司 | A kind of data cold standby method and system for Log-structured storage engines |
CN108874592B (en) * | 2018-06-20 | 2020-04-10 | 焦点科技股份有限公司 | Data cold standby method and system for Log-structured storage engine |
CN108958972A (en) * | 2018-06-25 | 2018-12-07 | 郑州云海信息技术有限公司 | A kind of method of mysql DB Backup |
CN109241185A (en) * | 2018-08-27 | 2019-01-18 | 武汉达梦数据库有限公司 | A kind of method and data synchronization unit that data are synchronous |
CN109241185B (en) * | 2018-08-27 | 2021-03-30 | 武汉达梦数据库股份有限公司 | Data synchronization method and data synchronization device |
CN109144790A (en) * | 2018-09-30 | 2019-01-04 | 广州鼎甲计算机科技有限公司 | The synthesized backup method and device of MySQL database |
CN109542682A (en) * | 2018-11-16 | 2019-03-29 | 上海达梦数据库有限公司 | A kind of data back up method, device, equipment and storage medium |
CN109542682B (en) * | 2018-11-16 | 2021-03-30 | 上海达梦数据库有限公司 | Data backup method, device, equipment and storage medium |
CN110209527A (en) * | 2018-11-30 | 2019-09-06 | 腾讯科技(深圳)有限公司 | Data reconstruction method, device, server and storage medium |
CN111158958A (en) * | 2019-12-31 | 2020-05-15 | 广州鼎甲计算机科技有限公司 | Backup method, system, device and storage medium capable of quickly recovering data |
CN111240897A (en) * | 2020-01-07 | 2020-06-05 | 腾讯科技(深圳)有限公司 | Data processing method and related equipment |
CN111240897B (en) * | 2020-01-07 | 2023-04-14 | 腾讯科技(深圳)有限公司 | Data processing method and related equipment |
CN111382012A (en) * | 2020-03-03 | 2020-07-07 | 广州鼎甲计算机科技有限公司 | Backup method and device for MySQL cloud database, computer equipment and storage medium |
CN111382012B (en) * | 2020-03-03 | 2020-12-29 | 广州鼎甲计算机科技有限公司 | Backup method and device for MySQL cloud database, computer equipment and storage medium |
CN111625397A (en) * | 2020-04-14 | 2020-09-04 | 北京捷通华声科技股份有限公司 | Service log backup method, cluster, device, electronic equipment and storage medium |
CN111625397B (en) * | 2020-04-14 | 2023-09-12 | 北京捷通华声科技股份有限公司 | Service log backup method, cluster, device, electronic equipment and storage medium |
CN113434339A (en) * | 2021-06-29 | 2021-09-24 | 湖南方心科技股份有限公司 | Data encryption transmission system and method based on combined cycle backup for intelligent computing center |
Also Published As
Publication number | Publication date |
---|---|
CN106354583B (en) | 2019-09-17 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN106354583A (en) | Hot backup method and system for MySQL database | |
CN110532247B (en) | Data migration method and data migration system | |
CN101582920B (en) | Method and device for verifying and synchronizing data blocks in distributed file system | |
CN106445738B (en) | Database backup method and device | |
CN103530290B (en) | Data migration method and system between database | |
US8527459B2 (en) | System and method for data replication between heterogeneous databases | |
CN102024016B (en) | Rapid data restoration method for distributed file system (DFS) | |
CN104281533B (en) | A kind of method and device of data storage | |
CN105446825B (en) | Database testing method and device | |
CN105701190A (en) | Data synchronizing method and device | |
CN105824846B (en) | Data migration method and device | |
CN105989059A (en) | Data record checking method and device | |
CN105573859A (en) | Data recovery method and device of database | |
CN103198122B (en) | Restart the method and apparatus of memory database | |
CN106802895A (en) | For repair data storehouse for database data method and apparatus | |
CN102521114A (en) | File system log storage system under virtualization environment | |
CN105376277A (en) | Data synchronization method and device | |
CN103605657A (en) | Method and device for reconstructing index online | |
CN105955845A (en) | Data recovery method and device | |
CN102200944A (en) | Test environment cloning method and system for enterprise resource planning (ERP) system | |
CN107391544A (en) | Processing method, device, equipment and the computer storage media of column data storage | |
CN104199963A (en) | Method and device for HBase data backup and recovery | |
CN102226892B (en) | Disk fault tolerance processing method and device thereof | |
CN103984309A (en) | Cigarette production system with disaster tolerance function and disaster tolerance exercise method thereof | |
CN104636218B (en) | Data reconstruction method and device |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
CP02 | Change in the address of a patent holder | ||
CP02 | Change in the address of a patent holder |
Address after: Room 901, 243 Science Avenue, Guangzhou High-tech Industrial Development Zone, Guangdong 510000 Patentee after: Guangzhou Dingjia Computer Technology Co.,Ltd. Address before: 510660 Unit 701-9, Comprehensive Building of Science and Technology Innovation Base, 80 Lanyue Road, Science City, Guangzhou High-tech Industrial Development Zone, Guangdong Province Patentee before: Guangzhou Dingjia Computer Technology Co.,Ltd. |
|
PE01 | Entry into force of the registration of the contract for pledge of patent right | ||
PE01 | Entry into force of the registration of the contract for pledge of patent right |
Denomination of invention: Hot backup method and system for MySQL database Effective date of registration: 20200204 Granted publication date: 20190917 Pledgee: Guangzhou Rural Commercial Bank Co.,Ltd. Huaxia Branch Pledgor: Guangzhou Dingjia Computer Technology Co.,Ltd. Registration number: Y2020440000023 |
|
PC01 | Cancellation of the registration of the contract for pledge of patent right | ||
PC01 | Cancellation of the registration of the contract for pledge of patent right |
Date of cancellation: 20230703 Granted publication date: 20190917 Pledgee: Guangzhou Rural Commercial Bank Co.,Ltd. Huaxia Branch Pledgor: Guangzhou Dingjia Computer Technology Co.,Ltd. Registration number: Y2020440000023 |