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