Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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

Discussion in 'Database Discussion' started by AndyB78, Mar 13, 2019.

  1. AndyB78

    AndyB78 Well-Known Member

    Joined:
    Oct 7, 2003
    Messages:
    66
    Likes Received:
    1
    Trophy Points:
    158
    Location:
    Romania
    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!
     
  2. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    5,766
    Likes Received:
    439
    Trophy Points:
    233
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    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.
    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!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. AndyB78

    AndyB78 Well-Known Member

    Joined:
    Oct 7, 2003
    Messages:
    66
    Likes Received:
    1
    Trophy Points:
    158
    Location:
    Romania
    Thanks. One more question: a MySQL dump generated by MySQL 5.6 can be imported in MariaDB 10.3?
     
  4. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    5,766
    Likes Received:
    439
    Trophy Points:
    233
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    It should be fine, but the upgrade process done through WHM should handle this as well so it shouldn't technically be necessary.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. AndyB78

    AndyB78 Well-Known Member

    Joined:
    Oct 7, 2003
    Messages:
    66
    Likes Received:
    1
    Trophy Points:
    158
    Location:
    Romania
    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.
     
  6. AndyB78

    AndyB78 Well-Known Member

    Joined:
    Oct 7, 2003
    Messages:
    66
    Likes Received:
    1
    Trophy Points:
    158
    Location:
    Romania
    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.
     
    cPanelLauren likes this.
  7. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    5,766
    Likes Received:
    439
    Trophy Points:
    233
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice