I wanted to remove a node from a three node cluster. I stopped the two non-bootstrapped nodes. I edited the my.cnf file to remove the one non-bootstrapped node. ran systemctl stop mysql@boostrap.service then ran systemctl start mysql@boostrap.service. I receive the error Job for mysql@boostrap.service failed because a configured resource limit was exceeded. See “systemctl status mysql@boostrap.service” and “journalctl -xe” for details. systemctl status shows
systemctl status mysql@boostrap.service
● mysql@boostrap.service - Percona XtraDB Cluster with config /etc/sysconfig/mysql.boostrap
Loaded: loaded (/usr/lib/systemd/system/mysql@.service; disabled; vendor preset: disabled)
Active: failed (Result: start-limit) since Wed 2017-02-01 15:51:51 CST; 50s ago
Feb 01 15:51:50 efiles-mysql.dev1.passage.nml.com systemd[1]: mysql@boostrap.service failed to run 'start-…ry
Feb 01 15:51:50 efiles-mysql.dev1.passage.nml.com systemd[1]: Failed to start Percona XtraDB Cluster with …p.
Feb 01 15:51:50 efiles-mysql.dev1.passage.nml.com systemd[1]: Unit mysql@boostrap.service entered failed state.
Feb 01 15:51:50 efiles-mysql.dev1.passage.nml.com systemd[1]: mysql@boostrap.service failed.
Feb 01 15:51:50 efiles-mysql.dev1.passage.nml.com systemd[1]: Starting Percona XtraDB Cluster with config …
Feb 01 15:51:51 efiles-mysql.dev1.passage.nml.com systemd[1]: mysql@boostrap.service holdoff time over, sc…t.
Feb 01 15:51:51 efiles-mysql.dev1.passage.nml.com systemd[1]: start request repeated too quickly for mysql…ce
Feb 01 15:51:51 efiles-mysql.dev1.passage.nml.com systemd[1]: Failed to start Percona XtraDB Cluster with …p.
Feb 01 15:51:51 efiles-mysql.dev1.passage.nml.com systemd[1]: Unit mysql@boostrap.service entered failed state.
Feb 01 15:51:51 efiles-mysql.dev1.passage.nml.com systemd[1]: mysql@boostrap.service failed.
Anyone have any ideas.
Regards,
Robin