News for hackers. Stuff that matters.
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.
Re:Why Uber Engineering Switched from Postgres to MySQL by snuxoll on Friday July 29, 2016 @01:21PM (#12188300)
I've handled this with a DNS CNAME record that points to the active master, though pgBouncer is a valid solution as well.