Data operation method and system of distributed database cluster

Abstract

The invention relates to the technical field of database clusters and discloses a data operation method and system of a distributed database cluster. The method comprises the following steps: receiving a data operation request of a user, and identifying types of data operation; simultaneously setting a queue and a cache region; storing data of non-inquiry operation into the cache region while storing the non-inquiry operation into the queue; processing the non-inquiry operation by a primary library through the queue and returning an operation state message; processing inquiry operation by a secondary library, and extracting and filtering data which exist in the secondary library and the cache region at the same time from the cache region and the secondary library; and taking the filtered data as an inquiry result to be returned. According to the technical scheme, high-occurrence and safe data operation is realized through controlling the queue and the cache region.

Description

technical field [0001] The invention relates to the technical field of database clusters, in particular to a data operation method and system for distributed database clusters. Background technique [0002] The development of the Internet, especially the mobile Internet, has brought great challenges to traditional database data management. With the help of the Internet, data operations can be carried out at any time and place. The original centralized management database handles high concurrent transactions Both capacity and fault tolerance are difficult to guarantee the security and integrity of data. [0003] For example, for multiple remote nodes to perform data input and query operations at the same time, traditional centralized databases usually use read-write control to perform sequential operations, but this method reduces processing efficiency and seriously affects overall performance; It causes the user to wait longer and degrades the user experience. Therefore, i...

AI Technical Summary

Problems solved by technology

[0002] The development of the Internet, especially the mobile Internet, has brought great challenges to traditional database data management. With the help of the Internet, data operations can be carried out at any time and place. The original centralized management database handles high concurrent transactions Capability and fault tolerance are difficult to guarantee the security and integrity of data

[0003] For example, for multiple remote nodes to perform data input and query operations at the same time, traditional centralized databases usually use read-write control to perform sequential operations, but this method reduces processing efficiency and seriously affects overall performance; Causes users to wait longer and degrades user experience

Therefore, in the prior art, a master-slave library method has further appeared to improve the efficiency of data operations. The master-slave library realizes concurrent reading and writing through backup and synchronization, but it also has obvious defects: the master-slave library can only guarantee different types of data operations Parallel processing, parallel processing of similar operations can easily cause data and database damage; the logic of parallel processing of read and write operations on the same data is complex, and it is difficult to ensure that users obtain correct data

Images