mysql集群搭建及测试

一、安装     1、每个节点做相同的操作         tar xzf mysql-cluster-gpl-7.2.8-linux2.6-i686.tar.gz          mv mysql-cluster-gpl-7.2.8-linux2.6-i686 /usr/local/mysql     2、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=mongo2          2、配置管理节点      [ndbd default]       NoOfReplicas=2    # Number of replicas     DataMemory=80M    # How much memory to allocate for data storage     IndexMemory=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 node     datadir=/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 address     datadir=/usr/local/mysql/data   # Directory for this data node's datafiles     # Options for data node 'B':     [ndbd]                             hostname=ndbd.com       # Hostname or IP address     datadir=/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               （成功后出现以下提示）

3、启动SQL节点          /usr/local/mysql/bin/mysqld_safe  & 4、检查状态          /usr/local/mysql/bin/ndb_mgm -e show如图：

四、测试服务是否正常     在SQL节点上执行如下数据库操作：     报错：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;     如果出现如图则表示工作正常。

五、安全关闭和重启     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

测试:      架构：1api  1mgm  2ndbd      mgm端：./ndb_mgm      ndb_mgm>show               #查看集群状态

ndb_mgm>2 stop          #停止数据节点的其中master节点，备份节点自动顶替成主节点。