CN107368390B - 数据库日志的备份方法、装置及服务器 - Google Patents
数据库日志的备份方法、装置及服务器 Download PDFInfo
- Publication number
- CN107368390B CN107368390B CN201710577029.XA CN201710577029A CN107368390B CN 107368390 B CN107368390 B CN 107368390B CN 201710577029 A CN201710577029 A CN 201710577029A CN 107368390 B CN107368390 B CN 107368390B
- Authority
- CN
- China
- Prior art keywords
- database
- journal
- storage engines
- backup
- engine
- 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.)
- Expired - Fee Related
Links
- 238000000034 method Methods 0.000 title claims abstract description 55
- 230000007246 mechanism Effects 0.000 claims abstract description 25
- 230000009471 action Effects 0.000 claims description 73
- 230000006399 behavior Effects 0.000 claims description 7
- 238000006243 chemical reaction Methods 0.000 claims description 4
- 238000004590 computer program Methods 0.000 claims description 4
- 230000008676 import Effects 0.000 claims description 3
- 238000004364 calculation method Methods 0.000 claims 1
- 230000005540 biological transmission Effects 0.000 abstract description 6
- 238000013500 data storage Methods 0.000 abstract description 2
- 230000008569 process Effects 0.000 abstract description 2
- 230000001360 synchronised effect Effects 0.000 abstract 1
- 238000010586 diagram Methods 0.000 description 6
- 230000004048 modification Effects 0.000 description 4
- 238000012986 modification Methods 0.000 description 4
- 238000011084 recovery Methods 0.000 description 4
- 238000012423 maintenance Methods 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 238000012546 transfer Methods 0.000 description 2
- 230000006978 adaptation Effects 0.000 description 1
- 230000003044 adaptive effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000007796 conventional method Methods 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000000151 deposition Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
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
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1458—Management of the backup or restore process
- G06F11/1469—Backup restoration techniques
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F16/275—Synchronous replication
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (11)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710577029.XA CN107368390B (zh) | 2017-07-14 | 2017-07-14 | 数据库日志的备份方法、装置及服务器 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710577029.XA CN107368390B (zh) | 2017-07-14 | 2017-07-14 | 数据库日志的备份方法、装置及服务器 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN107368390A CN107368390A (zh) | 2017-11-21 |
CN107368390B true CN107368390B (zh) | 2019-03-15 |
Family
ID=60308366
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710577029.XA Expired - Fee Related CN107368390B (zh) | 2017-07-14 | 2017-07-14 | 数据库日志的备份方法、装置及服务器 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN107368390B (zh) |
Families Citing this family (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109558455A (zh) * | 2018-12-03 | 2019-04-02 | 上海热璞网络科技有限公司 | 一种数据库备份方法、装置及服务器 |
Family Cites Families (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US9058371B2 (en) * | 2011-11-07 | 2015-06-16 | Sap Se | Distributed database log recovery |
CN104021200B (zh) * | 2014-06-16 | 2018-06-15 | 北京京东尚科信息技术有限公司 | 一种数据库的数据同步方法和装置 |
CN104239476B (zh) * | 2014-09-04 | 2018-09-25 | 上海天脉聚源文化传媒有限公司 | 一种数据库同步的方法、装置及*** |
CN106933703B (zh) * | 2015-12-30 | 2021-04-02 | 阿里巴巴集团控股有限公司 | 一种数据库数据备份的方法、装置及电子设备 |
-
2017
- 2017-07-14 CN CN201710577029.XA patent/CN107368390B/zh not_active Expired - Fee Related
Also Published As
Publication number | Publication date |
---|---|
CN107368390A (zh) | 2017-11-21 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
EP3779732A1 (en) | Data backup method, storage medium, and computing device | |
CN107220142B (zh) | 执行数据恢复操作的方法及装置 | |
CN107832138B (zh) | 一种扁平化的高可用namenode模型的实现方法 | |
EP2972983B1 (en) | Dynamically managing memberships in replicated state machines within a distributed computing environment | |
CN104246767A (zh) | 用于云同步***的遥测*** | |
CN109933632B (zh) | 一种数据库的数据迁移方法、装置及设备 | |
CN105574109A (zh) | 一种数据库同步方法、同步设备及*** | |
CN106933703A (zh) | 一种数据库数据备份的方法、装置及电子设备 | |
CN102272751A (zh) | 在数据库环境通过背景同步的数据完整性 | |
CN109361777B (zh) | 分布式集群节点状态的同步方法、同步***及相关装置 | |
US20090077262A1 (en) | System and method for synchronization between servers | |
CN114168190A (zh) | 接口文档生成方法、装置、计算机设备和存储介质 | |
CN114240409A (zh) | 基于改进哈希时间锁的跨链资产交互方法 | |
CN110121694A (zh) | 一种日志管理方法、服务器和数据库*** | |
CN107368390B (zh) | 数据库日志的备份方法、装置及服务器 | |
WO2021189283A1 (zh) | 数据处理方法、装置、电子装置及存储介质 | |
KR102031589B1 (ko) | 관계 체인 처리 방법 및 시스템, 그리고 저장 매체 | |
WO2023240995A1 (zh) | 一种双机热备***的数据恢复方法、装置及介质 | |
JP2018133044A (ja) | WebAPI実行フロー生成装置およびWebAPI実行フロー生成方法 | |
CN116303789A (zh) | 多分片多副本数据库并行同步方法、装置及可读介质 | |
CN115757642A (zh) | 一种基于归档日志文件的数据同步方法及装置 | |
CN102339305A (zh) | 基于偏序关系日志的数据库集群故障恢复方法 | |
CN116049306A (zh) | 数据同步方法、装置、电子设备以及可读存储介质 | |
CN111966650B (zh) | 一种运维大数据共享数据表的处理方法、装置及存储介质 | |
CN115238006A (zh) | 检索数据同步方法、装置、设备及计算机存储介质 |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | 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 | ||
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20190829 Address after: 100102 No. 6 Building, 6 Wangjing East Road, Chaoyang District, Beijing - 2 floors to 4 floors, 01 floors within 01 floors Co-patentee after: BEIJING SANKUAI ONLINE TECHNOLOGY Co.,Ltd. Patentee after: Sankuai Cloud Online (Beijing) Technology Co.,Ltd. Address before: 100080 Beijing Haidian District North Fourth Ring Road West, No. 9 2106-030 Patentee before: BEIJING SANKUAI ONLINE TECHNOLOGY Co.,Ltd. |
|
CP01 | Change in the name or title of a patent holder | ||
CP01 | Change in the name or title of a patent holder |
Address after: 100102 4th floor 01, building 6, courtyard 6, Wangjing East Road, Chaoyang District, Beijing Patentee after: Beijing Sankuai Network Technology Co.,Ltd. Patentee after: BEIJING SANKUAI ONLINE TECHNOLOGY Co.,Ltd. Address before: 100102 4th floor 01, building 6, courtyard 6, Wangjing East Road, Chaoyang District, Beijing Patentee before: Sankuai Cloud Online (Beijing) Technology Co.,Ltd. Patentee before: BEIJING SANKUAI ONLINE TECHNOLOGY Co.,Ltd. |
|
CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20190315 |