Difference between Cassandra and MySQL

1. Cassandra :
Cassandra is a free and open-source, distributed, wide column store, NoSQL database management system. It was developed by Apache Software foundation and initially released on July 2008. Cassandra is designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure.

2. MySQL :
MySQL is an open-source relational database management system(RDBMS) based on Structured Query Language (SQL). It is developed and managed by oracle corporation and initially released on 23 may, 1995. It is widely being used in many small and large scale industrial applications and capable of handling a large volume of data.

Difference between Cassandra and MySQL :

S.NO. Cassandra MySQL
1. Developed by Apache Software foundation and released on July 2008. Developed by Oracle and released on May 1995.
2. Cassandra is written only in Java language. MySQL is written in C and C++ languages.
3. Cassandra is a NoSQL type database. MySql is a RDBMS type database.
4. It does not provides ACID properties but can be tuned to support ACID properties. MySQL provides ACID properties.
5. Read performance is highly efficient is Cassandra as it takes O(1) time. MySQl requires reading from multiple tables using JOIN. Hence, to read it takes O(log(n)) time.
6. Writing performance in Cassandra is also very high and efficient. Writing in MySQL requires a search first which slows down write performance.
7. Cassandra does not provides the concept of Referential Integrity. Hence no Foreign Keys. MySQL provides the concept of Referential Integrity and have Foreign keys.
8. Cassandra provides Eventual Consistency and Immediate Consistency methods to ensure consistency in a distributed system. MySQL only provides Immediate Consistency method to ensure consistency in a distributed system.
9. Server operating systems for Cassandra are BSD, Linux, OS X, Windows. Server operating systems for MySQL are FreeBSD, Linux, OS X, Solaris, Windows.
10. Famous companies like Hulu, Instagram, Intuit, Netflix, Reddit, etc uses Cassandra. Famous companies like Airbnb, Pinterest, Slack, Udemy, Twitter, etc uses MySQL.

Don’t stop now and take your learning to the next level. Learn all the important concepts of Data Structures and Algorithms with the help of the most trusted course: DSA Self Paced. Become industry ready at a student-friendly price.

My Personal Notes arrow_drop_up

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.

Article Tags :
Practice Tags :

Be the First to upvote.

Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.