Comment on Stop using MySQL in 2026, it is not true open source
schnurrito@discuss.tchncs.de 1 month ago
Are there real advantages to using either MySQL or MariaDB instead of PostgreSQL?
Yeah,
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.
Oh misread my bad,
not much experience with PostgreSQL
MySQL 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.
Depends 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.
Operating and securing Postgres is a steeper learning curve.
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.
Is Maria that much better than MySQL?
MariaDB is MySQL’s fork, initiated by the main developers, so…
Does that mean it’s still an utter borderline unusable shit?
If you’re constrained by resources (CPU/RAM).
There’s a reason most web hosts usually have mariadb and not postgres.
Maybe that once every 2 years when you upgrade to major version it does it automatically? You save 15 mins every 2 years?
jubilationtcornpone@sh.itjust.works 1 month ago
No. But there are a number of advantages of using PostgreSQL over the others.