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.
CN104679907AInactive Publication Date: 2015-06-03XINYU XINGBANG INFORMATION IND

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
XINYU XINGBANG INFORMATION IND
Publication Date
2015-06-03
Estimated Expiration
Not applicable · inactive patent

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

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.
Need to check novelty before this filing date? Find Prior Art

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