CN115104092A - 数据同步方法及相关装置 - Google Patents

数据同步方法及相关装置 Download PDF

Info

Publication number
CN115104092A
CN115104092A CN202080096693.2A CN202080096693A CN115104092A CN 115104092 A CN115104092 A CN 115104092A CN 202080096693 A CN202080096693 A CN 202080096693A CN 115104092 A CN115104092 A CN 115104092A
Authority
CN
China
Prior art keywords
data
binary
database
sub
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.)
Pending
Application number
CN202080096693.2A
Other languages
English (en)
Inventor
郭子亮
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Guangdong Oppo Mobile Telecommunications Corp Ltd
Shenzhen Huantai Technology Co Ltd
Original Assignee
Guangdong Oppo Mobile Telecommunications Corp Ltd
Shenzhen Huantai Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Guangdong Oppo Mobile Telecommunications Corp Ltd, Shenzhen Huantai Technology Co Ltd filed Critical Guangdong Oppo Mobile Telecommunications Corp Ltd
Publication of CN115104092A publication Critical patent/CN115104092A/zh
Pending legal-status Critical Current

Links

Images

Classifications

    • 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

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Computing Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

一种数据同步方法，包括：首先将第一数据库中的第一二进制日志按照预设分批规则进行分批处理得到N个子二进制日志，N为正整数(201)；接着，在每个子二进制日志的预设位置插入数据标记得到第二二进制日志(202)；最后，根据所述第二二进制日志完成所述第一数据库与第二数据库之间的数据同步(203)。可以对二进制日志进行分批处理和标记处理，使得异地数据库之间进行数据同步时，自动识别出哪些数据是系统生成的，避免二进制日志在两地数据库不停的循环复制，大大提升了数据同步的效果。

Description

PCT国内申请，说明书已公开。

Claims (10)

  1. PCT国内申请，权利要求书已公开。
CN202080096693.2A 2020-05-29 2020-05-29 数据同步方法及相关装置 Pending CN115104092A (zh)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
PCT/CN2020/093374 WO2021237704A1 (zh) 2020-05-29 2020-05-29 数据同步方法及相关装置

Publications (1)

Publication Number Publication Date
CN115104092A true CN115104092A (zh) 2022-09-23

Family

ID=78745454

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202080096693.2A Pending CN115104092A (zh) 2020-05-29 2020-05-29 数据同步方法及相关装置

Country Status (2)

Country Link
CN (1) CN115104092A (zh)
WO (1) WO2021237704A1 (zh)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN116010172B (zh) * 2023-02-28 2023-06-23 天翼云科技有限公司 一种数据同步方法、数据库、数据同步装置和产品

Family Cites Families (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8510270B2 (en) * 2010-07-27 2013-08-13 Oracle International Corporation MYSQL database heterogeneous log based replication
CN104376017B (zh) * 2013-08-15 2018-10-23 阿里巴巴集团控股有限公司 在数据库之间进行数据同步的方法及系统
CN104391954B (zh) * 2014-11-27 2019-04-09 北京国双科技有限公司 数据库日志的处理方法及装置
CN107729366B (zh) * 2017-09-08 2021-01-05 广东省建设信息中心 一种普适多源异构大规模数据同步系统
CN109492050A (zh) * 2018-10-19 2019-03-19 北京极数云舟科技有限公司 防止MySQL双活系统循环复制的方法及装置
CN110659256B (zh) * 2019-09-30 2021-02-26 掌阅科技股份有限公司 多机房同步方法、计算设备及计算机存储介质

Also Published As

Publication number Publication date
WO2021237704A1 (zh) 2021-12-02

Similar Documents

Publication Publication Date Title
US8555161B2 (en) Concurrent editing of a document by multiple clients
WO2017028514A1 (zh) 一种数据存储、读取方法及装置
US8990140B2 (en) Transforming data into consumable content
US10600221B2 (en) System, method, and electronic device for information duplication and machine-readable storage medium
CN108334609B (zh) Oracle中实现JSON格式数据存取的方法、装置、设备及存储介质
CN102939581A (zh) 多个线程对文档的并发利用
CN110675479B (zh) 动态光照处理方法、装置、存储介质及电子装置
CN102272751A (zh) 在数据库环境通过背景同步的数据完整性
US20240169972A1 (en) Synchronization method and apparatus for audio and text, device, and medium
EP3343395A1 (en) Data storage method and apparatus for mobile terminal
CN115104092A (zh) 数据同步方法及相关装置
JP2019522847A (ja) データを抽出するための方法、デバイス及び端末デバイス
CN108280154B (zh) 一种地图标注信息展示方法、装置、终端及可读存储介质
CN107526730B (zh) 一种翻译数据的管理方法、存储介质及电子设备
CN107729347B (zh) 同义标签的获取方法、装置、设备及计算机可读存储介质
JP2000207260A (ja) ハンドヘルド装置のデ―タ記憶およびデ―タ取出しのための方法および装置
CN110069604B (zh) 文本搜索方法、装置和计算机可读存储介质
CN109165259B (zh) 基于网络附属存储的索引表更新方法、处理器及存储装置
CN116303888A (zh) 一种生僻字处理方法、装置、存储介质及电子设备
CN102722543B (zh) 一种用于文件储存的方法
CN104021026A (zh) 一种基于Android系统的语言添加方法
CN110263303B (zh) 文本修改历史的追溯方法及装置
CN115081412A (zh) 表格内容处理方法、装置、设备、存储介质
CN112036132A (zh) 一种文档的页眉页脚编辑方法、装置及电子设备
CN112948485B (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