Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of fiedler.andre@googlemail.com
 designates 209.85.160.172 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=googlemail.com; s=gamma;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :content-type;
        b=c920FYibCtE6cyLBsMu4DpgUi7TioIIAbvB4kgNICHqlutZnbZtSzNQYWvZBm5IViv
         cB5ag8O3B7SLxoeOWMHsWFGIp8d8fd4Ws5bu9zO+OFRFQxCRD4z/Ola6ub3eQcr5tXyI
         KwmL2DuWglGdhMSJUv0cSbpsgZKG6FQ/hnBm4=
MIME-Version: 1.0
In-Reply-To: <AANLkTim_6O_aaTDBgq2f6WTN5tHA_w9idOh6=W9NKBnp@mail.gmail.com>
References: <AANLkTim_6O_aaTDBgq2f6WTN5tHA_w9idOh6=W9NKBnp@mail.gmail.com>
From: =?UTF-8?Q?Andr=C3=A9_Fiedler?= <fiedler.andre@googlemail.com>
Date: Sun, 28 Nov 2010 13:01:46 +0100
Message-ID: <AANLkTimKKDsr4am5kp6QjTT3f9no31mEJ6dRrAL4BA+r@mail.gmail.com>
Subject: Re: Using mySQL to emulate Cassandra
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=0016362839d47b11be04961bb971

--0016362839d47b11be04961bb971
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

If you want to do this, don=C2=B4t use autoincrementing integers! ;o) Use U=
UID
instead. (or implement an stand alone id-server that handles autoincrement
savely)


2010/11/28 David Boxenhorn <david@lookin2.com>

> As our launch date approaches, I am getting increasingly nervous about
> Cassandra tuning. It is a mysterious black art that I haven't mastered ev=
en
> at the low usages that we have now. I know of a few more things I can do =
to
> improve things, but how will I know if it is enough? All this is
> particularly ironic since - as we are just starting out - we don't have
> scalability problems yet, though we hope to!
>
> Luckily, I have completely wrapped Cassandra in an entity mapper, so that=
 I
> can easily trade in something else, perhaps temporarily, until we really
> need Cassandra's scalability.
>
> So, I'm thinking of emulating Cassandra with mySQL. I would use mySQL
> either as a simple key-value store, without joins, or map Cassandra
> supercolumns to mySQL columns, probably of type CLOB.
>
> Does anyone want to talk me out of this?
>

--0016362839d47b11be04961bb971
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

If you want to do this, don=C2=B4t use autoincrementing integers! ;o) Use U=
UID instead. (or implement an stand alone id-server that handles autoincrem=
ent savely)<div><div><br><br><div class=3D"gmail_quote">2010/11/28 David Bo=
xenhorn <span dir=3D"ltr">&lt;<a href=3D"mailto:david@lookin2.com">david@lo=
okin2.com</a>&gt;</span><br>

<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex;"><div dir=3D"ltr">As our launch date approac=
hes, I am getting increasingly nervous about Cassandra tuning. It is a myst=
erious black art that I haven&#39;t mastered even at the low usages that we=
 have now. I know of a few more things I can do to improve things, but how =
will I know if it is enough? All this is particularly ironic since - as we =
are just starting out - we don&#39;t have scalability problems yet, though =
we hope to! <br>


<br>Luckily, I have completely wrapped Cassandra in an entity mapper, so th=
at I can easily trade in something else, perhaps temporarily, until we real=
ly need Cassandra&#39;s scalability. <br><br>So, I&#39;m thinking of emulat=
ing Cassandra with mySQL. I would use mySQL either as a simple key-value st=
ore, without joins, or map Cassandra supercolumns to mySQL columns, probabl=
y of type CLOB. <br>


<br>Does anyone want to talk me out of this? <br></div>
</blockquote></div><br></div></div>

--0016362839d47b11be04961bb971--