MySQL Cluster Setup Tutorial-Basic article

Source: Internet
Author: User
Tags mysql cluster setup

Computer-level examination system to use the cluster, the goal is to set up the cluster, to ensure that a library dang, will not affect the operation of the program. So under the leadership of Menghai brother Siang began my first build MySQL cluster, first read some information about the cluster, and then according to step by step of the whole, encountered some problems, here I encountered problems and solutions to share.

"What is it?"

Cluster (cluster) technology is a relatively new technology, through clustering technology, can be paid at a lower cost in the performance, reliability, flexibility of relatively high returns, and its task scheduling is the core technology in the cluster system.

MySQL Cluster technology provides redundancy for MySQL data in distributed system, and enhances security, so that single MySQL server failure does not have a huge negative effect on the system, and the stability of the system is guaranteed.



A MySQL cluster consists of three nodes: the management node, the data node, and the SQL node. The boot order is: Management node, data node, SQL node. The management node can only be one, and the data nodes and SQL nodes may be set as many as needed.

Management node: (also known as the Management Server) is primarily responsible for managing data nodes and SQL nodes, as well as cluster configuration files and cluster log files. It monitors the working state of other nodes and is capable of starting, shutting down, or restarting a node. The other nodes retrieve the configuration data from the management node and send the event information to the management node and write to the cluster log when the data node has a new event.

Data node: Responsible for storing data

SQL node: Use it for SQL operations.


"Why"

Why to use the cluster also through its advantages, the cluster with a lower cost, in terms of performance, flexible availability of a great improvement


"Advantages"

High scalability: Server clusters are highly scalable. As demand and load grow, more servers can be added to the cluster system. In such a configuration, multiple servers can perform the same application and database operations.


High availability: The ability to prevent system failures or to recover automatically from failures without the need for operator intervention. By moving applications on a failed server to a backup server, the cluster system can increase uptime to more than 99.9%, significantly reducing server and application downtime.


High manageability: System administrators can remotely manage one or even a group of clusters as if they were in a standalone system.


"Disadvantage"

We know that the application in the cluster runs on only one server, and if the application fails, one of the other servers restarts the application, taking over the data area on the shared enclosure, and then re-functioning the application. We know that the entire application process takes three steps in general: Detect and confirm the failure, the backup server restarts the app, takes over the shared data area. Therefore, in the process of switching to spend a certain amount of time, in principle, depending on the size of the application to switch the time will be different, the larger the application of the longer the switch time.

"Summary"

This is the first blog of MySQL cluster, mainly introduces the basic knowledge of the cluster, the origin of the cluster, why use, as well as the advantages and disadvantages of the cluster, the next blog on the MySQL cluster in the Windows environment of the building process and in the construction process encountered problems and solutions.


MySQL Cluster Setup Tutorial-Basic article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.