Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I currently have a massive MySQL Data but would like to move over to Cassandra nosql. How hard of a move over would this be? I've not found any examples yet on this being done. It is possible right.

share|improve this question

closed as not constructive by SvW, Dave M, Iain Nov 22 '12 at 16:23

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.

1  
The first step would be to find out if Cassandra solves any problem you actually have. Everyone and his brother is migrating to NoSQL, but it's my impression few have actual reason to do so beyond following the latest buzzword (and don't get me started on the subject of the cloud). –  SvW Nov 22 '12 at 16:16
add comment

1 Answer

A perfect answer to this question would represent a few months worth of work for a consultant. The simple fact that you ask the question means you need to have someone on board with you to execute any kind of migration.

This modification would impact code (interfaces to DB are differents), software (Cassandra node setup isn't the same as a MySQL Cluster, or MySQL replicated setup), hardware (technical requirement and proposed setup aren't exactly the same), maintenance (the 2 software have very different upgrade path), and even deployment procedure...

A standard path for migration would be :

  • Abstract your database connection class in your software
  • Add support for Cassandra in your abstracted db-class
  • Export your data, convert them to no-sql (not a relational db anymore) and inject them in Cassandra. This move is either done offline (no action on DB) or online (harder, need sync procedure).
  • finish QA in your staging environment.
  • Re-do all steps for the production environment.
share|improve this answer
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.