I have storing major data in mysql and logs are stored in cassandra. Cassandra db getting heavier and difficult to do queries.
So I want to migrate all my cassandra's table in mysql is it possible?
rchawdhari 0 Light Poster
Recommended Answers
Jump to PostCorrect me if I'm wrong, but isn't Cassandra a NoSQL database? I'm sure it's possible to move all of the data into MySQL, but it wouldn't be as simple as just running a migration script. Since MySQL is a relational database, you'd have to overhaul your entire database schema, and …
All 2 Replies
Dani 4,675 The Queen of DaniWeb Administrator Featured Poster Premium Member
Correct me if I'm wrong, but isn't Cassandra a NoSQL database? I'm sure it's possible to move all of the data into MySQL, but it wouldn't be as simple as just running a migration script. Since MySQL is a relational database, you'd have to overhaul your entire database schema, and restructure how your data will function with MySQL.
DimaYasny 180 Godmode enabled Team Colleague Featured Poster
When Cassandra is getting heavy, all you need do is migrae to ScyllaDB. You'll never want to look back
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.