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!

Multiple cPanel servers with a common MySQL Cluster

Discussion in 'Database Discussion' started by kUdtiHaEX, Apr 15, 2019.

  1. kUdtiHaEX

    kUdtiHaEX Member

    May 15, 2008
    Likes Received:
    Trophy Points:
    Belgrade, Serbia
    cPanel Access Level:
    DataCenter Provider
    Hi all

    Five years ago I tried to use one MySQL cluster with multiple cPanel servers. The issues were with some databases that WHM creates during installation (eximstats, cphukld, modsec, leechprotect etc.) because of username conflicts. I am aware of that and I managed somehow to go around it, but it wasn't production stable so I decided to leave it.

    I am also aware of the fact that documentation clearly states I should not do it because of the issues I mentioned, but I also have read that some people are running it anyway. But it is extremely inefficient to have MySQL server on each WHM node or one MySQL instance per WHM node, so I need to go with MYSQL cluster for all cPanel servers.

    So, I want to bring up a Percona PXC Cluster with the ProxySQL as a front. My question is (and this is for the staff and others who actually made it work) - how to overcome database & username conflicts? Apart from those are there any other gotchas that I could encounter?

    Thanks :)
  2. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Nov 14, 2017
    Likes Received:
    Trophy Points:
    cPanel Access Level:
    DataCenter Provider
    Hi @kUdtiHaEX

    Well some of those issues you won't run into any more in terms of our internal databases as we've transitioned all of those to SQLite. As far as username conflicts for the actual accounts on the server you'd need to ensure that none of the usernames are shared. We don't support DB clusters at this time though so configuration/troubleshooting of the configuration may be limited.
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...

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