Percona Server for MySQL 8.0 - Documentation¶
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.
Does this sound too good to be true? It’s not. Percona Server for MySQL offers breakthrough performance, scalability, features, and instrumentation. Its self-tuning algorithms and support for extremely high-performance hardware make it the clear choice for companies who demand the utmost performance and reliability from their database server.
Introduction¶
Installation¶
- Installing Percona Server for MySQL 8.0.17-8
- Installing Percona Server for MySQL from Repositories
- Installing Percona Server for MySQL from a Binary Tarball
- Installing Percona Server for MySQL from a Source Tarball
- Installing Percona Server for MySQL from the Git Source Tree
- Compiling Percona Server for MySQL from Source
- Building Percona Server for MySQL Debian/Ubuntu packages
- Percona Server for MySQL In-Place Upgrading Guide: From 5.7 to 8.0
Scalability Improvements¶
Performance Improvements¶
Flexibility Improvements¶
- Suppress Warning Messages
Improved MEMORY
Storage Engine- Extended
mysqldump
- Extended
SELECT INTO OUTFILE/DUMPFILE
- Extended
mysqlbinlog
- Support for PROXY protocol
- Compressed columns with dictionaries
- InnoDB Full-Text Search Improvements
- Ignoring Stopword List
- Binlogging and replication improvements
- Extended SET VAR Optimizer Hint
Reliability Improvements¶
Management Improvements¶
Security Improvements¶
- PAM Authentication Plugin
- Data at Rest Encryption
- Information about HashiCorp Vault
- Using the Keyring Plugin
- Rotating the Master Key
- Encrypting File-Per-Tablespace Tables
- Encrypting a Schema or a General Tablespace
- Encrypting the System Tablespace
- Encrypting Temporary Files
- Encrypting Binary Logs
- Encrypting the Redo Log
- Encrypting the Undo Tablespace
- Working with Background Encryption Threads
- Encrypting Doublewrite Buffers
- Verifying the Encryption for Tables, Tablespaces, and Schemas
- Data Scrubbing
- SSL Improvements
- Data Masking
Diagnostics Improvements¶
TokuDB¶
- TokuDB Introduction
- TokuDB Installation
- Using TokuDB
- Fast Updates with TokuDB
- TokuDB files and file types
- TokuDB file management
- TokuDB Background ANALYZE TABLE
- TokuDB Variables
- TokuDB Status Variables
- TokuDB Troubleshooting
- TokuDB Performance Schema Integration
- Percona TokuBackup
- Frequently Asked Questions
- Removing TokuDB storage engine
Percona MyRocks¶
Reference¶
- List of upstream MySQL bugs fixed in Percona Server for MySQL 8.0
- List of variables introduced in Percona Server for MySQL 8.0
- Development of Percona Server for MySQL
- Trademark Policy
- Index of
INFORMATION_SCHEMA
Tables - Frequently Asked Questions
- Copyright and Licensing Information
- Percona Server for MySQL 8.0 Release notes
- Glossary