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!

Is Percona supported by cPanel?

Discussion in 'Database Discussion' started by Onklmaps, Jan 14, 2019.

Tags:
  1. Onklmaps

    Onklmaps Member

    Joined:
    Nov 9, 2016
    Messages:
    16
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Norway
    cPanel Access Level:
    DataCenter Provider
    I have read about Percona being faster than MariaDB (and standard MySQL).
    Also Percona XtraBackup could make backups easier.

    I found this guide from Percona blog:
    How to Replace MySQL with Percona Server on a CPanel, WHM VPS or Dedicated Server

    I also found links to cPanel documentation that was about installing Percona. However, that one is deleted (why?).

    The Percona blog mentiones that Percona Server for MySQL 5.6 will work just fine, but Percona Server for MySQL 5.7 will have some issues: "One thing to keep in mind is that 5.7 breaks CPanel’s ability to create users in MySQL. I believe this is due to the changes to the mysql.user table. If this is an issue for you, you can always use Percona Server for MySQL 5.6."

    1. Is Percona supported by cPanel?
    2. Is the issue with Percona Server for MySQL 5.7 solved?
    3. Do I lose some WHM/cPanel functionality installing Percona on my server?
    4. Could my database and/or Percona setup break after WHM/cPanel updates?
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,555
    Likes Received:
    2,182
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @Onklmaps,

    Percona is not offered with cPanel & WHM and the workaround steps referenced in that guide are unsupported and look to be outdated.

    To use Percona in a supported fashion with cPanel & WHM, you could purchase CloudLinux and use it's MySQL Governor feature that offers support for Percona:

    CloudLinux

    Thank you.
     
  3. Onklmaps

    Onklmaps Member

    Joined:
    Nov 9, 2016
    Messages:
    16
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Norway
    cPanel Access Level:
    DataCenter Provider
    Using CloudLinux is planned.

    So you are saying:
    WHM/cPanel + Centos + Percona = not offered, and not recommended?
    WHM/cPanel + CloudLinux + MySQL Governor + Percona = supported and recommended?
     
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,555
    Likes Received:
    2,182
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hi @Onklmaps,

    Correct.

    Supported through CloudLinux, and recommended if you've already made the decision to use Percona.

    Thank you.
     
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