CODEWITHSUNDEEP
mysqlmigrationcassandra
Sampath Gunasekara
Sampath Gunasekara

Reputation: 687

How I translate mysql database/table data to cassandra data files...?

I have a large database in MySQL and it is about 4 Gb, still increasing day by day. Because of this, I'm going to migrate to Cassandra. But I don't have any idea how to convert the MySQL files to Cassandra hash files. There is no GUI for Cassandra, like PHPMyAdmin.

How should I do this?

Upvotes: 0

Views: 831

Answers (1)

jbellis
jbellis

Reputation: 19377

Cassandra is very different from MySQL. It's not just another relational database. It's designed to deal with datasets that do not fit in memory on a single machine.

For 4GB of data you have a lot of options. Redis. MongoDB. MySQL. These will all be fine, given appropriate hardware.

So I'd say that "How do I get this in Cassandra [or other Hot New Technology]?" is the wrong question. "How do I tune my MySQL database" is the right question, and/or, "What hardware should I buy or rent so I don't have this pain point?"

Upvotes: 2

Related Questions