Main and auxiliary database synchronization method and device

A primary database and database technology, applied in the field of data processing, can solve the problems of low synchronization efficiency of the primary and standby databases, and achieve the effects of improving synchronization efficiency, reducing delay, and increasing availability
CN103885986AActive Publication Date: 2014-06-25ALIBABA GRP HLDG LTD
5 Cites 35 Cited by

Patent Information

Authority / Receiving Office
CN Β· China
Patent Type
Applications(China)
Current Assignee / Owner
ALIBABA GRP HLDG LTD
Publication Date
2014-06-25

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

Abstract

The invention relates to a main and auxiliary database synchronization method and device for data synchronization between a main database and an auxiliary database. The method includes a transaction distributing step, namely distributing each transaction or transaction identifier read from the main database to writing queues; a transaction writing step, namely writing transactions or transactions with corresponding identifiers, in each writing thread corresponding to each writing thread through multiple writing thread parallel. According to the method, multiple writing threads are adopted to perform writing operations parallelly and simultaneously, delay is reduced, main and auxiliary database synchronization can be realized timely, and synchronization efficiency is improved.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The present application relates to the field of data processing, in particular to a method and device for synchronizing active and standby databases. Background technique

[0002] MySQL is an open source database software widely used in the Internet industry. Many large websites are using MySQL databases. As the business scale continues to grow, a MySQL database will not be able to support a huge amount of visits.

[0003] An effective solution is to establish a MySQL active and standby cluster, and the standby database is a complete mirror image of the primary database. Write requests only fall on the primary database, and read requests are evenly distributed to all databases, so that the entire cluster can provide larger-capacity read-write services. After the MySQL primary database receives the newly added changed data, it uses the synchronization tool to synchronize the changed data to the standby database in real time.

[0004] Mysql binlog log...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More