| 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_server_sst_user: sstuser |
| galera_server_sst_password: ${_param:galera_server_admin_password} |
| galera_max_connections: 20000 |
| galera_innodb_buffer_pool_size: 3138M |
| galera_innodb_read_io_threads: 0 |
| galera_innodb_write_io_threads: 0 |
| galera_wsrep_slave_threads: 0 |
| galera_xtrabackup_parallel: 0 |
| galera_error_log_enabled: true |
| galera_error_log_path: /var/log/mysql/error.log |
| galera_innodb_io_capacity: 500 |
| galera_innodb_io_capacity_max: 2000 |
| galera_innodb_flush_neighbors: 1 |
| galera: |
| master: |
| 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} |
| sst: |
| user: ${_param:galera_server_sst_user} |
| password: ${_param:galera_server_sst_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} |
| innodb_io_capacity: ${_param:galera_innodb_io_capacity} |
| innodb_io_capacity_max: ${_param:galera_innodb_io_capacity_max} |
| innodb_flush_neighbors: ${_param:galera_innodb_flush_neighbors} |
| mysql: |
| server: |
| users: |
| - name: ${_param:galera_server_sst_user} |
| password: ${_param:galera_server_sst_password} |
| host: localhost |
| database: '*.*' |
| grants: |
| - PROCESS |
| - RELOAD |
| - LOCK TABLES |
| - REPLICATION CLIENT |