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

Well-Known Member
Nov 17, 2018
53
5
8
Madagascar
cPanel Access Level
Root Administrator
Twitter
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
6,810
895
313
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: