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: local policy)
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0 (Apple Message framework v1081)
Subject: Re: How to migrate any relational database to Cassandra
From: =?iso-8859-1?Q?Michael_D=FCrgner?= <michael@duergner.de>
In-Reply-To: <AANLkTinKN3cgnzNp9_VGCT8meXY3qEckFtyqfmu0pvVM@mail.gmail.com>
Date: Fri, 6 Aug 2010 20:24:41 +0200
Content-Transfer-Encoding: quoted-printable
Message-Id: <7914D251-FAE7-4421-9449-429B0DB6C973@duergner.de>
References: <AANLkTinKN3cgnzNp9_VGCT8meXY3qEckFtyqfmu0pvVM@mail.gmail.com>
To: user@cassandra.apache.org

In my opinion it's the wrong approach when so ask how to migrate from =
MySQL to Cassandra from a database level view. The lack of joins in =
NoSQL should lead to think about what you wanna get out of your =
persistent storage and afterwards think about how to migrate and most of =
the time how to denormalize the data you have in order to insert it into =
a NoSQL storage like Cassandra.

Simply just migrating the data and moving the joins up to the =
application level might work in the beginning but most of the times =
doesn't scale in the end.

Am 06.08.2010 um 20:00 schrieb sonia gehlot:

> Hi All,
>=20
>=20
> Little background about myself. I am ETL engineer worked in only =
relational databases.
>=20
> I have been reading and trying Cassandra since 3-4 weeks. I kind of =
understood Cassandra data model, its structure,  nodes etc. I also =
installed Cassandra and played around with it, like=20
>=20
>   cassandra> set Keyspace1.Standard2['jsmith']['first'] =3D 'John'
>   Value inserted.
>  cassandra> get Keyspace1.Standard2['jsmith']
>     (column=3Dfirst, value=3DJohn; timestamp=3D1249930053103)
>   Returned 1 rows.
>=20
> But don't know what to do next? Like if someone says me this is MySQL =
database migrate it to cassandra, then I dont know what should be my =
next step?=20
>=20
> Can you please help me how to move forward? How should I do all the =
setup for this?=20
>=20
> Any help is appreciated.
>=20
> Thanks,
> Sonia=20
> =20