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 think that Cassandra is a totally different design and Cassandra design is tailored to once needs wether *SQL is more general. So all migrations are different. Ruslan if you are interested by "big" migrations you should check Reddit's blog or Digg's blog. They switch from *SQL to Cassandra and their hold a lot of data. Best Regards, Victor K. http://www.voxnucleus.fr 2011/1/14 Edward Capriolo <edlinuxg...@gmail.com> > On Fri, Jan 14, 2011 at 10:40 AM, ruslan usifov <ruslan.usi...@gmail.com> > 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 guys have a system to read mysql slave > logs and replay into hbase. Since all the nosql community seems to do > this maybe we can 'borrow' this idea. > > Edward >
