Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

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

VenkatVenkat Current User Role Contributor
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 Staff Role
    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 Current User Role 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 Current User Role 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 Role, API
    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 Current User Role 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.