Duplicate Replica Sets for the Same Server or Service_Name in the Replication Summary dashboard

Percona Monitoring and Management (PMM)
1

Hi,

How can I login and check the Victoria Metrics DB tables? I would like to check the replication Set details, including where and which table it is storing.

Can you please share with me the commands, how to login, and how to perform the DML (select, update,DELETE) operations?

image
image1841×237 35.7 KB

2

Hello @Naresh9999 , there are 2 options:

  1. A dashboard in grafana called Explore
  2. open VM UI by calling /prometheus endpoint.
3

Hi @nurlan

Thanks for the details. but actually I am facing the duplicate issue in the Replication Summary dashboard.

The same server shows two different replica sets.

Actaul Replica Set:

image
image1919×218 42.3 KB

Wrong Replica Set:

image
image1919×235 42.4 KB

Actually, we wrongly added the replica set name " * YDSARC-BI-RE", After some time, we realized and changed the replica set name to *“YDSARC-BI-REP”. But actually, it should show an actual replica set named “YDSARC-BI-REP” but why is " YDSARC-BI-RE" replica duplicating for the same server?

NOTE: Even in the inventory its showing replica-set name as “YDSARC-BI-REP”

4

Can someone please help me with the above issue?

5

Can someone please help me with the above issue?

6

Hi @Naresh9999, we use Victoria metrics data to generate those filters, so when retention period is passed that cluster should disappear.

7

Thanks @nurlan for the update.

Sure, we will wait until the retention period is passed.

8

@Naresh9999 you also can try to remove mysql_up metrics for your replication set using VM API VictoriaMetrics · VictoriaMetrics.

9

@nurlan But how can I delete a replica set named *“YDSARC-BI-RE ” that I don’t want?

10

@Naresh9999 Theoretically, removing metrics using mysql_up{replication_set="YDSARC-BI-RE"} should remove that replicaset from the dashboard.

11

@nurlan

Is the below command correct?

http://192.168.1.100:8428/api/v1/admin/tsdb/delete_series?match[]=mysql_up{replication_set=“YDSARC-BI-RE”}

12

@Naresh9999, I think the link should be http://192.168.1.100:8428/prometheus/api/v1/admin/tsdb/delete_series?match[]=mysql_up{replication_set=“YDSARC-BI-RE”}

13

Hi @nurlan

Let me try this and update you.