Multiple cPanel servers with a common MySQL server?

[geekbaaz]

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]

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]

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.