What year is this? No one should be using Mysql since MariaDB came about.
this post was submitted on 11 Jan 2026
328 points (97.4% liked)
Selfhosted
54534 readers
1091 users here now
A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.
Rules:
-
Be civil: we're here to support and learn from one another. Insults won't be tolerated. Flame wars are frowned upon.
-
No spam posting.
-
Posts have to be centered around self-hosting. There are other communities for discussing hardware or home computing. If it's not obvious why your post topic revolves around selfhosting, please include details to make it clear.
-
Don't duplicate the full text of your blog or github here. Just post the link for folks to click.
-
Submission headline should match the article title (don’t cherry-pick information from the title to fit your agenda).
-
No trolling.
-
No low-effort posts. This is subjective and will largely be determined by the community member reports.
Resources:
- selfh.st Newsletter and index of selfhosted software and apps
- awesome-selfhosted software
- awesome-sysadmin resources
- Self-Hosted Podcast from Jupiter Broadcasting
Any issues on the community? Report it using the report flag.
Questions? DM the mods!
founded 2 years ago
MODERATORS
If you don't want to use postgresql for some obscure reason use MariaDB real open source MySQL drop in replacement.
Perhaps MariaDB is a better choice.
Oracle sees itself as an activist organization, one whose goal is the advancement of the Israeli colonization project. Safra Catz, the company’s Israeli-American CEO, bluntly explained that any employees uncomfortable with supporting a genocide should simply quit. “We are not flexible regarding our mission, and our commitment to Israel is second to none” (source)
Hmm, MySQL or PostgreSQL—how will we ever decide which one to pick.
wow, I didn't need any more reasons not to support Oracle but thanks anyway
Why would anyone ever choose mysql over postgres?
MySQL has been the "default" choice for a long time for PHP programmers. I don't know why.
LAMP indeed
We need LAPP . Stat!
It used to be free with less of a barrier to entry than postgres
Tutorials mostly.
@Scrollone @BrilliantantTurd4361 Because it used to be a lot faster than postgresql for smaller sites. MyISAM (https://en.wikipedia.org/wiki/MyISAM) was super lightweight, at the expense of the occasional corrupt database (oops).
I don't know how many new people are coming to PHP these days (as opposed to javascript/python/rust/etc), but certainly the older PHP coders grew up using mysql.
What rock do you live under if you're using MySQL over MariaDB?
Older people about to return to programming, and most of the online tutorials they have are about 20 years old, having no idea an alternative exists.
MariaDB >>>
I've been using it since ever on my rpi because they say it's easier on resources
Who are “they”?
We use MariaDB at work but I don’t know why it was originally chosen over PostgreSQL, as that was before my time.
Blogs and forums back then when I looked it up.
Can't remember exactly where (since it's been a long time ago), but I'm sure more than someone claimed it.
Are there real advantages to using either MySQL or MariaDB instead of PostgreSQL?
No. But there are a number of advantages of using PostgreSQL over the others.
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
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.
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. I like Percona personally, but MariaDB is fine too.
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.
Operating and securing Postgres is a steeper learning curve. MariaDB is more forgiving for best-effort shoestring setups without compensating scalability for it.
As a dev I'm agnostic, as an owner and computer scientiest I prefer Postgres, as a sysadmin or *Ops I will put my hand up for MariaDB any day if I'll be on call or maintain deployments.
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?
I'd say ti's a little bit better.
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?
Clearly you can’t use MySQL because it isn’t webscale.
MariaDB is not always a drop-in replacement. There's several features that MySQL has that MariaDB doesn't, especially related to the optimizer (for some types of queries, MySQL will give you a more optimized execution plan compared to MariaDB). It's also missing some newer data types, like JSON (which indexes the individual fields in JSON objects to make filtering on them more efficient).
MariaDB and MySQL are both fine. Even though MySQL doesn't receive as much development any more, it doesn't really need it. It works fine. If you want a better database system, switch to PostgreSQL, not MariaDB.
when is Oracle gonna go Broadcom mode on MySQL, still waiting for the moment 🍿
That's why I moved to MSSQL
/s
Wamp anyone? (I think thats what its called, im at work and cant check my pc) Or am i the odd one out.
In case you are Czech, there is a translation at https://www.root.cz/clanky/prestante-uz-pouzivat-mysql-neni-to-skutecny-open-source/?nahled=1
Glad to see more translations show up!
But but but, it has the word “my” in it
/s
Dude. You never finish.
I didn't know this was ever in question?
Also stop calling it "my sequel"
stop calling it "my sequel"
Why?
Sequel is Microsoft. S-Q-L is Linux.
Microsoft's is "squeal". Like a pig. When you get the bill.
view more: next ›