Ansible playbook to install Percona XtraDB MySQL Cluster on Debian/Ubuntu servers
Ansible 2.2
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
If you want to use the recommended sst sync mthod: xtrabackup (because rsync method will lock the writes for the period of sst sync) you have to set these (on all nodes):
wsrep_sst_method: xtrabackup-v2
wsrep_sst_auth: sstuser:sstpassword
where the sstuser has at least the following privileges: ".:PROCESS,RELOAD,LOCK TABLES,REPLICATION CLIENT"
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:
- shakahl.ansible-percona
MIT / BSD
Ansible playbook to install Percona XtraDB MySQL Cluster on Debian/Ubuntu servers
Ansible 2.2
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
If you want to use the recommended sst sync mthod: xtrabackup (because rsync method will lock the writes for the period of sst sync) you have to set these (on all nodes):
wsrep_sst_method: xtrabackup-v2
wsrep_sst_auth: sstuser:sstpassword
where the sstuser has at least the following privileges: ".:PROCESS,RELOAD,LOCK TABLES,REPLICATION CLIENT"
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:
- shakahl.ansible-percona
MIT / BSD