MySQL 5.7 Introduces Document Store: Bridging Relational and NoSQL Worlds

MySQL 5.7.12 brings a major improvement: native support for document‑oriented storage, allowing JSON documents to be stored directly in MySQL just like in MongoDB.

This change is significant because MySQL, traditionally a relational database, now incorporates NoSQL advantages, breaking the strict “relational only” paradigm.

Developers familiar with MySQL who need document storage can now use a single database instead of a MySQL + MongoDB hybrid, simplifying architecture.

MySQL implements its own document‑store protocol rather than MongoDB’s, which enables better integration with built‑in functions and transactional support, though it prevents a drop‑in migration from existing MongoDB projects.

The document store supports ACID transactions and indexing of document fields, providing consistency and easy reference for document‑based APIs.

MySQL has previously experimented with non‑relational features such as MyCached (2009), the HandlerSocket plugin (2010), and MySQL Cluster’s Memcached protocol (2011), but those were limited to key‑value interfaces.

Recognizing developers’ demand for flexible, unstructured data alongside rich structured data, MySQL 5.7 introduced the JSON document feature.

While the document store is a fresh addition and less mature than MongoDB’s long‑standing ecosystem, it offers promising integration of NoSQL capabilities within a proven relational system.

MySQL remains a strong database with mature replication and sharding, though it has been outpaced in ease‑of‑use and dynamic scaling by newer systems; the new document support is an exciting step toward broader functionality.

For more details, see the official MySQL documentation: http://dev.mysql.com/doc/refman/5.7/en/document-store.html