Skip to content
logo
Percona XtraDB Cluster
Percona XtraDB Cluster 8.0.30-22.md (2022-12-28)
Initializing search
    percona/pxc-docs
    percona/pxc-docs
    • Home
      • About Percona XtraDB Cluster
      • Percona XtraDB Cluster limitations
      • Understand version numbers
      • Quick start guide for Percona XtraDB Cluster
      • Install Percona XtraDB Cluster
      • Configure nodes for write-set replication
      • Bootstrap the first node
      • Add nodes to cluster
      • Verify replication
      • High availability
      • PXC strict mode
      • Online schema upgrade
      • Non-Blocking Operations (NBO) method for Online Scheme Upgrades (OSU)
      • Security basics
      • Secure the network
      • Encrypt PXC traffic
      • Enable AppArmor
      • Enable SELinux
      • State snapshot transfer
      • Percona XtraBackup SST configuration
      • Restart the cluster nodes
      • Cluster failover
      • Monitor the cluster
      • Certification in Percona XtraDB Cluster
      • Percona XtraDB Cluster threading model
      • Understand GCache and Record-Set cache
      • GCache encryption and Write-Set cache encryption
      • Perfomance Schema instrumentation
      • Data at Rest Encryption
      • Upgrade Percona XtraDB Cluster
      • Crash recovery
      • Configure Percona XtraDB Cluster on CentOS
      • Configure Percona XtraDB Cluster on Ubuntu
      • Set up Galera arbitrator
      • How to set up a three-node cluster on a single box
      • How to set up a three-node cluster in EC2 environment
      • Load balancing with HAProxy
      • Load balancing with ProxySQL
      • ProxySQL admin utilities
      • Setting up a testing environment with ProxySQL
      • Release notes index
      • Percona XtraDB Cluster 8.0.31-23 (2023-03-14)
      • Percona XtraDB Cluster 8.0.30-22.md (2022-12-28)
        • Release highlights
        • Bug fixes
        • Platform support
        • Useful links
      • Percona XtraDB Cluster 8.0.29-21 (2022-09-12)
      • Percona XtraDB Cluster 8.0.28-19.1 (2022-07-19)
      • Percona XtraDB Cluster 8.0.27-18.1
      • Percona XtraDB Cluster 8.0.26-16.1
      • Percona XtraDB Cluster 8.0.25-15.1
      • Percona XtraDB Cluster 8.0.23-14.1
      • Percona XtraDB Cluster 8.0.22-13.1
      • Percona XtraDB Cluster 8.0.21-12.1
      • Percona XtraDB Cluster 8.0.20-11
      • Percona XtraDB Cluster 8.0.20-11.3
      • Percona XtraDB Cluster 8.0.20-11.2
      • Percona XtraDB Cluster 8.0.19-10
      • Percona XtraDB Cluster 8.0.18-9.3
      • Index of wsrep status variables
      • Index of wsrep system variables
      • Index of wsrep_provider options
      • Index of files created by PXC
      • Frequently asked questions
      • Glossary
      • Copyright and licensing information
      • Trademark policy

    • Release highlights
    • Bug fixes
    • Platform support
    • Useful links

    Percona XtraDB Cluster 8.0.30-22.md (2022-12-28)¶

    Release date December 28, 2022
    Install instructions Install Percona XtraDB Cluster
    Download this version Percona XtraDB Cluster

    Percona XtraDB Cluster (PXC) supports critical business applications in your public, private, or hybrid cloud environment. Our free, open source, enterprise-grade solution includes the high availability and security features your business requires to meet your customer expectations and business goals.

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

    For training, contact Percona Training - Start learning now.

    Release highlights¶

    Percona XtraDB Cluster is based on Percona Server for MySQL. Find a complete list of improvements and bug fixes in the Percona Server for MySQL 8.0.30-22 (2022-11-21) release notes.

    Note

    The following Percona Server for MySQL 8.0.30 features are not supported in this version of Percona XtraDB Cluster:

    • Amazon Key Management Service

    • Key Management Interoperability Protocol

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

    Improvements and bug fixes introduced by Oracle for MySQL 8.0.30 and included in Percona Server for MySQL are the following:

    • 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.

    Bug fixes¶

    • PXC-3639: The buffer overflow was not considered when using strncpy in WSREP patch.

    • PXC-3821: The truncation of the performance_schema table on a node was replicated across the cluster.

    • PXC-4012: The replica node left the cluster when executing CREATE USER with password_history option simultaneously.

    • PXC-4033: When the prepared statement is executed in parallel to the DDL modifying the table that the prepared statement uses, the server fails with an assertion saying that the prepared statement transaction was aborted, so it cannot be committed.

    • PXC-4048: gra_x_y_v2.log files created in case of failures were empty.

    Platform support¶

    • Percona XtraDB Cluster 8.0.30-22 supports Oracle Linux/Red Hat Enterprise Linux 9.

    • Percona XtraDB Cluster 8.0.30-22 supports Ubuntu 22.04.

    Useful links¶

    • The Percona XtraDB Cluster GitHub location

    • Contribute to the documentation

    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: 2022-12-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.