I'm having three nodes one acts as master and two as data nodes. I need to ensure high availability. I want master to write data only to one node, say node A and other node will be only read-only node, node B. But if node A goes down, I prefer node B to be changed to write node and get the data, till node A comes up.
Ideally I need my data to be written to one node, which is active
Is it possible???