3 ms·
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
by homebrewer 2y ago
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.
- throw0101c 2y ago> 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.
- mxey 2y agoMySQL has only logical replication, there is no equivalent to PostgreSQL‘s WAL/physical replication.
- ttfkam 2y agoSince v16, Postgres supports bidirectional logical replication out of the box. In other words, multiple writers.