MySQL 8.

0 Technical Specifications
MySQL Technical Specifications
MySQL Enterprise Backup1
Oracle MySQL Cloud  Hot Backup for InnoDB
Security
Service  Parallel backup, recovery operations
 OpenSSL by Default
 MySQL Database as a  Compressed Backup
Service  SQL Roles
 Full, Incremental, Partial Backups
 Password management
Flexible Architecture  Full, Partial Restore

 Open Source High-Performance  Point in Time Recovery

 Multi-threaded  Performance Schema  Auto-Restart/Recovery

 Pluggable Storage-  Information Schema  Scriptable, command line interface

Engine  SYS Schema  Integrated with Oracle Secure
 InnoDB, NDB  Resource Groups
Backup, NetBackup, Tivoli

 MyISAM  Partitioning MySQL Enterprise High Availability1

 MySQL Group Replication
ANSI SQL Standards  Optimized for high concurrency
 MySQL InnoDB Cluster
 Optimized for Read Only
 ANSI SQL
MySQL Enterprise Scalability1
  Optimized for use with SSD
SubQueries, Joins,  MySQL Thread Pool
Cursors  Multiple Index Type (B-tree, R-tree,
Hash, Full Text, etc.) MySQL Enterprise Security1
 Prepared Statements
 Server-side Thread Pool
 MySQL Enterprise Authentication1
 Views  MySQL Enterprise Transparent Data
 Connection Thread Caching
 Triggers Encryption (TDE)1
 Diagnostics, and SQL Tracing  MySQL Enterprise Encryption1
 Stored Procedures
 MySQL Enterprise Firewall1
 User-Defined Functions OLTP and Transactions  MySQL Enterprise Audit1
 Window Functions and  ACID Transactions MySQL Enterprise Monitor1
CTEs  Visual Dashboard
 Commit, Rollback
 NOWAIT and SKIP  Query Analyzer
LOCK  Foreign Keys
 Rules & Advisors
 Descending Indexes  Referential Integrity
 Trends & Analysis
 Invisible Indexes  Row-level Locking
 Health monitoring
 Grouping  Customizable Lock Isolation Levels
 Performance monitoring
 Distributed Transactions (XA)
Optimizer  InnoDB monitoring
 Snapshot Isolation
 Cost-based Optimizer  Replication monitoring
 Repeatable Reads (readers don't
 Optimizer Tracing block writers and vice-versa)  Backup Monitoring
 JSON Explain  Automatic Deadlock Detection  I/O Monitoring

 Optimizer Hints  Blocking/Locking Reports

Data Warehouse Optimized features
 Optimizer Histograms  Security administration
 Fast Data Load Utility
Oracle Enterprise Manager for
MySQL Document Store  High-Speed Multi-Insert Function
MySQL1
 Relational Tables  GROUP BY WITH ROLLUP
 JSON Documents  Aggregate UDF Graphical Tools
 X Protocol  Analytic SQL Functions  MySQL Workbench
 X DevAPI  Multi-Terabyte Scalability  Data Modeling
  MySQL Shell  Database Administration
Geo Spatial Support
 SQL Editor
JSON Support  InnoDB R-tree Spatial Indexes
 Native JSON Datatype  GeoHash Drivers
 JSON Table Functions  GeoJSON  MySQL Native C Library
 JSON Aggregation  Spatial Reference System (SRS)  MySQL Drivers for ODBC,
Functions JDBC, .Net, Python, C, C++
 SRID Spatial Data Types
 JSON Merge Functions  Community Drivers for PHP, Perl,
 SRID Spatial Indexes
Python, Ruby, Go
 JSON Partial Update
 SRID Spatial Functions
Replication & High-
Character Sets & Collations
Availability
 UTF8MB4 as default
 InnoDB Cluster
 Unicode 9.0
 Group Replication
 Case & Accent Sensitive Collations
 Router
 Built-in Replication Manageability and Ease of Use
Engine
 Easy Install and Setup
 Master/Slave, Ring, Tree
 "3 minutes to Success" with all-in-one
 Row-based Replication Windows Installer
 Semi-synchronous
Replication
 Multi-source Replication
 Time-delayed
Replication
 Global Transaction IDs
 Slave Failover, Recovery
 Multi-threaded slaves
 Sharding

MySQL NDB Cluster

 99.999% Availability
 Distributed architecture
 Synchronous replication
 Real-time transactional
performance
 Foreign Keys
 SQL & Non-SQL data
access
 Auto sharding of data
 Java, C++, memcached,
HTTP

1
Features only available in Commercial Editions.