Main memory database cluster synchronization method and main memory database host

Abstract

An embodiment of the invention discloses a main memory database cluster synchronization method. The method comprises: acquiring a synchronization request instruction sent by a memory database slave, wherein the synchronization request instruction comprises a synchronization offset address; determining whether a difference between a memory address to which data needs to be synchronized currently and the synchronization offset address is greater than an address capacity of an incremental synchronization buffer; if no, sending data that is stored after the synchronization offset address in the incremental synchronization buffer to the memory database slave to implement incremental synchronization; and if yes, sending data that is stored after the synchronization offset address in a persistent data storage file to the memory database slave to implement incremental synchronization. Accordingly, an embodiment of the invention further discloses a memory database host. According to the invention, data consistency between the host and the slave can be ensured, and efficiency of data synchronization and processing performance of the host can be improved.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method for synchronizing a memory database cluster and a memory database host. Background technique [0002] An in-memory database refers to a database in which data is directly operated in memory, and is generally deployed in a cluster. Such a cluster is called an in-memory database cluster. An in-memory database cluster includes an in-memory database host and an in-memory database slave, and data synchronization needs to be maintained between the two. Further, synchronization is divided into full synchronization and incremental synchronization. Full synchronization means that the memory database slave synchronizes all the data of the memory database host at one time. Incremental synchronization means that the memory database slave It should be understood that for the synchronization of large data, the efficiency of performing full synchronization is lower than that of incr...

AI Technical Summary

Problems solved by technology

[0004] However, the above-mentioned existing technologies have the following problems: (1) In the peak period of business or in the case of large concurrent data, it is very likely that the amount of data will exceed the cache size of the incremental synchronization buffer during the flash off period, resulting in a loop in the incremental synchronization buffer Covering the cache will cause data loss and affect the consistency of data between the master and slave machines; (2) when the synchronization offset address exceeds the range of the incremental synchronization buffer area, full synchronization will be performed, which will affect the synchronization efficiency and the memory database host. processing performance

Images