@Brooke: Thanks. This is an older script that I should have moved over but somehow forgot. I am surprised that you did not find it in your greps though. I will point it to the new servers momentarily.
@John: I believe you still can use something similar. Instead of "enwiki.labdsdb" you can use "enwiki.web.db.svc.wikimedia.cloud" and not worry about which DB slice that belongs to. See https://wikitech.wikimedia.org/wiki/News/Wiki_Replicas_2020_Redesign#New_host_names On Tue, Apr 6, 2021 at 3:39 PM John <phoenixoverr...@gmail.com> wrote: > is meta_p still supported? > > On Tue, Apr 6, 2021 at 3:31 PM John <phoenixoverr...@gmail.com> wrote: > >> Will we have a simple way to connect to the databases? One of the key >> reasons that "enwiki.labsdb" works so well is that from a programming level >> we dont have to worry about which server/slice a particular database is on. >> Using the <lang><project>_p at <lang><project>.labsdb created a simple >> uniform way to connect without having to keep track of what database moved >> to which slice (when that was added mid size wikis were being moved >> regularrly >> >> On Tue, Apr 6, 2021 at 3:11 PM Brooke Storm <bst...@wikimedia.org> wrote: >> >>> >>> >>> On Apr 6, 2021, at 11:49 AM, Huji Lee <huji.h...@gmail.com> wrote: >>> >>> Pardon my potentially dumb question, but how do the shorter DB names get >>> resolved? >>> >>> I have python code that looks like this: >>> >>> *conn = mysqldb.connect(host="enwiki.labsdb", db="enwiki_p", >>> read_default_file="~/replica.my.cnf")* >>> >>> How does *enwiki.labsdb* get resolved to, I am assuming, >>> *enwiki.web.db.svc.wikimedia.cloud* and will this stop working on April >>> 28th? >>> >>> >>> >>> Those names were deprecated years ago and are not maintained (they only >>> work for a certain fraction of databases). They are just CNAMES exactly >>> like the others: >>> enwiki.labsdb. 871 IN CNAME s1.analytics.db.svc.eqiad.wmflabs. >>> >>> I did mass grepping in Toolforge NFS and didn’t find any uses of them. >>> So, I’m surprised they are still used anywhere, but recursive greps can >>> miss things. >>> >>> So on those names: >>> 1. Please don’t use them anyway because they will certainly go away at >>> some point and only work for the oldest wikis. >>> 2. Since they point at the old DNS names for the sections, they go >>> wherever they go. If we redirect them to the new cluster, they’ll just keep >>> working like before. >>> >>> They honestly need to be cleaned up (as part of the overall removal of >>> “labs” names), but that’s a separate task that needs communication and so >>> forth. >>> >>> —Brooke Storm >>> _______________________________________________ >>> Wikimedia Cloud Services mailing list >>> Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) >>> https://lists.wikimedia.org/mailman/listinfo/cloud >>> >> _______________________________________________ > Wikimedia Cloud Services mailing list > Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) > https://lists.wikimedia.org/mailman/listinfo/cloud >
_______________________________________________ Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud
