Message from discussion
Details on FourSquare bug?
Received: by 10.204.46.85 with SMTP id i21mr488227bkf.18.1286324941628;
Tue, 05 Oct 2010 17:29:01 -0700 (PDT)
X-BeenThere: mongodb-user@googlegroups.com
Received: by 10.204.29.18 with SMTP id o18ls2340343bkc.3.p; Tue, 05 Oct 2010
17:28:57 -0700 (PDT)
Received: by 10.204.46.85 with SMTP id i21mr484122bkf.6.1286324937453;
Tue, 05 Oct 2010 17:28:57 -0700 (PDT)
Received: by 10.204.46.85 with SMTP id i21mr484121bkf.6.1286324937407;
Tue, 05 Oct 2010 17:28:57 -0700 (PDT)
Return-Path: <dwi...@10gen.com>
Received: from mail-bw0-f49.google.com (mail-bw0-f49.google.com [209.85.214.49])
by gmr-mx.google.com with ESMTP id p18si94672bkb.0.2010.10.05.17.28.57;
Tue, 05 Oct 2010 17:28:57 -0700 (PDT)
Received-SPF: neutral (google.com: 209.85.214.49 is neither permitted nor denied by best guess record for domain of dwi...@10gen.com) client-ip=209.85.214.49;
Authentication-Results: gmr-mx.google.com; spf=neutral (google.com: 209.85.214.49 is neither permitted nor denied by best guess record for domain of dwi...@10gen.com) smtp.mail=dwi...@10gen.com
Received: by bwz19 with SMTP id 19so6811609bwz.36
for <mongodb-user@googlegroups.com>; Tue, 05 Oct 2010 17:28:57 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.204.127.65 with SMTP id f1mr9164456bks.55.1286324937178; Tue,
05 Oct 2010 17:28:57 -0700 (PDT)
Received: by 10.204.82.207 with HTTP; Tue, 5 Oct 2010 17:28:57 -0700 (PDT)
In-Reply-To: <e84b952d-3f48-453c-930e-edbcf973a644@x42g2000yqx.googlegroups.com>
References: <e84b952d-3f48-453c-930e-edbcf973a644@x42g2000yqx.googlegroups.com>
Date: Tue, 5 Oct 2010 20:28:57 -0400
Message-ID: <AANLkTinVvcO-9EELUt51QMaqZ3O0tc7rSC_G-z4T851Q@mail.gmail.com>
Subject: Re: [mongodb-user] Details on FourSquare bug?
From: Dwight Merriman <dwi...@10gen.com>
To: mongodb-user@googlegroups.com
Content-Type: multipart/alternative; boundary=0016e6d975baf23ff00491e7dcc4
--0016e6d975baf23ff00491e7dcc4
Content-Type: text/plain; charset=ISO-8859-1
Basically, the issue is that if data migrates to a new shard, there is no
re-compaction yet in the old shard of the old collection. So there could be
small empty spots throughout it which were migrated out, and if the objects
are small, there is no effective improvement in RAM caching immediately
after the migration.
A few more notes:
- If your shard key has any correlation to insertion order, I think you are
ok.
- If you add new shards very early s.t. the source shard doesn't have high
load, i think you are ok.
- If your objects are fairly large (say 4KB+), i think you are ok.
- If the above don't hold, you will need the defrag enhancement which we
will do asap.
On Tue, Oct 5, 2010 at 8:15 PM, Colin Davis <cir...@gmail.com> wrote:
> Reading through FourSquare's post-mortem (http://blog.foursquare.com/
> 2010/10/05/so-that-was-a-bummer/) it looks like they had a blowup when
> adding a new shard to their existing systems; They had overloading
> problems, leading to a pretty sizable downtime.
>
> Are there any technical details about what went wrong, and more
> specifically, how do I avoid the same fate?
> If there is some particular "gotcha" I should avoid when adding new
> shards, it would be good to know about it. ;)
>
> Any details would be appreciated.
> -Colin
>
> --
> You received this message because you are subscribed to the Google Groups
> "mongodb-user" group.
> To post to this group, send email to mongodb-user@googlegroups.com.
> To unsubscribe from this group, send email to
> mongodb-user+unsubscribe@googlegroups.com<mongodb-user%2Bunsubscribe@googlegroups.com>
> .
> For more options, visit this group at
> http://groups.google.com/group/mongodb-user?hl=en.
>
>
--0016e6d975baf23ff00491e7dcc4
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
<div>Basically, the issue is that if data migrates to a new shard, there is=
no re-compaction yet in the old shard of the old collection. =A0So there c=
ould be small empty spots throughout it which were migrated out, and if the=
objects are small, there is no effective improvement in RAM caching immedi=
ately after the migration.</div>
<div><br></div><div>A few more notes:=A0</div><div><br></div><div>- If your=
shard key has any correlation to insertion order, I think you are ok.</div=
><div>- If you add new shards very early s.t. the source shard doesn't =
have high load, i think you are ok.</div>
<div>- If your objects are fairly large (say 4KB+), i think you are ok.</di=
v><div>- If the above don't hold, you will need the defrag enhancement =
which we will do asap.</div><div><br></div><div class=3D"gmail_quote">On Tu=
e, Oct 5, 2010 at 8:15 PM, Colin Davis <span dir=3D"ltr"><<a href=3D"mai=
lto:cir...@gmail.com">cir...@gmail.com</a>></span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex;">Reading through FourSquare's post-morte=
m (<a href=3D"http://blog.foursquare.com/
2010/10/05/so-that-was-a-bummer/" target=3D"_blank">http://blog.foursquare.=
com/<br>
2010/10/05/so-that-was-a-bummer/</a>) it looks like they had a blowup when<=
br>
adding a new shard to their existing systems; They had overloading<br>
problems, leading to a pretty sizable downtime.<br>
<br>
Are there any technical details about what went wrong, and more<br>
specifically, how do I avoid the same fate?<br>
If there is some particular "gotcha" I should avoid when adding n=
ew<br>
shards, it would be good to know about it. ;)<br>
<br>
Any details would be appreciated.<br>
-Colin<br>
<font color=3D"#888888"><br>
--<br>
You received this message because you are subscribed to the Google Groups &=
quot;mongodb-user" group.<br>
To post to this group, send email to <a href=3D"mailto:mongodb-user@googleg=
roups.com">mongodb-user@googlegroups.com</a>.<br>
To unsubscribe from this group, send email to <a href=3D"mailto:mongodb-use=
r%2Bunsubscribe@googlegroups.com">mongodb-user+unsubscribe@googlegroups.com=
</a>.<br>
For more options, visit this group at <a href=3D"http://groups.google.com/g=
roup/mongodb-user?hl=3Den" target=3D"_blank">http://groups.google.com/group=
/mongodb-user?hl=3Den</a>.<br>
<br>
</font></blockquote></div><br>
--0016e6d975baf23ff00491e7dcc4--