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