CN110008284A - 基于数据页预加载及回滚的数据库数据同步方法及设备 - Google Patents
基于数据页预加载及回滚的数据库数据同步方法及设备 Download PDFInfo
- Publication number
- CN110008284A CN110008284A CN201910203439.7A CN201910203439A CN110008284A CN 110008284 A CN110008284 A CN 110008284A CN 201910203439 A CN201910203439 A CN 201910203439A CN 110008284 A CN110008284 A CN 110008284A
- Authority
- CN
- China
- Prior art keywords
- data
- delete
- affairs
- update
- data page
- 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
- 238000000034 method Methods 0.000 title claims abstract description 37
- 230000001360 synchronised effect Effects 0.000 claims abstract description 54
- 230000036316 preload Effects 0.000 claims abstract description 37
- 238000006243 chemical reaction Methods 0.000 claims abstract description 28
- 238000004891 communication Methods 0.000 claims description 10
- 230000006399 behavior Effects 0.000 claims description 6
- 230000001052 transient effect Effects 0.000 claims description 4
- 238000005516 engineering process Methods 0.000 description 8
- 238000010586 diagram Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 241000208340 Araliaceae Species 0.000 description 1
- 235000005035 Panax pseudoginseng ssp. pseudoginseng Nutrition 0.000 description 1
- 235000003140 Panax quinquefolius Nutrition 0.000 description 1
- 238000013459 approach Methods 0.000 description 1
- 230000015556 catabolic process Effects 0.000 description 1
- 238000007418 data mining Methods 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 235000008434 ginseng Nutrition 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 230000010076 replication Effects 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 238000005096 rolling process Methods 0.000 description 1
- 238000000926 separation method Methods 0.000 description 1
- 238000012163 sequencing technique 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/1448—Management of the data involved in backup or backup restore
Abstract
Description
Claims (8)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910203439.7A CN110008284B (zh) | 2019-03-18 | 2019-03-18 | 基于数据页预加载及回滚的数据库数据同步方法及设备 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910203439.7A CN110008284B (zh) | 2019-03-18 | 2019-03-18 | 基于数据页预加载及回滚的数据库数据同步方法及设备 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN110008284A true CN110008284A (zh) | 2019-07-12 |
CN110008284B CN110008284B (zh) | 2021-06-22 |
Family
ID=67167288
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910203439.7A Active CN110008284B (zh) | 2019-03-18 | 2019-03-18 | 基于数据页预加载及回滚的数据库数据同步方法及设备 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110008284B (zh) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111694798A (zh) * | 2020-04-23 | 2020-09-22 | 武汉达梦数据库有限公司 | 一种基于日志解析的数据同步方法及数据同步系统 |
CN112394941A (zh) * | 2020-11-18 | 2021-02-23 | 京东数字科技控股股份有限公司 | 代码预热方法、装置、电子设备及存储介质 |
CN113688338A (zh) * | 2020-05-19 | 2021-11-23 | 上海惠芽信息技术有限公司 | 用户数据的处理方法、处理装置及计算机存储介质 |
Citations (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102043686A (zh) * | 2009-10-20 | 2011-05-04 | 华为技术有限公司 | 一种内存数据库的容灾方法、备用服务器及系统 |
US20110320403A1 (en) * | 2010-06-28 | 2011-12-29 | O'krafka Brian W | Approaches for the replication of write sets |
EP2555129A1 (en) * | 2011-08-03 | 2013-02-06 | Amadeus s.a.s. | Method and system to maintain strong consistency of distributed replicated contents in a client/server system |
CN105786959A (zh) * | 2016-01-11 | 2016-07-20 | 北京京东尚科信息技术有限公司 | 主备数据库的同步方法及装置 |
CN106209382A (zh) * | 2010-09-20 | 2016-12-07 | 安全第公司 | 用于安全数据共享的系统和方法 |
CN106709043A (zh) * | 2016-12-30 | 2017-05-24 | 江苏瑞中数据股份有限公司 | 一种基于数据库日志的数据同步加载方法 |
CN106970920A (zh) * | 2016-01-14 | 2017-07-21 | 阿里巴巴集团控股有限公司 | 一种用于数据库数据迁移的方法与设备 |
CN108170768A (zh) * | 2017-12-25 | 2018-06-15 | 腾讯科技(深圳)有限公司 | 数据库同步方法、装置及可读介质 |
CN108920698A (zh) * | 2018-07-16 | 2018-11-30 | 北京京东金融科技控股有限公司 | 一种数据同步方法、装置、系统、介质及电子设备 |
CN109271450A (zh) * | 2018-10-10 | 2019-01-25 | 北京百度网讯科技有限公司 | 数据库同步方法、装置、服务器和存储介质 |
-
2019
- 2019-03-18 CN CN201910203439.7A patent/CN110008284B/zh active Active
Patent Citations (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102043686A (zh) * | 2009-10-20 | 2011-05-04 | 华为技术有限公司 | 一种内存数据库的容灾方法、备用服务器及系统 |
US20110320403A1 (en) * | 2010-06-28 | 2011-12-29 | O'krafka Brian W | Approaches for the replication of write sets |
CN106209382A (zh) * | 2010-09-20 | 2016-12-07 | 安全第公司 | 用于安全数据共享的系统和方法 |
EP2555129A1 (en) * | 2011-08-03 | 2013-02-06 | Amadeus s.a.s. | Method and system to maintain strong consistency of distributed replicated contents in a client/server system |
CN103858122A (zh) * | 2011-08-03 | 2014-06-11 | 艾玛迪斯简易股份公司 | 保持客户端/服务器系统内的分布式复制内容的高度一致性的方法和系统 |
CN105786959A (zh) * | 2016-01-11 | 2016-07-20 | 北京京东尚科信息技术有限公司 | 主备数据库的同步方法及装置 |
CN106970920A (zh) * | 2016-01-14 | 2017-07-21 | 阿里巴巴集团控股有限公司 | 一种用于数据库数据迁移的方法与设备 |
CN106709043A (zh) * | 2016-12-30 | 2017-05-24 | 江苏瑞中数据股份有限公司 | 一种基于数据库日志的数据同步加载方法 |
CN108170768A (zh) * | 2017-12-25 | 2018-06-15 | 腾讯科技(深圳)有限公司 | 数据库同步方法、装置及可读介质 |
CN108920698A (zh) * | 2018-07-16 | 2018-11-30 | 北京京东金融科技控股有限公司 | 一种数据同步方法、装置、系统、介质及电子设备 |
CN109271450A (zh) * | 2018-10-10 | 2019-01-25 | 北京百度网讯科技有限公司 | 数据库同步方法、装置、服务器和存储介质 |
Non-Patent Citations (4)
Title |
---|
JACKYRONGVIP: ""mysql数据库中的预热"", 《HTTPS://BLOG.CSDN.NET/JACKYRONGVIP/ARTICLE/DETAILS/84356690》 * |
MYYSOPHIA: ""数据库表存在内存中"", 《HTTPS://BLOG.CSDN.NET/MYYSOPHIA/ARTICLE/DETAILS/79932470》 * |
YUBIAO WANG 等: ""Research on Incremental Heterogeneous Database Synchronization Update Based on Web Service"", 《2015 INTERNATIONAL CONFERENCE ON COMPUTATIONAL INTELLIGENCE AND COMMUNICATION NETWORKS》 * |
董朋志: ""云环境下数据库同步服务的研究与实现"", 《中国优秀硕士论文全文数据库 信息科技辑》 * |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111694798A (zh) * | 2020-04-23 | 2020-09-22 | 武汉达梦数据库有限公司 | 一种基于日志解析的数据同步方法及数据同步系统 |
CN111694798B (zh) * | 2020-04-23 | 2023-04-25 | 武汉达梦数据库股份有限公司 | 一种基于日志解析的数据同步方法及数据同步系统 |
CN113688338A (zh) * | 2020-05-19 | 2021-11-23 | 上海惠芽信息技术有限公司 | 用户数据的处理方法、处理装置及计算机存储介质 |
CN112394941A (zh) * | 2020-11-18 | 2021-02-23 | 京东数字科技控股股份有限公司 | 代码预热方法、装置、电子设备及存储介质 |
Also Published As
Publication number | Publication date |
---|---|
CN110008284B (zh) | 2021-06-22 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
KR102392944B1 (ko) | 데이터 백업 방법, 저장 매체 및 컴퓨팅 기기 | |
CN105373448B (zh) | 数据库中故障数据的恢复方法和系统 | |
US8825601B2 (en) | Logical data backup and rollback using incremental capture in a distributed database | |
CN101551801B (zh) | 数据同步的方法和系统 | |
CN109656934A (zh) | 基于日志解析的源端Oracle数据库DDL同步方法及设备 | |
CN109977168A (zh) | 基于数据页预加载的数据库数据同步方法及设备 | |
CN112000737A (zh) | 基于多云管理的数据同步方法、系统、终端及存储介质 | |
CN110008284A (zh) | 基于数据页预加载及回滚的数据库数据同步方法及设备 | |
CN104731956A (zh) | 同步数据的方法、系统及相关数据库 | |
CN111651519B (zh) | 数据同步方法、数据同步装置、电子设备及存储介质 | |
CN111382150A (zh) | 一种基于Flink的实时计算方法及系统 | |
CN104657497A (zh) | 一种基于分布式计算的海量用电信息并行计算系统及方法 | |
CN107301214A (zh) | 在hive中数据迁移方法、装置及终端设备 | |
CN106095957A (zh) | 分布式文件系统的跨域多副本文件同步方法及装置 | |
WO2019118274A1 (en) | Automated transaction engine | |
CN110704442A (zh) | 一种大数据的实时获取方法及装置 | |
CN106874343A (zh) | 一种时序数据库的数据删除方法及系统 | |
CN106959989A (zh) | 主备数据库的同步方法及装置 | |
US9009098B1 (en) | Methods and apparatus for creating a centralized data store | |
CN108958659A (zh) | 一种分布式存储系统的小文件聚合方法、装置及介质 | |
CN102360382B (zh) | 一种高速对象并行存储系统目录复制方法 | |
CN109871394B (zh) | 一种全量分布式高并发计算方法及装置 | |
CN110196786A (zh) | 数据库回滚同步中内存的控制方法及设备 | |
CN109788077A (zh) | 一种支持集群的云备份系统及其方法 | |
US11341159B2 (en) | In-stream data load in a replication environment |
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 | ||
CB02 | Change of applicant information | ||
CB02 | Change of applicant information |
Address after: 430000 16-19 / F, building C3, future technology building, 999 Gaoxin Avenue, Donghu New Technology Development Zone, Wuhan, Hubei Province Applicant after: Wuhan dream database Co.,Ltd. Address before: 430000 16-19 / F, building C3, future technology building, 999 Gaoxin Avenue, Donghu New Technology Development Zone, Wuhan, Hubei Province Applicant before: WUHAN DAMENG DATABASE Co.,Ltd. |
|
CB03 | Change of inventor or designer information | ||
CB03 | Change of inventor or designer information |
Inventor after: Sun Feng Inventor after: Yu Yuanlan Inventor before: Fu Quan Inventor before: Sun Feng Inventor before: Yu Yuanlan |
|
GR01 | Patent grant | ||
GR01 | Patent grant | ||
TR01 | Transfer of patent right |
Effective date of registration: 20220907 Address after: 430073 16-19 / F, building C3, future science and technology building, 999 Gaoxin Avenue, Donghu New Technology Development Zone, Wuhan City, Hubei Province Patentee after: Wuhan dream database Co.,Ltd. Patentee after: HUAZHONG University OF SCIENCE AND TECHNOLOGY Address before: 430000 16-19 / F, building C3, future technology building, 999 Gaoxin Avenue, Donghu New Technology Development Zone, Wuhan, Hubei Province Patentee before: Wuhan dream database Co.,Ltd. |
|
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20230728 Address after: 16-19/F, Building C3, Future Science and Technology Building, No. 999 Gaoxin Avenue, Donghu New Technology Development Zone, Wuhan City, Hubei Province, 430206 Patentee after: Wuhan dream database Co.,Ltd. Address before: 430073 16-19 / F, building C3, future science and technology building, 999 Gaoxin Avenue, Donghu New Technology Development Zone, Wuhan City, Hubei Province Patentee before: Wuhan dream database Co.,Ltd. Patentee before: HUAZHONG University OF SCIENCE AND TECHNOLOGY |