Hello,
I have a 2 node Percona cluster (percona-xtradb-cluster-56, 5.6.26-25.12-1.wheezy).
I had an issue where it seems db2 become unavailable due to some network issue.
While this happening db1 did not crash but locked down the database completely what freeradius was using. I guess this is normal behaviour.
During this time the database on db2 was accessible.
I have a feeling that there was not a long network outage between the nodes rather the auto-reconnect mechanism was failing because after I did restart db1 (just 4 minutes later of the last autoreconnect attempt) the cluster resynced and the dbs on db1 become accessible again.
My questions are:
1, How can I have the db at least in read only mode when the cluster split on both ends? In my case it would be useful for the radius to be still able to do authentication without updating infos in the database.
2, Can this be anyhow caused that my setup is using wsrep_sst_method=rsync instead of wsrep_sst_method=xtrabackup-v2?
I had no problem with this before.
3, How to increase the reconnect retry value to very high?
Logs: