MySQL Forums
Forum List  »  NDB clusters

Recommendation for running a MySQL cluster on 3 servers
Posted by: Brian Paquin
Date: June 21, 2018 07:56AM

I have created a MySQL Cluster across 3 physical servers, but I read a post that leads me to worry that I did not set it up properly... (that a failure of 1 server will cause the cluster to shutdown)

management node 1
data node 1

management node 2
sql node 1

sql node 2
data node 2

This is what I see from server1:
$ ndb_mgm -e SHOW
Connected to Management Server at: localhost:1186
Cluster Configuration
[ndbd(NDB)] 2 node(s)
id=1 @ (mysql-5.7.22 ndb-7.6.6, Nodegroup: 0, *)
id=2 @ (mysql-5.7.22 ndb-7.6.6, Nodegroup: 0)

[ndb_mgmd(MGM)] 2 node(s)
id=101 @ (mysql-5.7.22 ndb-7.6.6)
id=102 @ (mysql-5.7.22 ndb-7.6.6)

[mysqld(API)] 5 node(s)
id=53 @ (mysql-5.7.22 ndb-7.6.6)
id=54 @ (mysql-5.7.22 ndb-7.6.6)
id=231 (not connected, accepting connect from
id=232 (not connected, accepting connect from
id=233 (not connected, accepting connect from

Thank you,


Options: ReplyQuote

Written By
Recommendation for running a MySQL cluster on 3 servers
June 21, 2018 07:56AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.