# 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](installing.md)|


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](https://docs.percona.com/percona-server/8.0/release-notes/Percona-Server-8.0.28-19.html).

## 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](https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-28.html).

## Orchestrator

[DISTMYSQL-141](https://jira.percona.com/browse/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|