v0.47.0

New Features

• Bumped Go to.1.19.2

v1.0.2

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 Go to.1.19.1

v0.46.0

New Features

• Bumped Go to.1.19.1
• Bumped bundler to latest 2.x

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/bin

  Note 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

v0.45.0

New Features

• Bumped Percona XtraDB Cluster to v5.7.39-31.61

Miscellaneous

• The pxc-mysql job's get-sequence-number script no longer depends on galera-agent

• This release supports lower downtime when upgrading to pxc-release v1.0.0+

  It is recommended to upgrade to pxc/0.45.0+ before upgrading to pxc/1.0.0+ in
  order to reduce downtime. In effect this reduces the time the cluster is
  unavailable by approximately 10 seconds.

  pxc-maint-transition-period has been set to zero seconds so a PXC 5.7 node
  will exit a cluster sooner to allow the proxies to failover to a PXC 8.0
  node.

  The proxy drain script has been simplified and reduces downtime in certain
  corner cases related to the previous implementation of shutdown_delay.

• The pxc-release end-to-end tests have been cleaned up and moved from
  src/specs/integration to src/e2e-tests

v1.0.0

New Features

Some features of this release include:

• HA cluster remains writable during upgrade from 5.7 to 8.0
• Downtime during upgrade from 5.7 to 8.0 reduced when enabling galera-agent TLS. Previous alpha release experienced extended downtime during upgrade.

Breaking Changes

• Only ubuntu-jammy and ubuntu-bionic stemcells are supported. ubuntu-xenial is NOT supported.

• The mechanism for creating users has been updated. It is necessary to add the following to the deployment manifest for the pxc job

  jobs:
  - name: pxc-mysql
   properties:
     seeded_users:
       cluster-health-logger:
         host: localhost
         password: ((cf_mysql_mysql_cluster_health_password))
         role: minimal
       galera-agent:
         host: localhost
         password: ((cf_mysql_mysql_galera_healthcheck_db_password))
         role: minimal
       smoke-tests-user:
         host: any
         password: ((smoke_tests_db_password))
         role: schema-admin
         schema: pxc_release_test_db
  

  This requirement will be lifted in a future patch release.

v1.0.0-alpha.1

New Features

• Bumped Percona XtraDB Cluster to 8.0.27-18
• Bumped Percona Xtrabackup to 8.0.28-21

Provides Percona XtraDB Cluster 8.0. Installing this release will upgrade your cluster from Percona XtraDB Cluster 5.7 to 8.0

Some features of this release include:

• Removed the configuration option to enforce TLS 1.2. The defaults for TLS are now TLSv1.3 and TLSv1.2
• The cluster remains writeable during the upgrade process with minimal downtime.
• Uses the Ubuntu-Jammy stemcell

Breaking Changes

• Only Ubuntu-Jammy is supported. Ubuntu-Xenial and Ubuntu-Bionic are NOT supported.
• The mechanism for creating users has been updated. It is necessary to add the following to the deployment manifest for the pxc job

  jobs:
  - name: pxc-mysql
    properties:
      seeded_users:
        cluster-health-logger:
          host: localhost
          password: ((cf_mysql_mysql_cluster_health_password))
          role: minimal
        galera-agent:
          host: localhost
          password: ((cf_mysql_mysql_galera_healthcheck_db_password))
          role: minimal
        smoke-tests-user:
          host: any
          password: ((smoke_tests_db_password))
          role: schema-admin
          schema: pxc_release_test_db

v0.44.0

New Features

• Bumped Percona XtraDB Cluster to v5.7.38-31.59

• Bumped Go to v1.18.4

• proxy now supports TLS on its endpoints

  See the new ops-file ./operations/proxy-tls.yml

v0.43.0

New Features

• Bumped Percona XtraDB Cluster to v5.7.37-31.57

• Bumped Percona XtraBackup to v2.4.26

• Bumped Go to v1.18.2

• pxc-release now supports ubuntu-jammy stemcells

  Jammy stemcells are currently in beta and the default stemcell used in the sample manifests
  in this repository still defaults to ubuntu-xenial.

  To enable ubuntu-jammy with the default manifests, see the new ops-file ./operations/jammy-stemcell.yml

• galera-agent now supports TLS on its endpoint

  See the new ops-file ./operations/galera-agent-tls.yml

• Fixed: pxc-mysql/mysql.err.log is flooded with "Access denied for user 'cluster-health-logger'@'localhost'" messages

Miscellaneous

• pxc-release no longer uses submodules

  All components are now updated directly under ./src/ in this release repository.

v0.42.0

New Features

• Bumped Percona XtraDB Cluster to 5.7.36-31.55