Percona Distribution for MySQL 8.0.29 using Percona XtraDB Cluster (2022-09-12)¶
|Release date||September 12, 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.29-21
The following lists a number of the bug fixes for MySQL 8.0.29, provided by Oracle, and included in Percona XtraDB Cluster and Percona Distribution for MySQL:
The Performance Schema tracks if a query was processed on the PRIMARY engine, InnoDB, or a SECONDARY engine, HeatWave. An
EXECUTION_ENGINEcolumn, which indicates the engine used, was added to the Performance Schema statement event tables and the
Added support for the
IF NOT EXISTSoption for the
CREATE PROCEDURE, and
Added support for
ALTER TABLE … DROP COLUMN ALGORITHM=INSTANT.
An anonymous user with the
PROCESSprivilege was unable to select processlist table rows.
Find the full list of bug fixes and changes in the MySQL 8.0.29 Release Notes.
Percona Server for MySQL has changed the default for the supported DDL column operations to ALGORITHM=INPLACE. This change fixes the corruption issue with the INSTANT ADD/DROP COLUMNS (find more details in PS-8292).
In MySQL 8.0.29, the default setting for supported DDL operations is ALGORITHM=INSTANT. You can explicitly specify ALGORITHM=INSTANT in DDL column operations.
For more information, see Percona Blog: Percona XtraBackup 8.0.29 and INSTANT ADD/DROP Columns.
The following is the list of components supplied with the Percona XtraDB Cluster-based deployment variant of Percona Distribution for MySQL:
|Percona XtraBackup||8.0.29||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.4.3||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.|