Multiple cPanel web server with one remote mysql Cluster

[Spyros]

Hello,

I have implement a Mysql cluster under one ip and i was possible to setup a cpanel web server for remote mysql access. also cluster work with some autonomous web servers.

My problem is that i need to point 3 cpanel web server to the same mysql cluster. how can i do that without brake cpanel functionallity? i saw that when connect my web server for remote connection with the cluster , it create all database that cpanel need to be functional.


Many Regards,

 

[cPanelMichael]

Hello

You may find the following document helpful:

Manage MySQL® Profiles - Documentation - cPanel Documentation

In particular:

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.

While it may function, keep in mind that some database names are always the same on cPanel servers. EX:

eximstats
cphulkd
modsec
leechprotect
whmxfer

You will need to take this into account if you are using the same MySQL serer for multiple cPanel servers. Also, note a feature request for this also includes a helpful comment:

Remote mySQL server for multiple cPanel server

Thank you.