Since you already use HAProxy you should get that almost for free. Your app would talk to the databased by communicating through HAProxy, which would direct tra

Since you already use HAProxy you should get that almost for free. Your app would talk to the databased by communicating through HAProxy, which would direct traffic to the single-writer; HAProxy's health tests would detect who the single-writer is, and would adapt in the event of failover.