No. On Wed, May 19, 2010 at 4:12 PM, Beier Cai <beier....@hootsuite.com> wrote: > 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 > >
-- Jonathan Ellis Project Chair, Apache Cassandra co-founder of Riptano, the source for professional Cassandra support http://riptano.com
