Database Cluster (1) MySQLCluster entry, cluster mysqlcluster

Database Cluster (1) MySQLCluster entry, cluster mysqlcluster

Recently, the company is planning to do ITOO products, so preliminary technical research is essential.

This article briefly introduces MySQL Cluster:

(1) Overview

MySQL cluster is a highly redundant version suitable for Distributed Computer environments.

Cluster refers to a group of computers (in some cases, only computer processes) that provide users with a group of network resources as a whole, A single computer system is called a cluster node.

An ideal cluster is that users never realize the underlying nodes of the cluster system. In the user's view, the cluster is a system rather than multiple computer systems.

In addition, the system administrator of the cluster can add or delete nodes of the cluster at will.

Clusters are generally divided into the following two types:

1. high-availability cluster

We are committed to providing highly reliable services to reduce service interruption time. If a node fails, its redundant node takes over his responsibilities in a very short time. For users, the cluster will never stop.

There are two ways to work:

1) Fault Tolerance System: it is usually a master-slave server. Only when the master server is valid, the slave server immediately replaces the master server to provide services to the customer.

2) Server Load balancer system: All nodes in urgent need are active and share the workload of the system.

2. High-Performance Computer Group

HPC clusters are designed to provide powerful computing capabilities that a single computer cannot provide. The problem is divided into several points, and multiple nodes work at the same time to shorten the problem solving time.

(2) Hierarchy

There are three types of nodes:

1. manage nodes

Is the control center of the entire cluster. It is responsible for adding, creating, starting, and stopping each node. When starting a MySQL Cluster, you must first start the management node.

The startup command is ndb_mgmd.

2. Data Node

Used to store data. The cluster must have at least one data node. There are more than two Data nodes to ensure the high availability of the cluster.

Adding data nodes slows down the processing speed of the cluster.

Start command: ndbd

3. SQL Node

Is a common mysqld process used to access Cluster data.

Increasing SQL nodes can improve the concurrent access speed and overall throughput of the entire cluster.

Start command: mysqld-ndbCluster

The hierarchy of MySQL Cluster is as follows:

Application indicates an Application, such as a webpage.

The essence of SQL is the mysqld process, which provides interfaces for reading and writing MySQL database services to other applications.

Storage is the area where data is stored and has high redundancy.

Management is the Management Center of the entire cluster and has the highest control permissions.