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.

Problem Monitoring MariaDB Server in WHM

Discussion in 'Database Discussions' started by StephaneB, Sep 28, 2016.

Tags:
  1. StephaneB

    StephaneB Member

    Joined:
    Sep 12, 2013
    Messages:
    5
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    671
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello,

    Could you verify the steps you took to upgrade to MariaDB? For instance, per that document, it states:

    Thank you.
     
  3. StephaneB

    StephaneB Member

    Joined:
    Sep 12, 2013
    Messages:
    5
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    Please see my original post for the link to the procedure used to switch to MariaDB.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    671
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  5. StephaneB

    StephaneB Member

    Joined:
    Sep 12, 2013
    Messages:
    5
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    Sorry for the late reply to this thread.

    Okay so here are the updates: I've finally reverted back to MySQL successfully. Of course I had a copy of /var/lib/mysql that was taken before the upgrade to MariaDB.

    I have uninstalled MariaDB 10.2 using Yum and then removed the mariadb repository file from /etc/yum.repo.d

    I have reinstalled MySQL this way:

    /scripts/update_local_rpm_versions --edit target_settings.MySQL56 installed
    /scripts/check_cpanel_rpms --fix --targets=MySQL50,MySQL51,MySQL55,MySQL56

    Everything went fine and WHM was able to monitor the service successfully.

    So then I tried to upgrade to MariaDB 10.1 (the cPanel supported version) through WHM. At first, the upgrade failed saying that MariaDB packages conflicted with MySQL56 packages. So I did:

    /scripts/update_local_rpm_versions --edit target_settings.MySQL56 uninstalled
    /scripts/check_cpanel_rpms --fix --targets=MySQL50,MySQL51,MySQL55,MySQL56

    I restarted the upgrade through WHM and it all went fine. The MariaDB server is up and the websites are running fine.

    WHM is now able to monitor MariaDB successfully.
     
    cPanelMichael likes this.
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    671
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page