[Labs-l] [Labs-announce] New Wiki Replica servers ready for use

[Magnus Manske]

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 <dandreescu at 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 <bd808 at wikimedia.org> wrote:
>
>> On Mon, Sep 25, 2017 at 5:43 PM, Bryan Davis <bd808 at 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    <bd808 at wikimedia.org>
>> [[m:User:BDavis_(WMF)]] Manager, Cloud Services          Boise, ID USA
>> irc: bd808                                        v:415.839.6885 x6855
>>
>> _______________________________________________
>> Labs-announce mailing list
>> Labs-announce at lists.wikimedia.org
>> https://lists.wikimedia.org/mailman/listinfo/labs-announce
>>
>
> _______________________________________________
> Labs-l mailing list
> Labs-l at lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/labs-l
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/labs-l/attachments/20170926/8310cd2e/attachment.html>