difference between mysql and cassandra

Question

What is the difference between cassandra and mysql?

I searched using Google. But I am not satisfied, and I could not understand. Please tell me about it clearly.

Answer 1

MySQL is a relational database, which supports complex, flexible queries using the SQL query language. Essentially the relational model consists of tables (relations) which can be interlinked by keys common to multiple tables.

Cassandra is a key-value store (like a hashmap) that lets you look up plain or structured values based on a key. It does not support complex/flexible queries, but in return it provides greater scalability and performance. It does not use fixed predefined tables, but uses a "column-based" model, where each row of data can contain data items of various types, which don't have to be predefined.

Cassandra uses the Cassandra Query Language (CQL) which uses a syntax similar to SQL. Cassandra also provides an older binary query interface via the Thrift protocol.