WO2021237704A1 - Procédé de synchronisation de données et dispositif associé - Google Patents

Procédé de synchronisation de données et dispositif associé Download PDF

Info

Publication number
WO2021237704A1
WO2021237704A1 PCT/CN2020/093374 CN2020093374W WO2021237704A1 WO 2021237704 A1 WO2021237704 A1 WO 2021237704A1 CN 2020093374 W CN2020093374 W CN 2020093374W WO 2021237704 A1 WO2021237704 A1 WO 2021237704A1
Authority
WO
WIPO (PCT)
Prior art keywords
data
database
binary
sub
binary 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.)
Ceased
Application number
PCT/CN2020/093374
Other languages
English (en)
Chinese (zh)
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 Heytap Technology Corp Ltd
Original Assignee
Guangdong Oppo Mobile Telecommunications Corp Ltd
Shenzhen Heytap Technology Corp 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 Heytap Technology Corp Ltd filed Critical Guangdong Oppo Mobile Telecommunications Corp Ltd
Priority to CN202080096693.2A priority Critical patent/CN115104092B/zh
Priority to PCT/CN2020/093374 priority patent/WO2021237704A1/fr
Publication of WO2021237704A1 publication Critical patent/WO2021237704A1/fr
Anticipated expiration legal-status Critical
Ceased legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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

Definitions

  • the invention relates to the technical field of database storage, in particular to a data synchronization method and related devices.
  • this application proposes a data synchronization method and related device.
  • batch processing and marking processing on binary logs when data synchronization between remote databases is performed, it is possible to identify which data is generated by the system and avoid The binary log is replicated continuously in the two databases, which greatly improves the effect of data synchronization.
  • an embodiment of the present application provides a data synchronization method, and the method includes:
  • the first binary log in the first database is processed in batches according to a preset batching rule to obtain N sub-binary logs, where N is a positive integer;
  • the data synchronization between the first database and the second database is completed according to the second binary log.
  • an embodiment of the present application provides a data synchronization device, and the device includes:
  • the batching unit is used to process the first binary log in the first database in batches according to a preset batching rule to obtain N sub-binary logs, where N is a positive integer;
  • the marking unit is used to insert a data mark at the preset position of each sub-binary log to obtain the second binary log;
  • the synchronization unit is configured to complete data synchronization between the first database and the second database according to the second binary log.
  • an embodiment of the present application provides an electronic device, including an application processor, a memory, and one or more programs.
  • the one or more programs are stored in the memory and configured by the The application processor executes the program, and the program includes instructions for executing the steps in the method according to any one of claims 1-7.
  • an embodiment of the present application provides a computer storage medium, the computer storage medium stores a computer program, and the computer program includes program instructions that, when executed by a processor, cause all The processor executes the method according to any one of the first aspects of the embodiments of the present application.
  • an embodiment of the present application provides a computer product, wherein the above-mentioned computer program product includes a non-transitory computer-readable storage medium storing a computer program, and the above-mentioned computer program is operable to cause a computer to execute operations as described in the embodiments of the present application. Part or all of the steps described in any method of the first aspect.
  • the computer program product may be a software installation package.
  • the first binary log in the first database is first processed in batches according to the preset batching rule to obtain N sub-binary logs, where N is a positive integer; then, in the preset of each sub-binary log Insert a data mark at the position to obtain a second binary log; finally, complete data synchronization between the first database and the second database according to the second binary log.
  • the binary log can be processed in batches and marked, so that when data is synchronized between remote databases, it can automatically identify which data is generated by the system, avoiding the continuous circular replication of the binary log in the two databases, greatly improving data synchronization Effect.
  • FIG. 1 is a system architecture diagram of a data synchronization method provided by an embodiment of this application;
  • FIG. 2 is a schematic flowchart of a data synchronization method provided by an embodiment of this application.
  • FIG. 3 is a schematic diagram of an application scenario of a data synchronization method provided by an embodiment of the application
  • 4A is a schematic diagram of a truncated transaction fragment provided by an embodiment of the application.
  • 4B is a schematic diagram of another truncated transaction fragment provided by an embodiment of the application.
  • 4C is a schematic diagram of another truncated transaction fragment provided by an embodiment of the application.
  • FIG. 5 is a schematic structural diagram of an electronic device provided by an embodiment of this application.
  • FIG. 6 is a block diagram of the functional unit composition of a data synchronization device provided by an embodiment of the application.
  • FIG. 7 is a block diagram of the functional unit composition of another data synchronization device provided by an embodiment of the application.
  • the current remote database synchronization generally involves establishing independent data centers in different cities, and the databases of these data centers will work at the same time. All databases accept the writing of corresponding business data and synchronize and update data to other databases to achieve two-way data synchronization between databases with multiple activities in different places.
  • the above databases can be relational database management systems, such as MySQL, and data update SQL Statement information will be stored in the binary log binlog.
  • the above binlog is a binary log that records all database table structure changes (such as CREATE, ALTER TABLE%) and table data modifications (INSERT, UPDATE, DELETE).
  • binlog can represent a transaction
  • a transaction is a sequence of database operations, which is the smallest unit of work in the database.
  • a transaction consists of all database operations performed between the start of the transaction and the end of the transaction.
  • FIG. 1 is a system architecture diagram of a data synchronization method provided by an embodiment of this application.
  • the system architecture 100 includes a first database 110, a second database 120, a replication module 130, a first terminal 141, and a second terminal 142.
  • the above-mentioned first database 110 is connected to the second database 120 through the replication module 130,
  • the first terminal 141 in the location of the first database 110 interacts with the first database 110
  • the second terminal 142 in the location of the second database 120 interacts with the second database 120.
  • first database 110 and the second database 120 may be MySQL databases, and data is stored in the first database 110 and the second database 120 in the form of tables.
  • the above-mentioned replication module 130 may be mounted on a server, and is used to read data from the above-mentioned first database 110 and synchronize to the above-mentioned second database 120, and at the same time, read data from the above-mentioned second database 120 and synchronize to the above-mentioned first database. 110.
  • the replication module 130 may also process the read data in batches, so that the data synchronization between the first data 110 and the second database 120 is performed in batches.
  • the aforementioned user terminal 140 may be installed with various communication client applications, such as database management applications, shopping applications, search applications, instant messaging tools, email clients, social platform software, and so on.
  • the user terminal 140 may be various electronic devices with a display screen, including but not limited to smart phones, tablet computers, portable computers, desktop computers, and so on. There is no specific limitation here.
  • first database 110 and the second database 120 in the foregoing system architecture only represent different databases, and it does not mean that the embodiment of the present application can only be applied to two databases.
  • binary logs can be processed in batches and marked, so that when data is synchronized between remote databases, it can automatically identify which data is generated by the system, and avoid the continuous circular replication of binary logs in the two databases. Greatly improve the effect of data synchronization.
  • FIG. 2 is a data synchronization method provided by an embodiment of the application.
  • the schematic flow diagram of the synchronization method includes the following steps:
  • Step 201 Perform batch processing of the first binary log in the first database according to a preset batching rule to obtain N sub-binary logs.
  • N is a positive integer
  • the first binary log records the database operation sequence in the first database.
  • the size of the first binary log is the first amount of data.
  • the first amount of data can be set according to user needs.
  • the first amount of data is read from the first database through the replication module in the system architecture.
  • the second data volume corresponding to the second database is obtained. Because there is two-way synchronization between the first database and the second database, the second data volume can be used for the subsequent first
  • a binary log is processed in batches for data reference, and finally, the first two-level system log is processed in batches according to the first data volume and the second data volume to obtain N sub-binary logs.
  • FIG. 3 is provided for an embodiment of the application.
  • An application scenario diagram of a data synchronization method including a first database, a second database, and a replication (Repetition) module, a_select_size represents the first data volume, b_select_size represents the second data volume, and a_split_size represents the batch data volume, through the following pseudo
  • the code can determine the size of a_split_size:
  • a_split_size b_select_size-2; // means a head tag and a tail tag
  • a_split_size b_select_size
  • the replication module reads the first binary log of the first amount of data from the first database, performs batch processing on the first binary log, and then synchronizes to the second database, and reads from the second database at the same time.
  • the binary log of the second amount of data is synchronized to the above-mentioned first database.
  • FIG. 3 only shows the specific batch processing steps of synchronizing data from the above-mentioned first database to the above-mentioned second database.
  • the above-mentioned first database synchronization data is also the same processing step, which will not be repeated here.
  • the batch data volume when the first data volume is greater than the second data volume is named the first batch data volume;
  • the batch data volume can be determined to be the second data volume, that is, the size of each sub-binary log is the second data volume.
  • the first data volume is smaller than The batch data volume when it is equal to the above-mentioned second data volume is named the second batch data volume.
  • the size of one-time synchronization data can be reduced, the data volume pressure during synchronization is reduced, and the data volume pressure during synchronization is reduced. A deadlock situation occurs.
  • Step 202 Insert a data mark at a preset position of each sub-binary log to obtain a second binary log.
  • the data mark includes a head mark and a tail mark. Inserting a data mark at a preset position means inserting the head mark at the head of each sub-binary log and inserting the tail mark at the end of each sub-binary log, inserting the data mark
  • the size of each sub-binary log of is equal to the above-mentioned second data volume, so when the second database synchronizes data with the above-mentioned first database, at least one head mark or tail mark can be read.
  • each of the above-mentioned first database and the above-mentioned second database has a formulation table.
  • the binary log of the operation of generating data tags is stored in the formulation table.
  • a header can be inserted after each transaction header. Part mark, insert a tail mark before the end of each transaction.
  • the second binary log is obtained by inserting the data mark in the preset position of each sub-binary log, which can ensure the visibility of the data mark.
  • Step 203 Complete data synchronization between the first database and the second database according to the second binary log.
  • the system input segment and service input segment of the second binary log may be determined according to the head tag and the tail tag, that is, the segment between the head tag and the tail tag is determined as the
  • the system input fragments are determined to be the business input fragments other than the system input fragments.
  • the system input fragments represent data generated by the system. Recognizing the system input fragments during synchronization can avoid the phenomenon of data loopback.
  • the fragments represent the data entered into the database by the external terminal.
  • the data synchronization between the first database and the second database is completed according to the system input fragment and the service input fragment.
  • the data may be truncated when the batch-processed data is written into the second database.
  • Figure 4A is a kind of Schematic diagram of truncated transaction fragments
  • dml represents the operation sequence command for operating the database
  • transaction_begin represents the transaction head
  • transaction_end represents the transaction end
  • flag_begin represents the head tag
  • flag_end represents the tail tag.
  • the binary log By completing the data synchronization between the first database and the second database according to the second binary log, the binary log can be processed in batches and marked, reducing the data volume pressure of data synchronization, and making it remote When synchronizing data between databases, it automatically recognizes which data is generated by the system, avoids the continuous circular replication of binary logs in the two databases, and greatly improves the effect of data synchronization.
  • the electronic device includes hardware structures and/or software modules corresponding to each function.
  • this application can be implemented in the form of hardware or a combination of hardware and computer software. Whether a certain function is executed by hardware or computer software-driven hardware depends on the specific application and design constraint conditions of the technical solution. Professionals and technicians can use different methods for each specific application to implement the described functions, but such implementation should not be considered beyond the scope of this application.
  • FIG. 5 is a schematic structural diagram of an electronic device provided by an embodiment of its own application.
  • the electronic device 500 may be an electronic device with communication capabilities.
  • the electronic device may include various handheld devices with wireless communication functions, vehicle-mounted devices, and wearables.
  • the electronic device 500 in this application may include one or more of the following components: a processor 510, a memory 520, and an input/output device 530.
  • the processor 510 may include one or more processing cores.
  • the processor 510 uses a communication interface to connect various parts of the entire terminal 500, and executes the operations of the electronic device 500 by running or executing instructions, programs, code sets, or instruction sets stored in the memory 520, and calling data stored in the memory 520.
  • the processor 510 may include one or more processing units.
  • the processor 510 may include a central processing unit (CPU), an application processor (AP), a modem processor, and a graphics processor ( graphics processing unit (GPU), image signal processor (ISP), controller, video codec, digital signal processor (DSP), baseband processor, and/or neural network processor (neural-network processing unit, NPU), etc.
  • the CPU is mainly used to process the operating system, user interface, and application programs; the GPU is used to render and draw the display content; the modem is used to process wireless communication.
  • Digital signal processors are used to process digital signals. In addition to digital image signals, they can also process other digital signals.
  • the central processing unit CPU is taken as an example for description. For example, when the electronic device 500 is running an application, the CPU can obtain drawing data of the UI thread and other threads for the application, and determine the current drawing data based on the drawing data. Whether the running application program has dropped frames, etc., after that, based on the performance usage of the CPU itself, the frequency of the CPU can be dynamically controlled.
  • the processor 510 may be provided with a memory 520 for storing instructions and data.
  • the memory 520 in the processor 510 is a cache memory.
  • the memory 520 can store instructions or data that the processor 510 has just used or used cyclically. If the processor 510 needs to use the instruction or data again, it can be directly called from the memory 520. Avoid repeated accesses, reduce the waiting time of the processor 510, and improve system efficiency.
  • the above-mentioned processor 510 can be mapped to a system-on-chip (SOC) in an actual product, and the above-mentioned processing unit and/or interface may not be integrated into the processor 510 and pass through a communication chip alone. Or electronic components realize the corresponding function.
  • SOC system-on-chip
  • the above-mentioned interface connection relationship between the modules is only a schematic description, and does not constitute the only limitation on the structure of the electronic device 500.
  • the memory 520 may include random access memory (Random Access Memory, RAM), and may also include read-only memory (Read-Only Memory).
  • RAM Random Access Memory
  • Read-Only Memory the memory 520 includes a non-transitory computer-readable storage medium.
  • the memory 520 may be used to store instructions, programs, codes, code sets or instruction sets.
  • the memory 520 may include a storage program area and a storage data area, where the storage program area may store instructions for implementing the operating system and instructions for implementing at least one function (such as touch function, sound playback function, image playback function, etc.) , Instructions used to implement the following various method embodiments, etc., the operating system can be the Android system (including the system based on the in-depth development of the Android system), the IOS system developed by Apple (including the system based on the in-depth development of the IOS system) ) Or other systems.
  • the data storage area can also store data created by the electronic device 500 during use.
  • the input and output device 530 may include a touch display screen, which is used to receive a user's touch operation on or near any suitable object such as a finger, a touch pen, etc., and to display a user interface of each application program.
  • the touch screen is usually arranged on the front panel of the terminal 500.
  • the touch screen can be designed as a full screen, curved screen or special-shaped screen.
  • the touch display screen can also be designed as a combination of a full screen and a curved screen, or a combination of a special-shaped screen and a curved screen, which is not limited in the embodiment of the present application.
  • the embodiment of the present application may divide the electronic device into functional units according to the foregoing method examples.
  • each functional unit may be divided corresponding to each function, or two or more functions may be integrated into one processing unit.
  • the above-mentioned integrated unit can be implemented in the form of hardware or software functional unit. It should be noted that the division of units in the embodiments of the present application is illustrative, and is only a logical function division, and there may be other division methods in actual implementation.
  • FIG. 6 is a block diagram of the functional unit composition of a data synchronization device provided in an embodiment of the application.
  • the data synchronization device 600 includes:
  • the batching unit 610 is configured to perform batch processing of the first binary log in the first database according to a preset batching rule to obtain N sub-binary logs, where N is a positive integer;
  • the marking unit 620 is configured to insert a data mark at the preset position of each sub-binary log to obtain the second binary log;
  • the synchronization unit 630 is configured to complete data synchronization between the first database and the second database according to the second binary log.
  • FIG. 7 is a functional unit composition block diagram of another central processor frequency control device 700 involved in an embodiment of the present application.
  • the device 700 for controlling the frequency of the central processing unit is applied to electronic equipment that supports display functions.
  • the electronic device includes a processor, a display module, etc.
  • the device for controlling the frequency of the central processing unit 700 includes a processing unit 701 and a communication unit 702, wherein ,
  • the processing unit 701 is configured to perform any step in the above method embodiment, and when performing data transmission such as sending, it can optionally call the communication unit 702 to complete the corresponding operation.
  • the device 700 for controlling the frequency of the central processing unit may further include a storage unit 703 for storing program codes and data of the electronic device.
  • the processing unit 701 may be a central processing unit
  • the communication unit 702 may be a touch screen or a transceiver
  • the storage unit 703 may be a memory.
  • Both the data synchronization device 600 and the data synchronization device 700 described above can execute all the data synchronization methods included in the foregoing embodiment.
  • An embodiment of the present application also provides a computer storage medium, wherein the computer storage medium stores a computer program for electronic data exchange, and the computer program enables a computer to execute part or all of the steps of any method as described in the above method embodiment ,
  • the above-mentioned computer includes electronic equipment.
  • the embodiments of the present application also provide a computer program product.
  • the above-mentioned computer program product includes a non-transitory computer-readable storage medium storing a computer program.
  • the above-mentioned computer program is operable to cause a computer to execute any of the methods described in the above-mentioned method embodiments. Part or all of the steps of the method.
  • the computer program product may be a software installation package, and the above-mentioned computer includes electronic equipment.
  • the disclosed device may be implemented in other ways.
  • the device embodiments described above are merely illustrative, for example, the division of the above-mentioned units is only a logical function division, and there may be other divisions in actual implementation, for example, multiple units or components can be combined or integrated. To another system, or some features can be ignored, or not implemented.
  • the displayed or discussed mutual coupling or direct coupling or communication connection may be indirect coupling or communication connection through some interfaces, devices or units, and may be in electrical or other forms.
  • the units described above as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the objectives of the solutions of the embodiments.
  • the functional units in the various embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units may be integrated into one unit.
  • the above-mentioned integrated unit can be implemented in the form of hardware or software functional unit.
  • the aforementioned integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer readable memory.
  • the technical solution of the present application essentially or the part that contributes to the existing technology or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a memory, A number of instructions are included to enable a computer device (which may be a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the foregoing methods of the various embodiments of the present application.
  • the aforementioned memory includes: U disk, Read-Only Memory (ROM, Read-Only Memory), Random Access Memory (RAM, Random Access Memory), mobile hard disk, magnetic disk or optical disk and other media that can store program codes.
  • the program can be stored in a computer-readable memory, and the memory can include: a flash disk , Read-only memory (English: Read-Only Memory, abbreviation: ROM), random access device (English: Random Access Memory, abbreviation: RAM), magnetic disk or optical disc, etc.

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

Procédé de synchronisation de données, consistant : premièrement, à traiter de premiers journaux binaires dans une première base de données par lots selon une règle d'établissement de lots prédéfinie pour obtenir N sous-journaux binaires, N étant un nombre entier positif (201) ; ensuite, à insérer un marqueur de données dans une position prédéfinie de chaque sous-journal binaire pour obtenir de seconds journaux binaires (202) ; et, enfin, à achever la synchronisation de données entre la première base de données et une seconde base de données selon les seconds journaux binaires (203). Des journaux binaires peuvent être traités par lots et marqués, de sorte que les données générées par le système sont automatiquement identifiées pendant la synchronisation de données entre des bases de données distantes, afin d'éviter une réplication circulaire répétée des journaux binaires dans les deux bases de données, ce qui permet d'améliorer l'effet de synchronisation de données.
PCT/CN2020/093374 2020-05-29 2020-05-29 Procédé de synchronisation de données et dispositif associé Ceased WO2021237704A1 (fr)

Priority Applications (2)

Application Number Priority Date Filing Date Title
CN202080096693.2A CN115104092B (zh) 2020-05-29 2020-05-29 数据同步方法及相关装置
PCT/CN2020/093374 WO2021237704A1 (fr) 2020-05-29 2020-05-29 Procédé de synchronisation de données et dispositif associé

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
PCT/CN2020/093374 WO2021237704A1 (fr) 2020-05-29 2020-05-29 Procédé de synchronisation de données et dispositif associé

Publications (1)

Publication Number Publication Date
WO2021237704A1 true WO2021237704A1 (fr) 2021-12-02

Family

ID=78745454

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2020/093374 Ceased WO2021237704A1 (fr) 2020-05-29 2020-05-29 Procédé de synchronisation de données et dispositif associé

Country Status (2)

Country Link
CN (1) CN115104092B (fr)
WO (1) WO2021237704A1 (fr)

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114356943A (zh) * 2021-12-29 2022-04-15 瀚云科技有限公司 一种数据库同步方法、装置、电子设备及存储介质
CN115203202A (zh) * 2022-07-01 2022-10-18 杭州米络星科技(集团)有限公司 一种多模块处理记录对齐方法、装置、终端和介质
CN116010172A (zh) * 2023-02-28 2023-04-25 天翼云科技有限公司 一种数据同步方法、数据库、数据同步装置和产品
CN116450739A (zh) * 2023-04-13 2023-07-18 济南浪潮数据技术有限公司 一种多站点数据同步方法、系统、装置及介质

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115730010A (zh) * 2022-11-23 2023-03-03 中国银行股份有限公司 数据库同步方法、系统、生产端及消费端解析服务器

Citations (6)

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

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9886347B2 (en) * 2015-01-08 2018-02-06 International Business Machines Corporation Data replication in a database management system
CN105426440B (zh) * 2015-11-06 2018-07-27 云南电网有限责任公司 一种基于数据库的异构型数据批量同步方法
CN106959996B (zh) * 2017-01-20 2020-10-13 华数传媒网络有限公司 一种基于互联网电视的后台数据同步方法
CN109753511B (zh) * 2018-12-28 2020-12-04 北京东方国信科技股份有限公司 一种大数据平台的跨地域实时同步方法及系统
KR20190022600A (ko) * 2019-02-25 2019-03-06 주식회사 실크로드소프트 데이터베이스 관리 시스템에서의 데이터 복제 기법

Patent Citations (6)

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

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
BRIELLA: "MySQL database two-way synchronous replication", CSDN BLOG, 25 November 2015 (2015-11-25), pages 1 - 7, XP055871583, Retrieved from the Internet <URL:https://blog.csdn.net/weixin_33738982/article/details/85776255> [retrieved on 20211210] *

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114356943A (zh) * 2021-12-29 2022-04-15 瀚云科技有限公司 一种数据库同步方法、装置、电子设备及存储介质
CN115203202A (zh) * 2022-07-01 2022-10-18 杭州米络星科技(集团)有限公司 一种多模块处理记录对齐方法、装置、终端和介质
CN115203202B (zh) * 2022-07-01 2025-10-10 杭州米络星科技(集团)有限公司 一种多模块处理记录对齐方法、装置、终端和介质
CN116010172A (zh) * 2023-02-28 2023-04-25 天翼云科技有限公司 一种数据同步方法、数据库、数据同步装置和产品
CN116450739A (zh) * 2023-04-13 2023-07-18 济南浪潮数据技术有限公司 一种多站点数据同步方法、系统、装置及介质

Also Published As

Publication number Publication date
CN115104092B (zh) 2025-06-17
CN115104092A (zh) 2022-09-23

Similar Documents

Publication Publication Date Title
WO2021237704A1 (fr) Procédé de synchronisation de données et dispositif associé
WO2023231665A1 (fr) Procédé, système et dispositif de traitement de transaction distribuée, et support d&#39;enregistrement lisible
CN110134648A (zh) 日志处理方法、装置、设备、系统及计算机可读存储介质
WO2017028514A1 (fr) Procédé et un dispositif permettant de stocker et de lire des données
CN103970870A (zh) 数据库查询方法和服务器
EP4120060A1 (fr) Procédé et appareil de stockage de données, et procédé et appareil de lecture de données
CN115168440A (zh) 数据读写方法、分布式存储系统、装置、设备和存储介质
CN109241015B (zh) 用于在分布式存储系统中写入数据的方法
CN106326243A (zh) 一种数据处理方法及装置
US20250094694A1 (en) Multi-person cooperative input method, apparatus and system based on input method
CN113434595A (zh) 数据库同步方法、装置、电子设备和存储介质
CN115905322A (zh) 业务处理方法、装置、电子设备及存储介质
WO2020259227A1 (fr) Système de communication de tâche de fil d&#39;exécution, procédé et produit associé
CN109347899B (zh) 在分布式存储系统中写入日志数据的方法
CN110019444A (zh) 一种操作请求处理方法、装置、设备及系统
CN115600257A (zh) 数据脱敏方法及装置、介质、设备及产品
CN115617800A (zh) 数据读取方法、装置、电子设备及存储介质
CN108345648B (zh) 一种基于列式存储的获取日志信息的方法及装置
CN105931054A (zh) 一种交易请求处理方法、网关设备、代理设备及业务设备
CN116721007B (zh) 任务控制方法、系统及装置、电子设备和存储介质
CN116166605B (zh) 数据混合传输方法、装置、dma控制器、介质及系统
CN111427917A (zh) 搜索数据处理方法及相关产品
CN116382940A (zh) 一种共享内存通信方法、装置、设备和存储介质
CN114968535A (zh) 一种数据传输方法、装置、电子设备及介质
CN115543462A (zh) Bios设置布局修改方法、装置、设备及存储介质

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 20937226

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

32PN Ep: public notification in the ep bulletin as address of the adressee cannot be established

Free format text: NOTING OF LOSS OF RIGHTS PURSUANT TO RULE 112(1) EPC (EPO FORM 1205A DATED 19.04.2023)

122 Ep: pct application non-entry in european phase

Ref document number: 20937226

Country of ref document: EP

Kind code of ref document: A1

WWG Wipo information: grant in national office

Ref document number: 202080096693.2

Country of ref document: CN