Re:Why Uber Engineering Switched from Postgres to MySQL
by fanf2 on Wednesday July 27, 2016 @05:20AM
(#12171477)
Does repmgr handle most of this?
[ Parent
| on HN ]
Re:Why Uber Engineering Switched from Postgres to MySQL
by LoSboccacc on Wednesday July 27, 2016 @06:52AM
(#12171816)
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.