I had my new XtraDB-Cluster (5.7.19, Debian 9) up and running for a while and today I decided to restart one of the three Nodes. That was apparently not a good Idea, because now it’s not willing to rejoin the Cluster anymore. I really tried out what I could, but got the following Error, over and over again:
“mysql: WSREP: Failed to recover position:”
Here’s my /etc/mysql/percona-xtradb-cluster.conf.d/mysqld.cnf which flawless works on the other 2 Nodes:
Also starting the Node, without making any changes to mysqld.cnf, and filling up the wsrep* variables manually (wsrep_cluster_address, global wsrep_provider, wsrep_node_address, wsrep_sst_auth) did not help.
My Boss will be killing me, please help!
With best regards,