Hi Akshay, this heavily depends on your data model. There is no general way to do it. It includes several steps:
1) Migration of applications using Mysql to Cassandra 2) Migration of the Mysql Database to Cassandra itself Keep in mind that there are no such things like relations or joins in Cassandra. In general Actually Datastax published some documents that could be of interest for you: http://www.datastax.com/2012/03/how-to-move-data-from-relational-databases-to-datastax-enterprise-cassandra-using-sqoop http://www.datastax.com/resources/whitepapers/mysql-to-cassandra Also I found this from EbayTech: http://www.ebaytechblog.com/2012/07/16/cassandra-data-modeling-best-practices-part-1/#.VHV2BlXF_Eg Regards Andi From: Akshay Ballarpure [akshay.ballarp...@tcs.com] Sent: 26 November 2014 07:15 To: user@cassandra.apache.org Subject: Re: mysql based columnar DB to Cassandra DB - Migration Hello Folks, I have one mysql based columnar DB, i want to migrate it to Cassandra. How its possible ? Best Regards Akshay Ballarpure Tata Consultancy Services Cell:- 9985084075 Mailto: akshay.ballarp...@tcs.com Website: http://www.tcs.com<http://www.tcs.com/> ____________________________________________ Experience certainty. IT Services Business Solutions Consulting ____________________________________________ From: Akshay Ballarpure/HYD/TCS To: user@cassandra.apache.org Date: 11/18/2014 09:00 PM Subject: mysql based columnar DB to Cassandra DB - Migration ________________________________ I have one mysql based columnar DB, i want to migrate it to Cassandra. How its possible ? Best Regards Akshay Ballarpure Tata Consultancy Services Cell:- 9985084075 Mailto: akshay.ballarp...@tcs.com Website: http://www.tcs.com<http://www.tcs.com/> ____________________________________________ Experience certainty. IT Services Business Solutions Consulting ____________________________________________ =====-----=====-----===== Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you
