We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Has anyone used Cassandra as their DBMS for data?

Hello!

When managing a large amount of incoming and outgoing data, I'm not sure which DBMS is best suited for this. First and foremost I have to decide whether I choose a SQL database or a NoSQL database, and then I need a suitable DBMS. What do you think is better for a large amount of data? SQL or NoSQL databases?
The classic model would be a SQL database with MySQL as DBMS. Should I still rely on it? I've heard a lot of good things about Cassandra, but that's for NoSQL databases - I'm not sure what to choose. In addition, the performance and scalability should be better than with SQL databases, especially when it comes to larger data volumes. I would then manage and run it through a provider like Aiven, as I could then integrate it into my cloud.

What would you recommend: NoSQL (like Cassandra) or SQL (MySQL)? And why?
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 351.7K Banking & Borrowing
  • 253.4K Reduce Debt & Boost Income
  • 454K Spending & Discounts
  • 244.7K Work, Benefits & Business
  • 600.1K Mortgages, Homes & Bills
  • 177.3K Life & Family
  • 258.4K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.2K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.