Why Uber dropped PostgreSQL
Why Uber dropped PostgreSQL
Posted Aug 7, 2016 3:54 UTC (Sun) by giraffedata (guest, #1954)In reply to: Why Uber dropped PostgreSQL by niner
Parent article: Why Uber dropped PostgreSQL
At the same time, logical replication like MySQL does bring a whole class of corruptions that are simply not possible in the same way with Postgres' WAL based replication.
But are corruptions of that class as dangerous?
I take the complaint to be that with the WAL-based replication, a single trigger of a bug can cost you the whole cluster. But with logical replication, for all it's opportunities to fail, the most you will lose is one replica, and at worst you'll have to blow away that replica and replace it.
Is there a class of bug specific to MySQL that corrupts the entire cluster at once?