Realization method and system for high-availability and high-performance database cluster

A database and high-performance technology, applied in the field of implementation methods and systems of high-availability and high-performance database clusters, can solve problems such as large data delay, serious data loss, and inability to meet the high-performance and high-availability requirements of cluster systems.

Inactive Publication Date: 2015-06-03
XINYU XINGBANG INFORMATION IND
View PDF3 Cites 39 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The manual switching operation is relatively complicated, and the database downtime is long, resulting in a relatively large data delay when the database synchronizes data between the master and standby machines, the system is unstable, and data loss is particularly serious, which cannot meet the high-performance and high-availability requirements of the cluster system

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
  • Realization method and system for high-availability and high-performance database cluster
  • Realization method and system for high-availability and high-performance database cluster
  • Realization method and system for high-availability and high-performance database cluster

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] The present invention will be described in further detail below in conjunction with the accompanying drawings.

[0031] figure 1 A method for realizing a MySQL database-based high-performance and high-availability cluster is schematically shown according to an embodiment of the present invention. figure 2 schematically shows the basis of figure 1 The frame diagram of the high-performance and high-availability cluster system based on the MySQL database in the embodiment shown.

[0032] In the construction of the server environment in this embodiment, the operating system uses the CentOS 6.4x86_64 version, the distributed replication block device software uses the DRBD8313 version, the high-availability cluster components use the Heartbeat-3037 version, the database uses MySQL, and the multi-master software uses MySQLGalera5.5.29 version of.

[0033]Before the present invention was proposed, the combination of the above-mentioned software was too difficult, and there ...

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 realization method and system for a high-availability and high-performance database cluster. The method comprises the following steps: installing all dependent packages of distributed replicated block equipment software, a high-availability cluster assembly and the multi-master software of a database on a master machine and standby machines in the cluster; establishing the environment of the distributed replicated block equipment software on the master machine and the standby machines in the cluster; establishing the environment of the high-availability cluster assembly on the master machine and the standby machines in the cluster; establishing the multi-master environment of the database on the master machine, the standby machine and slave machines in the cluster; carrying out resource definition on the master machine and the standby machines in the cluster to enable the master machine and the standby machines in the cluster to be mutually switched and enable the salve machines to access the database service of the master machine or the standby machine. According to the realization method and system, free and open source software is used for improving a fault-tolerant function, a seamless handling capability can be provided when a certain node fails, a data loss rate is almost zero, the expandable multi-master node permits multiple computers to simultaneously process a complex data problem, and the database achieves high performance and high availability.

Description

technical field [0001] The invention relates to a database integration system, in particular to a method and system for realizing a high-availability and high-performance database cluster. Background technique [0002] In the current database master-slave architecture, manual switching is used for switching between the master machine and the standby machine. The manual switching operation is relatively complicated, and the database downtime is long, which leads to a relatively large data delay when the database synchronizes data between the master and standby machines, the system is unstable, and data loss is particularly serious, which cannot meet the high-performance and high-availability requirements of the cluster system . Contents of the invention [0003] The object of the present invention is to provide a method and system for realizing a database cluster with high availability and high performance, so as to solve at least one of the above technical problems. [0...

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): G06F17/30
CPCG06F11/2023G06F11/2076G06F11/2097G06F16/27G06F2201/80G06F16/22G06F11/203G06F2201/805
Inventor 姚晓宏周龚
Owner XINYU XINGBANG INFORMATION IND
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