On Thu, Sep 28, 2017 at 9:56 AM, Bryan Davis <bd...@wikimedia.org> wrote: > On Thu, Sep 28, 2017 at 4:04 AM, Jaime Crespo <jcre...@wikimedia.org> wrote: >> On Thu, Sep 28, 2017 at 10:40 AM, MarcoAurelio <strig...@gmail.com> wrote: >>> Hello Bryan, >>> >>> So let's say I want to conect to centralauth_p using the new servers. Shall >>> I 'sql --cluster=analytics centralauth_p'? > > In theory this would work. It looks like in practice however it > currently will not work. The process I used to make the > *.{analytics,web}.db.svc.eqiad.wmflabs service name aliases is based > on the production dblist files. Specifically the script makes CNAME > DNS records for each host listed in s[1-7].dblist as read from > https://noc.wikimedia.org/conf/ which point to the correct > s[1-7].{analytics,web}.db.svc.eqiad.wmflabs A record. > > The centralauth database isn't a wikidb properly so it is not listed > in the dblist files. I opened a bug about this > (<https://phabricator.wikimedia.org/T176978>). I'll find a way to > create additional aliases for the handful of special databases that > are in the cluster.
'sql --cluster=analytics centralauth_p' works now. Bryan -- Bryan Davis Wikimedia Foundation <bd...@wikimedia.org> [[m:User:BDavis_(WMF)]] Manager, Cloud Services Boise, ID USA irc: bd808 v:415.839.6885 x6855 _______________________________________________ Cloud mailing list Cloud@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/cloud