mysql集群
①版本:mysql-cluster-gpl-7.5.9-linux-glibc2.12-x86_64
②概述:
三台服务器:
xxx.xx.xxx.1: 管理节点, sql节点
xxx.xx.xxx.2: 数据节点(1) sql节点
xxx.xx.xxx.3: 数据节点 (2) sql节点
③配置文件:
config.ini
[ndbd default]
NoOfReplicas=2
DataMemory=80M
IndexMemory=18M
[mysqld default]
[ndb_mgmd default]
[tcp default]
Cluster Control / Management node
[ndb_mgmd]
hostname=xxx.xx.xx.1
datadir=/var/lib/mysql-cluster/cluster-data
NodeId=1
MaxNoOfAttributes=5000000
MaxNoOfConcurrentTransactions=1000000
MaxNoOfConcurrentOperations=1000000
Data Node 1
[ndbd]
hostname=xxx.xx.xxx.2
datadir=/usr/local/mysql/data
NodeId=2
MaxNoOfAttributes=5000000
MaxNoOfConcurrentTransactions=1000000
MaxNoOfConcurrentOperations=1000000
Data Node 2
[ndbd]
hostname=xxx.xx.xxx.3
datadir=/usr/local/mysql/data
NodeId=3
MaxNoOfAttributes=5000000
MaxNoOfConcurrentTransactions=1000000
MaxNoOfConcurrentOperations=1000000
SQL Node
[mysqld]
hostname=xxx.xx.xxx.1
NodeId=4
[mysqld]
hostname=xxx.xx.xxx.2
NodeId=5
[mysqld]
hostname=xxx.xx.xxx.3
NodeId=6
If you to add new SQL Node
[mysqld]
[mysqld]
[mysqld]
my.cnf(xxx.xx.xxx.2)
jinsan@shopping2:~$ cat /etc/my.cnf
[mysqld]
ndbcluster # run NDB storage engine
datadir=/data/mysql
basedir=/opt/mysql-cluster-gpl-7.5.9-linux-glibc2.12-x86_64
ndb-connectstring=172.17.154.237
user=mysql
sql_mode=NO_ENGINE_SUBSTITUTION #,STRICT_TRANS_TABLES
max_connections=500
interactive_timeout=28800
wait_timeout=28800
explicit_defaults_for_timestamp=true
[mysql_cluster]
ndb-connectstring=172.17.154.237
my.cnf(xxx.xx.xxx.3)
root@shopping3:/home/jinsan# cat /etc/my.cnf
[mysqld]
ndbcluster # run NDB storage engine
datadir=/data/mysql
basedir=/opt/mysql-cluster-gpl-7.5.9-linux-glibc2.12-x86_64
ndb-connectstring=xxx.xx.xxx.1
sql_mode=NO_ENGINE_SUBSTITUTION #,STRICT_TRANS_TABLES
max_connections=500
interactive_timeout=28800
wait_timeout=28800
explicit_defaults_for_timestamp=true
[mysql_cluster]
ndb-connectstring=xxx.xx.xxx.1
④问题:
管理节点,sql节点均正常,
数据节点1正常,
数据节点2启动时:
ndb_mgm> Node 3: Forced node shutdown completed. Occured during startphase 0. Initiated by signal 9.
请问大神原因是什么 ? 该怎么处理? 不是新搭建的集群,是运行一段时间后