News for hackers. Stuff that matters.
Re:Ask HN: It's 2023, how do you choose between MySQL and Po... by throw0101b on Thursday May 11, 2023 @10:43PM (#35911295)
> 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-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.

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.
Re:Ask HN: It's 2023, how do you choose between MySQL and Po... by avinassh on Saturday May 13, 2023 @12:15AM (#35925447)
how do multi master MySQL handles conflicts?