I tried that before getting "Error: Maximum number of characters exceeded. It cannot be more than 10000 characters. The current number of characters is 11599"
We are running the following version of Percona using 3 nodes but something strange happened today, node1 and node3 were requesting sync while the node2 is in donor state. How could this happen? this is not fault tolerant.
[root@afdoz mysql]# yum list installed | grep percona
Percona-Server-shared-compat.x86_64 5.5.25a-rel27.1.277.rhel6 @percona
Percona-XtraDB-Cluster-client.x86_64 1:5.5.24-23.6.340.rhel6 @percona-testing
Percona-XtraDB-Cluster-galera.x86_64 2.0-1.113.rhel6 @percona-testing
Percona-XtraDB-Cluster-server.x86_64 1:5.5.24-23.6.340.rhel6 @percona-testing
percona-release.x86_64 0.0-1 installed
percona-testing.noarch 0.0-1 installed
percona-toolkit.noarch 2.1.3-2 @percona
percona-xtrabackup.x86_64 2.0.1-446.rhel6 @percona
Taking close look at logs, first node3 is out of sync, fine, then suddenly node1 requests transfer from any. Should node2 be a Donor or be in Synced state and wait for manual sync at certain time by administrator? Is there a way to make it so that when 2 out 3 nodes are requesting sync, to switch to synced state and wait for manual sync? Please see the logs below:
The issue I'm having is all the nodes should not be down at the same time, donor state is down state. If two nodes are down, do not use the third as donor and wait for manual since at a certain time when nobody is using the system. Else my sites are down till at least 2 nodes are synced. If this takes minutes to since, then no problem but the sync takes an hour because it's a big database. How can I make it so that at least one node needs to be up? any configuration option. Thank you!