Page MenuHomePhabricator

Service name aliases in *.{analytics,web}.db.svc.eqiad.wmflabs missing for non-wiki databases
Closed, ResolvedPublic

Description

The current CNAMEs (e.g. enwiki.analyatics.db.svc.wmflabs) are created by iterating the s[1-7].dblist files as read from noc.wikimedia.org. This will get all of the wikidb names, but it misses creating aliases for non-wiki databases like centralauth.

$ sql -vv --cluster=analytics centralauth
Looking up centralauth.analytics.db.svc.eqiad.wmflabs
Could not find requested database
Make sure to ask for a db in format of <wiki>_p

$ sql -vv --cluster=labsdb centralauth
Looking up centralauth.labsdb
Resolved centralauth_p to centralauth.labsdb
Connecting to centralauth.labsdb
['mysql', '--defaults-file=/home/bd808/replica.my.cnf', '-h', 'centralauth.labsdb', 'centralauth_p']
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 51452892
Server version: 10.0.22-MariaDB MariaDB Server

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

(u3518@centralauth.labsdb) [centralauth_p]>

Event Timeline

Is centralauth in s7 the only database like this?

Is centralauth in s7 the only database like this?

(u3518@centralauth.labsdb) [information_schema_p]> select schema_name from schemata
    -> where schema_name not like '%wiki%'
    -> and schema_name not like '%wiktionary';
+-------------+
| schema_name |
+-------------+
| centralauth |
+-------------+
1 row in set (0.01 sec)

Mentioned in SAL (#wikimedia-operations) [2017-09-28T16:48:58Z] <bd808> Created centralauth.{analytics,web}.db.svc.eqiad.wmflabs Designate CNAME (T176978)

Change 381260 had a related patch set uploaded (by BryanDavis; owner: Bryan Davis):
[operations/puppet@production] wmcs: wikireplica_dns: add support for non-wikidb CNAMES

https://gerrit.wikimedia.org/r/381260

Change 381260 merged by Rush:
[operations/puppet@production] wmcs: wikireplica_dns: add support for non-wikidb CNAMES

https://gerrit.wikimedia.org/r/381260

bd808 claimed this task.
bd808 edited projects, added cloud-services-team (Kanban); removed Patch-For-Review.
$ sql -vv --cluster=analytics centralauth
Looking up centralauth.analytics.db.svc.eqiad.wmflabs
Resolved centralauth_p to centralauth.analytics.db.svc.eqiad.wmflabs
Connecting to centralauth.analytics.db.svc.eqiad.wmflabs
['mysql', '--defaults-file=/home/bd808/replica.my.cnf', '-h', 'centralauth.analytics.db.svc.eqiad.wmflabs', 'centralauth_p']
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 4331167
Server version: 10.1.25-MariaDB MariaDB Server

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

(u3518@centralauth.analytics.db.svc.eqiad.wmflabs) [centralauth_p]>