Page MenuHomePhabricator

Fix power power accounting for misc cluster
Open, MediumPublic

Description

Hosts starting from db2200 are accounted as the misc cluster in the power dashboard but they do not belong to misc:

https://grafana-rw.wikimedia.org/d/f64mmDzMz/power-dashboard?forceLogin=true&from=now-2d&orgId=1&timezone=utc&to=now&var-datasource=PA7DE9A562EF40E24&var-instance=$__all&var-row=$__all&var-site=codfw&viewPanel=panel-110

The section in the zarcillo table need to be cross-checked with what is in puppet and what shows up in the dashboard above.

Event Timeline

FCeratto-WMF triaged this task as Medium priority.
FCeratto-WMF added a project: DBA.
FCeratto-WMF moved this task from Triage to Ready on the DBA board.
FCeratto-WMF removed a subscriber: Aklapper.

It is very likely a case of changing it from core to misc on the zarcillo table

It is very likely a case of changing it from core to misc on the zarcillo table

I‌ don't know where these metrics are coming from but it's way beyond mysql. Other clusters are "swift", "analytics", "wikikube", etc. All of databases have been clustered under "mysql" so it's somewhere above zarcillo I‌think

Yes, zarcillo seems to be fine indeed as these hosts are indeed misc so the issue must be somewhere else:

cumin2024@db1215.eqiad.wmnet[zarcillo]> select * from instances where name like 'db22%' and `group`='misc';
+--------+--------------------+------+---------+------------+-------+
| name   | server             | port | version | last_start | group |
+--------+--------------------+------+---------+------------+-------+
| db2232 | db2232.codfw.wmnet | 3306 | NULL    | NULL       | misc  |
| db2233 | db2233.codfw.wmnet | 3306 | NULL    | NULL       | misc  |
| db2234 | db2234.codfw.wmnet | 3306 | NULL    | NULL       | misc  |
| db2235 | db2235.codfw.wmnet | 3306 | NULL    | NULL       | misc  |
+--------+--------------------+------+---------+------------+-------+
4 rows in set (0.002 sec)