CN108052623A - The synchronous method and synchronization system of MySQL master-slave databases - Google Patents

The synchronous method and synchronization system of MySQL master-slave databases Download PDF

Info

Publication number
CN108052623A
CN108052623A CN201711356578.0A CN201711356578A CN108052623A CN 108052623 A CN108052623 A CN 108052623A CN 201711356578 A CN201711356578 A CN 201711356578A CN 108052623 A CN108052623 A CN 108052623A
Authority
CN
China
Prior art keywords
server
packaged
network availability
master
binlog files
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
CN201711356578.0A
Other languages
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.)
Shenyang Ming Xi Science And Technology Co Ltd
Original Assignee
Shenyang Ming Xi Science And 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 Shenyang Ming Xi Science And Technology Co Ltd filed Critical Shenyang Ming Xi Science And Technology Co Ltd
Priority to CN201711356578.0A priority Critical patent/CN108052623A/en
Publication of CN108052623A publication Critical patent/CN108052623A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/07Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/14Error detection or correction of the data by redundancy in operation
    • G06F11/1402Saving, restoring, recovering or retrying
    • G06F11/1446Point-in-time backing up or restoration of persistent data
    • G06F11/1448Management of the data involved in backup or backup restore
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor

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

The invention discloses the synchronous method and synchronization system of MySQL master-slave databases, wherein, synchronous method includes the following steps:Whether S1, monitoring primary database have new binlog files to generate;S2, if there is new binlog files generate, then newly-generated binlog files are packaged and compress and sent to from server, if generated without new binlog files, return to S1;S3, unpacking verification is carried out to the compression binlog files of reception from server, obtains partial data, and preserved to flash back memory block;The precise synchronization of master-slave database is realized in S4, the operation note that flash back memory block is read from database.The synchronization system includes monitoring unit, file is packaged compression unit, file unpacks verification unit, flash back memory block and reading unit.The synchronous method and synchronization system of the MySQL master-slave databases by synchronous binlog files and can be stored in from server, realize the synchronization of master-slave database.

Description

The synchronous method and synchronization system of MySQL master-slave databases
Technical field
The present invention relates to database technical field, the synchronous method of a kind of MySQL master-slave databases and same is specifically provided Step system.
Background technology
The master slave mode of database can realize read and write abruption, and master-slave database has late replicating mechanism in itself, still, If network failure occurs during principal and subordinate's data synchronization, the data of main and subordinate node will be unable to synchronization, cause principal and subordinate's data not Unanimously, meanwhile, the late replicating mechanism of existing MySQL database there is a problem in that:
1st, Thread Count cannot change at any time used by data synchronously replicate;
2nd, in data synchronization process, it is impossible to carry out network bandwidth limitation and intervene, the time delay of synchronization action is fixed, it is impossible to It is adjusted according to network availability bandwidth into Mobile state;
3rd, data is not supported to flash back according to specified time.
Therefore, the method for data synchronization and synchronization system of a kind of late replicating mechanism independently of MySQL in itself are developed, into For people's urgent problem to be solved.
The content of the invention
In consideration of it, it is an object of the invention to provide a kind of synchronous method and synchronization system of MySQL master-slave databases, with The late replicating methods of MySQL in itself are solved after network failure, main and subordinate node data are inconsistent and can not be quickly accurate Complete the problem of synchronization of data in ground.
One aspect of the present invention provides a kind of synchronous method of MySQL master-slave databases, wherein, primary database is arranged at master It on server, is arranged at from database from server, which is characterized in that include the following steps:
S1:Whether monitoring primary database has new binlog files to generate;
S2:If there is new binlog files generate, then compression is packaged to newly-generated binlog files and to from service Device is sent, if generated without new binlog files, returns to S1;
S3:Unpacking verification is carried out to the compression binlog files of reception from server, obtains partial data, and is preserved to sudden strain of a muscle Restore storage area;
S4:The operation note of flash back memory block is read from database, realizes the precise synchronization of master-slave database.
It is preferred that compression is packaged to newly-generated binlog files in S2 and is included to from server transmission:
Detect network availability bandwidth;
Newly-generated binlog files are carried out according to compressed file number corresponding with the network availability bandwidth detected It is packaged and compresses and sent to from server.
Further preferably, compression is packaged in S2 to newly-generated binlog files and includes following step to being sent from server Suddenly:
Detect network availability bandwidth;
Newly-generated binlog files are packaged compression, afterwards, are prolonged according to corresponding with the network availability bandwidth detected The slow time will be packaged compressed file stall and be sent to from server.
Further preferably, compression is packaged in S2 to newly-generated binlog files and before being sent from server, also wrapped Include following steps:
Detect network availability bandwidth;
The transmission Thread Count of compressed file is set according to transmission Thread Count corresponding with the network availability bandwidth detected.
Further preferably, compression is packaged in S2 to newly-generated binlog files and before being sent from server, also wrapped Include following steps:
Detect network availability bandwidth;
The bandwidth for transmitting compressed file and using is set according to transmission bandwidth corresponding with the network availability bandwidth detected.
The present invention also provides a kind of synchronization system of MySQL master-slave databases, wherein, primary database is arranged at main service On device, it is arranged at from database from server, including:Monitoring unit, file are packaged compression unit, file unpacks verification list Member, flash back memory block and reading unit, wherein,
Monitoring unit is arranged on master server, for monitoring whether primary database has new binlog files to generate;
File is packaged compression unit, is arranged on master server, for when there is new binlog files to generate, to new life Into binlog files be packaged compress and sent to from server;
File unpacks verification unit, is arranged at from server, for being packaged the compression that compression unit is sent to file Binlog files carry out unpacking verification, obtain partial data;
Flash back memory block, is arranged at from server, for preserving the partial data after unpacking;
Reading unit is arranged at from server, for reading the operation note after unpacking from flash back memory block, and it is synchronous Extremely from database.
It is preferred that the synchronization system of the MySQL master-slave databases further includes storage unit and network availability bandwidth detection Unit, wherein, network availability bandwidth detection unit stores network availability bandwidth for detecting network availability bandwidth in storage unit With the table of comparisons of compressed file number, newly-generated binlog files are according to the network availability bandwidth pair with detecting in the table of comparisons The compressed file number answered carries out packing compression.
Further preferably, network availability bandwidth and the table of comparisons of time delay are also stored in the storage unit, it is newly-generated Binlog files be packaged compression after, according to time delay corresponding with the network availability bandwidth detected in the table of comparisons postpone to It is sent from server.
Further preferably, network availability bandwidth is also stored in the storage unit with transmitting the table of comparisons of Thread Count, it is newborn Into binlog files be packaged after compression using the transmission thread biography of number correspondings with the network availability bandwidth of detection in the table of comparisons It send to from server.
Further preferably, network availability bandwidth and the table of comparisons of transmission bandwidth are also stored in the storage unit, is packaged pressure File after contracting is transmitted using transmission bandwidth corresponding with the network availability bandwidth of detection in the table of comparisons.
The synchronous method of MySQL master-slave databases provided by the invention, independently of the delay of MySQL master-slave databases in itself Replicanism is packaged compression by being monitored on master server to binlog files, to binlog files, from server On compressed package unpack verification and store, the backup to binlog files can be realized, when the net of database in itself After network breaks down, master-slave database can not be realized by the late replicating mechanism of database in itself synchronously, at this point it is possible to pass through The binlog files backed up from server are read, realize the flash back from database, which will not occupy database money Binlog files are directly replicated in system level in source, on data store internal without influence, make up current MySQL database The shortcomings that data manipulation fault-tolerance of framework is weak.
The synchronization system of MySQL master-slave databases provided by the invention, by master server set monitoring unit and File is packaged compression unit, file is being set to unpack verification unit and flash back memory block from server, can realize pair The backup of binlog files, when database network in itself breaks down after, master-slave database can not be by database in itself Late replicating mechanism is realized synchronously, at this point it is possible to by reading the binlog files backed up in flash back memory block, is realized from data The flash back in storehouse, the synchronous method will not occupy database resource, directly binlog files be replicated in system level, logarithm According to the data manipulation fault-tolerance that current MySQL database framework without influence, is made up inside storehouse it is weak the shortcomings that.
Description of the drawings
Below in conjunction with the accompanying drawings and embodiment the present invention is described in further detail:
Fig. 1 is the flow chart of the synchronous method of MySQL master-slave databases provided by the invention.
Specific embodiment
The present invention is further explained below in conjunction with specific embodiment, but the not limitation present invention.
As shown in Figure 1, the present invention provides the synchronous method of MySQL master-slave databases, wherein, primary database is arranged at master It on server, is arranged at from database from server, which is characterized in that include the following steps:
S1:Whether monitoring primary database has new binlog files to generate;
S2:If there is new binlog files generate, then compression is packaged to newly-generated binlog files and to from service Device is sent, if generated without new binlog files, returns to S1;
S3:Unpacking verification is carried out to the compression binlog files of reception from server, obtains partial data, and is preserved to sudden strain of a muscle Restore storage area;
S4:The operation note of flash back memory block is read from database, realizes the precise synchronization of master-slave database.
The synchronous method of the MySQL master-slave databases, independently of the late replicating mechanism of MySQL master-slave databases in itself, By being monitored on master server to binlog files, to binlog files be packaged compression, from server to compression Bag is carried out unpacking verification and stored, and can realize the backup to binlog files, when event occurs in the network of database in itself After barrier, master-slave database can not be realized by the late replicating mechanism of database in itself synchronously, at this point it is possible to by reading from clothes The binlog files backed up on business device, realize the flash back from database, which will not occupy database resource, in system Level directly replicates binlog files, on data store internal without influence, makes up the data of current MySQL database framework The shortcomings that operation fault tolerance is weak.
As the improvement of technical solution, compression is packaged to newly-generated binlog files in S2 and is wrapped to being sent from server It includes:
Detect network availability bandwidth;
Newly-generated binlog files are carried out according to compressed file number corresponding with the network availability bandwidth detected It is packaged and compresses and sent to from server.
By the way that newly-generated binlog files packing is compressed into multiple files, transmission risk can be reduced, afterwards, is being solved When bag verification, if it find that vicious compressed package files, can individually transmit broken parts again, without whole weights New transmission, can improve efficiency of transmission.
As the improvement of technical solution, newly-generated binlog files are packaged compression in S2 and are wrapped to being sent from server Include following steps:
Detect network availability bandwidth;
Newly-generated binlog files are packaged compression, afterwards, are prolonged according to corresponding with the network availability bandwidth detected The slow time will be packaged compressed file stall and be sent to from server.
Newly-generated binlog files are packaged as the improvement of technical solution, in S2 and compresses and sends it to from server Before, further include following steps:
Detect network availability bandwidth;
The transmission Thread Count of compressed file is set according to transmission Thread Count corresponding with the network availability bandwidth detected.
Newly-generated binlog files are packaged as the improvement of technical solution, in S2 and compresses and sends it to from server Before, further include following steps:
Detect network availability bandwidth;
The bandwidth for transmitting compressed file and using is set according to transmission bandwidth corresponding with the network availability bandwidth detected.
The present invention also provides a kind of synchronization system of MySQL master-slave databases, wherein, primary database is arranged at main service On device, it is arranged at from database from server, including:Monitoring unit, file are packaged compression unit, file unpacks verification list Member, flash back memory block and reading unit, wherein,
Monitoring unit is arranged on master server, for monitoring whether primary database has new binlog files to generate;
File is packaged compression unit, is arranged on master server, for when there is new binlog files to generate, to new life Into binlog files be packaged compress and sent to from server;
File unpacks verification unit, is arranged at from server, for being packaged the compression that compression unit is sent to file Binlog files carry out unpacking verification, obtain partial data;
Flash back memory block, is arranged at from server, for preserving the partial data after unpacking;
Reading unit is arranged at from server, for reading the operation note after unpacking from flash back memory block, and it is synchronous Extremely from database.
The synchronization system of the MySQL master-slave databases, by the way that monitoring unit and file is set to be packaged pressure on master server Contracting unit is setting file to unpack verification unit and flash back memory block from server, can realize to the standby of binlog files Part, after the network of database in itself breaks down, master-slave database can not be real by the late replicating mechanism of database in itself It is now synchronous, at this point it is possible to by reading the binlog files backed up in flash back memory block, realize the flash back from database, this is same One step process will not occupy database resource, directly binlog files be replicated in system level, to data store internal without shadow Ring, make up current MySQL database framework data manipulation fault-tolerance it is weak the shortcomings that.
As the improvement of technical solution, the synchronization system of the MySQL master-slave databases further includes storage unit and network can With bandwidth detection unit, wherein, network availability bandwidth detection unit stores net for detecting network availability bandwidth in storage unit Network available bandwidth and the table of comparisons of compressed file number, newly-generated binlog files are according to the network with detecting in the table of comparisons The corresponding compressed file number of available bandwidth carries out packing compression.
As the improvement of technical solution, network availability bandwidth and the table of comparisons of time delay are also stored in storage unit, newly After the binlog files of generation are packaged compression, prolong according to time delay corresponding with the network availability bandwidth detected in the table of comparisons It is sent late to from server.
Network availability bandwidth is also stored as the improvement of technical solution, in storage unit with transmitting the table of comparisons of Thread Count, The transmission line of number corresponding with the network availability bandwidth of detection in the table of comparisons is used after newly-generated binlog files packing compression Journey is sent to from server.
As the improvement of technical solution, network availability bandwidth and the table of comparisons of transmission bandwidth are also stored in storage unit, is beaten Compressed file is wrapped to be transmitted using transmission bandwidth corresponding with the network availability bandwidth of detection in the table of comparisons.
The specific embodiment of the present invention is write according to progressive mode, highlights each embodiment Difference, similar portion can be with cross-reference.
Embodiments of the present invention are elaborated above in conjunction with attached drawing, but the present invention is not limited to above-mentioned implementations Mode, within the knowledge of a person skilled in the art, can also be on the premise of present inventive concept not be departed from Various changes can be made.

Claims (10)

  1. The synchronous method of 1.MySQL master-slave databases, wherein, primary database is arranged on master server, is arranged at from database From server, which is characterized in that include the following steps:
    S1:Whether monitoring primary database has new binlog files to generate;
    S2:If there is new binlog files generate, then newly-generated binlog files are packaged and compress and sent out to from server It send, if generated without new binlog files, returns to S1;
    S3:Unpacking verification is carried out to the compression binlog files of reception from server, partial data is obtained, and preserves to flash back and deposit Storage area;
    S4:The operation note of flash back memory block is read from database, realizes the precise synchronization of master-slave database.
  2. 2. the synchronous method of MySQL master-slave databases described in accordance with the claim 1, it is characterised in that:To newly-generated in S2 Binlog files are packaged compression and include to from server transmission:
    Detect network availability bandwidth;
    Newly-generated binlog files are packaged according to compressed file number corresponding with the network availability bandwidth detected It compresses and is sent to from server.
  3. 3. the synchronous method of MySQL master-slave databases described in accordance with the claim 1, it is characterised in that:To newly-generated in S2 Binlog files are packaged compression and include the following steps to from server transmission:
    Detect network availability bandwidth;
    Newly-generated binlog files are packaged compression, afterwards, during according to delay corresponding with the network availability bandwidth detected Between will be packaged compressed file stall and be sent to from server.
  4. 4. the synchronous method of MySQL master-slave databases described in accordance with the claim 1, it is characterised in that:To newly-generated in S2 Binlog files are packaged compression and before being sent from server, further include following steps:
    Detect network availability bandwidth;
    The transmission Thread Count of compressed file is set according to transmission Thread Count corresponding with the network availability bandwidth detected.
  5. 5. the synchronous method of MySQL master-slave databases described in accordance with the claim 1, it is characterised in that:To newly-generated in S2 Binlog files are packaged compression and before being sent from server, further include following steps:
    Detect network availability bandwidth;
    The bandwidth for transmitting compressed file and using is set according to transmission bandwidth corresponding with the network availability bandwidth detected.
  6. The synchronization system of 6.MySQL master-slave databases, wherein, primary database is arranged on master server, is arranged at from database From server, which is characterized in that including:Monitoring unit, file are packaged compression unit, file unpacks verification unit, flash back is deposited Storage area and reading unit, wherein,
    Monitoring unit is arranged on master server, for monitoring whether primary database has new binlog files to generate;
    File is packaged compression unit, is arranged on master server, for when there is new binlog files to generate, to newly-generated Binlog files, which are packaged, to be compressed and is sent to from server;
    File unpacks verification unit, is arranged at from server, for being packaged the compression that compression unit is sent to file Binlog files carry out unpacking verification, obtain partial data;
    Flash back memory block, is arranged at from server, for preserving the partial data after unpacking;
    Reading unit is arranged at from server, for from flash back memory block read unpack after operation note, and be synchronized to from Database.
  7. 7. according to the synchronization system of the MySQL master-slave databases described in claim 6, it is characterised in that:Further include storage unit With network availability bandwidth detection unit, wherein, network availability bandwidth detection unit is for detecting network availability bandwidth, storage unit The table of comparisons of middle storage network availability bandwidth and compressed file number, newly-generated binlog files according in the table of comparisons with detection To the corresponding compressed file number of network availability bandwidth carry out packing compression.
  8. 8. according to the synchronization system of the MySQL master-slave databases described in claim 7, it is characterised in that:It is also deposited in storage unit Store up network availability bandwidth and the table of comparisons of time delay, after newly-generated binlog files are packaged compression, according in the table of comparisons with The network availability bandwidth corresponding time delay detected postpones to send to from server.
  9. 9. according to the synchronization system of the MySQL master-slave databases described in claim 7, it is characterised in that:It is also deposited in storage unit Store up network availability bandwidth and transmit the table of comparisons of Thread Count, newly-generated binlog files be packaged after compression using in the table of comparisons with The transmission thread that the network availability bandwidth of detection corresponds to number is sent to from server.
  10. 10. according to the synchronization system of the MySQL master-slave databases described in claim 7, it is characterised in that:It is also deposited in storage unit Network availability bandwidth and the table of comparisons of transmission bandwidth are stored up, compressed file is packaged and can use using the network with detection in the table of comparisons The corresponding transmission bandwidth of bandwidth is transmitted.
CN201711356578.0A 2017-12-16 2017-12-16 The synchronous method and synchronization system of MySQL master-slave databases Pending CN108052623A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201711356578.0A CN108052623A (en) 2017-12-16 2017-12-16 The synchronous method and synchronization system of MySQL master-slave databases

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201711356578.0A CN108052623A (en) 2017-12-16 2017-12-16 The synchronous method and synchronization system of MySQL master-slave databases

Publications (1)

Publication Number Publication Date
CN108052623A true CN108052623A (en) 2018-05-18

Family

ID=62133281

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201711356578.0A Pending CN108052623A (en) 2017-12-16 2017-12-16 The synchronous method and synchronization system of MySQL master-slave databases

Country Status (1)

Country Link
CN (1) CN108052623A (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109361748A (en) * 2018-10-24 2019-02-19 杭州数梦工场科技有限公司 Binlog document down loading method, device, equipment and readable storage medium storing program for executing
CN109522152A (en) * 2018-09-06 2019-03-26 清华大学 Electron microscopic data disaster recovery method, storage medium and device
CN110489092A (en) * 2019-08-27 2019-11-22 四川长虹电器股份有限公司 The solution of data latency issues is read under a kind of data base read-write separation architecture

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102075441A (en) * 2011-02-24 2011-05-25 福建星网锐捷网络有限公司 Method and device for updating and releasing link bandwidth information and network equipment
CN102404182A (en) * 2010-09-07 2012-04-04 中国移动通信集团公司 Transmission control method and device
US20140218379A1 (en) * 2013-02-07 2014-08-07 Nvidia Corporation Device, system and method for transferring network data
CN105608229A (en) * 2016-01-29 2016-05-25 锐达互动科技股份有限公司 System and method for synchronizing master-slave databases
CN106354865A (en) * 2016-09-09 2017-01-25 北京奇虎科技有限公司 Method, device and system for synchronizing master database and secondary database
CN107391628A (en) * 2017-06-30 2017-11-24 北京奇虎科技有限公司 Method of data synchronization and device

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102404182A (en) * 2010-09-07 2012-04-04 中国移动通信集团公司 Transmission control method and device
CN102075441A (en) * 2011-02-24 2011-05-25 福建星网锐捷网络有限公司 Method and device for updating and releasing link bandwidth information and network equipment
US20140218379A1 (en) * 2013-02-07 2014-08-07 Nvidia Corporation Device, system and method for transferring network data
CN105608229A (en) * 2016-01-29 2016-05-25 锐达互动科技股份有限公司 System and method for synchronizing master-slave databases
CN106354865A (en) * 2016-09-09 2017-01-25 北京奇虎科技有限公司 Method, device and system for synchronizing master database and secondary database
CN107391628A (en) * 2017-06-30 2017-11-24 北京奇虎科技有限公司 Method of data synchronization and device

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
YUBIAO WANG ET AL: "Research on Incremental Heterogeneous Database Synchronization Update Based on Web Service", 《2015 INTERNATIONAL CONFERENCE ON COMPUTATIONAL INTELLIGENCE AND COMMUNICATION NETWORKS (CICN)》 *
姚祥龙: "一种通用分布式异构数据同步系统设计与实现", 《中国优秀硕士学位论文全文数据库 信息科技辑》 *

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109522152A (en) * 2018-09-06 2019-03-26 清华大学 Electron microscopic data disaster recovery method, storage medium and device
CN109522152B (en) * 2018-09-06 2021-05-14 清华大学 Disaster recovery method, storage medium and device for electron microscope data
CN109361748A (en) * 2018-10-24 2019-02-19 杭州数梦工场科技有限公司 Binlog document down loading method, device, equipment and readable storage medium storing program for executing
CN109361748B (en) * 2018-10-24 2021-04-20 杭州数梦工场科技有限公司 Method, device and equipment for downloading Binlog file and readable storage medium
CN110489092A (en) * 2019-08-27 2019-11-22 四川长虹电器股份有限公司 The solution of data latency issues is read under a kind of data base read-write separation architecture
CN110489092B (en) * 2019-08-27 2022-08-16 四川长虹电器股份有限公司 Method for solving read data delay problem under database read-write separation architecture

Similar Documents

Publication Publication Date Title
JP6745884B2 (en) Data synchronization method, device and system
CN108052623A (en) The synchronous method and synchronization system of MySQL master-slave databases
CN106302806A (en) A kind of method of data synchronization, system, synchronous obtaining method and relevant apparatus
CN112118174B (en) Software defined data gateway
CN107247793A (en) The mirror image synchronization method and mirror image synchronization system in Docker mirror images warehouse
CN106598789A (en) Container service disaster recovery method and device, production site and disaster recovery backup site
CN106354865B (en) Method, device and system for synchronizing master database and slave database
CN109032837A (en) The method and apparatus of data backup
CN108804464A (en) Data consistency detection, device, distributed data base and storage medium
CN110581782A (en) Disaster tolerance data processing method, device and system
CN110633168A (en) Data backup method and system for distributed storage system
CN104580432A (en) Memcached system, memory cache data provision method and device, memory cache data maintenance method and device as well as cluster maintenance method and device
CN109584105B (en) Service response method and system
CN105095358A (en) Method and system for acquiring database operation logs
CN108647118B (en) Storage cluster-based copy exception recovery method and device and computer equipment
CN106611001A (en) Method, device and system for checking consistency of data in database tables in virtual machines
CN109241182B (en) Big data real-time synchronization method and device, computer equipment and storage medium
CN110351313B (en) Data caching method, device, equipment and storage medium
CN114070739A (en) Cluster deployment method, device, equipment and computer readable storage medium
CN106844694B (en) Method and apparatus for synchrodata
KR102225815B1 (en) Managing data feeds
CN106850724A (en) Data push method and device
TW201238288A (en) Backup server, system and method for recovering client devices register at primary server
CN113407340A (en) Service control system, gateway service method, service request forwarding method and device
CN109831473A (en) Logistics service providing method and equipment

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
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20180518