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 server?

Discussion in 'Database Discussion' started by geekbaaz, Jun 21, 2018.

Tags:
  1. geekbaaz

    geekbaaz Registered

    Joined:
    Jun 21, 2018
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    India
    cPanel Access Level:
    DataCenter Provider
    Looking for an architecture advice. We have one inquiry where a customer wants a scalable solution using cpanel.

    Customer wants to host 300 applications/websites on a server with cPanel/WHM and cloudlinux.

    CPU, RAM and HDD requirement will go on increasing as more applications will be added in future. There will be a common MySQL database used by this applications.

    My question is can we setup multiple cPanel servers with a common MySQL server deployed on a dedicated server or common storage ?
     
  2. twhiting9275

    twhiting9275 Well-Known Member

    Joined:
    Sep 26, 2002
    Messages:
    556
    Likes Received:
    16
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    Twitter:
    You need more than one database for these applications. That's just asking for trouble here.
    If you're going to insist on using a single database, then make sure you've at least got redundant MySQL servers setup.
    This is something you should definitely not rely on forum help or advice for. Hire a professional
     
    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:
    45,214
    Likes Received:
    1,936
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @geekbaaz,

    While technically possible, we strongly recommend that you only connect one cPanel & WHM server to each remote MySQL server. If you connect multiple cPanel & WHM servers to one remote MySQL server, you may experience database and username conflicts. This is noted on the following document:

    Manage MySQL Profiles - Version 70 Documentation - cPanel Documentation

    I encourage you to open a feature request if you'd like to see support for this offered:

    Submit A Feature Request

    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