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. MariaDB :
MariaDB is an open source relational database management system (RDBMS) that is a compatible drop-in replacement for the widely used MySQL database technology. It is developed by MariaDB Foundation and initially released on 29 October 2009. MariaDB has a significantly high number of new features, which makes it better in terms of performance and user-orientation than MySQL.
Difference between Cassandra and MariaDB :
|1.||Developed by Apache Software foundation and released on July 2008.||Developed by MariaDB Corporation Ab. and initially released on 29 October 2009.|
|2.||Cassandra is written only in Java language.||MariaDB is written in C, C++, Perl and Bash languages.|
|3.||Cassandra does not provides ACID transactions but can be tuned to support ACID properties.||MariaDB provides ACID transactions without snapshot isolation.|
|4.||Cassandra supports Selectable Replication Factor replication method.||MariaDB supports Master-Slave Replication and Master-Master Replication replication methods.|
|5.||In Cassandra there is no concept of Foreign keys||MariaDB provides the concept of Referential Integrity and have Foreign keys.|
|6.||Cassandra supports Map Reduce method.||MariaDB does not supports Map Reduce method.|
|7.||Cassandra does not supports XML data format.||Mariadb does supports XML data format.|
|8.||Cassandra has only cursory support for secondary indexes i.e secondary indexing is restricted.||MariaDB does supports the concept of secondary indexes.||9.||Server operating systems for Cassandra are BSD, Linux, OS X, Windows.||Server operating systems for MariaDB are FreeBSD, Linux, Solaris, Windows.||10.||Famous companies like GitHub, GoDaddy, Hulu, Instagram, Reddit, The Weather Channel, etc uses Cassandra.||Famous companies like CUNY, Accenture, Docplanner, Nasdaq, Red Hat, ServiceNow, etc uses MariaDB.|
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.