Skip to content
logo
Percona XtraDB Cluster
Percona XtraDB Cluster 8.0.31-23 (2023-03-14)
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.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)
        • Release highlights
        • New Features
        • Improvement
        • Bug fixes
        • Useful links
      • 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
      • 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
    • New Features
    • Improvement
    • Bug fixes
    • Useful links

    Percona XtraDB Cluster 8.0.31-23 (2023-03-14)¶

    Release date May 24, 2023
    Install instructions Install 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.

    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.31-23 (2022-11-21) release notes.

    This release adds the following feature in tech preview:

    • GCache encryption and Write-Set cache encryption

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

    • MySQL adds support for the SQL standard INTERSECT and EXCEPT table operators.

    • InnoDB supports parallel index builds. This improves index build performance. The sorted index entries are loaded into a B-tree in a multithread. In previous releases, this action was performed by a single thread.

    • The Performance and sys schemas show metrics for the global and session memory limits introduced in MySQL 8.0.28.

      The following columns have been added to the Performance Schema tables:

      Performance Schema tables Columns
      SETUP_INSTRUMENTS FLAGS
      THREADS CONTROLLED_MEMORY, MAX_CONTROLLED_MEMORY, TOTAL_MEMORY, MAX_TOTAL_MEMORY
      EVENTS_STATEMENTS_CURRENT, EVENTS_STATEMENTS_HISTORY, EVENTS_STATEMENTS_HISTORY_LONG MAX_CONTROLLED_MEMORY, MAX_TOTAL_MEMORY
      Statement Summary Tables MAX_CONTROLLED_MEMORY, MAX_TOTAL_MEMORY
      Performance Schema Connection Tables MAX_SESSION_CONTROLLED_MEMORY, MAX_SESSION_TOTAL_MEMORY
      PREPARED_STATEMENTS_INSTANCES MAX_CONTROLLED_MEMORY, MAX_TOTAL_MEMORY

      The following columns have been added to the sys schema STATEMENT_ANALYSIS and X$STATEMENT_ANALYSIS views:

      • MAX_CONTROLLED_MEMORY

      • MAX_TOTAL_MEMORY

      The controlled_by_default flag has been added to the PROPERTIES column of the SETUP_INSTRUMENTS table.

      Now, you can add and remove non-global memory instruments to the set of controlled-memory instruments. To do this, set the value of the FLAGS column of SETUP_INSTRUMENTS.

      SQL> UPDATE PERFORMANCE_SCHEMA.SETUP_INTRUMENTS SET FLAGS="controlled" 
      WHERE NAME='memory/sql/NET::buff';
      
    • The audit_log_flush variable has been deprecated and will be removed in future releases.

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

    New Features¶

    • Added support for GCache and Write-Set encryption.

    • PXC-3574: Added support for the wsrep_mode variable.

    Improvement¶

    • The Data at Rest encryption now encrypts Record-Set cache.

    Bug fixes¶

    • PXC-3989: Added support for keyring components.

    • PXC-4077: Injecting an empty transaction caused GTID inconsistencies between nodes.

    • PXC-4120: Enabling wsrep-debug created multiple entries of wsrep_commit_empty() in the Error log.

    • PXC-4126: When stream replication and TOI are active, the CREATE USER statement was not allowed.

    • PXC-4116: A PXC replica node stalled with parallel asynchronous parallel replication.

    • PXC-4148: A fix for the MDL conflict db= ticket=10 solved by abort error.

    Useful links¶

    The Percona XtraDB Cluster GitHub location

    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-04-18
    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.