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