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 <beier...@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
