mysql-cluster 7.4.6集群安装部署-方法1

1.软件环境：
OS:linux as 6.5
mysql:mysql-cluster-advanced-7.4.6

2.集群环境：
管理(MGM)节点"node1":192.168.168.129
MySQL服务器(SQL)节点"node2":192.168.168.137
数据(NDBD)节点"node3":192.168.168.133
数据(NDBD)节点"node4":192.168.168.135

3.Sql节点以及Ndb节点安装步骤：

 tar zxvf mysql-cluster-advanced-7.4.6-linux-glibc2.5-x86_64.tar.gz  
 mv mysql-cluster-advanced-7.4.6-linux-glibc2.5-x86_64 /usr/local/mysql

cd /usr/local/mysql/scripts
./mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
cp support-files/mysql.server /etc/rc.d/init.d/mysqld
 chown -R mysql:mysql /usr/local/mysql/
 service mysqld start


4.管理节点安装步骤：
 tar zxvf mysql-cluster-advanced-7.4.6-linux-glibc2.5-x86_64.tar.gz  
 mv mysql-cluster-advanced-7.4.6-linux-glibc2.5-x86_64 /usr/local/mysql


mkdir -p /var/lib/mysql-cluster
vi /var/lib/mysql-cluster/config.ini
[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


# TCP/IP options:
[tcp default]
portnumber=2202   # This the default; however, you can use any port that is free




# Management process options:
[ndb_mgmd]
hostname=192.168.168.129           # Hostname or IP address of management node
datadir=/var/lib/mysql-cluster  # Directory for management node log files

# SQL node options "node2":
[mysqld]
hostname=192.168.168.137           # Hostname or IP address


# Options for data node "node3":
[ndbd]
                                # (one [ndbd] section per data node)
hostname=192.168.168.133           # Hostname or IP address
datadir=/usr/local/mysql/data   # Directory for this data node's data files

# Options for data node "node4":
[ndbd]
                                # (one [ndbd] section per data node)
hostname=192.168.168.135           # Hostname or IP address
datadir=/usr/local/mysql/data   # Directory for this data node's data files


5.配置MySQL server (SQL) node2:
vi /etc/my.cnf
#ptions for mysqld process:
[mysqld]
ndbcluster                      # run NDB storage engine
ndb-connectstring=192.168.168.129  # location of management server


# Options for ndbd process:
[mysql_cluster]
ndb-connectstring=192.168.168.129  # location of management server


6.配置 Data (NDBD) node "node3,node4":
创建/etc/my.cnf文件,并添加下面的内容
#ptions for mysqld process:
[mysqld]
ndbcluster                      # run NDB storage engine
ndb-connectstring=192.168.168.129  # location of management server


# Options for ndbd process:
[mysql_cluster]
ndb-connectstring=192.168.168.129  # location of management server


7.启动Management节点:
ndb_mgmd -f /var/lib/mysql-cluster/config.ini

netstat -ntl |grep 1186

8.启动  Data (NDBD) node "node3"及 Data (NDBD) node "node4":
首次启动需要--initial参数初始化:
/usr/local/mysql/bin/ndbd --initial
下次就可以正常启动了
/usr/local/mysql/bin/ndbd


9.启动  MySQL server (SQL) node
[root@www local]# /etc/init.d/mysql.server start


10.所有的节点都已经起动完成了
[root@www local]# ndb_mgm
ndb_mgm> show


11.测试服务是否正常
在node2:SQL节点上执行如下数据库操作：
/usr/local/mysql/bin/mysql -uroot -p
mysql> 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;

12.启动cluster
1)重启管理节点
/usr/local/mysql/bin/ndb_mgmd  -f /var/lib/mysql-cluster/config.ini
ps -ef |grep ndb_mgmd

2)启数据节点
/usr/local/mysql/bin/ndbd

3)启SQL节点
service mysqld start


13.关闭cluster
1)关闭SQL节点：
service mysqld stop

2)关闭数据节点和管理节点（在管理节点或数据节点执行即可）
/usr/local/mysql/bin/ndb_mgm -e shutdown

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/91975/viewspace-1733107/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/91975/viewspace-1733107/