OttoStop using MySQL in 2026, it is not true open source
schnurritoAre there real advantages to using either MySQL or MariaDB instead of PostgreSQL?
illusionistDepends on the task but for general usage there is no big difference. You would choose one over the other if you need one for work.
RoguelazerMySQL often has moderately higher performance (particularly for workloads where you want your data clustered by PK, which is how InnoDB is natively structured) and its replication system is much more flexible than either of PostgreSQL’s.
Is it true?
Postgres with correct fillfactor, it doesn’t create new pages and works very fast.
Replication in MySQL always sucked ass, only received synchronous replication in some new edition, and that also didn’t sound great.
Postgres has logstream and logical replication, both of them can be set to various levels of synchronicity, and logical replication is configurable at least as well as MySQL is in terms of which data is sent.
No. But there are a number of advantages of using PostgreSQL over the others.
Rikj000Yeah,
I did a speed test comparison between Oracle MySQL and MariaDB MySQL,
MariaDB is about 10 times faster.
FYI: When Oracle bought MySQL a lot of developers left and created MariaDB, so the brains behind the project moved, and in the meantime Oracle did a great job of fucking things up.
That’s not what I asked. I asked about a comparison of both of them to PostgreSQL.
Is Maria that much better than MySQL?
Cause that one is absolute shit, very difficult to maintain, and requires lots of config changes and even replicas can disconnect when something’s not 100% ok.
I will take Postgres over any other DB any day of the week.
Wispy2891