difference between mysql and cassandra -


what difference between cassandra , mysql?

i searched using google. not satisfied, , not understand. please tell me clearly.

mysql relational database, supports complex, flexible queries using sql query language. relational model consists of tables (relations) can interlinked keys common multiple tables.

cassandra key-value store (like hashmap) lets plain or structured values based on key. not support complex/flexible queries, in return provides greater scalability , performance. not use fixed predefined tables, uses "column-based" model, each row of data can contain data items of various types, don't have predefined.

cassandra uses cassandra query language (cql) uses syntax similar sql. cassandra provides older binary query interface via thrift protocol.


Comments

Popular posts from this blog

c# - how to write client side events functions for the combobox items -

exception - Python, pyPdf OCR error: pyPdf.utils.PdfReadError: EOF marker not found -