MariaDB Vs Mysql

Hello All, I am currently using 5.7 version of Mysql and Want to know, it has any kind of effect relocating from MySql to MariaDB? Which is best for hosting serves between MariaDB and Mysql?

Hello Shivambhatele

Thanks for joining the Forum.

That is a huge question that would really require an analysis of your application and needs before we could answer it. So I am afraid it’s well out of scope for Percona to answer in the Forum, since we could only provide a high quality answer by addressing this through our consultancy services. For example, perhaps Percona Server for MySQL might answer your needs without leaving MySQL at all.

You should be aware that MariaDB with version 10.4 have diverged and is no longer considered a distribution of MySQL as MariaDB is developing their own code and functionalities. You’ll find a lot of discussion about that online. It might be a discussion other forum users might enjoy.

Meanwhile, I thought you might find these free webinars a good start for your own explorations, the third one takes hosting into consideration:
[LIST]
[]https://www.percona.com/resources/webinars/differences-between-mariadb%C2%AE-and-mysql%C2%AE
[
]https://www.percona.com/resources/webinars/mariadb-server-103
[*]https://www.percona.com/resources/webinars/databases-hosted-cloud-0
[/LIST]
If your company is in the position to use our professional consulting services, please let me know and I will get someone to discuss the options, you can email me if you would like to look at that.

Shivambhatele ,
MariaDB was born as a drop-in replacement of MySQL. Up to version 5.5, MariaDB was “MySQL plus some other features”. All features, SQL syntax and options from MySQL 5.5 were important into MariaDB 5.5 (possibly with some exception, but if so, they were rarely used features). Frankly, I’ve never considered MariaDB as a “drop-in replacement”. But up to that point, switching from MySQL to MariaDB was less risky than upgrading MySQL or MariaDB to the next major version.

Later, MariaDB decided that maintaining the compatibility wasn’t worth the effort. They started to dedicate less effort to compatibility and more effort to develop unique features. Next MySQL version was 5.7, but next MariaDB version was 10.0. This mismatch indicated that the products were starting to diverge, and be less compatible.

I still consider them “mostly compatible”. If you need to install some application, as a general rule you can expect it to work equally well with MySQL and MariaDB (again, there may be exceptions).

Unique features exist on both sides. I’ll mention the ones that I personally judge more relevant, which is not a universal truth.

MariaDB:

MySQL:

More links:

To conclude, what is better? None of them is better. They are usually equivalent, unless you need / want a feature that is implemented only in one of them.

MariaDB doesn’t use Xtradb anymore, it uses a version of InnoDB heavily modified by them. Xtradb specific options are not available anymore in recent versions (there could be some exception).

Generated columns are available in MySQL since version 5.7. MySQL implementation is slightly more complete because:

  • you can index virtual (non-persistent) columns
  • indexes on generated columns can be used even by queries that don’t mention the column explicitally

I wouldn’t say that MariaDB is faster - depending on your workload, one or another can be faster.

On the other side, your message reminds me that MariaDB comes with RocksDB, which is an interesting storage engine.