etMySQL Enterprise Edition
MySQL Enterprise Edition includes the most comprehensive set ofadvanced features, management tools and technical support toachieve the highest levels of MySQL scalability, security andcompliance, reliability, and uptime. It reduces the risk, cost, andcomplexity in developing, deploying, and managing business-critical
MySQL applications.

Highlights
MySQL Database
MySQL Enterprise HAMySQL Enterprise Backup
MySQL Enterprise Scalability
MySQL Enterprise Authentication• Achieve database high availability using MySQL InnoDB Cluster andMySQL InnoDB ClusterSet

MySQL Enterprise TDE• Meet exponential growth in users and data with MySQL Enterprise
Scalability

MySQL Enterprise Firewall• Reduce risk of data loss with MySQL Enterprise Backup for hot, online
backup and recovery

MySQL Enterprise Telemetry

MySQL Enterprise Encryption

MySQL Enterprise Audit

MySQL Operator for Kubernetes• Leverage existing security infrastructures with MySQL Enterprise

MySQL Document Store

Authentication

Oracle Premier Support• Protect sensitive data using encryption, key generation, and digital
signatures“We chose MySQLEnterprise Edition
over Microsoft SQL
Server as it provided
all the tools we neededto secure our databaseat low costs, comparedto the astronomicallyexpensive Microsoft.”• Block database attacks such as an SQL Injection with MySQL Enterprise
Firewall• Implement policy-based auditing compliance to existing MySQLapplications with MySQL Enterprise Audit• Monitor MySQL performance and behavior using MySQL Enterprise
Telemetry• Build, deploy, and manage a private DBaaS and microservices using
MySQL Operator for Kubernetes• Use relational tables and schema-less JSON documents with MySQL
Document Store• Get 24x7 assistance in the development, deployment, and managementof MySQL applications.

Tony SearleCIOGuard.me

POWERED BY MYSQL

Web/Enterprise
AirbnbDisney
FacebookTencent

1Twitter
VISA
Wells Fargo
Uber

Data Sheet / MySQL Enterprise Edition
Copyright © 2024, Oracle and/or its affiliates / Public

Embedded/ISVAdobe
AirbusEMC
F5 Networks

IBMIntuit
NetApp
Palo Alto Networks

Telecom
AT&T
ComcastEricssonFrance Telecom

Nokia
Siemens
Telenor
TeligentMYSQL TECHNICAL SPECIFICATION
Flexible Architecture•Open Source•Multi-threaded•
Pluggable Storage-Engine•
InnoDB, NDBANSI SQL Standards•ANSI SQL
•SubQueries, Joins, Cursors•Prepared Statements•Views•
Triggers•
Stored Procedures•
User-Defined Functions•
Window Functions and CTEs•
NOWAIT and SKIP LOCK•
Descending Indexes•
Invisible Indexes•GroupingOptimizer•
Cost-based Optimizer•
Optimizer Tracing•
JSON Explain•
Optimizer Hints•
Optimizer Histograms

MySQL Operator for Kubernetes•
Containers and microservices•
Private DBaaSSecurity•••

OpenSSL by Default
SQL Roles
Password management

High-Performance
•
••
•
••
•
••••
•

Performance Schema
Information Schema
SYS Schema
Resource GroupsPartitioning
Optimized for high concurrencyOptimized for Read Only
Optimized for use with SSD
Multiple Index Type (B-tree, R-tree,Hash, Full Text, etc.)
Server-side Thread PoolConnection Thread Caching
Diagnostics, and SQL Tracing

JSON Support•
Native JSON Datatype•
JSON Table Functions•
JSON Aggregation Functions•
JSON Merge Functions•
JSON Partial Update
Replication & High-Availability•
InnoDB Cluster, ClusterSet•
Group Replication•
Router•
Built-in Replication Engine•
Row-based Replication•
Multi-source Replication•
Time-delayed Replication•
Global Transaction IDs
MySQL NDB Cluster•
99.999% Availability•
Distributed architecture•
Synchronous replication•
Real-time performance•
Foreign Keys•
SQL & Non-SQL data access•
Auto sharding of data••••••••••ACID Transactions
Commit, Rollback
Foreign Keys
Referential Integrity
Row-level Locking
Customizable Lock Isolation Levels
Distributed Transactions (XA)
Snapshot Isolation
Repeatable Reads (readers don’t block
writers and vice-versa)
Automatic Deadlock Detection

Geo Spatial Support••••InnoDB R-tree Spatial Indexes
GeoHashGeoJSON
Spatial Reference System (SRS)MySQL Shell•
Admin API•
Python Scripting
MySQL Connectors•MySQL Native C Library•
MySQL Drivers for ODBC, JDBC,.Net,Python, C, C++•Community Drivers for PHP, Perl,Python, Ruby, Node.js, Go, Rust

Connect with us
Visit mysql.com/contact
blogs.oracle.com/mysql

2

facebook.com/mysql

Data Sheet / MySQL Enterprise Edition
Copyright © 2024, Oracle and/or its affiliates / Public

MySQL Enterprise Backup•Hot Backup for InnoDB•Parallel backup, recovery operations•Compressed Backup•Full, Incremental, Partial Backups•Full, Partial Restore•
Point in Time Recovery•Auto-Restart/Recovery•
Scriptable, command line interface•
Integrated with Oracle Secure Backup,NetBackup, Tivoli
MySQL Enterprise High Availability••

twitter.com/mysql

MySQL InnoDB Cluster, ClusterSet
MySQL Group Replication

MySQL Enterprise Scalability•

OLTP and Transactions

MySQL Document Store•
Relational Tables•
JSON Documents•
X Protocol•
X DevAPIHeatWave•
Fully Managed Database Service•
OLTP, OLAP, ML, and Lakehouse•GenAI and Vector Store•
OCI, AWS, Azure

MySQL Thread PoolMySQL Enterprise Security•••••

MySQL Enterprise Authentication
MySQL Enterprise Transparent Data
Encryption (TDE)
MySQL Enterprise Encryption
MySQL Enterprise Firewall
MySQL Enterprise Audit

MySQL Enterprise Telemetry•••

OpenTelemetry Framework
TracingMetrics

Oracle Enterprise Manager for MySQL•••

Monitoring
Alerts and Notifications
Reports and Dashboards