PMM: 2.6.0 How to remove a db node from monitoring?

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 ID
PostgreSQL    pmm-server-postgresql 127.0.0.1:5432    /service_id/fab676f7-3a1a-4434-93f8-83a6c5cb0e92

Agent type                  Status     Agent ID                                        Service ID
pmm_agent                   Connected  pmm-server
node_exporter               Running    /agent_id/feca75c3-084e-4351-8075-4e76b38bfb5f
mysqld_exporter             Running    /agent_id/3b8dc738-8aed-46ad-2101-dc373f07632e  /service_id/1a27cc80-fb81-4e64-832b-3877a3c4b00d
mysqld_exporter             Running    /agent_id/34701eb9-73f4-4b87-bd10-77a8ab0375fb  /service_id/e61b0121-e18f-4874-ba5d-5b0e6b3dcf3a
mysqld_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-732e045ae2a4
postgres_exporter           Running    /agent_id/6fae6449-3e6e-4d34-9422-d0c2bab64f26  /service_id/fab676f7-3a1a-4434-93f8-83a6c5cb0e92
postgres_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!

Best Answer

Answers

  • adivinhoadivinho Percona Percona
    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.
    [[email protected] ~]$ 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

    [[email protected] ~]$ pmm-admin remove mongodb mongodb_node_3
    Service removed.

  • VenkatVenkat Active Member Contributor
    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 ID
    PostgreSQL    pmm-server-postgresql 127.0.0.1:5432    /service_id/fab676f7-3a1a-4434-93f8-83a6c5cb0e92

    Agent type                  Status     Agent ID                                        Service ID
    pmm_agent                   Connected  pmm-server
    node_exporter               Running    /agent_id/feca75c3-084e-4351-8075-4e76b38bfb5f
    mysqld_exporter             Running    /agent_id/3b8dc738-8aed-46ad-2101-dc373f07632e  /service_id/1a27cc80-fb81-4e64-832b-3877a3c4b00d
    mysqld_exporter             Running    /agent_id/34701eb9-73f4-4b87-bd10-77a8ab0375fb  /service_id/e61b0121-e18f-4874-ba5d-5b0e6b3dcf3a
    mysqld_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-732e045ae2a4
    postgres_exporter           Running    /agent_id/6fae6449-3e6e-4d34-9422-d0c2bab64f26  /service_id/fab676f7-3a1a-4434-93f8-83a6c5cb0e92
    postgres_exporter           Running    /agent_id/7272a419-b8a3-4ceb-be7a-e9cb3250e261  /service_id/281226f4-77d1-4b6a-90c1-9b0aff69fdaa

    Regards.
    Venkat 
  • VenkatVenkat Active Member Contributor
    Hi Adivinho,
    That's perfect! It all now worked! I don't have enough words to thank you!
    Thanks a TON!
    Regards.
    -Venkat
  • daniil.bazhenovdaniil.bazhenov Percona Admin
    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
  • VenkatVenkat Active Member Contributor
    Additionally, had to remove the nodes as well.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.