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, one DB server?

Discussion in 'Database Discussion' started by jimmystack, May 30, 2019.

  1. jimmystack

    jimmystack Registered

    Joined:
    May 30, 2019
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    London
    cPanel Access Level:
    DataCenter Provider
    Hi all,

    Wanted to ask some advice here.

    I have a customer with a number of sites that need to be load-balanced. The idea here is to have two web servers, a load balancer, and a single MySQL server between them. Each web server, running cPanel, would use the single mysql server for databases.

    Is this an advisable setup? Is it safe to connect two cPanel servers to a single remote mysql server? I know there’s a warning in the docs about it, but has anyone actually used it?

    If not, can I simply have the remote mysql server connected to one server, and have the applications on the other connected to the DB server IP directly?

    How do you manage grants and users etc? Do these need to be manually added?

    Looking forward to hearing your advice/horror stories/best practices :)
     
  2. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,484
    Likes Received:
    187
    Trophy Points:
    193
    Location:
    Chesapeake, VA
    cPanel Access Level:
    DataCenter Provider
    My advice is that if this is just one domain would be to not use cpanel at all.

    If you need cpa el for mail or something get a separate vm with cpanel and just use it for the mail services.

    Even if it is more than one site trying to do this with cpanel is not a road I would advise going down.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,528
    Likes Received:
    2,180
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @jimmystack,

    We document how to connect a cPanel & WHM server to a remote MySQL server on the document below:

    Manage MySQL Profiles - Version 80 Documentation - cPanel Documentation

    While technically this is possible, note the warning on the above document regarding the use of more than one cPanel & WHM server on a single remote MySQL server:

    For instance, if the same database name or database username exists on multiple cPanel & WHM servers, then conflicts could arise on the remote MySQL server because it would have no way of determining which cPanel account owns the database.

    The feature request to follow for better integration of remote MySQL servers is found on the link below:

    MySQL Only version of cPanel & WHM

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
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