Buy Percona ServicesBuy Now!

Delete orphan databases in QAN and PMM System Summary using curl commands

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Delete orphan databases in QAN and PMM System Summary using curl commands

    I have a dozens of old staging databases and their respective agents were removed via curl commands. Curl commands are more practical for my deployment/decommissioning tools. However, the databases still remain in the drop list for several dashboards including QAN and _PMM System Summary. What are the curl commands for removing them from QAN and _PMM System Summary?

    Curl Commands used to de-register database in PMM
    curl -X DELETE 'http://USER:PASSWORD@PMM-SERVER-IP/prometheus/api/v1/series?match\[\]=\{instance="NODE-NAME"\}'
    curl -s -X PUT -d '{"Datacenter":"dc1","Node":"NODE-NAME"}' 'http://USER:PASSWORD@PMM-SERVER-IP/v1/catalog/deregister?dc=dc1'
Working...
X