Not the answer you need?
Register and ask your own question!

Remove redundant hosts from QAN

cduffincduffin EntrantCurrent User Role Beginner
We created database hosts for testing, upon which we installed pmm-client so we could monitor the impact of some changes. After this testing was done the hosts were deleted. While the hosts have disappeared from Grafana, they are still showing in QAN, and as one of them is first alphabetically, you are greeted by an error every time you load QAN. Is there anyway to remove this host from QAN?

Comments

  • MykolaMykola Percona Percona Staff Role
    Hi,

    1. login to consul interface http://PMM.SERVER.IP/consul/
    2. click "NODES" button,
    3. choose and "Deregister" unwanted node
    3. login to Query Analytics interface http://PMM.SERVER.IP/qan/
    4. choose unwanted node in dropdown menu
    5. copy-paste node ID from the url
    http://PMM.SERVER.IP/qan/#/instance/46c294490cd4417e685d22196496a777/begin/2017-01-19T19:47:24/end/2017-01-19T20:47:24/
    6. make delete query to PMM Server
    curl -X "DELETE" 'http://PMM.SERVER.IP/qan-api/instances/46c294490cd4417e685d22196496a777'
    
    7. Close tab with Query Analytics interface. reload is not working!
    8. open Query Analytics interface without node ID in url - http://PMM.SERVER.IP/qan/
  • cduffincduffin Entrant Current User Role Beginner
    That works perfectly, thank you!
  • albertalbert Entrant Current User Role Contributor
    Does pmm v1.1.0 cancel the "Deregister" button?
  • MykolaMykola Percona Percona Staff Role
    Hi Albert,

    We always update grafana, prometheus, consul, orchestrator services during PMM Server release.

    unfortunately, Consul developers removed this button from the web interface :(
    https://github.com/hashicorp/consul/issues/2541
  • albertalbert Entrant Current User Role Contributor
    Oh,I see. Thanks!
This discussion has been closed.

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