MySQLCluster (MySQL Cluster) initial entry test_mysql

Source: Internet
Author: User
MySQL Cluster bitsCN. comMySQL Cluster is a highly practical and redundant Mysql version suitable for distributed computing environments. It uses the NDB Cluster Storage Engine and allows multiple MySQL servers to run in one Cluster. This storage engine is provided in binary versions of MyQL5.0 and later, and in RPM compatible with the latest Linux version. (Note: To obtain the functions of MySQL Cluster, you must install mysql-server and mysql-max RPM ).

Currently, the operating systems that can run MySQL Cluster include Linux, Mac OS X, and Solaris (some users have reported that MySQL Cluster has been successfully run on FreeBSD, but MySQL AB does not officially support this feature ).

   I. MySQL Cluster overview

MySQL Cluster is a technology that allows you to deploy the "in memory" database Cluster in a non-shared system. Without a shared architecture, the system can use cheap hardware without special requirements for hardware and software. In addition, since each component has its own memory and disk, there is no single point of failure.

MySQL Cluster is composed of a group of computers, each of which runs a variety of processes, including MySQL servers, NDB Cluster data nodes, management servers, and (possibly) dedicated Data Access program. For the relationship between these components in the Cluster, see:
  
All these nodes form a complete MySQL Cluster System. The data is stored in the storage engine of the "NDB storage server", and the table (structure) is saved in the "MySQL server. Applications access these data tables through the "MySQL server", and the cluster management server manages the "NDB storage server" through the management tool (ndb_mgmd ".


By introducing MySQL Cluster into the open source world, MySQL provides Cluster data management with high availability, high performance, and scalability for all people who need it.

   II. basic concepts of MySQL Cluster

"NDB" is a "in-memory" storage engine with high availability and good data consistency.
MySQL Cluster can use a variety of failover and load balancing options to configure the NDB storage engine, but it is the easiest to do this on the storage engine at the Cluster level. The NDB storage engine of MySQL Cluster contains the complete dataset, which depends only on other data in the Cluster.

Currently, the Cluster of the MySQL Cluster can be configured independently of the MySQL server. In MySQL Cluster, each part of the Cluster is considered as one node.

Management (MGM) nodes: These Nodes manage other nodes in the MySQL Cluster, such as providing configuration data, starting and stopping nodes, and running backups. Because these nodes are responsible for managing the configurations of other nodes, they should be started before other nodes are started. The MGM node is started with the command "ndb_mgmd.

Data nodes: These nodes are used to save Cluster data. The number of data nodes is related to the number of copies, which is a multiple of the segments. For example, if two copies have two segments, each of them has four data nodes. However, there is no need to set multiple copies. The data node is started with the "ndbd" command.

SQL node: this is the node used to access Cluster data. For MySQLCluster, the client node is a traditional MySQL server that uses the NDBCluster storage engine. Generally, the SQL node uses the command "mysqld

The above is the content of test_mysql at the beginning of MySQLCluster (MySQL Cluster). For more information, see PHP Chinese network (www.php1.cn )!

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.