I have a percona galera cluster with 3 node, and a standalone asynchronously replicated slave for DR on AWS.
My problem is, that my cluster was broken yesterday and my DR also.
I tried to fix the DR but failed. My second node is the master for DR, so i maked a backup from the node 2. Push out to AWS DR and i tired to restart replication but i saw, that the position everytime was moved when i checked with
show master status;
So i think, i need to take out the node 2 until the DR will be fix, to keep the position fixed.But how can i do that? I read the docs and a lot of forum post and also i tried some stuffs, like wsrep_on, wsrep_desync, variout strict setup but the sync everytime goes on.
Can you help me, to take out this node?
Thank you very much any help!