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
