We are currently testing a 3-node Percona cluster in our dev environment. Our production and test DBs are still basic MySQL master / replica configurations. Previously, I had written a script to update dev or test with data from one of the other environments, which worked acceptably. I am now attempting to update this process to populate the cluster with data from one of the other two systems, but having some difficulty. My current iteration stopped mysql on all three nodes before populating one with the new data. However, I am now unable to restart mysql on the node with the new data. The error log isn’t telling me anything I’m finding useful; the last line is simply
Log of wsrep recovery (--wsrep-recover):
with no further information, and I’m not having a lot of luck searching for what this indicates.
I have not yet tried to start mysql on either of the other two nodes. I have tried several different bootstrap command examples on this node, with the same result.