Great! 5x was the initial (shy) estimation, good to see it actually delivers! This will encourage other users to migrate ASAP.
Thank you again! On Tue, Sep 26, 2017 at 9:27 AM, Magnus Manske <[email protected]> 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 <[email protected]> > 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 <[email protected]> wrote: >>> >>> On Mon, Sep 25, 2017 at 5:43 PM, Bryan Davis <[email protected]> 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 <[email protected]> >>> [[m:User:BDavis_(WMF)]] Manager, Cloud Services Boise, ID USA >>> irc: bd808 v:415.839.6885 x6855 >>> >>> _______________________________________________ >>> Labs-announce mailing list >>> [email protected] >>> https://lists.wikimedia.org/mailman/listinfo/labs-announce >> >> >> _______________________________________________ >> Labs-l mailing list >> [email protected] >> https://lists.wikimedia.org/mailman/listinfo/labs-l > > > _______________________________________________ > Labs-l mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/labs-l > -- Jaime Crespo <http://wikimedia.org> _______________________________________________ Labs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/labs-l
