Thanks Magnus, that's amazing. On Tue, Sep 26, 2017 at 3:27 AM, Magnus Manske <magnusman...@googlemail.com> wrote:
> Hooray! I have switched most of my tools over, taking care to put > long-running queries (including PetScan queries) on the analytics server. > Initial tests see a ~5x improvement in query time! > > On Tue, Sep 26, 2017 at 4:25 AM Dan Andreescu <dandree...@wikimedia.org> > wrote: > >> In case you are tempted to overlook this, I'm here to change your mind. >> This is a *BIG *deal. These servers are so much better and faster and >> smarter, it's beautiful. >> >> Also, small side note: stay tuned for better analytics-oriented databases >> being made available on our cloud over the next quarter. >> >> On Mon, Sep 25, 2017 at 7:45 PM, Bryan Davis <bd...@wikimedia.org> wrote: >> >>> On Mon, Sep 25, 2017 at 5:43 PM, Bryan Davis <bd...@wikimedia.org> >>> wrote: >>> > After more than a year of effort by the DBA team, a new set of Wiki >>> > Replica servers are ready for full use by Cloud Services users. The >>> > new servers are faster, have more disk space, and are using updated >>> > software and configuration that corrects many historic problems with >>> > replica drift and security. >>> > >>> > See the technical blog post for full details: <> >>> > >>> > TL;DR: >>> > - Change your tools and scripts to use: >>> > - `*.web.db.svc.eqiad.wmflabs` (real-time response needed) >>> > - `*.analytics.db.svc.eqiad.wmflabs` (batch jobs; long queries) >>> > - Replace `*` with either a shard name (e.g. `s1`) or a wikidb name >>> > (e.g. `enwiki`). >>> > - The new servers **do not** support user created databases/tables >>> > because replication can't be guaranteed. See the blog post for more >>> > information. >>> > - `tools.db.svc.eqiad.wmflabs` (also known as `tools.labsdb`) will >>> > continue to support user created databases and tables. >>> > - Report any bugs you find with these servers in Phabricator using the >>> > #Data-Services tag. >>> >>> And the missing URL to the blog post: >>> <https://phabricator.wikimedia.org/phame/post/view/ >>> 70/new_wiki_replica_servers_ready_for_use/> >>> >>> 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 >>> >>> _______________________________________________ >>> Labs-announce mailing list >>> labs-annou...@lists.wikimedia.org >>> https://lists.wikimedia.org/mailman/listinfo/labs-announce >>> >> >> _______________________________________________ >> Labs-l mailing list >> Labs-l@lists.wikimedia.org >> https://lists.wikimedia.org/mailman/listinfo/labs-l >> > > _______________________________________________ > Labs-l mailing list > Labs-l@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/labs-l > > -- Chase Pettet chasemp on phabricator <https://phabricator.wikimedia.org/p/chasemp/> and IRC
_______________________________________________ Labs-l mailing list Labs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/labs-l