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

A clustering and capability technology, applied in the computer field, can solve the problems of large system occupation and limited disaster recovery capability, and achieve the effect of ensuring available functions, improving disaster recovery capability, and high-availability functions.

Active Publication Date: 2020-12-15
重庆紫光华山智安科技有限公司
View PDF6 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and system for improving disaster tolerance capability of PostgreSQL cluster, medium and terminal
  • Method and system for improving disaster tolerance capability of PostgreSQL cluster, medium and terminal
  • Method and system for improving disaster tolerance capability of PostgreSQL cluster, medium and terminal

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0033] The embodiments of the present invention will be described below with reference to the specific examples of the present invention, and those skilled in the art can easily understand other advantages and efficacy of the present invention. The present invention can also be implemented or applied by other embodiments, and various details in this specification may also be based on different viewpoints and applications without departing from the spirit of the invention. It should be noted that the features in the following examples and embodiments may be combined with each other in the case of unlilled.

[0034] It should be noted that the illustrations provided in the following examples will be described only by way of illustration only, and only the components associated with the components associated with the present invention are not in accordance with the actual implementation of the components, shape and Dimensions, the type, number, and proportion of each component can be...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

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...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F11/20G06F16/27
CPCG06F11/2023G06F16/27
Inventor 许克尧
Owner 重庆紫光华山智安科技有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap