Multiple cPanel servers with a common MySQL server?

geekbaaz

Registered
Jun 21, 2018
2
0
1
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 ?
 

twhiting9275

Well-Known Member
Sep 26, 2002
560
28
178
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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,908
2,216
463
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.