[re-promo] Ansible role for PXC 8 - now supports EL 9

MySQL & MariaDB Percona XtraDB Cluster 8.x
1

Hi,

I’d like to promote an Ansible I developed for Percona XtraDB Cluster 8 again. I’ve updated it to support EL-9 like systems. It also supports EL-8 like systems, e.g. Alma/Rocky/RHEL/CentOS.

I hope this will ease the installation, configure and management process of this application a lot for system engineers for their environment.

The functionalities of the role are.

  • Secured connection by encrypting mysql traffic
  • Bootstrapping a cluster, includes end2end tests
  • Scaling: add or remove hosts from the cluster with ease !
  • Add an arbitrator with ease
  • Adds a beautiful backup script
  • Automatically calculates the recommended mysql configuration settings, based on resources
  • Logrotation configuration
  • Adding user defined users
  • Adding user defined databases
  • Idempotent and desired state

The role can be found on my GitHub.

2

Hey @kevinr1,
Awesome work! I’d invite you to write a blog on the usage/demo on our Percona Community Blog to maximize exposure!