未连接到群集的mysqld节点

Question

我试图设置一个基本的NDB集群，数据节点正确注册，但是mysqld API节点不接受

Connected to Management Server at: 174.138.80.168:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=2    @104.131.16.252  (mysql-5.6.37 ndb-7.4.16, Nodegroup: 0, *)
id=3    @174.138.80.126  (mysql-5.6.37 ndb-7.4.16, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @174.138.80.168  (mysql-5.6.37 ndb-7.4.16)

[mysqld(API)]   1 node(s)
id=4 (not connected, accepting connect from manager.mysql.cluster)

Node经理的my.cnf

[ndb_mgmd]
config-dir=/usr/local/mysql/mysql-cluster
config-file=/usr/local/mysql/mysql-cluster/config.ini

# MySQL Config
[mysqld]
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
user=mysql

# Run ndb storage engine
ndbcluster
# IP address management node
ndb-connectstring=174.138.80.168

# MySQL Pid and Log
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

管理节点的/var/lib/mysql-群集/config.ini文件

[ndb_mgmd]
# Management process options:
hostname=manager.mysql.cluster  # Hostname of the manager
[ndbd]
hostname=node1.mysql.cluster    # Hostname of the first data node
datadir=/var/lib/mysql-cluster   # Remote directory for the data files

[ndbd]
hostname=node2.mysql.cluster    # Hostname of the second data node
datadir=/var/lib/mysql-cluster   # Remote directory for the data files

[mysqld]
# SQL node options:
hostname=manager.mysql.cluster

每个数据节点的/etc/my.cnf文件：

# MySQL Config
[mysqld]
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
user=mysql

# Run ndb storage engine
ndbcluster
# IP address management node
ndb-connectstring=174.138.80.168

[mysql_cluster]
# IP address management node
ndb-connectstring=174.138.80.168

# MySQL Pid and Log
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

谢谢

Answer 1

我想我以前也有过这个问题

再次检查mysql是否已启动

运行以下命令并查看

[root@aba ~]# systemctl status mysqld.service  

活动状态应该是

 Active: active (running) since Wed 2018-02-7 12:50:46  

在建立集群之前