The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Upgrade from MySQL 5.6 to MariaDB - how much downtime?

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

Tags:
  1. stormy

    stormy Well-Known Member

    Joined:
    Nov 22, 2003
    Messages:
    107
    Likes Received:
    6
    Trophy Points:
    18
    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:
    865
    Likes Received:
    9
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Practically zero. Though you should make a full backup of the entire database just in case.......
     
    cPanelMichael likes this.
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  4. stormy

    stormy Well-Known Member

    Joined:
    Nov 22, 2003
    Messages:
    107
    Likes Received:
    6
    Trophy Points:
    18
    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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  6. stormy

    stormy Well-Known Member

    Joined:
    Nov 22, 2003
    Messages:
    107
    Likes Received:
    6
    Trophy Points:
    18
    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