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 :
|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.
- Difference between Cassandra and IBM Db2
- Difference between SQLite and Cassandra
- Difference between HBase and Cassandra
- Difference between MS SQL Server and Cassandra
- Difference between Cassandra and PostgreSQL
- Difference between Cassandra and CouchDB
- Difference between Cassandra and MariaDB
- Difference between Cassandra and Couchbase
- Difference between PouchDB and Cassandra
- Difference between Derby and Cassandra
- Difference between Cassandra and MongoDB
- Difference Between Hadoop and Cassandra
- Difference between MySQL and IBM Db2
- Difference between MySQL and PostgreSQL
- Difference between Derby and MySQL
- Difference between PouchDB and MySQL
- Difference Between MySQL and MariaDB
- Difference between MySQL and SQLite
- Difference between MySQL and MS SQL Server
- Difference between CouchDB and MySQL
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to email@example.com. 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.