在sql节点机器安装MySQL-Cluster-client-gpl-7.3.5-1.el6.x86_64.rpm
[root@node2 ~]# rpm -Uvh MySQL-Cluster-client-gpl-7.3.5-1.el6.x86_64.rpm
[root@node3 ~]# rpm -Uvh MySQL-Cluster-client-gpl-7.3.5-1.el6.x86_64.rpm
三、配置管理节点
[root@node1 ~]# mkdir /var/lib/mysql-cluster
[root@node1 ~]# cd /var/lib/mysql-cluster/
[root@node1 mysql-cluster]# vim 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
# For DataMemory and IndexMemory,we have used the
# default values.Since the "world" database tabkes up
# only about 500kb, this should be more than enough for
# this example Cluster setup
[ndb_mgmd]
#Management process otions
hostname=192.168.100.10 #Hostname or IP address of MGM node
datadir=/var/lib/mysql-cluster #Directory for MGM node log files
[ndbd]
#Options for data node "A"
hostname=192.168.100.40 #Hostname or IP address
datadir=/usr/local/mysql/data #Directory for this data node's data files
[ndbd]
#Options for data node "B"
hostname=192.168.100.50 #Hostname or IP address
datadir=/usr/local/mysql/data #Directory for this data node's data files
[mysqld]
#SQL node options
hostname=192.168.100.20 #Hostname or IP address
[mysqld]
hostname=192.168.100.30 #Hostname or IP address 四、配置存储节点和SQL节点
存储节点：
[root@node4 ~]# mkdir -p /usr/local/mysql/data
[root@node5 ~]# mkdir -p /usr/local/mysql/data
SQL节点：
[root@node2 ~]# mkdir -p /var/run/mysqld
[root@node2 ~]# chmod -R 777 /var/run/mysqld/
[root@node3 ~]# mkdir -p /var/run/mysqld
[root@node3 ~]# chmod -R 777 /var/run/mysqld/
在所有存储节点和SQL节点上建立配置文件/etc/my.cnf
vim /etc/my.cnf
[client]
socket=/var/lib/mysql/mysql.sock
[mysqld]
max_connections=100
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
ndbcluster
ndb-connectstring=192.168.100.10
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[mysql_cluster]
ndb-connectstring=192.168.100.10
五、启动各个节点
注意顺序。
1. 启动管理节点：
[root@node1 ~]# ndb_mgmd -f /var/lib/mysql-cluster/config.ini
2. 启动存储节点：
[root@node4 ~]# ndbd --initial
[root@node5 ~]# ndbd --initial
初次启动时需要加–initial参数，以后只需要执行ndbd即可；
3. 启动SQL节点：
[root@node2 ~]# mysqld_safe --defaults-file=/etc/my.cnf --explicit_defaults_for_timestamp &
[root@node3 ~]# mysqld_safe --defaults-file=/etc/my.cnf --explicit_defaults_for_timestamp &
六、检查所有节点是否正常启动
在管理节点中执行ndb_mgm 进入集群管理console,使用show命令列出所有节点信息
七、修改root用户密码
在每个sql节点执行
[root@node2 ~]# cat .mysql_secret ----记录安装cluster-server时自动生成的初始密码
# The random password set for the root user at Sat Jun 14 01:20:33 2014 (local time): HtPV2gJbSrRPi8Is
[root@node2 ~]# mysqladmin -uroot -pHtPV2gJbSrRPi8Is password 'zhyzhy'
Warning: Using a password on the command line interface can be insecure. ----此警告提示密码设置过于简单不安全
[root@node2 ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection> Server version: 5.6.17-ndb-7.3.5-cluster-gpl MySQL Cluster Community Server (GPL)
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> exit
Bye
[root@node3 ~]# cat .mysql_secret
# The random password set for the root user at Sat Jun 14 01:21:06 2014 (local time): NtwwjhqTfsqTihGM
[root@node3 ~]# mysqladmin -uroot -pNtwwjhqTfsqTihGM password 'zhyzhy'
Warning: Using a password on the command line interface can be insecure.
[root@node3 ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection> Server version: 5.6.17-ndb-7.3.5-cluster-gpl MySQL Cluster Community Server (GPL)
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> exit
Bye
八、测试集群：
在sql节点 node2上登陆mysql:
[root@node2 ~]# mysql -u root -pzhyzhy
mysql> create database lxw;
Query OK, 1 row affected (0.06 sec)
在sql节点node3上登陆mysql:
[root@node3 ~]# mysql -u root -pzhyzhy
mysql> show databases;
+——————–+
| Database |
+——————–+
| information_schema |
| lxw |
| mysql |
| ndbinfo |
| performance_schema |
| test |
+——————–+
6 rows in set (0.00 sec)
可以看到database已经同步。
九、常用命令：
1) ndb_mgmd管理命令：ndb_mgm
执行之后就是管理控制台了，里面可以继续输入命令。
查看集群里面的全部节点的状态：show
2) 停止集群服务器的命令：ndb_mgm -e shutdown
如果集群配置有更新了：rm /usr/mysql-cluster/ndb_1_config.bin.1
3) 停止SQL节点的命令：mysqladmin -uroot shutdown
4) SQL Node上连接MySQL：mysql -u root –pPASSWORD
执行之后就是MySQL控制台了，里面可以继续输入命令。
QQ群⑧：
窥视卡
雷达卡
发表于 2018-10-2 11:47:54
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
千斤顶
显身卡