0

I have to update the os on a few servers and I need to remove a db from the cluster.

wsrep_cluster_address='gcomm://192.168.2.59,192.168.2.60,192.168.2.61,192.168.2.62,192.168.2.63'

Do I remove the ip adress from the cluster line then restart each node? Or do I stop the service on the server I want to remove from the cluster then remove the ip address on the other nodes then restart the mysql service?

user3525290
  • 101
  • 1
  • 2
    In general you do both: you stop the node to be removed, and then remove it from configurations of other nodes, where it is mentioned. However, this is not required nor recommended for an update. Had you read Galera update instructions? – Nikita Kipriyanov Oct 29 '21 at 13:07
  • No I have not read the update instructions. I couldn't find any instructions. My issue is i am moving from mysql 5.7 to 8.0. My plan was update on server get galera working then update another server. Can you post the link. – user3525290 Oct 29 '21 at 13:37
  • dba.stackexchange is a better place for DBA questions about may database. – Rick James Oct 29 '21 at 15:19

0 Answers0