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 |