In this blog, we’ll look at the MySQL 5.7 document store feature, and how it is implemented.

Document Store

MySQL 5.7.12 is a major new release, as it contains quite a number of new features:

1. Document store and “MongoDB” like NoSQL interface to JSON storage
2. Protocol X / X Plugin, which can be used for asynchronous queries (I will write about it as well)
3. New MySQL shell

Peter already wrote the document store overview; in this post, I will look deeper into the document store implementation. In my next post, I will demonstrate how to use document store for Internet of Things (IoT) and event logging.

Older MySQL 5.7 …

Today we are introducing a new MySQL Server feature called MySQL Document Store. Make sure to watch the announcement video on the MySQL YouTube Channel!

Find out more by looking into the following documents.

• Using MySQL as a Document Store – Manual
• X DevAPI – Tutorial for JavaScript
• X DevAPI – Tutorial for Python
• …

So hopefully you’ve read the first 5 blogs in this 6 part series you should have a good introduction to
•    Part 1 – What we heard from the MySQL Community (keep it solid, and innovate faster) and our change to new release model those requirements.…

In part 2 of this series of blog posts about MySQL 5.7.12 you could read about our new X Protocol for MySQL. Part 3 gave a glance on our new common basic API, the DevAPI. What’s a protocol and an API without clients using it?…

The classic MySQL command line tool is how most users – developers and administrators – interact with a MySQL server. From administrative tasks to trying out queries, it wouldn’t be far-fetched to call it the face of MySQL.

With a new programming interface built into the MySQL Server, we need to properly support it at the client side in connectors, tools and of course, the command line client.…

If you have been following our multi-part blog-post series around MySQL 5.7.12 so far you have heard on term a lot: “X”. So what does X stand for? A very good question, let’s see if Part 3 of the blog-post series on the MySQL Document Store will help you finding more about that.…

The X Protocol

For the MySQL Document Store we developed a new protocol to lay out a solid foundation for the features we’ll implement over the next years.

Building a Protocol with Async APIs in mind

Asynchronous APIs are all about executing other work while a task gets blocked.

…

What is JSON

JSON is an text based, human readable format for transmitting data between systems, for serializing objects and for storing document store data for documents that have different attributes/schema for each document. Popular document store databases use JSON (and the related BSON) for storing and transmitting data.

Problems with JSON in MySQL

It is difficult to inter-operate between MySQL and MongoDB (or other document databases) because JSON has traditionally been very difficult to work with. Up until recently, JSON is just a TEXT document. I said up until recently, so what has changed? The biggest thing is that there are new JSON UDF by Sveta Smirnova, which are part of the MySQL 5.7 Labs releases. Currently the JSON UDF are up to version 0.0.4. While these new UDF are a welcome edition to the MySQL database, they don’t solve the really tough …