I have completed a 5 node cluster db using proxsql with 2 nodes for write and rest 3 nodes for select.
based on the node down the write did switch to the 2nd node. now i do see that it is saying the server is shunned since the db was down. i have brought the db back up but it sill showing as shunned.
What is the way to enable it back and also what is the method to fail back the write to the first node again.
what happens now if the 2nd goes down ? sicne the first server is shunned the write will hang
please let me know how to go about it.
thanks in advance.
Arun