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.geh...@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 <mich...@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 >> > >> > >
