Database high availability method and system based on remote direct memory access

Abstract

The invention provides a database high availability method and system based on remote direct memory access. The method comprises the following steps of arranging RDMA interfaces based on an RDMA protocol on a sending module and a receiving module of a database; inserting the generated pre-written log data into a main library cache, and managing the main library cache by adopting a cache elimination algorithm; calling an RDMA (Remote Direct Memory Access) interface of a main library sending module, and sending the pre-written log data newly inserted in the cache of the main library to a standby library; the standby database receiving the pre-written log data and storing the pre-written log data in the cache of the database, data persistence being carried out on the pre-written log data, meanwhile, an RDMA interface of a sending module of the database being called, and the pre-written log data in the cache of the database being sent to the connected standby database through an RoCE network card to be subjected to cascade copying; when the main library breaks down, selecting one standby library and setting as a new main library, and switching the business system of the main library which breaks down to the new main library. The high availability reliability of the database is improved.

Description

technical field [0001] The invention relates to the technical field of database access, in particular to a high-availability method and system for a database based on remote direct memory access. Background technique [0002] In order to ensure the continuous, stable operation and robustness of the business system or metadata database software, it is often necessary to design the metadata database system as a high-availability solution in the stream replication-based high-availability framework. [0003] For example, PostgreSQL is a powerful open source object-relational database system that uses and extends the SQL language and incorporates many features for securely storing and scaling the most complex data workloads. It is currently the most powerful, feature-rich and structured open source database, some of which are not even available in commercial databases. Based on this, PostgreSQL can be used to securely store data and retrieve data when processing requests. It is ...

AI Technical Summary

Problems solved by technology

[0006] For the data to be replicated multiple times in different spaces, sending messages through the system kernel has high data movement and data replication overhead, which will lead to very low performance and flexibility, reduce the efficiency of the streaming replication process, and occupy a large amount of memory Bandwidth and CPU overhead lead to slow database response and even affect the business system. The present invention provides a high-availability method and system for databases based on remote direct memory access to solve the above technical problems

Images