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!

SOLVED MySQL upgrade recommendation

Discussion in 'Database Discussion' started by psytanium, Jan 17, 2018.

  1. psytanium

    psytanium Well-Known Member

    Joined:
    Jun 6, 2014
    Messages:
    111
    Likes Received:
    4
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Hello,

    Currently I'm running MySQL 5.6 on my VPS server.

    Should I upgrade to MariaDB 10.1 ?
    Is it safe ?
    On step 2, i get 3 warnings :

    1- The selected MariaDB version (10.1) is more than one generation newer than the currently installed version. The upgrade process will iterate over each intervening version to ensure tables are upgraded appropriately.

    2- Although in-place upgrades are generally safe, you should always perform a full database backup before you begin the upgrade process.

    3- Please note that downgrades to previous versions are unsupported. After you upgrade your system to a newer version, it may be impossible to switch back.

    Should I ignore and proceed ?

    All the best,
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

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

    One potential reason you may want to avoid migrating to MariaDB is that you won't be able to convert back to MySQL in the future. cPanel version 70 offers support for MySQL 5.7, but the conversion to MySQL 5.7 isn't supported if you are already using MariaDB, so that's something to consider. Other than that, you should definitely follow the advice quoted below:

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. DennisMidjord

    DennisMidjord Well-Known Member

    Joined:
    Sep 27, 2016
    Messages:
    193
    Likes Received:
    15
    Trophy Points:
    18
    Location:
    Denmark
    cPanel Access Level:
    Root Administrator
    We've been using MariaDB 10.1 with MySQL Governor for years now on multiple servers, and we haven't had any real issues.
    The only issues have appeared when we've setup a new server and forgotten to install MariaDB on it. Transferring accounts to that cPanel server gives errors, but it's fixed by installing MariaDB.

    CloudLinux also supports MariaDB 10.2, which should support MySQL 5.7. I haven't tested it yet.
     
    psytanium likes this.
  4. PeteS

    PeteS Well-Known Member

    Joined:
    Jun 8, 2017
    Messages:
    136
    Likes Received:
    21
    Trophy Points:
    18
    Location:
    Oregon
    cPanel Access Level:
    Root Administrator
    I too would like the latest cPanel recommendation regarding staying with MySQL (and upgrading to 5.7 as soon as cPanel version 70 comes out) vs. moving to Mariadb 10.1. The current cPanel 68 recommendation is Mariadb 10.1 and I was about to pull the handle on that until I noticed that 70 will have 5.7 in it.

    If cPanel is moving away from MySQL that would be important to know. Please look in your crystal ball and give us your thoughts.

    @cPanelMichael ?
     
    #4 PeteS, Feb 5, 2018
    Last edited: Feb 6, 2018
  5. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,585
    Likes Received:
    439
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    PeteS likes this.
  6. PeteS

    PeteS Well-Known Member

    Joined:
    Jun 8, 2017
    Messages:
    136
    Likes Received:
    21
    Trophy Points:
    18
    Location:
    Oregon
    cPanel Access Level:
    Root Administrator
    Sorry for that, but I had no way of knowing and needed more info asap.

    Indeed it is useful; very informative. That's the info I've been looking for from cPanel. Someone (from cPanel) had previously made a statement that pointed to moving away from MySQL support. Then when I saw that 5.7 was part of v 70 I was conflicted over what cPAnel's position was on it. This quote from the blog sums it up for me:

    Thanks!
     
  7. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,585
    Likes Received:
    439
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    There are multiple threads on this topic on these forums I'm sure.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  8. PeteS

    PeteS Well-Known Member

    Joined:
    Jun 8, 2017
    Messages:
    136
    Likes Received:
    21
    Trophy Points:
    18
    Location:
    Oregon
    cPanel Access Level:
    Root Administrator
    Nothing nearly as clear as the blog post you linked (at least that I found), so thanks for that!
     
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