Skip to content
logo
Percona Distribution for MySQL
Percona Distribution for MySQL 8.0.29 using Percona Server for MySQL (2022-08-09)
Initializing search
    /percona/pdmysql-docs
    /percona/pdmysql-docs
    • Home
      • Components
      • Deployment variants
      • Install Percona Distribution for MySQL
      • Upgrade Percona Distribution for MySQL
      • Downgrade Percona Distribution for MySQL
      • Technical overview
      • Architecture and components
      • Measurement and monitoring
      • Deployment
      • Replication manager for Percona XtraDB Cluster
      • Replication manager troubleshooting
      • Single replica manager for Percona XtraDB Cluster
      • Uninstalling Percona Distribution for MySQL
      • Release notes index
        • Percona Distribution for MySQL 8.0.32 using Percona Server for MySQL Second Update (2023-04-04)
        • Percona Distribution for MySQL 8.0.32 using Percona Server for MySQL Update (2023-03-28)
        • Percona Distribution for MySQL 8.0.32 using Percona Server for MySQL (2023-03-20)
        • Percona Distribution for MySQL 8.0.31 using Percona Server for MySQL Update (2023-02-15)
        • Percona Distribution for MySQL 8.0.31 using Percona Server for MySQL (2023-02-09)
        • Percona Distribution for MySQL 8.0.30 using Percona Server for MySQL Second Update (2023-01-23)
        • Percona Distribution for MySQL 8.0.30 using Percona Server for MySQL Update (2023-01-06)
        • Percona Distribution for MySQL 8.0.30 using Percona Server for MySQL (2022-11-29)
        • Percona Distribution for MySQL 8.0.29 using Percona Server for MySQL (2022-08-09)
          • Release Highlights
          • Orchestrator
          • Packaging Notes
        • Percona Distribution for MySQL 8.0.28 using Percona Server for MySQL Update (2022-06-20)
        • Percona Distribution for MySQL 8.0.28 using Percona Server for MySQL (2022-05-12)
        • Percona Distribution for MySQL 8.0.27 using Percona Server for MySQL (2022-03-03)
        • Percona Distribution for MySQL 8.0.26 using Percona Server for MySQL (2021-10-20)
        • Percona Distribution for MySQL 8.0.25 using Percona Server for MySQL (2021-07-13)
        • Percona Distribution for MySQL 8.0.23 using Percona Server for MySQL (2021-05-12)
        • Percona Distribution for MySQL 8.0.22 using Percona Server for MySQL (2020-12-14)
        • Percona Distribution for MySQL 8.0.21 using Percona Server for MySQL (2020-10-13)
        • Percona Distribution for MySQL 8.0.20 using Percona Server for MySQL (2020-07-21)
        • None
        • Percona Distribution for MySQL 8.0.32 using Percona XtraDB Cluster Update (2023-05-24)
        • Percona Distribution for MySQL 8.0.32 using Percona XtraDB Cluster (2023-04-18)
        • Percona Distribution for MySQL 8.0.31 using Percona XtraDB Cluster Second Update (2023-04-04)
        • Percona Distribution for MySQL 8.0.31 using Percona XtraDB Cluster Update (2023-03-28)
        • Percona Distribution for MySQL 8.0.31 using Percona XtraDB Cluster (2023-03-15)
        • Percona Distribution for MySQL 8.0.30 using Percona XtraDB Cluster Update (2023-01-23)
        • Percona Distribution for MySQL 8.0.30 using Percona XtraDB Cluster (2022-12-28)
        • Percona Distribution for MySQL 8.0.29 using Percona XtraDB Cluster Update (2022-12-01)
        • Percona Distribution for MySQL 8.0.29 using Percona XtraDB Cluster (2022-09-12)
        • Percona Distribution for MySQL 8.0.28 using Percona XtraDB Cluster (2022-07-19)
        • Percona Distribution for MySQL 8.0.27 using Percona XtraDB Cluster (2022-04-11)
        • Percona Distribution for MySQL 8.0.26 using Percona XtraDB Cluster (2022-01-17)
        • Percona Distribution for MySQL 8.0.25 using Percona XtraDB Cluster (2021-11-22)
        • Percona Distribution for MySQL 8.0.23 using *Percona XtraDB Cluster* Update (2021-09-15)
        • Percona Distribution for MySQL 8.0.23 using Percona XtraDB Cluster (2021-06-09)
        • Percona Distribution for MySQL 8.0.22 using Percona XtraDB Cluster (2021-03-22)
        • Percona Distribution for MySQL 8.0.21 using Percona XtraDB Cluster (2020-12-28)
        • Percona Distribution for MySQL 8.0.20 using Percona XtraDB Cluster Second Update (2020-10-22)
        • Percona Distribution for MySQL 8.0.20 using Percona XtraDB Cluster Update (2020-10-09)
        • Percona Distribution for MySQL 8.0.20 using Percona XtraDB Cluster (2020-10-01)
        • Percona Distribution for MySQL 8.0.19 (2020-06-22)
      • Copyright and Licensing Information
      • Trademark Policy
      • Glossary

    • Release Highlights
    • Orchestrator
    • Packaging Notes

    Percona Distribution for MySQL 8.0.29 using Percona Server for MySQL (2022-08-09)¶

    Release date August 8, 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 is focused on the Percona Server for MySQL-based deployment variant. It is based on Percona Server for MySQL 8.0.29-21.

    Release Highlights¶

    The following lists a number of the bug fixes for MySQL 8.0.29, provided by Oracle, and included in Percona Server for MySQL 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_ENGINE column, which indicates the engine used, was added to the Performance Schema statement event tables and the sys.processlist and the sys.x$processlist views.
    • Added support for the IF NOT EXISTS option for the CREATE FUNCTION, CREATE PROCEDURE, and CREATE TRIGGER statements.
    • Added support for ALTER TABLE ... DROP COLUMN ALGORITHM=INSTANT.
    • An anonymous user with the PROCESS privilege was unable to select processlist table rows.

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

    Note

    Percona Server for MySQL has changed the default for supported DDL column operations to ALGORITHM=INPLACE. This fixes corruption issue and several other issues with the INSTANT ADD/DROP COLUMN DDL (Find more details in PS-8292, PS-8291 and PS-8303).

    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.

    Orchestrator¶

    • DISTMYSQL-198: orchestrator client packages were missing for RPM based distributions. Starting from v8.0.29 they are now built and available for download.
    • DISTMYSQL-197: Option --version now returns a more understandable version number (in addition to the commit hash).

    Packaging Notes¶

    Debian 9 (“Stretch”) is no longer supported. To learn more, see Percona Blog: OS Platform End of Life (EOL) Announcement for Debian Linux 9


    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-3 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.29-22 An open-source hot backup utility for MySQL-based servers
    Percona Toolkit 3.4.0 The set of scripts to simplify and optimize database operation
    MySQL Shell 8.0.29 An advanced client and code editor for MySQL Server
    MySQL Router 8.0.29 Lightweight middleware that provides transparent routing between your application and back-end MySQL servers

    Contact us

    For free technical help, visit the Percona Community Forum.

    To report bugs or submit feature requests, open a JIRA ticket.

    For paid support and managed or consulting services , contact Percona Sales.


    Last update: 2023-05-24
    Percona LLC and/or its affiliates, © 2023
    Made with Material for MkDocs

    Cookie consent

    We use cookies to recognize your repeated visits and preferences, as well as to measure the effectiveness of our documentation and whether users find what they're searching for. With your consent, you're helping us to make our documentation better.