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 :
|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.|