MySQL Workshop

Last week I attended a MySQL workshop presented by Oracle

The main feature of the workshop was to introduce the development release of MySQL 8.0. This is the next major release, for several reasons Oracle is skipping from 5.7 to 8.0.

There are a couple of changes that make MySQL look more like Oracle Database

– A new table based data dictionary replacing the text file based one

– A SYS schema that looks somewhat like the Oracle Database one, with management views

The other big item is a JSON based database engine, to compete with MongoDB. MySQL JSON retains the ACID transactions of MySQL so in that way it is a bit different from Mongo. It will be slower but more durable. This is implemented with an entirely new protocol called X, rather than extensions to the SQL protocol. It just didn’t fit into the SQL protocol.

Some of these features, most notably JSON, have been back ported to 5.7 as the production 8.0 release is perhaps a year away.

The 8.0 development release is available at dev.mysdql.com. It is still small and still installs and runs easily on a laptop.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: