Multi Node Mysql cluster setup, API node mysqld not starting.

“See “systemctl status mysqld.service” and “journalctl -xe” for details.”

Answering my own question, I found the solution. Note -: While creating the “mysql” user and group on “manager.mysql.cluster” we are missing to do following, which is stopping Mysqld to start.

1. sudo groupadd mysql
2. sudo useradd -r -g mysql -s /bin/false mysql
3. sudo mkdir -p /data/mysql
4. sudo mkdir /var/lib/mysql-files
5. sudo chown mysql:mysql /var/lib/mysql-files
6. sudo chown mysql:mysql /data/mysql

Rest all the steps are perfectly correct. Now everything is working as expected.

But i want to test actual cluster benefit like taking node-1 down and checking if the web site or application is still working and again starting the node-1 and it should have all the database sync on it.

Kindly shade some light how can we do this practice before using it in real setup.

Thanks Pushkar