What's New in MySQL 8.0

MySQL is the most trusted and widely used open source database platform in use today. 10 out of the top 10 most popular and highly-trafficked websites in the world rely on MySQL. MySQL 8.0 builds on this momentum by delivering across the board improvements designed to enable innovative DBAs and developers to create and deploy the next generation of web, embedded, mobile and Cloud/SaaS/PaaS/DBaaS applications on the latest generation of development frameworks and hardware platforms. MySQL 8.0 highlights include:

MySQL Document Store
Transactional Data Dictionary
SQL Roles
Default to utf8mb4
Common Table Expressions
Window Functions
And much more...

MySQL 8.0: Up to 2x Faster

MySQL powers the most demanding Web, E-commerce, SaaS and Online Transaction Processing (OLTP) applications. It is a fully integrated transaction-safe, ACID compliant database with full commit, rollback, crash recovery and row level locking capabilities. MySQL delivers the ease of use, scalability, and performance to power Facebook, Google, Twitter, Uber, and Booking.com.

MySQL 8.0 includes significant performance, security and developer productivity improvements enabling the next generation of web, mobile, embedded and Cloud applications.

MySQL 8.0 delivers:

New! Document Store for developing both SQL and NoSQL document applications using a single database.
New! Transactional Data Dictionary implemented as a set of SQL tables stored in a single InnoDB tablespace.
New! SQL Roles for granting and denying permissions to groups of users, greatly reducing the security workload.
New! Default to utf8mb4 character set for richer mobile applications and international character sets.
New! Common Table Expressions also known as WITH queries have been added to MySQL 8.0.
New! Window Functions to reduce code complexity and help developers be more productive.
New! Invisible Indexes to better manage software upgrades and database changes for applications that run 24x7.
New! Descending Indexes to eliminate the need for sorting results and leads to performance improvements.
Improved! JSON Support with numerous additions including the JSON_TABLE() function which accepts JSON data and returns it as a relational table.
Improved! Up to 2x faster and sets new benchmarks records with upto 1.8 Million Queries/Second.
Improved! OpenSSL as the default TLS/SSL library in MySQL.
Improved! Performance Schema with queries that are up to 30x faster.
Improved! Information Schema with queries that are up to 100x faster.
Improved! GIS is enhanced to support geography and Spatial Reference Systems (SRS).
Improved! Replication and InnoDB Cluster for better scale out of high volume applications.
Reliability requiring little or no intervention to achieve continuous uptime.
Ease of use with "3 minutes from download to development" installation and configuration.
Low administration with very little database maintenance required.
Replication providing flexible topologies for scale-out and high availability.
Partitioning to improve performance and management of very large database environments.
ACID Transactions to build reliable and secure business critical applications.
Stored Procedures to improve developer productivity.
Triggers to enforce complex business rules at the database level.
Views to ensure sensitive information is not compromised.

MySQL Document Store

MySQL Document Store allows developers to work with SQL relational tables and schema-less JSON collections. To make that possible MySQL has created the X Dev API which puts a strong focus on CRUD by providing a fluent API allowing you to work with JSON documents in a natural way. The X Protocol is a highly extensible and is optimized for CRUD as well as SQL API operations.

Flexible

MySQL Document store gives users maximum flexibility developing traditional SQL relational applications and NoSQL schema-free document database applications. This eliminates the need for a separate NoSQL document database. Developers can mix and match relational data and JSON documents in the same database as well as the same application. For example, both data models can be queried in the same application and results can be in table, tabular or JSON formats.

Highly Reliable, Fully Consistent

The MySQL Document Store provides multi-document transaction support and full ACID compliance for schema-less JSON documents. With InnoDB as the storage engine behind the Document Store, you get the same data guarantees and performance advantages as you do for relational data. This guarantees users get data reliability with complete data consistency. This also makes the MySQL Document Store easy to manage.

High Availability

MySQL Document Store utilizes all the advantages of MySQL Group Replication and InnoDB Cluster to scale out applications and achieve high availability. Documents are replicated across all members of the high availability group and transactions are committed in sync across masters. Any master can take over from another master if one fails, without down time.

Online Hot Backup

Just as Document Store leverages Group Replication and InnoDB Cluster, it also works transparently with MySQL Enterprise Backup. Users can perform full, incremental and partial backups of documents. All document data is consistent to the point in time when the backups are completed. Users also have the flexibility to perform Point in Time recovery to recover to a specific transaction using the MySQL binlog.

Security

MySQL and the Document Store are secure by. Plus all the advanced security features of MySQL Enterprise Edition such as Transparent Data Encryption (TDE), auditing, advanced authentication and firewall help to maximize security.

Reporting and Analytics

MySQL Document Store gives you the simplicity of performing CRUD operations as well as the power of SQL to extract data from JSON documents. The power of SQL, and all the popular reporting and analytics tools are available.

Easy to Use

MySQL Document Store provides simple to use, fluent CRUD APIs supported across many languages so that organizations can develop document based applications using their language of choice.

Architecture

The MySQL Document Store architecture consists of the following components:

Native JSON Document Storage - MySQL provides a native JSON datatype is efficiently stored in binary with the ability to create virtual columns that can be indexed. JSON Documents are automatically validated.
X Plugin - The X Plugin enables MySQL to use the X Protocol and uses Connectors and the Shell to act as clients to the server.
X Protocol - The X Protocol is a new client protocol based on top of the Protobuf library, and works for both, CRUD and SQL operations.
X DevAPI - The X DevAPI is a new, modern, async developer API for CRUD and SQL operations on top of X Protocol. It introduces Collections as new Schema objects. Documents are stored in Collections and have their dedicated CRUD operation set.
MySQL Shell - The MySQL Shell is an interactive Javascript, Python, or SQL interface supporting development and administration for the MySQL Server. You can use the MySQL Shell to perform data queries and updates as well as various administration operations.
MySQL Connectors - The following MySQL Connectors support the X Protocol and enable you to use X DevAPI in your chosen language.
- MySQL Connector/Node.js
- MySQL Connector/PHP
- MySQL Connector/Python
- MySQL Connector/J
- MySQL Connector/Net
- MySQL Connector/C++