Page MenuHomePhabricator

the centralauth databases is accessible form the mysql shell on terbium only in some cases
Closed, ResolvedPublic

Description

If I run sql hewiki, then I am connected to the hewiki databases. Coincidentally, this allows me also to run queries from centralauth tables, for example select * from centralauth.globaluser where gu_id = 1156;.

However, I cannot do the same if I do sql enwiki, probably because the centralauth database only happens to be on the same host as hewiki.

It would be nice to have centralauth accessible from all other databases, because it's central.

Thanks!

Event Timeline

Amire80 raised the priority of this task from to Needs Triage.
Amire80 updated the task description. (Show Details)
Amire80 added projects: Analytics, SRE.
Amire80 added subscribers: Amire80, yuvipanda.

This works fine if you are using the analytics slaves from stat*, rather
than the production masters/slaves. I highly doubt we will replicate the CA
db to all production masters/slaves.

As with T122479, whatever works. Can I access them?

Milimetric moved this task from Incoming to Airflow on the Analytics board.
fgiunchedi claimed this task.
fgiunchedi triaged this task as Medium priority.
fgiunchedi subscribed.

@Amire80 according T122479 you should have access to stat boxes and therefore mysql slaves with all dbs, resolving but reopen if this is still an issue