Ansible playbook to install Percona XtraDB MySQL Cluster on Debian/Ubuntu servers
None.
Available variables are listed below with its default values.
mysql_root_password: reallylongpassword
percona_package: percona-xtradb-cluster-56
Define the MySQL root password, this password will be used to create a /root/.my.cnf to allow root mysql connections without password
mysql_port: 3306
mysql_bind_address: 0.0.0.0
Define port and bind address for MySQL connections
mysql_max_allowed_packet: 16M
mysql_key_buffer: 16M
mysql_thread_stack: 192K
mysql_cache_size: 8
Various other settings are available in defaults/main.yml
If using a cluster define at least wsrep_cluster_name and wsrep_cluster_hosts(a list of hosts) and optionally other settings:
wsrep_slave_threads: 2 wsrep_sst_method: rsync
Additionally one node should be set with percona_master_node to true. This is because a percona cluster must be started with the
bootsrap-pxc command on its first start. The percona_master_node will attempt to start with the bootstrap when its package is
installed and should be the first node in a cluster to run.
These are optional variables that default to undefined
wsrep_node_name wsrep_notify_cmd wsrep_sst_receive_address wsrep_sst_auth
The role can be setup to enable ssl for mysql. SSL for intra cluster communication is not yet implemented, more information on that configuration is available here
If mysql_ssl_key is defined then ssl is enabled and all of the below ssl variables need to be defined.
- mysql_ssl_ca
- mysql_ssl_cert
- mysql_ssl_key
Optionally to copy in the appropriate certs define these variables
- mysql_ssl_ca_src
- mysql_ssl_cert_src
- mysql_ssl_key_src
None.
---
- hosts: all
sudo: true
roles:
- tkuhlman.percona
MIT / BSD