Cassandra vs MySQL

Cassandra is an alternative to MySQL, Oracle, or another data manager for very large query volumes.
It tends to be used by an increasing number of different subjects, but it remains a new product that has not encountered the full variety of uses. You can expect crashes by adapting it for a new application.

Cassandra, base de données NoSQL

It is suitable for fully distributed and highly expandable databases, so for high traffic sites like Facebook (which developed it), with millions of queries per hour.
The distributed model allows you to store information on many different servers managed by one central system.
Written in Java, it can more easily fit into the server environment in this language .

Cassandra is based on the BigTable non-relational data model created by Google and used by an index of its search engine running on Dynamo, Amazon's storage model.

It was released by Facebook in 2008 and has since been supported by the Apache Foundation.

The word Cassandra (Cassandra) comes from Greek mythology: This is a princess who has the right to predict the future, but whose fate is never to be true. This vision idea includes a logo depicting a female gaze. It is assumed that the developer expected that he would not be believed when in the future this system.

Cassandra vs MySQL

Cassandra fits into the NoSQL movement, which wants to simplify databases by removing the relational aspect.
Tables no longer have a predefined fixed schema (which can be modified later) and can evolve both horizontally (when columns) and vertically (when a row is therefore records).
NoSQL actually stands for Not Only SQL (not just SQL), so this does not call into question the query language that SQL is always.

Cassandra has no scheme and no table. The number of columns may vary depending on the row. MariaDB (an alternative to MySQL) has implemented a dynamic speaker system that allows you to do the same. But we exit the SQL framework when on commands.

Here is a performance comparison provided by Apache:

Design differences:

Cassandra is less reliable than MySQL and has a less important community and therefore support. There are much fewer tools for its work, such as graphical interfaces, managers like PhpMyAdmin.

This is not a system like MySQL, just install it to make it work, you should carefully read the guide and adapt the configuration to your software project (regardless of creating tables).

Cassandra users

Twitter still does not use Cassandra to manage tweets, as it will have to completely rewrite the system, it uses it for statistics and geolocation.

Complaining about the slow pace of MySQL, Digg decided to completely reprint his data management under Cassandra.

Netflix, the TV streaming company, prefers to forgo relational advantages for Cassandra's extensibility.

Cassandra is behind Facebook, although the project was subsequently built into Apache. But Hadoop, a Java framework for distributed data processing, replaced it. Cassandra is also written in Java, but there is a version of C++, ScyllaDB, which is claimed to be 10 times faster .

Cassandra, like other open source programs, tends to replace Oracle, which saw a 28% drop in new licenses in 2014.