On Thu, Sep 28, 2017 at 9:56 AM, Bryan Davis <bd808(a)wikimedia.org> wrote:
On Thu, Sep 28, 2017 at 4:04 AM, Jaime Crespo
<jcrespo(a)wikimedia.org> wrote:
On Thu, Sep 28, 2017 at 10:40 AM, MarcoAurelio
<strigiwm(a)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 <bd808(a)wikimedia.org>
[[m:User:BDavis_(WMF)]] Manager, Cloud Services Boise, ID USA
irc: bd808 v:415.839.6885 x6855