Skip to content

Percona Distribution for MySQL 8.0.28 using Percona Server for MySQL (2022-05-12)

Release date May 12, 2022
Installation Installing Percona Distribution for MySQL

Percona Distribution for MySQL is a single solution with the best and 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 Server for MySQL-based deployment variant. It is based on Percona Server for MySQL 8.0.28-19.

Release Highlights

The following lists a number of the bug fixes for MySQL 8.0.28, provided by Oracle, and included in Percona Server for MySQL and Percona Distribution for MySQL:

  • The ASCII shortcut for CHARACTER SET latin1 and UNICODE shortcut for CHARACTER SET ucs2 are deprecated and raise a warning to use CHARACTER SET instead. 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 COLUMN operations when using ALGORITHM=INSTANT.

  • The limit for innodb_open_files now includes temporary tablespace files. The temporary tablespace files were not counted in the innodb_open_files in previous versions.

Find the full list of bug fixes and changes in the MySQL 8.0.28 Release Notes.

Orchestrator

DISTMYSQL-141: In complicated environments, such as 3 or more datacenters, or when each server has more than 2 intermediary masters, Orchestrator could miss replication delays in one or more datacenters. This was happening due to a hard-coded limitation of two intermediary masters to check for the replication delay. This is now fixed.


The following is the list of components supplied with Percona Server for MySQL-based deployment variant of Percona Distribution for MySQL:

Component Version Description
Orchestrator 3.2.6 The replication topology manager for Percona Server for MySQL
ProxySQL 2.3.2 A high performance, high-availability, protocol-aware proxy for MySQL
Percona XtraBackup 8.0.28-20.0 An open-source hot backup utility for MySQL-based servers
Percona Toolkit 3.3.1 The set of scripts to simplify and optimize database operation
MySQL Shell 8.0.28 An advanced client and code editor for MySQL Server
MySQL Router 8.0.28 Lightweight middleware that provides transparent routing between your application and back-end MySQL servers

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.