MariaDB - [ROADMAPPED] - Enhance Control Panel

MariaDB - [ROADMAPPED]

DracoBlue

MariaDB support and optimization for performance would be nice.

Aliysa_Enhance

Hi DracoBlue, MariaDB is scheduled on our roadmap for April https://enhance.com/resources/article/product-roadmap.

digitalexpanse

+Critical
Surprised this isn't a best practice at this point, we've been using MariaDB for Wordpress sites for 3+ years now.

digitalexpanse

Cool, will review the roadmap, so maybe in a year this will be production ready for us. Also hilarious, I looked at the roadmap last week and when I saw July, I straight up though you stopped rolling out updates, because this is completely backwards if you think about it.

prasad0889

digitalexpanse Isn't MYSQL8 better as compared to MariaDB?

John-P

prasad0889 Isn't MYSQL8 better as compared to MariaDB?

There is a lot less of a performance difference than there was a while ago.

In the benchmarks that we ran internally MariaDB was slightly faster, but really the difference for most sites was tiny.

digitalexpanse

@prasad0889
I can't say I've ever seen it outperform MariaDB for modern WordPress sites with millions of page views monthly. That being said, database performance is often attributed to proper configuration for the application.

necrom

It'd be nice to have the choice, but when it comes to performance the database is toward the end of the list of things we look at.

John-P

necrom It'd be nice to have the choice, but when it comes to performance the database is toward the end of the list of things we look at.

Same thoughts here. Unless your DB is absolutely huge it is not often going to be a major deciding factor in site/app speed.

AdamM

Between MySQL and MariaDB there is no significant difference I think. What we need more is a database cache, such as Redis/KeyDB.

digitalexpanse

Except that we use MariaDB and aren't switching to MySQL8, nor are we taking a hit on performance across 100 million page views just because. So it definitely varies company to company needs wise.

josedieguez

sad that mariadb didn't make it on April 🙁

Zoinkies

josedieguez Yea super sad face. I just saw it’s planned for September, uff.

Adrien

Zoinkies Would you mind telling me why some prefer MariaDB over MySQL?

Thank you.

Zoinkies

Adrien way faster, more reliable, better caching, tangibly faster all round for WP

gavin

@Zoinkies Only out of box. Well configured MySQL8 is as fast at MariaDB 10.11.4 or Percona. I have found InnoDB clusters to be more stable than Galera Clusters or Percona XtraDB Clusters.

Adam

As I understand it, the main difference is that MariaDB was forked from MySQL 5.7 and therefore still contains the query cache which is beneficial on some workloads.

Also we have seen some compatibility issues with importing cPanel backups which were generated on MariaDB servers and therefore it's important that we support MariaDB for users who are doing mass migrations from cPanel so they can ensure the best possible compatibility.

The reason it's been delayed is the complexity of supporting MySQL 8 and MariaDB side by side.

DracoBlue

Please latest MariaDB 10.11