Percona Distribution for MySQL 8.0.28 using Percona XtraDB Cluster (2022-07-19)¶
| Release date | July 19, 2022 |
|---|---|
| Installation | Installing Percona Distribution for MySQL |
Percona Distribution for MySQL is a single solution with the most critical enterprise components from the MySQL open source community, designed and tested to work together.
Percona Distribution for MySQL provides two deployment variants: one is based on Percona Server for MySQL and another one is based on Percona XtraDB Cluster.
This release of Percona Distribution for MySQL is focused on the Percona XtraDB Cluster-based deployment variant. It is based on Percona XtraDB Cluster 8.0.28-19.1
Release Highlights¶
The following lists a number of the bug fixes for MySQL 8.0.28, provided by Oracle, and included in Percona XtraDB Cluster and Percona Distribution for MySQL:
- The
ASCIIshortcut forCHARACTER SET latin1andUNICODEshortcut forCHARACTER SET ucs2are deprecated and raise a warning to useCHARACTER SETinstead. The shortcuts will be removed in a future version. - A stored function and a loadable function with the same name can share the same namespace. Add the schema name when invoking a stored function in the shared namespace. The server generates a warning when function names collide.
- InnoDB supports
ALTER TABLE ... RENAME COLUMNoperations when usingALGORITHM=INSTANT. - The limit for
innodb_open_filesnow includes temporary tablespace files. The temporary tablespace files were not counted in theinnodb_open_filesin previous versions.
Find the full list of bug fixes and changes in the MySQL 8.0.28 Release Notes.
The following is the list of components supplied with the Percona XtraDB Cluster-based deployment variant of Percona Distribution for MySQL:
| Component | Version | Description |
|---|---|---|
| Percona XtraBackup | 8.0.28 | An open-source hot backup utility for MySQL-based servers that doesn’t lock your database during the backup. |
| HAProxy | 2.5.6 | A high-availability and load-balancing solution for Percona XtraDB Cluster. This is a default proxy. |
| ProxySQL | 2.3.2 | A high performance, high-availability, protocol-aware proxy for MySQL. |
| Percona Toolkit | 3.4.0 | The set of scripts to simplify and optimize database operation. |
Get expert help¶
If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.