I’m trying to run XtraDB Cluster with 2 nodes. Those nodes are connected by using not so good WAN connection. All MySQL client of both nodes need to work independently on online and offline condition. One node is for incoming insert from web based forms, the other node is for approval process of inserted row by updating the status column. Below are 2 possible condition of working for that case.
- Clients of each node never work on the same row with the other node clients
- Clients of each node can work on the same row with other node clients but never update the same row at the same time
Is it possible to do that with XtraDB Cluster? How can I make both nodes still available on WAN link outage? I know it will become split brain condition, but since mostly works is reading and the update will never conflict on above case, is it a way to do that? On my current setup, the lower priority node will be not available on WAN link outage condition even for read only works. What we need is to make both nodes still available on WAN link outage condition and both node will synchronize any update happen on offline time when the WAN link is become normal again.