Level 75
Dec 18, 2020
10
Level 14
Should I use MySQL or MariaDB?
I'm confused which one is better. I know that MariaDB is a fork of MySQL but what does the Laravel community use? Is MariaDB better or more modern? Which one would you recommend and why?
Level 14
@michaloravec which one do you prefer?
Level 75
I use MySQL.
1 like
Level 14
@michaloravec why do you use MySQL instead of MariaDB?
Level 75
They are the same. Even in Java the same connector works with Mysql and MariaDB, the JDBC Driver for MySQL.
To add, for a larger Enterprise setup you would want MySQL. But for most things people are going to do in laravel there is really no significant difference. Innodb the same.
However I would suggest you read the specs of both for yourself.
Level 73
They are basically the same. The only difference is MySQL 8 has Oracle written all over it.
Level 39
Use postgresql :-) , more reliable and performant.
Level 14
More performant? I was reading the opposite that MySQL was faster.
Level 39
You can find many simple "benchs" on the net with this conclusion, but it's not right, that's does not mean than mariadb is not performant.
https://olinux.net/postgresql-vs-mysql-performance/
and for db optimization
https://www.optimizdba.com/optimizdba-blog
What's good with Laravel is that you can use both without pb if you don't want some specific functionality like partial index that does not exist in mariadb.
Level 39
Personally I use Postgresql mainly for reliability, 0 data lost in 20 years, in case of "crash of the server", it'll be more difficult to retrieve your data with mariadb
Please or to participate in this conversation.