Hi, I have an unwanted management server reported here on macfgan01, it is
marked as DOWN:
mysql> SELECT * FROM mshost;
+----+-----------------+---------------+----------+--------------------------------------+-------+----------+------------+--------------+---------------------+---------+-------------+
| id | msid | runid | name | uuid
| state | version | service_ip | service_port | last_update |
removed | alert_count |
+----+-----------------+---------------+----------+--------------------------------------+-------+----------+------------+--------------+---------------------+---------+-------------+
| 1 | 207360503444273 | 1627662680438 | macfgan01 |
f685b3cf-5459-4425-bd2e-6be2865540c4 | Down | 4.15.1.0 | 10.257.0.4 |
9090 | 2021-07-30 17:17:36 | NULL | 0 |
| 2 | 279278805491062 | 1627987566294 | macfgan01 |
64ce078b-e945-475d-a9d6-30dbe30569a7 | Up | 4.15.1.0 | 10.257.0.4 |
9090 | 2021-08-03 10:46:27 | NULL | 0 |
| 3 | 191709488474348 | 1627987314655 | macfgan05 |
03544bf1-41af-4d5f-b36d-e7190b3c5504 | Up | 4.15.1.0 | 10.257.0.8 |
9090 | 2021-08-03 10:46:28 | NULL | 0 |
| 4 | 38182022782117 | 1627980352341 | macfgan04 |
19c51d30-2d29-4a0e-8991-1af35835b6dd | Up | 4.15.1.0 | 10.257.0.7 |
9090 | 2021-08-03 10:46:27 | NULL | 0 |
| 5 | 209430416376190 | 1627987033082 | macfgan02 |
de6d0fa5-6c8f-40b4-88de-7a9bcf717e07 | Up | 4.15.1.0 | 10.257.0.5 |
9090 | 2021-08-03 10:46:27 | NULL | 0 |
| 6 | 205492837091104 | 1627987210052 | macfgan03 |
5ed659d7-8c9b-4499-86a0-321531fab9aa | Up | 4.15.1.0 | 10.257.0.6 |
9090 | 2021-08-03 10:46:27 | NULL | 0 |
+----+-----------------+---------------+----------+--------------------------------------+-------+----------+------------+--------------+---------------------+---------+-------------+
6 rows in set (0.00 sec)
What are the commands needed to remove this management server? MySQL newbie
question probably!
TIA, Jim
