Re:Ask HN: It's 2023, how do you choose between MySQL and Po...
by dijit on Friday May 12, 2023 @02:05AM
(#35912538)
Last 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-distribut...
Re:Ask HN: It's 2023, how do you choose between MySQL and Po...
by davidgerard on Friday May 12, 2023 @04:14AM
(#35913409)
yeah, that's the use case "I run an application that requires or is highly optimised for MySQL".
Re:Ask HN: It's 2023, how do you choose between MySQL and Po...
by jaachan on Friday May 12, 2023 @12:34PM
(#35918517)
We 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.
Galera is the main one I can think of:
* https://galeracluster.com/library/documentation/tech-desc-in...
* https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/
* 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.