incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Benjamin Black...@b3k.us>
Subject Re: How to migrate any relational database to Cassandra
Date Fri, 06 Aug 2010 21:17:57 GMT
http://maxgrinev.com/2010/07/12/do-you-really-need-sql-to-do-it-all-in-cassandra/
http://www.slideshare.net/benjaminblack/cassandra-basics-indexing

On Fri, Aug 6, 2010 at 11:42 AM, sonia gehlot <sonia.gehlot@gmail.com> wrote:
> Thanks for reply,
>
> I am sorry It seems my question comes out wrong..
>
> * My question is what are the considration should I keep in mind to Migrate
> to Cassandra?
>
> * Like we do in ETL to extract data from source data we write query and then
> load it in our database after applying desired transformation.. How can we
> do this if we want extract data from MySQL and load it into Cassandra.
>
> * I think I can write script for these kind of stuff but do anyone have any
> example script?
>
> * What kind of setup I need to do this?
>
> -Sonia
>
>
> On Fri, Aug 6, 2010 at 11:24 AM, Michael Dürgner <michael@duergner.de>
> wrote:
>>
>> 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,
>> >
>> >
>> > Little background about myself. I am ETL engineer worked in only
>> > relational databases.
>> >
>> > 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
>> >
>> >   cassandra> set Keyspace1.Standard2['jsmith']['first'] = 'John'
>> >   Value inserted.
>> >  cassandra> get Keyspace1.Standard2['jsmith']
>> >     (column=first, value=John; timestamp=1249930053103)
>> >   Returned 1 rows.
>> >
>> > 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?
>> >
>> > Can you please help me how to move forward? How should I do all the
>> > setup for this?
>> >
>> > Any help is appreciated.
>> >
>> > Thanks,
>> > Sonia
>> >
>>
>
>

Mime
View raw message