v1.0.1
Important pxc-release v1.0 is a major database upgrade from Percona XtraDB Cluster 5.7 to Percona XtraDB Cluster 8.0
Version Bumps
-
Bumped Percona XtraDB Cluster to 8.0.29-21
-
Bumped Percona XtraBackup to 8.0.29-22
New Features
-
The database server default character set and collation have been changed to
the Percona XtraDB Cluster 8.0 default of utf8mb4 and utf8mb4_0900_ai_ci
respectively.The new defaults will only affect newly created databases created after
pxc-release v1.0.1. For more information about the default database character
set and collation see this MySQL documentation:https://dev.mysql.com/doc/refman/8.0/en/charset-server.html
The database server's default character set and collation may be configured
explicitly via the pxc-mysql job's "engine_config.character_set_server" and
"engine_config.collation_server" properties, respectively. -
galera-agent and cluster-health logger users no longer need to be explicitly
specified in the pxc-mysql job's seeded_users property.pxc-mysql will automatically generate these users when the galera-agent or
cluster-health-logger jobs are deployed. This removes the breaking change
from the previous release. -
Percona XtraDB Cluster 5.7 packages are now included in deployments to aid in
upgrades. In the previous release, only the Percona XtraDB Cluster 8.0
package was included on pxc/1.0 VMs. -
Percona XtraDB Cluster 8.0 packages have been renamed from
"/var/vcap/packages/pxc" to "/var/vcap/packages/percona-xtradb-cluster-8.0"
in an effort to distinguish from the percona-xtradb-cluster-5.7 package -
In the previous release, upgrades from pxc-release prior to 1.0 running
Percona XtraDB Cluster 5.7 where the v5.7 instance was not cleanly shutdown
or had crashed would fail.As of pxc-release v1.0.1, the pxc-mysql job will run crash recovery with
Percona XtraDB Cluster 5.7 prior to the upgrade to Percona XtraDB Cluster 8.0 -
The "migrate-to-pxc" utility that previously assisted with migrations from
cf-mysql-release are no longer included in this version of pxc-release
Breaking Changes
-
If you previously relied on /var/vcap/packages/pxc in this release, the
latest Percona XtraDB Cluster binaries are now located under
/var/vcap/packages/percona-xtradb-cluster-8.0/binNote that pxc-release always symlinks /usr/local/bin/mysql to the latest
Percona XtraDB Cluster mysql cli for troubleshooting on the local VM. -
Since v1.0, ubuntu-xenial is no longer supported! Only ubuntu-jammy or ubuntu-bionic stemcells can be used to deploy pxc-release v1.0.1