Hacker News new | past | comments | ask | show | jobs | submit login

MySQL/MariaDB have binary and logical replication too. They also support much more advanced topologies like multi-master out of the box. It's just that what you need for 99% of situations relies on a well trodden path and requires no configuration at all.

I have suspected for a long time that most people who criticize MySQL have never actually worked with it, or have done so a couple of decades ago. It's often the default choice if you don't need some of the PostgreSQL features (like PostGIS) and can work with either one.






MySQL has only logical replication, there is no equivalent to PostgreSQL‘s WAL/physical replication.

> They also support much more advanced topologies like multi-master out of the box.

This is the one thing in My/MariaDB that I miss in Pg: Galera. So handy for in-house stuff that needs some kind of HA: either a three-server setup, or a two-server+arbitrator.


I haven’t used Galera, but I am very happy with https://patroni.readthedocs.io/en/latest/ for Postgres.


Since v16, Postgres supports bidirectional logical replication out of the box. In other words, multiple writers.



Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: