Migrating all accounts from MySQL 5.6 & EA3 => MariaDB 10.3 & EA4

AndyB78

• March 13, 2019 09:18

Hello, I have to migrate all accounts from an older server with CentOS6 / EA3 to CentOS7 / EA4 and I am contemplating to also switch from MySQL 5.6 to MariaDB 10.3. The transfer itself will be done with the transfer tool from cPanel and possibly some will be transfered by cPanel backup files (if necessary). I would like to know if migrating to MariaDB 10.3 is a good idea (if data loss is likely) and if MariaDB is a drop-in replacement for MySQL or it might cause problems. I take any tips gladly but I also need an answer from a cPanel tech. Thanks!

• 

  cPanelLauren

  • March 13, 2019 20:17

  I would like to know if migrating to MariaDB 10.3 is a good idea (if data loss is likely)

  
  I think it'd definitely be a great idea and while data loss is not anticipated you it would be wise to have current backups any time you perform upgrades like this.

  and if MariaDB is a drop-in replacement for MySQL or it might cause problems.

  
  That's precisely what MariaDB is - a drop in replacement for MySQL! If you run into any issues I'd encourage you to open a ticket with us, we'd be more than happy to assist you with this. Thanks!

  0
• 

  AndyB78

  • March 14, 2019 06:03

  Thanks. One more question: a MySQL dump generated by MySQL 5.6 can be imported in MariaDB 10.3?

  0
• 

  cPanelLauren

  • March 14, 2019 14:19

  It should be fine, but the upgrade process done through WHM should handle this as well so it shouldn't technically be necessary.

  0
• 

  AndyB78

  • March 15, 2019 19:13

  Well, it's not all fine unfortunately. When I upgraded the MySQL server from MySQL 5.7 to MariaDB 10.3, the default EA4/PHP version was 7.2. This works fine. But no other version works although they do have mysqlnd and pdo active in EA4 provisioning. I would need some help/tips here as I have already started the migration process.

  0
• 

  AndyB78

  • March 15, 2019 20:26

  I made some progress. The problem does not seem to be related in any way to MySQL but to some settings in /etc/suphp.conf. I'll continue another thread in the appropriate forum section.

  0
• 

  cPanelLauren

  • March 15, 2019 20:45

  Hi @AndyB78 Well, I'm glad the MySQL portion went over well and hopefully we can help you get the suphp.conf issues sorted as well.

  0

Please sign in to leave a comment.