Data Migration from MYSQL to Cassandra

Impetus / kundera

A JPA 2.1 compliant Polyglot Object-Datastore Mapping Library for NoSQL Datastores.Please subscribe to:

http://groups.google.com/group/kundera-discuss/subscribe

Apache License 2.0

903 stars 233 forks source link

Data Migration from MYSQL to Cassandra #309

Closed Gargee closed 11 years ago

Gargee commented 11 years ago

Hi We are planning to migrate from mysql to no sql (cassandra).The columnfamilies in the cassandra DB dont have the same structure as the old mysql db. Need ideas on the ways to export data from old system to Cassandra. Are there any tools available in the market which can help. I have billions of data which needs migration.

mevivs commented 11 years ago

Hi, Have a look at: http://www.datastax.com/docs/datastax_enterprise2.0/sqoop/sqoop_about

See if it helps.

-Vivek

pires commented 11 years ago

Moving from a relational to a non-relational data-model difficulty level is proportional to your level of relational data-model design skills. It takes lots of study - there are plenty presentations out there - and practice! Do not take this lightly, or you'll face hell very soon ;-)