I am able to list services using pmm-admin after using -server-insecure-tls. But interestingly, it shows something like below:
Service type Service name Address and port Service IDPostgreSQL pmm-server-postgresql 127.0.0.1:5432 /service_id/fab676f7-3a1a-4434-93f8-83a6c5cb0e92
Agent type Status Agent ID Service IDpmm_agent Connected pmm-servernode_exporter Running /agent_id/feca75c3-084e-4351-8075-4e76b38bfb5fmysqld_exporter Running /agent_id/3b8dc738-8aed-46ad-2101-dc373f07632e /service_id/1a27cc80-fb81-4e64-832b-3877a3c4b00dmysqld_exporter Running /agent_id/34701eb9-73f4-4b87-bd10-77a8ab0375fb /service_id/e61b0121-e18f-4874-ba5d-5b0e6b3dcf3amysqld_exporter Running /agent_id/3c4b2103-0449-46e0-8cc2-e6e197953898 /service_id/3814c920-7636-467c-85bb-b11c66a95447
postgres_exporter Running /agent_id/11be76e9-c72a-4bc0-7825-6f6820948c9c /service_id/ce1b7578-5653-40e2-979c-732e045ae2a4postgres_exporter Running /agent_id/6fae6449-3e6e-4d34-9422-d0c2bab64f26 /service_id/fab676f7-3a1a-4434-93f8-83a6c5cb0e92postgres_exporter Running /agent_id/7272a419-b8a3-4ceb-be7a-e9cb3250e261 /service_id/281226f4-77d1-4b6a-90c1-9b0aff69fdaa.
.
I have several MySQL and couple of postgres instances registered and showing up on the dashboard. I want to remove some postgres and some mysql instances. How do I do that.
Thank you!
Hi Venkat,
Please use the command pmm-admin remove <service-type> [<service-name>]
You should specify type and name of a service for removing.
Here is an example of removing a mongodb instance.
e.g.
[ec2-user@ip-10-178-1-105 ~]$ pmm-admin list
Service type Service name Address and port Service ID
MongoDB mongodb_node_2 localhost:27021 /service_id/2b9c269b-29e4-479a-94d0-14ac8268b1ad
MongoDB mongodb_node_3 localhost:27026 /service_id/615cb5c8-8545-4694-bc9a-676d32fb2d65
MongoDB mongodb_node_1 localhost:27017 /service_id/e2b5bd94-bd88-498c-937c-b61c885fa916
Agent type Status Agent ID Service ID
pmm_agent Connected /agent_id/bb75578f-f6ea-4b16-8f29-7fc76dc71f01
node_exporter Running /agent_id/15504187-a8c0-4948-89e9-fd8beca42b8f
mongodb_exporter Running /agent_id/f9e15c61-ef75-4251-8bee-23181067ad1f /service_id/e2b5bd94-bd88-498c-937c-b61c885fa916
mongodb_profiler_agent Running /agent_id/3a664850-46c9-4cfa-a50d-bb9b23db97d5 /service_id/e2b5bd94-bd88-498c-937c-b61c885fa916
mongodb_profiler_agent Running /agent_id/b6d5e285-1d00-4037-b476-b52384c05428 /service_id/615cb5c8-8545-4694-bc9a-676d32fb2d65
mongodb_profiler_agent Running /agent_id/baab7571-9598-448b-9d62-52216148eba0 /service_id/2b9c269b-29e4-479a-94d0-14ac8268b1ad
[ec2-user@ip-10-178-1-105 ~]$ pmm-admin remove mongodb mongodb_node_3
Service removed.
Hi Adivinho,Thank you for your response. I appreciate it. I am aware of that from documentation. However if you see what I had posted, it’s only showing one service name. Others are all agent type. I have a feel that something has changed in the latest update 2.6.0. I could be missing something?
Here it is again:
Service type Service name Address and port Service IDPostgreSQL pmm-server-postgresql 127.0.0.1:5432 /service_id/fab676f7-3a1a-4434-93f8-83a6c5cb0e92
Agent type Status Agent ID Service IDpmm_agent Connected pmm-servernode_exporter Running /agent_id/feca75c3-084e-4351-8075-4e76b38bfb5fmysqld_exporter Running /agent_id/3b8dc738-8aed-46ad-2101-dc373f07632e /service_id/1a27cc80-fb81-4e64-832b-3877a3c4b00dmysqld_exporter Running /agent_id/34701eb9-73f4-4b87-bd10-77a8ab0375fb /service_id/e61b0121-e18f-4874-ba5d-5b0e6b3dcf3amysqld_exporter Running /agent_id/3c4b2103-0449-46e0-8cc2-e6e197953898 /service_id/3814c920-7636-467c-85bb-b11c66a95447
postgres_exporter Running /agent_id/11be76e9-c72a-4bc0-7825-6f6820948c9c /service_id/ce1b7578-5653-40e2-979c-732e045ae2a4postgres_exporter Running /agent_id/6fae6449-3e6e-4d34-9422-d0c2bab64f26 /service_id/fab676f7-3a1a-4434-93f8-83a6c5cb0e92postgres_exporter Running /agent_id/7272a419-b8a3-4ceb-be7a-e9cb3250e261 /service_id/281226f4-77d1-4b6a-90c1-9b0aff69fdaa
Regards.Venkat
Hi Venkat,
You are using pmm-admin command directly on the pmm-server. So service names are not shown.
There is present an additional command that can be used for managing instances.
pmm-admin inventory --help
Please notice that an agent related to a service has to be removed first.
e.g.
# pmm-admin inventory remove agent /agent_id/b52e2f4e-e758-4fe9-af07-6bc8e9adebb1
Agent removed.
# pmm-admin inventory remove service /service_id/21747bde-6a30-4d4f-89b3-27a3c744fbae
Service removed.
Hi Adivinho,
That’s perfect! It all now worked! I don’t have enough words to thank you!
Thanks a TON!
Regards.
-Venkat
Dear @Venkat
Thank you for using PMM. We are glad that we were able to help you on this forum.
We would really appreciate it if you write a review of PMM on Capterra. You can even write a short review, share your experience or tell others about some cool PMM feature. It won’t take long at all.
Capterra Link: https://review.capterra.com/SS-Percona-Monitoring-and-Management-203166-3458367763
Forum Link: https://forums.percona.com/discussion/55636/pmm-product-reviews#latest
Additionally, had to remove the nodes as well.