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

Tue Sep 26 14:46:01 UTC 2017

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
<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
>

-- 
Jaime Crespo
<http://wikimedia.org>