As you might know, MySQL introduces Document Store (via JSON field) from version 5.7 and version 8.0. Since currently, it is in an early stage, the performance is not really good compared to its direct competitor: MongoDB. However, this is really a good move for MySQL after their introduction of MySQL Group Replication and MySQL Router for InnoDB Cluster. So this blog entry dedicates for some discussion around MySQL Document Store – NoSQL solution for MySQL.
- In some early comparison (conducted in 2017), MySQL DS performs much worse comparing to MongoDB.
- In the other side, lefred’s blog published a good article about Top 10 reasons for NoSQL with MySQL.
For me, I’ll wait for a little bit before trying MySQL DS. The reason is that having MongoDB in the system is really simple and not really complicated, so it is not worth trading off between performance and system simplicity this time. In addition, MongoDB has really good auto-sharding feature for better scaling this time of writing.