incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jonathan Ellis <jbel...@gmail.com>
Subject Re: Data migration from mysql to cassandra
Date Wed, 19 May 2010 06:25:56 GMT
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