Member Avatar for rchawdhari

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?

  • 3 Contributors
  • 2 Replies
  • 325 Views
  • 2 Years Discussion Span
  • Latest Post Latest Post by DimaYasny
Member Avatar for Dani

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.

Member Avatar for DimaYasny

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.