Comments on How to Setup Three Node MySQL 8 Cluster on Debian 10

MySQL is a widely-used open source relational database management system. In this tutorial, we will use one master node to store the cluster's configuration and two data nodes to store the cluster data.

2 Comment(s)

Add comment

Please register in our forum first to comment.

Comments

By: Harold Zubieta
Reply  

Thanks for sharing! In my case it threw an error (unable to connect) when executing ndbd on data node. Looks like mysql client needs to be installed first, then it ran fine.

By: hossein
Reply  

Dear jethva

Thank you so much for your realy practical document.

I follow and did your instrauction step by step.

in SQL data nodes when I start data node with command ndbd, I get response like below:

Angel connected to '*****:1186'Failed to allocate nodeid. error: Illegal reply from server

in management cluster everything is OK. and I get result like you when I use this command: mysql> SHOW ENGINE NDB STATUS \G

ndb_mgm> SHOW

I get the following output:

Connected to Management Server at: 104.245.33.61:1186 Cluster Configuration --------------------- [ndbd(NDB)] 2 node(s) id=2 (not connected, accept connecting from *****) id=3 (not connected, accept connecting from *****) [ndb_mgmd(MGM)] 1 node(s) id=1 @**** (mysql-8.0.24 ndb-8.0.24) [mysqld(API)] 1 node(s) id=4 (not connected, accept connecting from *****) I am really confused.in advance i will be indebted to you for your concern.