Oracle MySQL Cloud Service

MySQL Database as a Service

Flexible Architecture

Open Source

Multi-threaded

Pluggable Storage-Engine

InnoDB, NDB

MyISAM

ANSI 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

Grouping

Optimizer

Cost-based Optimizer

Optimizer Tracing

JSON Explain

Optimizer Hints

Optimizer Histograms

MySQL Document Store

Relational Tables

JSON Documents

X Protocol

X DevAPI

MySQL Shell

JSON Support

Native JSON Datatype

JSON Table Functions

JSON Aggregation Functions

JSON Merge Functions

JSON Partial Update

Replication & High-Availability

InnoDB Cluster

Group Replication

Router

Built-in Replication Engine

Master/Slave, Ring, Tree

Row-based Replication

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

Security

OpenSSL by Default

SQL Roles

Password management

High-Performance

Performance Schema

Information Schema

SYS Schema

Resource Groups

Partitioning

Optimized for high concurrency

Optimized for Read Only

Optimized for use with SSD

Multiple Index Type (B-tree, R-tree, Hash, Full Text, etc.)

Server-side Thread Pool

Connection Thread Caching

Diagnostics, and SQL Tracing

OLTP and Transactions

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

Data Warehouse Optimized features

Fast Data Load Utility

High-Speed Multi-Insert Function

GROUP BY WITH ROLLUP

Aggregate UDF

Analytic SQL Functions

Multi-Terabyte Scalability

Geo Spatial Support

InnoDB R-tree Spatial Indexes

GeoHash

GeoJSON

Spatial Reference System (SRS)

SRID Spatial Data Types

SRID Spatial Indexes

SRID Spatial Functions

Character Sets & Collations

UTF8MB4 as default

Unicode 9.0

Case & Accent Sensitive Collations

Manageability and Ease of Use

Easy Install and Setup

"3 minutes to Success" with all-in-one Windows Installer

MySQL Enterprise Backup1

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 Availability1

MySQL Group Replication

MySQL InnoDB Cluster

MySQL Enterprise Scalability1

MySQL Thread Pool

MySQL Enterprise Security1

MySQL Enterprise Authentication1

MySQL Enterprise TDE1

MySQL Enterprise Encryption1

MySQL Enterprise Masking1

MySQL Enterprise Firewall1

MySQL Enterprise Audit1

MySQL Enterprise Monitor1

Visual Dashboard

Query Analyzer

Rules & Advisors

Trends & Analysis

Health monitoring

Performance monitoring

InnoDB monitoring

Replication monitoring

Backup Monitoring

I/O Monitoring

Blocking/Locking Reports

Security administration

Oracle Enterprise Manager for MySQL1

Graphical Tools

MySQL Workbench

Data Modeling

Database Administration

SQL Editor

Drivers

MySQL Native C Library

MySQL Drivers for ODBC, JDBC, .Net, Python, C, C++

Community Drivers for PHP, Perl, Python, Ruby, Go