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

Manoa R.

• November 03, 2020 08:45

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

  • November 03, 2020 14:28

  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:

  0
• 

  Manoa R.

  • November 03, 2020 15:01

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

  0
• 

  cPRex Jurassic Moderator

  • November 03, 2020 16:00

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

  0

Please sign in to leave a comment.