Percona Server for MySQL Feature Comparison
Percona Server for MySQL is an enhanced drop-in replacement for MySQL. With Percona Server for MySQL,
- Your queries will run faster and more consistently.
- You will consolidate servers on powerful hardware.
- You will delay sharding, or avoid it entirely.
- You will save money on hosting fees and power.
- You will spend less time tuning and administering.
- You will achieve higher uptime.
- You will troubleshoot without guesswork.
We provide these benefits by significantly enhancing Percona Server for MySQL as
compared to the standard MySQL database server:
| Features |
Percona Server for MySQL 8.0.13 |
MySQL 8.0.13 |
|---|
| Open source |
Yes |
Yes |
| ACID Compliance |
Yes |
Yes |
| Multi-Version Concurrency Control |
Yes |
Yes |
| Row-Level Locking |
Yes |
Yes |
| Automatic Crash Recovery |
Yes |
Yes |
| Table Partitioning |
Yes |
Yes |
| Views |
Yes |
Yes |
| Subqueries |
Yes |
Yes |
| Triggers |
Yes |
Yes |
| Stored Procedures |
Yes |
Yes |
| Foreign Keys |
Yes |
Yes |
| Window Functions |
Yes |
Yes |
| Common Table Expressions |
Yes |
Yes |
| Geospatial Features (GIS, SPRS) |
Yes |
Yes |
| GTID Replication |
Yes |
Yes |
| Group Replication |
Yes |
Yes |
| MyRocks Storage Engine |
Yes |
No |
| TokuDB Storage Engine |
Yes |
No |
Improvements for Developers
| Feature |
Percona Server for MySQL 8.0.13 |
MySQL 8.0.13 |
|---|
| NoSQL Socket-Level Interface |
Yes |
Yes |
| X API Support |
Yes |
Yes |
| JSON Functions |
Yes |
Yes |
| InnoDB Full-Text Search Improvements |
Yes |
No |
| Extra Hash/Digest Functions |
Yes |
No |
Security Features
| Feature |
Percona Server for MySQL 8.0.13 |
MySQL 8.0.13 |
|---|
| SQL Roles |
Yes |
Yes |
| SHA-2 Based Password Hashing |
Yes |
Yes |
| Password Rotation Policy |
Yes |
Yes |
| PAM Authentication |
Yes |
Enterprise Only |
| Audit Logging Plugin |
Yes |
Enterprise Only |
Encryption Features
| Feature |
Percona Server for MySQL 8.0.13 |
MySQL 8.0.13 |
|---|
| Storing Keyring in a File |
Yes |
Yes |
| Storing Keyring in Hashicorp Vault |
Yes |
No |
| Encrypt InnoDB Data |
Yes |
Yes |
| Encrypt InnoDB Logs |
Yes |
Yes |
| Encrypt Built-in InnoDB Tablespaces (General, System, Undo, Temp) |
Yes |
No |
| Encrypt Binary Logs |
Yes |
No |
| Encrypt Temporary Files |
Yes |
No |
| Key Rotation with Scrubbing |
Yes |
No |
| Enforce Encryption |
Yes |
No |
Operational Improvements
| Feature |
Percona Server for MySQL 8.0.13 |
MySQL 8.0.13 |
|---|
| Atomic DDL |
Yes |
Yes |
| Transactional Data Dictionary |
Yes |
Yes |
| Instant DDL |
Yes |
Yes |
| SET PERSIST |
Yes |
Yes |
| Invisible Indexes |
Yes |
Yes |
| Changed Page Tracking |
Yes |
No |
| Threadpool |
Yes |
Enterprise Only |
| Backup Locks |
Yes |
Yes |
| Extended SHOW GRANTS |
Yes |
No |
| Improved Handling of Corrupted Tables |
Yes |
No |
| Ability to Kill Idle Transactions |
Yes |
No |
| Improvements to START TRANSACTION WITH CONSISTENT SNAPSHOT |
Yes |
No |
Percona Server for MySQL Feature Comparison 