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.

Question about MySQL warning in cPanel Docs

Discussion in 'Database Discussions' started by edigest, Jul 14, 2015.

  1. edigest

    edigest Active Member

    Joined:
    Nov 24, 2010
    Messages:
    42
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    S. Pole
    cPanel Access Level:
    Root Administrator
    The documentation for "Setup remote MySQL server" (https://documentation.cpanel.net/display/ALD/Setup+Remote+MySQL+Server)
    contains the following warning:
    • We strongly recommend that each remote MySQL server correspond to a single cPanel & WHM server. While you can use a single remote MySQL server for multiple cPanel & WHM servers, we do not recommend this configuration.
    There is no further discussion in the docs. What are the issues with having multiple WHM servers accessing a single DB server?

    Any experience running multiple web servers with one DB server? Problems encountered?
     
  2. edigest

    edigest Active Member

    Joined:
    Nov 24, 2010
    Messages:
    42
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    S. Pole
    cPanel Access Level:
    Root Administrator
    Quick update:

    Chatted with a CPanel tech and got some good information regarding my question.

    No specific problems with multiple web servers and on DB server. The main issue is to ensure the DB server is beefy enough to handle the load if hooking up multiple web servers.
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    You may encounter some issues with shared database names. For instance, a recent issue brought up from a customer involves the update process invoking /scripts/horde_mysqltosqlite, causing the deletion of the horde database on the remote MySQL server. It's truly unsupported, meaning we don't plan for multiple cPanel servers sharing a remote MySQL server when developing features or addressing bugs. My personal opinion is that you should not utilize the same remote MySQL server for multiple cPanel servers unless you are comfortable with the potential for unforeseen issues.

    Thank you.
     
Loading...

Share This Page