Re: How to migrate any relational database to Cassandra

2010-08-09 Thread Peng Guo
Maybe you could integrate with Hadoop. On Mon, Aug 9, 2010 at 1:15 PM, sonia gehlot wrote: > Hi Guys, > > Thanks for sharing your experiences and valuable links these are really > helpful. > > But I want to do ETL and then wanted to load data in Cassandra. I have link > 10-15 various source

Re: How to migrate any relational database to Cassandra

2010-08-08 Thread sonia gehlot
Hi Guys, Thanks for sharing your experiences and valuable links these are really helpful. But I want to do ETL and then wanted to load data in Cassandra. I have link 10-15 various source system, presently daily ETL jobs runs load data in our database which is Netezza. How can I do this in Cas

Re: How to migrate any relational database to Cassandra

2010-08-07 Thread Zhong Li
Yes, I use OrderPreservngPartitioner, the token considers datacenter+ip +function+timestamp+recordId+... On Aug 7, 2010, at 10:36 PM, Jonathan Ellis wrote: are you using OrderPreservingPartitioner then? On Sat, Aug 7, 2010 at 10:32 PM, Zhong Li wrote: Here is just my personal experiences.

Re: How to migrate any relational database to Cassandra

2010-08-07 Thread Jonathan Ellis
are you using OrderPreservingPartitioner then? On Sat, Aug 7, 2010 at 10:32 PM, Zhong Li wrote: > Here is just my personal experiences. > > I recently use Cassandra to implement a system cross 5 datacenters. Because > it is impossible to do it in SQL Database at low cost, Cassandra helps. > > Cas

Re: How to migrate any relational database to Cassandra

2010-08-07 Thread Zhong Li
Here is just my personal experiences. I recently use Cassandra to implement a system cross 5 datacenters. Because it is impossible to do it in SQL Database at low cost, Cassandra helps. Cassandra is all about indexing, there is no relationship naturally, you have to use indexing to keep a

Re: How to migrate any relational database to Cassandra

2010-08-06 Thread Peter Harrison
On Sat, Aug 7, 2010 at 6:00 AM, sonia gehlot wrote: > Can you please help me how to move forward? How should I do all the setup > for this? My view is that Cassandra is fundamentally different from SQL databases. There may be artefact's which are superficially similar between the two systems, bu

Re: How to migrate any relational database to Cassandra

2010-08-06 Thread Benjamin Black
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 wrote: > Thanks for reply, > > I am sorry It seems my question comes out wrong.. > > * My question is w

Re: How to migrate any relational database to Cassandra

2010-08-06 Thread sonia gehlot
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

Re: How to migrate any relational database to Cassandra

2010-08-06 Thread Michael Dürgner
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 denor

How to migrate any relational database to Cassandra

2010-08-06 Thread 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>