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

Tue Sep 26 13:59:03 UTC 2017

Thanks Magnus, that's amazing.

On Tue, Sep 26, 2017 at 3:27 AM, Magnus Manske <magnusmanske at 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 <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
>>
>
> _______________________________________________
> Labs-l mailing list
> Labs-l at lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/labs-l
>
>

-- 
Chase Pettet
chasemp on phabricator <https://phabricator.wikimedia.org/p/chasemp/> and
IRC
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/labs-announce/attachments/20170926/c319df34/attachment.html>