cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From DuyHai Doan <doanduy...@gmail.com>
Subject Re: Case Study from Migrating from RDBMS to Cassandra
Date Wed, 23 Jul 2014 08:33:42 GMT
"How they have migrated from RDBMS to Cassandra?"

-> there is no one-answer-fits-all. It all depends on the application
features


"What are the things to consider?"
-> design data model with query-first approach. The choice of how/when/what
to denormalize is crucial

"How they have converted data model and after the new data model?"
-> for zero downtime migration you'll probably need double-run strategy
where you insert into old (RDBMS) and new (Cassandra) data store at the
same time but read only hit the RDBMS. Then launch data migration script to
copy existing data from RDBMS to Cassandra, then cut all read/write access
to RDBMS

"How they have loaded the data into cassadnra ?"
-> migration

"Performance test after and before migartion etc."
-> mandatory.




On Wed, Jul 23, 2014 at 8:40 AM, Mark Reddy <mark.reddy@boxever.com> wrote:

> PlanetCassandra has a collection of migration use cases:
>
> http://planetcassandra.org/mysql-to-cassandra-migration/
> http://planetcassandra.org/oracle-to-cassandra-migration/
>
> If they don't contain the information you need I'm sure you could reach
> out to the companies involved or DataStax itself to get what you require.
>
>
> Mark
>
>
> On Wed, Jul 23, 2014 at 5:28 AM, Surbhi Gupta <surbhi.gupta01@gmail.com>
> wrote:
>
>> Thansk Shane, Howover i am looking for any Proof of Concepts kind of
>> document .
>> Does anybody has complete end to end document which contains the
>> application overview,
>>
>> How they have migrated from RDBMS to Cassandra?
>> What are the things to consider?
>> How they have converted data model and after the new data model?
>> How they have loaded the data into cassadnra ?
>> Performance test after and before migartion etc.
>>
>> Thanks
>> Surbhi
>>
>> On 23 July 2014 08:51, Shane Hansen <shanemhansen@gmail.com> wrote:
>>
>>> There's lots of info on migrating from a relational database to
>>> Cassandra here:
>>> http://www.datastax.com/relational-database-to-nosql
>>>
>>>
>>>
>>> On Tue, Jul 22, 2014 at 7:45 PM, Surbhi Gupta <surbhi.gupta01@gmail.com>
>>> wrote:
>>>
>>>> Hi,
>>>>
>>>> Does anybody has the case study for Migrating from RDBMS to Cassandra ?
>>>>
>>>> Thanks
>>>>
>>>
>>>
>>
>

Mime
View raw message