Re: Case Study from Migrating from RDBMS to Cassandra

2014-07-23 Thread Mark Reddy
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.gupt...@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 shanemhan...@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.gupt...@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

2014-07-23 Thread DuyHai Doan
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.re...@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.gupt...@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 shanemhan...@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.gupt...@gmail.com
 wrote:

 Hi,

 Does anybody has the case study for Migrating from RDBMS to Cassandra ?

 Thanks







Case Study from Migrating from RDBMS to Cassandra

2014-07-22 Thread Surbhi Gupta
Hi,

Does anybody has the case study for Migrating from RDBMS to Cassandra ?

Thanks


Re: Case Study from Migrating from RDBMS to Cassandra

2014-07-22 Thread Shane Hansen
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.gupt...@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

2014-07-22 Thread Surbhi Gupta
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 shanemhan...@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.gupt...@gmail.com
 wrote:

 Hi,

 Does anybody has the case study for Migrating from RDBMS to Cassandra ?

 Thanks