| 1. | It was developed by Redis labs and initially released on May 10, 2009. | It was developed by Oracle and released in May 1995. |
|---|
| 2. | It is written in ANSI and C languages. | It is written in C and C++. |
|---|
| 3. | The primary database model for Redis is Key-Value Store. | The primary database model for MySQL is Relational DBMS. |
|---|
| 4. | It is Data Schema free. | In MySQL, Data Schema is fixed. |
|---|
| 5. | It does not support XML data format. | It supports XML data format. |
|---|
| 6. | It supports secondary indexes with the RediSearch module only. | It supports secondary indexes without any restrictions. |
|---|
| 7. | It has no Triggers. | It supports Triggers. |
|---|
| 8. | It does not provide the concept of Referential Integrity. Hence, no Foreign Keys. | It provides the concept of Referential Integrity and has Foreign keys. |
|---|
| 9. | Server operating systems for Redis are BDS, Linux, OS X, and Windows. | Server operating systems for MySQL are FreeBSD, Linux, OS X, Solaris, and Windows. |
|---|
| 10. | In Redis, only sharding is permitted. | For partitioning, MySQL uses either horizontal partitioning or sharding with the MySQL Cluster. |
|---|
| 11. | Famous companies like Twinkl Educational Publishing, Merrill Corporation, ASOS.com Limited, Owler, Inc., etc use Redis. | Famous companies like Airbnb, Pinterest, Slack, Udemy, Twitter, etc use MySQL. |
|---|