mysql cluster connection done fro mwrong host ip

12 views
Skip to first unread message

Christophe Dumont

unread,
Dec 8, 2016, 5:51:10 PM12/8/16
to codership
Hello, 

Trying to set up a mysql cluster. 
4 hosts : 1 mgmt server, 2 data nodes and 1 sql node. 

MGMT SERVER : 192.168.56.101
DATA 1 : 192.168.56.102
DATA 2 : 192.168.56.103
SQL : 192.168.56.104

mgmt server config.ini file :

[ndbd default]
NoOfReplicas=2
DataMemory=80M
IndexMemory=18M

[ndb_mgmd]
hostname=192.168.56.101
datadir=/var/lib/mysql-cluster

[ndbd]
hostname=192.168.56.102
datadir=/usr/local/mysql/data

[ndbd]
hostname=192.168.56.103
datadir=/usr/local/mysql/data

[mysqld]
hostname=192.168.56.104

my.cnf file for data1, data2, sql :

[mysqld]
ndbcluster

[mysql_cluster]
ndb-connectstring=192.168.56.101

The SQL cannot connect to the mgmt server, althought ping and telnet 1186 works. The error messages are joigned.

christophe
ndb_mgm_show.PNG
ndbd_sql_node.PNG
Reply all
Reply to author
Forward
0 new messages