Skip to content
logo
Percona Distribution for MySQL
Percona Distribution for MySQL 8.0.30 using Percona XtraDB Cluster (2022-12-28)
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 Update (2023-03-28)
      • Percona Distribution for MySQL 8.0.31 using Percona XtraDB Cluster 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 XtraDB Cluster (2023-03-15)
      • 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 XtraDB Cluster Update (2023-01-23)
      • 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 XtraDB Cluster (2022-12-28)
        • Release highlights
          • Replication manager for Percona XtraDB Cluster
      • Percona Distribution for MySQL 8.0.29 using Percona XtraDB Cluster Update (2022-12-01)
      • Percona Distribution for MySQL 8.0.30 using Percona Server for MySQL (2022-11-29)
      • Percona Distribution for MySQL 8.0.29 using Percona XtraDB Cluster (2022-09-12)
      • Percona Distribution for MySQL 8.0.29 using Percona Server for MySQL (2022-08-09)
      • Percona Distribution for MySQL 8.0.28 using Percona XtraDB Cluster (2022-07-19)
      • 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 XtraDB Cluster (2022-04-11)
      • Percona Distribution for MySQL 8.0.27 using Percona Server for MySQL (2022-03-03)
      • Percona Distribution for MySQL 8.0.26 using Percona XtraDB Cluster (2022-01-17)
      • Percona Distribution for MySQL 8.0.26 using Percona Server for MySQL (2021-10-20)
      • Percona Distribution for MySQL 8.0.25 using Percona XtraDB Cluster (2021-11-22)
      • Percona Distribution for MySQL 8.0.25 using Percona Server for MySQL (2021-07-13)
      • 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.23 using Percona Server for MySQL (2021-05-12)
      • Percona Distribution for MySQL 8.0.22 using Percona XtraDB Cluster (2021-03-22)
      • Percona Distribution for MySQL 8.0.22 using Percona Server for MySQL (2020-12-14)
      • Percona Distribution for MySQL 8.0.21 using Percona XtraDB Cluster (2020-12-28)
      • Percona Distribution for MySQL 8.0.21 using Percona Server for MySQL (2020-10-13)
      • 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.20 using Percona Server for MySQL (2020-07-21)
      • Percona Distribution for MySQL 8.0.19 (2020-06-22)
      • Copyright and Licensing Information
      • Trademark Policy
      • Glossary

    • Release highlights
      • Replication manager for Percona XtraDB Cluster

    Percona Distribution for MySQL 8.0.30 using Percona XtraDB Cluster (2022-12-28)¶

    Release date December 28, 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.30-22

    Release highlights¶

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

    • Supports Generated Invisible Primary Keys(GIPK). This feature automatically adds a primary key to InnoDB tables without a primary key. The generated key is always named my_row_id. The GIPK feature is not enabled by default. Enable the feature by setting sql_generate_invisible_primary_key to ON.

    • The InnoDB_doublewrite system has two new settings:

    • DETECT_ONLY. This setting allows only metadata to be written to the doublewrite buffer. Database page content is not written to the buffer. Recovery does not use the buffer to fix incomplete page writes. Use this setting only when you need to detect incomplete page writes.

    • DETECT_AND_RECOVER. This setting is equivalent to the current ON setting. The doublewrite buffer is enabled. Database page content is written to the buffer and the buffer is accessed to fix incomplete page writes during recovery.

    • The --skip_host_cache server option is deprecated and will be removed in a future release. Use SET GLOBAL host_cache_size= 0 or set host_cache_size = 0.

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

    Note

    The following Percona Server for MySQL 8.0.30 features are not supported in Percona XtraDB Cluster 8.0.30-22:

    • Amazon Key Management Service

    • Key Management Interoperability Protocol

    The features will be supported in the next version of Percona XtraDB Cluster.

    Replication manager for Percona XtraDB Cluster¶

    PXC-4062: The Replication manager for Percona XtraDB Cluster is a tech preview feature. The replication manager helps manage multi-source replication between multiple Percona XtraDB Cluster clusters. To manage a single replica, use Single replica manager for Percona XtraDB Cluster.

    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.30-23 An open-source hot backup utility for MySQL-based servers that doesn’t lock your database during the backup.
    HAProxy 2.5.10 A high-availability and load-balancing solution for Percona XtraDB Cluster. This is a default proxy.
    ProxySQL 2.4.4 A high performance, high-availability, protocol-aware proxy for MySQL.
    Percona Toolkit 3.5.0 The set of scripts to simplify and optimize database operation.

    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-03-28
    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.