Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

A method and system for database service to prevent dual master node using HA

A database and master node technology, which is applied to the redundancy in hardware for data error detection, electrical digital data processing, response error generation, etc. Undamaged effect

Active Publication Date: 2019-02-15
WUHAN DAMENG DATABASE
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When dual master nodes appear, it will cause the database instances of the master and slave machines to access the same data file at the same time, resulting in fatal damage to the data file

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
  • A method and system for database service to prevent dual master node using HA
  • A method and system for database service to prevent dual master node using HA
  • A method and system for database service to prevent dual master node using HA

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0032] Such as Figures 1 to 4 As shown, a database service uses HA to prevent the method of dual master nodes, which includes the following steps:

[0033] S1. In the dual-machine HA cluster system, set the local listening port in the database service on the main machine and the standby machine respectively. Before the database instance is started, it first listens to the local listening port to receive connections from other database instances targeting the local listening port. ;

[0034] S2. In the dual-machine HA cluster system, set the connection IP address of the peer server in the database service on the master machine and the standby machine respectively, and use this IP address to connect to the listening port of the peer server before starting the local database instance;

[0035] S3. In the dual-machine HA cluster system, when the HA cluster resource manager starts the resources of the database service, the database service first listens to the monitoring port set...

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

A method for database service to prevent dual master node using HAis provided, The method includes such steps as setting up local listening port in database service of host and standby in HA cluster system, monitoring local listening port before database instance is started, receiving connection of other database instance to local listening port, setting up local listening port in HA cluster system, setting up local listening port in HA cluster system, setting up local listening port in HA cluster system, setting up local listening port in HA cluster system, setting up local listening port inHA cluster system, setting up local listening port in HA cluster system, setting local listening port in HA cluster system, setting local listening port in HA cluster system, setting local listening port in HA cluster system. S2, in the dual-computer HA cluster system, the connection IP address of the opposite end server is respectively set in the database service of the host computer and the standby computer; S3, in the dual-machine HA cluster system, when the HA cluster resource manager starts the resources of the database service, the database service first listens to the monitoring port set locally for preventing the dual-master, and then connecting the monitoring port of the database service of the peer through the set peer server IP; S4, executing the startup process of the local database instance and other startup processes in the HA cluster system until the dual-machine HA cluster system is successfully started.

Description

technical field [0001] The invention relates to the technical field of server clusters, in particular to a method and a system for preventing double-master nodes by using HA for database services. Background technique [0002] High Availability Cluster (High Availability Cluster) is a server cluster technology, which is an effective solution to improve the availability of system services and ensure the continuity of business systems. In the master-slave dual-machine HA cluster system, the main machine provides external services, while the standby machine is in a monitoring and ready state; when the main machine is unavailable due to system hardware or software errors, the standby machine can be used without manual intervention. Automatically detect faults, and automatically switch services, take over all the work of the host, and automatically ensure that the system continues to provide services to the outside world. In order to ensure the data consistency of the master and...

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/20
CPCG06F11/2028G06F11/2046G06F2201/82G06F2201/80
Inventor 付铨孙峰赵家威杨春
Owner WUHAN DAMENG DATABASE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com