MySQL 5.7 or MariaDB 10.2

davetanguay

• December 24, 2018 13:31

I see MySQL 5.6 is near its end of life cycle. I'm looking for some feedback as to if I should switch to MariaDB 10.2 or just upgrade to MySQL 5.7 Are there any disadvantages of switching to MariaDB instead of MySQL? Did anyone have any major issues after switching to MariaDB?

• 

  vacancy

  • December 24, 2018 20:54

  Mariadb is generating a higher sql query in some databases, mysql 5.7 is always more stable. I haven't updated my servers to mariadb, I'm very happy. Note: This is my personal experience.

  0
• 

  cPanelMichael

  • December 25, 2018 17:26

  Hello @davetanguay, We created a blog post that details why we added support for MySQL 5.7 to the product: Being a Good Open Source Community Member: Why we hesitated on MySQL 5.7 | cPanel Blog One caveat about MariaDB to keep-in-mind is that upgrades to MariaDB are currently one-way, meaning you can't switch back to MySQL after converting to MariaDB. Thus, you may want to upgrade to MySQL 5.7 first and then switch to MariaDB later if you determine it's a better fit. Thank you.

  0
• 

  masterross

  • January 21, 2019 17:16

  Absolutely true! MariaDB makes 2-4x much load compared to Mysql. I really regret "upgraded" to MariaDB. DONT do it!

  0
• 

  PlotHost

  • January 29, 2019 07:06

  I think soon cPanel will offer a script/tool to switch from MariaDB to MySQL. There is a feature request here Revert to MySQL from MariaDB Migration

  0

Please sign in to leave a comment.