Method for realizing high-availability cluster of OpenGauss database

A database and cluster technology, applied in the direction of database design/maintenance, special data processing applications, redundant data error detection in computing, etc., can solve the problems of inability to determine and automatically select a new main database, the possibility of large misuse, Problems such as long-term suspension of database services to achieve the effect of avoiding long-term suspension of services and avoiding manual misoperation

Pending Publication Date: 2022-03-15
MASSIVE CLOUD BEIJING DATA TECH
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] (1) Since it is impossible to quickly detect whether the OpenGauss database is faulty, it will cause the database to suspend services for a long time
[0005] (2) When there are multiple alternative standby databases, it is impossible to determine and automatically select the most suitable new primary database
[0006] (3) The failover command needs to be executed manually, and there is a greater possibility of misoperation

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 realizing high-availability cluster of OpenGauss database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0045] Embodiment 1: a kind of method that realizes OpenGauss database high-availability cluster, this method is by creating a monitoring program independent of OpenGauss database, by this monitoring program OpenGauss database is carried out status detection and status recording, and according to the database that detects and obtains The state is processed accordingly, and the method is implemented according to the following processes: a main library and at least one standby library are built using the stream replication of the OpenGauss database to realize data redundancy; the characteristics of ETCD are used to realize a distributed lock (leader key), the The leader key is created by the monitoring program and the lease period is set. The monitoring program holding the leader key is responsible for renewing the lease regularly. When the lease period is reached, the leader key is automatically released; when there is no leader key holder in the cluster, the monitoring program 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 belongs to the technical field of relational database management and operating systems, and particularly relates to a method for achieving a high-availability cluster of an OpenGauss database and application of the method. According to the method, the monitoring program independent of the OpenGauss database is created, state detection and state recording are conducted on the OpenGauss database through the monitoring program, corresponding processing is conducted according to the database state obtained through detection, a high-availability cluster scheme of the OpenGauss database is achieved, and the high-availability cluster efficiency of the OpenGauss database is improved. And the functions of database availability state automatic detection and node fault rapid processing are supported in the cluster, so that the defects of the OpenGauss database in main database fault automatic detection and standby database lifting operation are overcome, the reliability of the database is remarkably improved, the adverse effect of faults on the use of the database is reduced, and the service life of the database is prolonged. And a powerful technical guarantee is provided for normal performance of the database.

Description

technical field [0001] The invention belongs to the technical field of relational database management and operating system, and in particular relates to a method for realizing a high-availability cluster of an OpenGauss database and an application thereof. Background technique [0002] OpenGauss is an open source relational database management system. Its core is derived from PostgreSQL. As an open source and free database platform, it aims to encourage community contributions and cooperation. At present, the OpenGauss database already supports streaming physical replication (streaming replication) of the pre-written log (WAL). Database users can use streaming replication to realize the playback of the received WAL while receiving the WAL from the main database during the backup process. In this way, a read-only standby database is built. When the read-only standby database is set as a synchronous standby database, it can be guaranteed that after each transaction is successf...

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): G06F11/30G06F11/14G06F16/21
CPCG06F11/302G06F11/3006G06F16/21G06F11/1415
Inventor 潘浩文何小栋
Owner MASSIVE CLOUD BEIJING DATA TECH
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