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?
Please sign in to leave a comment.