Oracle-MSEES MySQL Enterprise Edition Subscription (1-4 socket server)
MySQL Enterprise Edition Subscription (1-4 socket server)
MySQL is the world’s most popular open source database. Whether you are a fast growing web property, technology ISV or large enterprise, MySQL can cost-effectively help you deliver high performance, scalable database applications.
MySQL Enterprise Edition includes the most comprehensive set of MySQL production, backup, monitoring, modeling, development, and administration tools so businesses can achieve the highest levels of reliability, security, and uptime. Along with industry-leading, global support from Oracle, MySQL Enterprise Edition Subscription reduces the risk, cost, and time required in developing, deploying, and managing business-critical MySQL applications.
MySQL Technical Specifications
MySQL Technical Specifications
Flexible Architecture
Open Source
Multi-threaded
Pluggable Storage-Engine Architecture
InnoDB, NDB Cluster
MyISAM, Merge, Memory, Archive
ANSI SQL Standards
ANSI SQL
SubQueries, Joins, Cursors
Prepared Statements
Views
Triggers
Stored Procedures
User-Defined Functions
Information Schema
Unicode
Referential Integrity
Server-enforced Data Integrity
Replication & High-Availability
Built-in Replication Engine
Master/Slave, Ring, Tree
Row-based Replication
Semi-synchronous Replication
Multi-source Replication
Time-delayed Replication
MySQL Cluster HA
Global Transaction IDs
Slave Failover, Recovery
Multi-threaded slaves
Router
Sharding
MySQL 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
Storage Management
Storage Administration
Automatic Space Expansion
Built-in Space Reclamation
Auto Undo/Rollback Management
Customizable Storage Assignments
Compressed and Archive Tables
Packed Index Storage
Works with NAS or SAN storage
Security
SSL Support
Built-in Data Encryption/Decryption
SSL Key Generation
Password management
Fine Grained Object Privileges
View Support
Triggers for auditing
Query Logs for auditing
High-Performance
Performance Schema
SYS Schema
Optimized for high concurrency
Optimized for Read Only
Optimized for use with SSD
Multiple Index Type (B-tree, R-tree, Hash, Full Text, etc.)
Cost-based Optimizer
Diagnostics, and SQL Tracing
Optimizer Tracing
JSON EXPLAIN
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
Web Application Optimized features
Server-side Thread Pool
Connection Thread Caching
Query Results Caching
Load Balancing
Prepared Statements
Full Text Search
Multiple Character Sets
Multi-Terabyte Scalability
JSON Support
Native JSON Datatype
JSON Functions
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
Partitioning (Table/Index)
Range, Hash, List, Key
Composite
8k partitions per table
Portable partitions between tables
Explicit querying by partition
Transparent Pruning
Geo Spatial Support
InnoDB R-tree Spatial Indexes
GeoHash
GeoJSON
Full Text Search
Native InnoDB Full Text Search
Chinese, Japanese, & Korean
Manageability and Ease of Use
Easy Install and Setup
"3 minutes to Success" with all-in-one Windows Installer
Information Schema
Event Scheduler
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
Windows Failover Clustering for MySQL
Oracle Solaris Clustering
MySQL Enterprise Scalability1
MySQL Thread Pool
MySQL Enterprise Security1
MySQL Enterprise Authentication1
MySQL Enterprise Transparent Data Encryption (TDE)1
MySQL Enterprise Encryption1
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
Database Migration
MySQL for Visual Studio
MySQL for Excel
Drivers
MySQL Native C Library
MySQL Drivers for ODBC, JDBC, .Net, Python, C, C++