You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Surbhi Gupta <su...@gmail.com> on 2014/07/23 03:45:59 UTC
Case Study from Migrating from RDBMS to Cassandra
Hi,
Does anybody has the case study for Migrating from RDBMS to Cassandra ?
Thanks
Re: Case Study from Migrating from RDBMS to Cassandra
Posted by DuyHai Doan <do...@gmail.com>.
"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 <ma...@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 <su...@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 <sh...@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 <su...@gmail.com>
>>> wrote:
>>>
>>>> Hi,
>>>>
>>>> Does anybody has the case study for Migrating from RDBMS to Cassandra ?
>>>>
>>>> Thanks
>>>>
>>>
>>>
>>
>
Re: Case Study from Migrating from RDBMS to Cassandra
Posted by Mark Reddy <ma...@boxever.com>.
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 <su...@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 <sh...@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 <su...@gmail.com>
>> wrote:
>>
>>> Hi,
>>>
>>> Does anybody has the case study for Migrating from RDBMS to Cassandra ?
>>>
>>> Thanks
>>>
>>
>>
>
Re: Case Study from Migrating from RDBMS to Cassandra
Posted by Surbhi Gupta <su...@gmail.com>.
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 <sh...@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 <su...@gmail.com>
> wrote:
>
>> Hi,
>>
>> Does anybody has the case study for Migrating from RDBMS to Cassandra ?
>>
>> Thanks
>>
>
>
Re: Case Study from Migrating from RDBMS to Cassandra
Posted by Shane Hansen <sh...@gmail.com>.
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 <su...@gmail.com>
wrote:
> Hi,
>
> Does anybody has the case study for Migrating from RDBMS to Cassandra ?
>
> Thanks
>