MySQL Technical Specifications-Enterprise Edition (from MySQL website)

Source: Internet
Author: User
Tags mysql for visual studio

MySQL Technical specifications
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 thread pool
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

1 features are only available for commercial editions.

MySQL Technical Specifications-Enterprise Edition (from MySQL website)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.