Permanently delete a host
Hi,
I am working on a POC using a temporary enterprise license. Trying to learn how everything works and I came across an issue that I've tried to fix myself, but can't seem to find the right combination. I have a 3-node Percona cluster that I build out myself using Chef and then added the cluster via the "Existing Cluster" wizard. It only detected two of the three nodes, and added those two to the cluster correctly. There doesn't appear to be any way to add an existing cluster member to a precreated cluster, so I deleted it and tried to recreate it. Now, all three IPs are stored in the "hosts" table, but are not associated with any actual cluster. I can't find any way in the UI to delete hosts.
So I jumped into the MySQL DB that cmon uses and deleted the entries for the bad hosts from hosts, cluster_*, and any other references I could find from cmon and dcps. Everything looked clean. I deleted /etc/cmon.d/*2 and *3 (the two relevant clusters). When I restart cmon, all of these tables are repopulated. How can I permanently mark a host as actually *gone* so that I can reuse it?
Thanks!
Wes
-
Hi Wes,
About add existing:- Did you have all three nodes listed in the wsrep_cluster_address in the my.cnf files for the galera cluster?
- Do you have an error message from the job?
About cleaning:
- Next version will have an improved cleanup . so the /etc/cmon.d/cmon*.cnf files for a cluster will be deleted when you press "Delete Cluster" in the UI .
To clean up the wrong host please do (this is also improved):1) service cmon stop
2) delete the wrong host
3) rm -rf /etc/cmon.d/cmon*
4) rm -rf /etc/cmon.cnf.bak
5) EDIT /etc/cmon.cnf
Remove any wrongly added host there in the mysql_server_addresses parameter.And sorry for the late response. For urgency I recommend you put tickets in support.severanines.com/tickets/new
BR
johan -
Thanks, Johan. Sorry if the request ended up in the wrong place, but this was the only path I ended up with clicking through the site. It looked mysteriously like a forum post, but also said "Add a ticket" or something, so I went with it.
- Yep, all three were in the my.cnf. My *initial* trial, however, they were not. But I've tried it both ways.
- On cluster0, I probably tried to add it 8 times before I got the correct combination of everything in place. The *final* add had no error messages : )I actually just wiped the entire install and started over, though I think I'd tried everything in your list; perhaps not all during the same reboot cycle. When the database kept getting repopulated I just gave up and decided to start clean.
Thanks!
Wes
Please sign in to leave a comment.
Comments
3 comments