I have a freshly build cluster as of yesterday. All three nodes syncing and working great. Added one test database and it worked fine. Then , added some user permissions to the DB and the entire cluster failed. Mysql will not start. So i built it again- Created a small test DB- and it crashed.
When it crashes it takes the MSQL down. Rendering it unable to restart. Where am I going wrong,
Jul 02 06:54:19 ussigatxpercona001p mysql-systemd[11572]: /usr/bin/mysql-systemd: line 283: kill: (11526) - No such process
Jul 02 06:54:19 ussigatxpercona001p mysql-systemd[11572]: ERROR! Failed to stop the server with PID: 11526 with 1 status
Jul 02 06:54:19 ussigatxpercona001p systemd[1]: mysql.service: control process exited, code=exited status=1
Jul 02 06:54:19 ussigatxpercona001p mysql-systemd[11603]: /usr/bin/mysql-systemd: line 226: kill: (11526) - No such process
Jul 02 06:54:19 ussigatxpercona001p mysql-systemd[11603]: WARNING: mysql already dead
Jul 02 06:54:19 ussigatxpercona001p mysql-systemd[11603]: ERROR! Stale PID file: /run/mysqld/mysql.pid
Jul 02 06:54:19 ussigatxpercona001p systemd[1]: mysql.service: control process exited, code=exited status=3
Jul 02 06:54:19 ussigatxpercona001p systemd[1]: Failed to start Percona XtraDB Cluster.
Jul 02 06:54:19 ussigatxpercona001p systemd[1]: Unit mysql.service entered failed state.
Jul 02 06:54:19 ussigatxpercona001p systemd[1]: mysql.service failed.