Re: live data migration from mysql to cassandra

2011-01-14 Thread Victor Kabdebon
gosh, sorry for the mistakes I am tired ! Victor K. 2011/1/14 Victor Kabdebon > I personnally did it the other way around : from Cassandra to PostGreSQL, I > needed an hybrid system : Cassandra solidly holds all data while PostGreSQL > holds fewer data but request are simple and efficient ( wit

Re: live data migration from mysql to cassandra

2011-01-14 Thread Victor Kabdebon
I personnally did it the other way around : from Cassandra to PostGreSQL, I needed an hybrid system : Cassandra solidly holds all data while PostGreSQL holds fewer data but request are simple and efficient ( with SELECT WHERE). This is pretty easy once you master key browsing and iterating. I thin

Re: live data migration from mysql to cassandra

2011-01-14 Thread Edward Capriolo
On Fri, Jan 14, 2011 at 10:40 AM, ruslan usifov wrote: > Hello > > Dear community please share your experience, home you make live(without > stop) migration from mysql or other RDBM to cassandra > There is no built in way to do this. I remember hearing at hadoop world this year that the hbase guy

live data migration from mysql to cassandra

2011-01-14 Thread ruslan usifov
Hello Dear community please share your experience, home you make live(without stop) migration from mysql or other RDBM to cassandra

Re: Data migration from mysql to cassandra

2010-05-20 Thread Jonathan Ellis
No. On Wed, May 19, 2010 at 4:12 PM, Beier Cai wrote: > Thanks Jonathan, using mysql as an id sequence generator definitely is a > good options. One thing though, does using sequential ids defeat the purpose > of random partitioner? > > On Tue, May 18, 2010 at 11:25 PM, Jonathan Ellis wrote: >>

Re: Data migration from mysql to cassandra

2010-05-19 Thread Beier Cai
Thanks Jonathan, using mysql as an id sequence generator definitely is a good options. One thing though, does using sequential ids defeat the purpose of random partitioner? On Tue, May 18, 2010 at 11:25 PM, Jonathan Ellis wrote: > Those are 2 of the 3 options (the other one being, continue to >

Re: Data migration from mysql to cassandra

2010-05-18 Thread Jonathan Ellis
Those are 2 of the 3 options (the other one being, continue to generate incrementing IDs either by continuing to use mysql solely for that purpose, or by using another system like redis for that). On Mon, May 17, 2010 at 10:48 PM, Beier Cai wrote: > I'm currently moving my existing mysql database

Data migration from mysql to cassandra

2010-05-17 Thread Beier Cai
I'm currently moving my existing mysql database to cassandra. One particular problem I have is to migrate all those integer auto-increment ids to cassandra's code generated keys (like UUID). One way I can do is to dump all the existing records into Cassandra and start with UUID for new records, but