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 Thu, 20 May 2010 14:51:49 GMT
No.

On Wed, May 19, 2010 at 4:12 PM, Beier Cai <beier.cai@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 <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
>
>



-- 
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of Riptano, the source for professional Cassandra support
http://riptano.com

Mime
View raw message