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)

server1:
management node 1
data node 1

server2:
management node 2
sql node 1

server3:
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 @127.0.0.1 (mysql-5.7.22 ndb-7.6.6, Nodegroup: 0, *)
id=2 @10.84.2.13 (mysql-5.7.22 ndb-7.6.6, Nodegroup: 0)

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

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

Thank you,

Brian

Options: ReplyQuote


Subject
Views
Written By
Posted
Recommendation for running a MySQL cluster on 3 servers
751
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.