On Thu, Sep 28, 2017 at 9:56 AM, Bryan Davis bd808@wikimedia.org wrote:
On Thu, Sep 28, 2017 at 4:04 AM, Jaime Crespo jcrespo@wikimedia.org wrote:
On Thu, Sep 28, 2017 at 10:40 AM, MarcoAurelio strigiwm@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