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:
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 settingsql_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. UseSET GLOBAL host_cache_size
= 0 or sethost_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
inWSREP
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
withpassword_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.