cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Victor Kabdebon <victor.kabde...@gmail.com>
Subject Re: live data migration from mysql to cassandra
Date Fri, 14 Jan 2011 16:22:06 GMT
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 <edlinuxguru@gmail.com>

> On Fri, Jan 14, 2011 at 10:40 AM, ruslan usifov <ruslan.usifov@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
>

Mime
View raw message