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.