4 ms·
> There is almost no good reason to choose MySQL over PostgreSQL for any operational reason Galera is the main one I can think of: * https://galeracluster.com
by throw0101b 3y ago
> There is almost no good reason to choose MySQL over PostgreSQL for any operational reason
Galera is the main one I can think of:
* https://galeracluster.com/library/documentation/tech-desc-introduction.html https://galeracluster.com/library/documentation/tech-desc-in...
* https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/ https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/
* https://packages.debian.org/search?keywords=galera https://packages.debian.org/search?keywords=galera
I'm not aware of any multi-master, active-active(-active) replication system that is open source for PostgreSQL.
- jaachan 3y agoWe ran a Galera cluster for 4 days and it died on the first ALTER TABLE we did. Only option was to reduce it down to a Primary / Replica setup. I really can't recommend anyone using this.
- dijit 3y agoLast time I looked at Galera it had a limit at 5TiB of data. Which is fine I guess. In the Postgres space there is citusdb which provides multi master. There is also BDR from 2ndquadrant if you want a paid/supported solution. https://www.enterprisedb.com/products/edb-postgres-distributed https://www.enterprisedb.com/products/edb-postgres-distribut...
- davidgerard 3y agoyeah, that's the use case "I run an application that requires or is highly optimised for MySQL".
- avinassh 3y agohow do multi master MySQL handles conflicts?