Method and system for improving disaster tolerance capability of PostgreSQL cluster, medium and terminal

Abstract

The invention provides a method and a system for improving the disaster tolerance capability of a PostgreSQL cluster, a medium and a terminal; the method comprises the steps of obtaining a logic relation between a node and the cluster, and updating Internet protocol address information and final updating time information in a database if the node is an external node of the PostgreSQL cluster; if the node is a PostgreSQL cluster internal node, regularly inserting or updating Internet protocol address information and updating time of a to-be-checked node into a database; if the to-be-checked node is a main node, obtaining a service state of the to-be-checked node, and when it is judged that the to-be-checked node is in an abnormal state, taking a first active and available node selected fromthe DBCommon as a new intra-cluster node, updating a database, and deleting abnormal nodes; according to the invention, when the number of PostgreSQL clusters is reduced, the available nodes are actively searched from the storage cluster to replace the offline nodes, and under the condition that the storage cluster has the available nodes, the number of the clusters is kept unchanged, so that a high-availability function can be ensured, and the disaster tolerance capability and the better cluster self-repairing capability are improved.

Description

technical field [0001] The invention relates to the field of computers, in particular to a method, system, medium and terminal for improving the disaster recovery capability of a PostgreSQL cluster. Background technique [0002] In the field of computer storage technology, the stability of storage clusters has always been a concern for everyone. In current cluster applications, the business layer mostly involves PostgreSQL database services. PostgreSQL provides data services for multiple nodes in the entire cluster. The simple way to use it is single-node deployment, that is, select a node in the storage cluster as the PostgreSQL service installation node. The more complicated way of use is to deploy multiple nodes into a PostgreSQL cluster, that is, select a certain number of nodes in the storage cluster to deploy PostgreSQL, and add high-availability technology to achieve high availability of PostgreSQL. [0003] Currently, as far as PostgreSQL is deployed on a single nod...

AI Technical Summary

Problems solved by technology

[0004] However, the scale of this kind of multi-node database cluster will not be too large in actual application, otherwise it will occupy a large amount of system, network and other resources, so its disaster recovery capability is limited during deployment, and it cannot solve the problem of unrecoverable failures in one or more PostgreSQL clusters. Under abnormal circumstances, such as power failure, hardware damage, etc., the disaster recovery capability of the database cluster remains unchanged, resulting in a problem of stable number of database clusters

Images