4 ms·
I see this explanation a lot. However, from what I can gather: - pgsql supports synchronous master-slave replication natively, with excellent performance - my
by sergiosgc 13y ago
I see this explanation a lot. However, from what I can gather:
- pgsql supports synchronous master-slave replication natively, with excellent performance
- mysql supposedly does multi-master replication, but does not solve the hard problems. You can't write on the same row on two masters simultaneously or replication stops; sequential ids are not synchronized between masters; you can't get serial transaction isolation between masters.
All in all, I'd rate replication support between both databases as nearly identical. Pgsql does master-slave better, mysql has a half-hearted attempt at multi master. Given that on all else pgsql is markedly better, I can't see replication as the reason for picking mysql.