You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by ruslan usifov <ru...@gmail.com> on 2011/01/14 16:40:14 UTC
live data migration from mysql to cassandra
Hello
Dear community please share your experience, home you make live(without
stop) migration from mysql or other RDBM to cassandra
Re: live data migration from mysql to cassandra
Posted by Victor Kabdebon <vi...@gmail.com>.
gosh, sorry for the mistakes I am tired !
Victor K.
2011/1/14 Victor Kabdebon <vi...@gmail.com>
> 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 <ed...@gmail.com>
>
> On Fri, Jan 14, 2011 at 10:40 AM, ruslan usifov <ru...@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
>>
>
>
Re: live data migration from mysql to cassandra
Posted by Victor Kabdebon <vi...@gmail.com>.
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 <ed...@gmail.com>
> On Fri, Jan 14, 2011 at 10:40 AM, ruslan usifov <ru...@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
>
Re: live data migration from mysql to cassandra
Posted by Edward Capriolo <ed...@gmail.com>.
On Fri, Jan 14, 2011 at 10:40 AM, ruslan usifov <ru...@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