A database failover method and device based on SAS dual-control equipment

A technology of failover and database, which is applied in the direction of data error detection by redundancy in hardware, error detection by redundancy in operation, electrical digital data processing, etc., and can solve the problem that data synchronization requires a certain amount of time and waste Save storage space and other issues to achieve the effect of saving recovery time, reducing data duplication, saving storage resources and network resources

Active Publication Date: 2019-08-02
BEIJING CERESDATA TECH CO LTD
View PDF8 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This method will waste a lot of storage space, and data synchronization will take a certain amount of time

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 database failover method and device based on SAS dual-control equipment
  • A database failover method and device based on SAS dual-control equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0017] The present invention will be described in detail below in conjunction with the accompanying drawings and embodiments.

[0018] Such as figure 1 As shown, the present invention relates to a database cluster composition structure based on a SAS dual-control device for realizing the above method, including a database cluster monitoring module and a database instance management module, and the database instance management module includes a database state judgment module, a controller state judgment module, and a storage pool state Monitoring module, database instance startup module.

[0019] The database cluster monitoring module is used for: monitoring all the segment data nodes of the database cluster, and sending the information of the failed segment data node to the database status judging module when a segment data node fails.

[0020] The database state judging module is used to: after receiving the information of the faulty segment data node, judge whether the curr...

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 discloses a database failure switching method and configuration based on SAS dual-control equipment, which relates to the field of distributed database high availability. The method comprises the following steps: monitoring the heartbeat of the database on the SAS dual-control device; judging that the database on the end controller is a fault database when the controller or the database link is broken and the controller and the database on the other end can work normally; If the fault controller is not down and the database instance is down, the controller attempts to start the database instance. If the fault controller goes down, it will directly fail over, start the instance of the fault database on the other end of the controller, and switch the storage pool of the fault database to the normal working controller. When the database on the SAS dual-control device fails, the invention can quickly switch the fault database, simultaneously avoids data synchronization and saves storage resources and network resources.

Description

technical field [0001] The invention belongs to the high-availability field of Internet back-end distributed databases, and relates to a failover method for database clusters based on SAS dual-control devices. Background technique [0002] At present, in the high-availability field of Internet back-end distributed databases, failover is usually performed in the form of database mirroring (mirror) pairs. This method will waste a large amount of storage space, and data synchronization requires a certain amount of time. Contents of the invention [0003] In view of the above problems, the purpose of the present invention is to provide a database failover method and equipment based on SAS (Serial Attached SCSI, ie Serial Attached Small Computer System Interface) dual-control equipment. When the Internet back-end distributed database cluster fails, using this method can quickly locate the faulty database node and quickly perform failover operations. The failover of the presen...

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 Patents(China)
IPC IPC(8): G06F11/20G06F11/14
CPCG06F11/1438G06F11/2089G06F2201/80
Inventor 杨刚
Owner BEIJING CERESDATA TECH CO LTD
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