galera-formula/metadata/service/slave/cluster.yml

applications:
- galera
classes:
- service.galera.support
parameters:
  _param:
    galera_server_cluster_name: galeracluster
    galera_server_bind_address: ${_param:cluster_local_address}
    galera_server_bind_port: 3306
    galera_server_admin_user: root
    galera_max_connections: 20000
    galera_innodb_buffer_pool_size: 3138M
    galera_innodb_read_io_threads: 8
    galera_innodb_write_io_threads: 8
    galera_wsrep_slave_threads: 8
    galera_xtrabackup_parallel: 4
    galera_error_log_enabled: true
    galera_error_log_path: /var/log/mysql/error.log
  galera:
    slave:
      enabled: true
      name: ${_param:galera_server_cluster_name}
      bind:
        address: ${_param:galera_server_bind_address}
        port: ${_param:galera_server_bind_port}
      maintenance_password: ${_param:galera_server_maintenance_password}
      admin:
        user: ${_param:galera_server_admin_user}
        password: ${_param:galera_server_admin_password}
      members:
      - host: ${_param:cluster_node01_address}
        port: 4567
      - host: ${_param:cluster_node02_address}
        port: 4567
      - host: ${_param:cluster_node03_address}
        port: 4567
      max_connections: ${_param:galera_max_connections}
      innodb_buffer_pool_size: ${_param:galera_innodb_buffer_pool_size}
      innodb_read_io_threads: ${_param:galera_innodb_read_io_threads}
      innodb_write_io_threads: ${_param:galera_innodb_write_io_threads}
      wsrep_slave_threads: ${_param:galera_wsrep_slave_threads}
      xtrabackup_parallel: ${_param:galera_xtrabackup_parallel}
      error_log_enabled: ${_param:galera_error_log_enabled}
      error_log_path: ${_param:galera_error_log_path}
  mysql:
    server:
      users:
      - name: haproxy
        host: localhost
      - name: haproxy
        host: '%'
      - name: haproxy
        host: ${_param:cluster_local_address}