1、一、安装1、每个节点做相同的操作 tar xzf mysql-cluster-gpl-7.2.8-l足毂忍珩inux2.6-i686.tar.gz mv mysql-cluster-gpl-7.2.8-linux2.6-i686 /usr/local/mysql2、SQL节点安装 groupadd mysql useradd -g mysql mysql chown -R root /usr/local/mysql chown -R mysql /usr/local/mysql/data chgrp -R mysql /usr/local/mysql /usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql cp /usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf 开机启动： cp support-files/mysql.server /etc/rc.d/init.d/ chmod +x /etc/rc.d/init.d/mysql.server chkconfig --add mysql.server 3、存储节点 cp bin/ndbd /usr/local/bin/ cp bin/ndbmtd /usr/local/bin/ chmod +x /usr/local/bin/* 4、管理节点 cp /usr/local/mysql/bin/ndb_mgm* /usr/local/bin/ chmod + /usr/local/bin/*二、节点配置1、配置存储节点和SQL(API)节点 [mysqld] ndbcluster ndb-connectstring=mongo2 #enable the NDB storage engine[mysql_cluster]ndb-connectstring=mongo22、配置管理节点[ndbd default]NoOfReplicas=2 # Number of replicasDataMemory=80M # How much memory to allocate for data storageIndexMemory=18M # How much memory to allocate for index storage # For DataMemory and IndexMemory, we have used the # default values. Since the "world" database takes up # only about 500KB, this should be more than enough for # this example Cluster setup.# TCP/IP options:[tcp default]portnumber=2202 # This the default; however, you can use any # port that is free for all the hosts in cluster # Note: It is recommended beginning with MySQL 5.0 that # you do not specify the portnumber at all and simply allow # the default value to be used instead# Management process options:[ndb_mgmd]hostname=mongo2 # Hostname or IP address of MGM nodedatadir=/var/lib/mysql-cluster # Directory for MGM node logfiles# Options for data node "A":[ndbd] # (one [NDBD] section per data node)hostname=mongo1 # Hostname or IP addressdatadir=/usr/local/mysql/data # Directory for this data node's datafiles# Options for data node "B":[ndbd]hostname=ndbd.com # Hostname or IP addressdatadir=/usr/local/mysql/data # Directory for this data node's datafiles# SQL node options:[mysqld]hostname=sqld.com # Hostname or IP address # (additional mysqld connections can be # specified for this node for various # purposes such as running ndb_restore)三、首次启动节点 1、启动管理节点 /usr/local/mysql/bin/ndb_mgmd --configdir=/var/lib/mysql-cluster -f /var/lib/mysql-cluster/config.ini 2、启动数据节点 /usr/local/mysql/bin/ndbd --initial （成功后出现以下提示）
2、启动SQL节点 /usr/local/mysql/bin/mysqld_safe &4、检查状态 /usr/local/mysql/bin/ndb_mgm -e show如图：
3、四、测试服务是否正常在S兑恶铼融QL节点上执行如下数据库操作： 报错：Could not connect to storage engine ，sql节点没有连接到管理节点。 /usr/local/mysql/bin/mysql -uroot -pmysql> create database clusterdb;use clusterdb;mysql> create table simples (id int not null primary key) engine=ndb;mysql> insert into simples values (1),(2),(3),(4);mysql> select * from simples; 如果出现如图则表示工作正常。
4、五、安全关闭和重启 1、关闭mysql集群，可在管理节点在执行如下命令： /usr/local/mysql/bin/ndb_mgm -e shutdown 所有节点将关闭，sql节点需要重新关闭再启动。 3 stop -f 2、重启管理节点 /usr/local/mysql/bin/ndb_mgmd --configdir=/var/lib/mysql-cluster -f /var/lib/mysql-cluster/config.ini 3、重启数据节点 /usr/local/mysql/bin/ndbd
5、测试: 架构：1api 1mgm 2ndbd mgm端：./ndb_mgm ndb_mgm>show #查看集群状态
6、ndb_mgm>2 stop #停止数据节点的其中master节点，备份节点自动顶替成主节点。
