A method and system data buffering and synchronization under cluster environment

Abstract

The invention provides a cluster environment data caching synchronous method, including the steps that a storage queue is created in server nodes; when caching object in one server node is updated successfully, method name and ordered parameter list table for updating of the caching object are positioned in the queue waiting to be sent; the queue waiting to be sent is checked according to preset time threshold, and method name and ordered parameter list table for updating of the caching object in the queue are packaged into a message body; the packaged message body is sent to all other sever nodes that subscibe the packaged message body; after the other server nodes receive the packaged message body, the method name and the ordered parameter list table are acquired from the packaged message body; The corresponding caching object updating method is matched in the local sever nodes according to the method name and the ordered parameter list table; and the caching object updating method after matching is implemented to update the caching object of the local sever nodes. The caching updating efficiency is enhanced and the network resource and the computer system resource are saved.

Description

technical field [0001] The invention relates to database application technology, in particular to a method and system for data cache synchronization in a cluster environment. Background technique [0002] In the database application system, in order to meet the performance requirements of large-scale applications, there are usually two technical solutions on the server side of the application system: cluster technology and cache technology. Among them, the cluster technology is to enable individual servers to be connected physically and programmatically, and to carry out cooperative communication between servers so that they can perform common tasks; even if a certain server stops running, the emergency process will automatically The server's workload is shifted to another server to ensure continuous service. Therefore, cluster technology can improve the computing power of the system through parallel computing of multiple servers. In order to improve the response speed of ...

AI Technical Summary

Problems solved by technology

[0007] 1. In many cases, only one or more cache objects in the cache area are updated, and the granularity of the updated cache objects is also very small

After receiving the message, other server nodes will re-query the latest data from the database to update the entire cache area. When there are many objects in the cache area, it will consume a lot of performance and waste computer system resources.

[0008] 2. When the cache update frequency is high, other server nodes will receive a lot of messages. Assuming that N queries are executed to obtain the latest data from the database and update the entire cache area, the first N-1 queries are redundant. Therefore, it is also a great waste of computer system resources.

[0011] 1. When the granularity of the updated cache object is large, the cache object is attached to the message body for transmission, which will seriously affect the network bandwidth, waste network resources, and lead to poor performance

[0012] 2. When the frequency of message sending is high, a large number of messages will be broadcast. In severe cases, it will cause network congestion, which greatly wastes network resources.

[0013] To sum up, each existing technical solution to solve the cache synchronization problem alone fails to solve its various shortcomings at the same time.

Images