7 ms·
most of it. but in the master-slave configuration the clients can only work if connecting to the master, and when the master switch, scripts needs to go to each
by LoSboccacc 10y ago
most of it. but in the master-slave configuration the clients can only work if connecting to the master, and when the master switch, scripts needs to go to each clients and update their config. not immensely bad if you also use pgbouncer so you can do it on the fly without restarting the whole client, but exceptionally vulnerable to split brains and the like.
- snuxoll 10y agoI've handled this with a DNS CNAME record that points to the active master, though pgBouncer is a valid solution as well.