incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Beier Cai <beier....@hootsuite.com>
Subject Re: Data migration from mysql to cassandra
Date Wed, 19 May 2010 23:12:51 GMT
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 <jbellis@gmail.com> wrote:

> 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 <beiercai@gmail.com> wrote:
> > 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
> > this will leave mixed mode of ids. another way I can think of is to
> > re-create existing records using UUID and deal with all
> > those referential keys. Either way seems kinda awkward. Are there any
> > good practice to deal with this? I know many people here come from mysql,
> > what did you do?
>
>
>
> --
> Jonathan Ellis
> Project Chair, Apache Cassandra
> co-founder of Riptano, the source for professional Cassandra support
> http://riptano.com
>

Mime
View raw message