Method for constructing PostgreSQL database cluster

A database and cluster technology, applied in the information field, can solve problems such as low efficiency, and achieve the effect of simple mechanism, robust cluster, and shortened fault recovery time.

Pending Publication Date: 2020-07-28
BEIJING XJ ELECTRIC +1
View PDF5 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, existing databases have many inconveniences when establishing and deploying clusters, resulting in very low efficiency

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 for constructing PostgreSQL database cluster

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] In order to make the technical problems, technical solutions and advantages to be solved by the present invention clearer, the following will describe in detail with reference to the drawings and specific embodiments.

[0029] The embodiment of the present invention proposes a method for collaboratively constructing a PostgreSQL database cluster by using a distributed configuration storage system.

[0030] The Distributed Configuration Storage System (DCS) uses key-value storage to store configuration and status information of the PostgreSQL database, and uses REST APIs to interact with the PostgreSQL database. The DCS can be deployed on each node of the cluster in a distributed manner, or can be set separately in a centralized manner; in order to prevent DCS nodes from failing, a large-scale DCS cluster can be applied in the embodiment of the present invention for disaster prevention backup. At the same time, the DCS in the embodiment of the present invention adopts a ...

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 for constructing a PostgreSQL database cluster, which comprises the following steps of initializing an uninitialized node, and adding the node into a candidate node list of a main node; when only one node exists in the candidate node list of the main node, setting the node as the main node and setting the Leader Key parameter of the cluster as the node ID of the node; enabling the main node to start a PostgreSQL instance and initialize a database; after detecting the Leader Key of the cluster, enabling the slave node to start the PostgreSQL instance, and clone the database from the master node into the slave node; enabling other nodes to start a PostgreSQL instance after waiting for a Leader Key in a set cluster, and cloning a database from a master node tobecome slave nodes.

Description

technical field [0001] The embodiment of the present invention relates to the field of information technology, in particular to a method for building a PostgreSQL database cluster together with a distributed key-value storage system. Background technique [0002] With the widespread use of information technology, databases are widely used, among which database clusters can effectively reduce hardware costs and improve database availability. PostgreSQL database is a powerful open source database system widely adopted in various industries. It is very important to deploy and manage a highly available and high performance PostgreSQL database cluster. However, existing databases have many inconveniences when establishing and deploying clusters, resulting in very low efficiency. Contents of the invention [0003] In view of the lack of effective deployment and management of highly available and high-performance PostgreSQL database clusters in the prior art, the embodiment of ...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/21G06F16/27
CPCG06F16/27G06F16/21
Inventor 裴振军缪燕喻翠微
Owner BEIJING XJ ELECTRIC
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