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.

One MySQL Server ; Multiple cPanel/WHM installs

Discussion in 'General Discussion' started by wizzy420, Jan 7, 2008.

  1. wizzy420

    wizzy420 Well-Known Member

    Joined:
    Nov 13, 2007
    Messages:
    125
    Likes Received:
    2
    Trophy Points:
    18
    So, can one build a big MySQL server (gobs of RAM, mega-fast drives, gigE interfaces, etc)

    And then have any number of cPanel servers connect to it - running just one instance of MySQL?

    WHM Server 1 Remote DB -> BigJuicyMySQL server
    WHM Server 2 Remote DB -> BigJuicyMySQL server
    etc. etc.

    You know - pool together RAM/disk so instead of ten different MySQL servers running for ten different WHM installs, you have one MySQL server running which can pool the resources.

    Instead of ten little MySQL servers with 512MB of RAM serving db access for ten WHM installs, you have 1 big MySQL server with 5GB of RAM and all the WHM's pointing to it as remote DB.

    Share all that RAM for caching, spend all your money on one big fast array of drives.

    W
     
  2. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,481
    Likes Received:
    28
    Trophy Points:
    48
    cPanel Access Level:
    Root Administrator
    You can certainly do that, however you need to put something in place to guarantee cPanel account name uniqueness amongst all your cPanel servers. Otherwise, if multiple cPanel accounts have the same user name, they will be able to meddle with each other's databases.
     
  3. wizzy420

    wizzy420 Well-Known Member

    Joined:
    Nov 13, 2007
    Messages:
    125
    Likes Received:
    2
    Trophy Points:
    18
    Well, how would this deal with the standard databases like eximstats, horde, cphulkd?

    Can all these be shared between the cPanel + 1 servers, or would one need to modify all the cPanel scripts to use unique names per server?

    Steve
     
    #3 wizzy420, Jan 17, 2008
    Last edited: Jan 17, 2008
  4. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,481
    Likes Received:
    28
    Trophy Points:
    48
    cPanel Access Level:
    Root Administrator
    They should have unique names, which will require modifying all the necessary scripts and excluding them (/etc/cpanelsync.exclude) from updates.
     
Loading...

Share This Page