MySQL adds NoSQL and many new enhancements to the world’s most popular open source database:
- NoSQL – Document Store gives developers the flexibility of developing traditional SQL relational applications and NoSQL, schema-free document database applications.
- SQL – Window functions, Common Table Expressions, NOWAIT and SKIP LOCKED, Descending Indexes, Grouping, Regular Expressions, Character Sets, Cost Model, and Histograms.
- JSON – Extended syntax, new functions, improved sorting, and partial updates. With JSON table functions you can use the SQL machinery for JSON data.
- GIS – Geography support. Spatial Reference Systems (SRS), as well as SRS aware spatial datatypes, spatial indexes, and spatial functions.
- Reliability – DDL statements have become atomic and crash safe, meta-data is stored in a single, transactional data dictionary
- Observability- Performance Schema, Information Schema, Invisible Indexes, Error Logging.
- Manageability – Persistent Configuration Variables, Undo tablespace management, Restart command, and New DDL.
- High Availability – InnoDB Cluster delivers an integrated, native, HA solution for your databases.
- Security – OpenSSL improvements, new default authentication, SQL Roles, breaking up the super privilege, password strength, authorization.
- Performance – Up to 2x faster than MySQL 5.7