Skip to content
logo
Percona XtraDB Cluster
Percona XtraDB Cluster 8.0.33-25 (2023-08-02)
Initializing search
    percona/pxc-docs
    percona/pxc-docs
    • Home
      • Release notes index
      • Percona XtraDB Cluster 8.0.34-26 (2023-11-01)
      • Percona XtraDB Cluster 8.0.33-25 Update (2023-08-25)
      • Percona XtraDB Cluster 8.0.33-25 (2023-08-02)
        • Release highlights
        • New features
        • Bug fixes
        • Useful links
      • Percona XtraDB Cluster 8.0.32-24.2 (2023-05-24)
      • Percona XtraDB Cluster 8.0.32-24 (2023-04-18)
      • Percona XtraDB Cluster 8.0.31-23.2 (2023-04-04)
      • Percona XtraDB Cluster 8.0.31-23 (2023-03-14)
      • Percona XtraDB Cluster 8.0.30-22.md (2022-12-28)
      • 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
      • About Percona XtraDB Cluster
      • Percona XtraDB Cluster limitations
      • Understand version numbers
      • High availability
      • Percona XtraDB Cluster strict mode
      • Online schema upgrade
      • Non-Blocking Operations (NBO) method for Online Scheme Upgrades (OSU)
      • Quickstart Guide for Percona XtraDB Cluster
      • Get started with Percona XtraDB Cluster
      • Install Percona XtraDB Cluster
      • Install Percona XtraDB Cluster on Debian or Ubuntu
      • Install Percona XtraDB Cluster on Red Hat Enterprise Linux and CentOS
      • Install Percona XtraDB Cluster from Binary Tarball
      • Compile and install from Source Code
      • Running Percona XtraDB Cluster in a Docker Container
      • Configure nodes for write-set replication
      • Bootstrap the first node
      • Add nodes to cluster
      • Verify replication
      • Upgrade Percona XtraDB Cluster
      • Restore a 5.7 backup to an 8.0 cluster
      • 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
      • Crash recovery
      • Configure a cluster on Red Hat-based distributions
      • Configure a cluster on Debian or 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 balance with ProxySQL
      • ProxySQL admin utilities
      • Set up a testing environment with ProxySQL
      • Index of wsrep status variables
      • Index of wsrep system variables
      • Index of wsrep_provider options
      • Index of files created by PXC
      • Telemetry on Percona XtraDB Cluster
      • Frequently asked questions
      • Glossary
      • Copyright and licensing information
      • Trademark policy

    • Release highlights
    • New features
    • Bug fixes
    • Useful links

    Percona XtraDB Cluster 8.0.33-25 (2023-08-02)¶

    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.

    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.33-25 (2023-06-15) release notes.

    Improvements and bug fixes introduced by Oracle for MySQL 8.0.33 and included in Percona XtraDB Cluster are the following:

    • The INSTALL COMPONENT includes the SET clause. The SET clause sets the values of component system variables when installing one or several components. This reduces the inconvenience and limitations associated with assigning variable values in other ways.

    • The mysqlbinlog --start-position accepts values up to 18446744073709551615. If the --read-from-remote-server or --read-from-remote-source option is used, the maximum is 4294967295. (Bug #77818, Bug #21498994)

    • Using a generated column with DEFAULT(col_name) to specify the default value for a named column is not allowed and throws an error message. (Bug #34463652, Bug #34369580)

    • Not all possible error states were reported during the binary log recovery process. (Bug #33658850)

    • User-defined collations are deprecated. The usage of the following user-defined collations causes a warning that is written to the log:

    • When COLLATE is followed by the name of a user-defined collation in an SQL statement.

    • When the name of a user-defined collation is used as the value of collation_server, collation_database, or collation_connection.

    The support for user-defined collations will be removed in a future releases of MySQL.

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

    New features¶

    • PXC-3760: Added FC auto eviction variables allow the eviction of a lagging node.

    Bug fixes¶

    • PXC-667: Unexpected exit during the BF-abort of active HANDLER <table> OPEN AS <alias>.

    • PXC-679: An undetected state gap discovery causes the server to hang on shutdown.

    • PXC-4222: When a node abruptly leaves the applier thread causes all the other nodes in the cluster to hang.

    • PXC-4225: In the INFORMATION_SCHEMA.PROCCESSLIST, the COMMAND value is incorrect.

    • PXC-4228: The NBO mode corrupted the binary log.

    • PXC-4233: A cluster state interruption during NBO can lead to a permanent cluster lock.

    • PXC-4253: The merge to 8.0.33 fixes a number of CVE vulnerabilities.

    • PXC-4258: A failure to add a foreign key resulted in an inconsistency.

    • PXC-4268: If the ALTER DEFINER VIEW was changed with insufficient privileges, the Percona XtraDB Cluster node gets a Disconnected/Inconsistent state

    • PXC-4278: Renaming a table with NBO caused a server exit.

    Useful links¶

    Install Percona XtraDB Cluster

    The Percona XtraDB Cluster GitHub location

    Download product binaries, packages, and tarballs at Percona Product Downloads

    Contribute to the documentation

    For training, contact Percona Training - Start learning now.

    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-07-13
    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. Read more about Percona Cookie Policy.