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!

Upgrade from MySQL 5.6 to MariaDB - how much downtime?

Discussion in 'Database Discussion' started by stormy, Sep 27, 2016.

Tags:
  1. stormy

    stormy Well-Known Member

    Joined:
    Nov 22, 2003
    Messages:
    127
    Likes Received:
    8
    Trophy Points:
    168
    Location:
    Spain
    cPanel Access Level:
    Root Administrator
    How much downtime should I expect when upgrading from MySQL 5.6 to MariaDB, using the WHM interface?
     
  2. kernow

    kernow Well-Known Member

    Joined:
    Jul 23, 2004
    Messages:
    929
    Likes Received:
    15
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    Practically zero. Though you should make a full backup of the entire database just in case.......
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    cPanelMichael likes this.
  3. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,179
    Likes Received:
    1,935
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    The upgrade itself shouldn't result in downtime, but it's a good idea to backup your databases before upgrading, as mentioned in the previous response. Documentation on this option is found at:

    MySQL or MariaDB Upgrade - Documentation - cPanel Documentation

    Let us know if you have any additional questions.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. stormy

    stormy Well-Known Member

    Joined:
    Nov 22, 2003
    Messages:
    127
    Likes Received:
    8
    Trophy Points:
    168
    Location:
    Spain
    cPanel Access Level:
    Root Administrator
    Well, the automated upgrade didn't work. MySQL needed to be manually uninstalled, which caused some downtime.
     
  5. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,179
    Likes Received:
    1,935
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    I'm sorry to see it didn't go as planned. Were you able to troubleshoot the issue with a support ticket to determine what happened?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. stormy

    stormy Well-Known Member

    Joined:
    Nov 22, 2003
    Messages:
    127
    Likes Received:
    8
    Trophy Points:
    168
    Location:
    Spain
    cPanel Access Level:
    Root Administrator
    Thanks for the concern! My datacenter was familiar with the issue and they were able to troubleshoot it, no problem.
     
    cPanelMichael likes this.
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