Skip to content
logo
Percona XtraDB Cluster
Percona XtraDB Cluster 8.0.28-19.1 (2022-07-19)
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)
      • 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)
        • Release Highlights
        • Bugs Fixed
        • Useful Links
      • 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
    • Bugs Fixed
    • Useful Links

    Percona XtraDB Cluster 8.0.28-19.1 (2022-07-19)¶

    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¶

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

    • The ASCII shortcut for CHARACTER SET latin1 and UNICODE shortcut for CHARACTER SET ucs2 are deprecated and raise a warning to use CHARACTER SET instead. The shortcuts will be removed in a future version.

    • A stored function and a loadable function with the same name can share the same namespace. Add the schema name when invoking a stored function in the shared namespace. The server generates a warning when function names collide.

    • InnoDB supports ALTER TABLE ... RENAME COLUMN operations when using ALGORITHM=INSTANT.

    • The limit for innodb_open_files now includes temporary tablespace files. The temporary tablespace files were not counted in the innodb_open_files in previous versions.

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

    Bugs Fixed¶

    • PXC-3923: When the read_only or super_read_only option was set, the ANALYZE TABLE command removed the node from the cluster.

    • PXC-3388: Percona XtraDB Cluster stuck in a DESYNCED state after joiner was killed.

    • PXC-3609: The binary log status variables were updated when the binary log was disabled. Now the status variables are not registered when the binary log is disabled. (Thanks to Stofa Kenida for reporting this issue.)

    • PXC-3848: The cluster node exited when the CURRENT_USER() function was used. (Thanks to Steffen Böhme for reporting this issue.)

    • PXC-3872: A user without system_user privilege was able to drop system users. (Thanks to user jackc for reporting this issue.)

    • PXC-3918: Galera Arbitrator (garbd) could not connect if the Percona XtraDB Cluster server used encrypted connections. The issue persisted even when the proper certificates were specified.

    • PXC-3924: Using TRUNCATE TABLE X and INSERT INTO X options when the foreign keys were disabled and violated caused the HA_ERR_FOUND_DUPP_KEY error on a slave node. (Thanks to Daniel Bartoníček for reporting this issue.)

    • PXC-3062: The wsrep_incoming_addresses status variable did not contain the garbd IP address.

    Useful Links¶

    • The Percona XtraDB Cluster installation instructions

    • The Percona XtraDB Cluster downloads

    • The Percona XtraDB Cluster GitHub location

    • To contribute to the documentation, review the Documentation Contribution Guide

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