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

[manoaratefy]

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]

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:

Manage MySQL® Profiles | cPanel & WHM Documentation

This interface allows you to manage multiple MySQL® profiles.

docs.cpanel.net

 

[manoaratefy]

But in the MySQL client side (the PHP application), does hostname need to be updated or not?

 

[cPRex]

Nope - since they will point to the system's MySQL configuration you don't need to do anything at the account level.