MySQL clustering - Does users need to update their MySQL hosts on configuration file?

Operating System & Version
CloudLinux 7.8
cPanel & WHM Version
v90.0.16

manoaratefy

Active Member
Nov 17, 2018
37
3
8
Madagascar
cPanel Access Level
Root Administrator
Good morning,

To avoid downtime during a MySQL downgrade operation, I wish to setup a clustering to keep data available and useable.

If I setup a MySQL cluster from a cPanel server and with another MySQL server (non-cpanel, just MySQL installed), does I need to update the MySQL hostname on each wp-config.php, configuration.php, ... of each website (as I'm going to shutdown the local MySQL server during the downgrade)?

Best regards.
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
2,313
307
213
cPanel Access Level
Root Administrator
Hey there! The configuration gets setup in the main /etc/my.cnf, so you don't have to update each individual file on the system. Additional details on the remote MySQL setup can be found here: