CN106354583B - 一种MySQL数据库的热备份方法与*** - Google Patents
一种MySQL数据库的热备份方法与*** Download PDFInfo
- Publication number
- CN106354583B CN106354583B CN201610764307.8A CN201610764307A CN106354583B CN 106354583 B CN106354583 B CN 106354583B CN 201610764307 A CN201610764307 A CN 201610764307A CN 106354583 B CN106354583 B CN 106354583B
- Authority
- CN
- China
- Prior art keywords
- backup
- log
- mysql database
- data
- serial number
- 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.)
- Active
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 (3)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610764307.8A CN106354583B (zh) | 2016-08-30 | 2016-08-30 | 一种MySQL数据库的热备份方法与*** |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610764307.8A CN106354583B (zh) | 2016-08-30 | 2016-08-30 | 一种MySQL数据库的热备份方法与*** |
Publications (2)
Publication Number | Publication Date |
---|---|
CN106354583A CN106354583A (zh) | 2017-01-25 |
CN106354583B true CN106354583B (zh) | 2019-09-17 |
Family
ID=57855981
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201610764307.8A Active CN106354583B (zh) | 2016-08-30 | 2016-08-30 | 一种MySQL数据库的热备份方法与*** |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN106354583B (zh) |
Families Citing this family (13)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109947592B (zh) * | 2017-12-20 | 2022-11-18 | 腾讯科技(深圳)有限公司 | 一种数据同步方法、装置以及相关设备 |
CN108599982B (zh) * | 2018-03-14 | 2021-02-12 | 华为技术有限公司 | 数据恢复方法及相关设备 |
CN108874592B (zh) * | 2018-06-20 | 2020-04-10 | 焦点科技股份有限公司 | 一种针对Log-structured存储引擎的数据冷备方法及*** |
CN108958972A (zh) * | 2018-06-25 | 2018-12-07 | 郑州云海信息技术有限公司 | 一种mysql数据库备份的方法 |
CN109241185B (zh) * | 2018-08-27 | 2021-03-30 | 武汉达梦数据库股份有限公司 | 一种数据同步的方法以及数据同步装置 |
CN109144790A (zh) * | 2018-09-30 | 2019-01-04 | 广州鼎甲计算机科技有限公司 | MySQL数据库的合成备份方法和装置 |
CN109542682B (zh) * | 2018-11-16 | 2021-03-30 | 上海达梦数据库有限公司 | 一种数据备份方法、装置、设备和存储介质 |
CN110209527B (zh) * | 2018-11-30 | 2023-05-05 | 腾讯科技(深圳)有限公司 | 数据恢复方法、装置、服务器以及存储介质 |
CN111158958B (zh) * | 2019-12-31 | 2020-11-13 | 广州鼎甲计算机科技有限公司 | 一种可快速恢复数据的备份方法、***、装置及存储介质 |
CN111240897B (zh) * | 2020-01-07 | 2023-04-14 | 腾讯科技(深圳)有限公司 | 一种数据处理方法及相关设备 |
CN111382012B (zh) * | 2020-03-03 | 2020-12-29 | 广州鼎甲计算机科技有限公司 | MySQL云数据库的备份方法、装置、计算机设备和存储介质 |
CN111625397B (zh) * | 2020-04-14 | 2023-09-12 | 北京捷通华声科技股份有限公司 | 业务日志备份方法、集群、装置、电子设备及存储介质 |
CN113434339B (zh) * | 2021-06-29 | 2023-07-18 | 方心科技股份有限公司 | 一种智能计算中心基于组合循环备份的数据加密传输***与方法 |
Citations (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102156720A (zh) * | 2011-03-28 | 2011-08-17 | 中国人民解放军国防科学技术大学 | 一种数据恢复的方法、装置和*** |
Family Cites Families (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US9418129B2 (en) * | 2013-03-08 | 2016-08-16 | Oracle International Corporation | Adaptive high-performance database redo log synchronization |
-
2016
- 2016-08-30 CN CN201610764307.8A patent/CN106354583B/zh active Active
Patent Citations (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102156720A (zh) * | 2011-03-28 | 2011-08-17 | 中国人民解放军国防科学技术大学 | 一种数据恢复的方法、装置和*** |
Non-Patent Citations (1)
Title |
---|
Oracle数据库备份策略研讨;易剑等;《科技广场》;20090331(第3期);第61页 |
Also Published As
Publication number | Publication date |
---|---|
CN106354583A (zh) | 2017-01-25 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN106354583B (zh) | 一种MySQL数据库的热备份方法与*** | |
CN110532247B (zh) | 数据迁移方法和数据迁移*** | |
CN106445738B (zh) | 一种数据库备份方法及装置 | |
CN103488544B (zh) | 检测慢盘的处理方法和装置 | |
US20120246116A1 (en) | System and method for data replication between heterogeneous databases | |
CN103744906A (zh) | 一种数据同步***、方法及装置 | |
WO2018098972A1 (zh) | 一种日志恢复方法、存储装置和存储节点 | |
CN105824846B (zh) | 数据迁移方法及装置 | |
WO2014169142A1 (en) | Partition level backup and restore of a massively parallel processing database | |
CN109189860A (zh) | 一种基于Kubernetes***的MySQL主备增量同步方法 | |
CN105573859A (zh) | 一种数据库的数据恢复方法和设备 | |
CN104301360A (zh) | 一种日志数据记录的方法、日志服务器及*** | |
CN105701190A (zh) | 一种数据同步的方法和装置 | |
CN103530388A (zh) | 一种云存储***中提升性能的数据处理方法 | |
CN110704242A (zh) | 一种基于Oracle日志捕获的连续数据保护***及方法 | |
CN103198122B (zh) | 重启内存数据库的方法和装置 | |
WO2019020081A1 (zh) | 分布式***及其故障恢复方法、装置、产品和存储介质 | |
CN105302667A (zh) | 基于集群架构的高可靠性数据备份与恢复方法 | |
CN105446825B (zh) | 数据库测试方法及装置 | |
CN105376277A (zh) | 一种数据同步方法及装置 | |
CN104899071A (zh) | 集群中虚拟机的恢复方法和*** | |
CN110502523A (zh) | 业务数据存储方法、装置、服务器及计算机可读存储介质 | |
CN105589887A (zh) | 分布式文件***的数据处理方法及分布式文件*** | |
CN111666266A (zh) | 一种数据迁移方法及相关设备 | |
CN106899654A (zh) | 一种序列值生成方法、装置及*** |
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 |
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. |
|
CP02 | Change in the address of a patent holder | ||
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 |
|
PE01 | Entry into force 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 |
|
PC01 | Cancellation of the registration of the contract for pledge of patent right |