Oracle MySQL Cloud service
- MySQL Database as a service
A flexible architecture
- Open source
- Multithreading
- Pluggable Storage Engine Architecture
- INNODB,NDB Cluster
- MyISAM, merging, memory, archive
ANSI SQL Standard
- ANSI SQL
- Sub-query, join, cursor
- Prepared statements
- View
- Trigger
- Stored Procedures
- User-defined Functions
- Information mode
- Unified
- Referential integrity
- Server-Enforced data integrity
replication and 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-lapse replication
- MySQL Cluster HA
- Global Transaction ID
- recovery from a Slave failure
- Multi-threaded slave
- Split
MySQL cluster
- Availability 99.999%
- Distributed architecture
- Synchronous replication
- Real-Time Transaction performance
- FOREIGN key
- SQL and non-SQL data access
- Automatic Data fragmentation
- Java,c ++,memcached,http
Storage Management
- Storage Management
- Automatic Space expansion
- Built-in space reclamation
- Automatic undo/Rollback Management
- Customizable Storage allocation
- Compressing and archiving tables
- Packaged Index Storage
- Suitable for NAS or SAN storage
Safety
- SSL support
- Built-in data encryption/decryption
- SSL key generation
- Password management
- Fine-Grained object permissions
- View Support
- Triggering audits
- Query logs for auditing
|
High Performance
- Performance mode
- SYS schema
- Optimized for high concurrency
- Optimized for read-only
- Optimized for SSDs
- Multiple index types (b-Tree, R-Tree, hash, full-text, etc.)
- Cost-based Optimizer
- Diagnostics and SQL Tracing
- Optimizer tracking
- JSON explanation
OLTP and Transactions
- Acid Trading
- Commit, Roll back
- FOREIGN key
- Referential integrity
- Row-level locking
- Customizable lock Isolation Level
- Distributed Transactions (XA)
- Snapshot isolation
- Repeatable reads (Readers do not block authors, and vice versa)
- Automatic deadlock Detection
Web application Optimization features
- Server thread pool
- Connection Thread Cache
- Query Result Cache
- Load Balancing
- Prepared statements
- Full Text Search
- Multiple character sets
- Multi-terabyte scalability
JSON support
- Native JSON data types
- JSON functions
Data Warehouse optimization features
- Fast Data Loading Tool
- High-speed multi-insertion function
- GROUP by with ROLLUP
- Collection UDF
- Parsing SQL functions
- Multi-terabyte scalability
partition (table/index)
- Range, hash, list, key
- Comprehensive
- 8k partitions per table
- Table between portable partitions
- Explicitly querying partitions
- Transparent trimming
Geo-spatial support
- InnoDB R-tree Spatial Index
- Geo-Hash
- With Geojson
Full Text Search
- Local InnoDB full-text Search
- Chinese, Japanese and Korean
|
Manageability and ease-of-use
- Easy setup and Setup
- "3 minutes to Success" with Integrated Windows Installer
- Information mode
- Event Scheduler
MySQL Enterprise backup1
- InnoDB Hot Backup
- Parallel backup, recovery operations
- Compress backup
- Full, incremental, partial backup
- Full, partial restore
- Point-in-time recovery
- Automatic Restart/recovery
- scriptable command-line interface
- Integration with Oracle Secure Backup,netbackup,tivoli
MySQL Enterprise High availability1
- MySQL Group replication
- MySQL InnoDB Cluster
MySQL Enterprise- Scale scalability1
MySQL Enterprise Security1
- MySQL enterprise certification 1
- MySQL Enterprise transparent Data encryption (TDE)1
- MySQL Enterprise encryption 1
- MySQL Enterprise firewall 1
- MySQL Enterprise Audit 1
MySQL Enterprise Monitor1
- Visualize dashboards
- Query Analyzer
- Rules and Advisors
- Trends and Analysis
- Health monitoring
- Performance monitoring
- InnoDB Monitoring
- Replication Monitoring
- Backup monitoring
- I/O monitoring
- Block/Lock Report
- Security management
Oracle Enterprise Manager for MySQL1Graphical Tools
- MySQL Workbench
- Data modeling
- Database management
- SQL Editor
- Database migration
- MySQL for Visual Studio
- MySQL for Excel
Driver Program
- MySQL Local c library
- MySQL driver for Odbc,jdbc,.net,python,c,c + +
- Community-driven drivers for Php,perl,python,ruby,go
Operating System
- Linux,solaris,freebsd,mac os,windows
|