| Petr Michalec | bafff1b | 2018-03-23 12:40:13 +0100 | [diff] [blame] | 1 | applications: |
| 2 | - galera |
| 3 | classes: |
| 4 | - service.galera.support |
| 5 | parameters: |
| 6 | _param: |
| 7 | galera_server_cluster_name: galeracluster |
| 8 | galera_server_bind_address: ${_param:single_address} |
| 9 | galera_server_bind_port: 3306 |
| 10 | galera_server_admin_user: root |
| Stanislav Riazanov | 7205cbf | 2018-12-18 14:38:29 +0400 | [diff] [blame^] | 11 | galera_server_sst_user: sstuser |
| 12 | galera_server_sst_password: ${_param:galera_server_admin_password} |
| Petr Michalec | bafff1b | 2018-03-23 12:40:13 +0100 | [diff] [blame] | 13 | galera_max_connections: 20000 |
| 14 | galera_innodb_buffer_pool_size: 3138M |
| Michal Kobus | 6a33c42 | 2018-09-28 14:32:57 +0200 | [diff] [blame] | 15 | galera_error_log_enabled: true |
| Vasyl Saienko | c50ffc7 | 2018-11-15 10:58:50 +0000 | [diff] [blame] | 16 | galera_innodb_read_io_threads: 0 |
| 17 | galera_innodb_write_io_threads: 0 |
| 18 | galera_wsrep_slave_threads: 0 |
| 19 | galera_xtrabackup_parallel: 0 |
| Michal Kobus | 6a33c42 | 2018-09-28 14:32:57 +0200 | [diff] [blame] | 20 | galera_error_log_path: /var/log/mysql/error.log |
| Petr Michalec | bafff1b | 2018-03-23 12:40:13 +0100 | [diff] [blame] | 21 | galera: |
| 22 | master: |
| 23 | enabled: true |
| 24 | name: ${_param:galera_server_cluster_name} |
| 25 | bind: |
| 26 | address: ${_param:galera_server_bind_address} |
| 27 | port: ${_param:galera_server_bind_port} |
| 28 | maintenance_password: ${_param:galera_server_maintenance_password} |
| 29 | admin: |
| 30 | user: ${_param:galera_server_admin_user} |
| 31 | password: ${_param:galera_server_admin_password} |
| Stanislav Riazanov | 7205cbf | 2018-12-18 14:38:29 +0400 | [diff] [blame^] | 32 | sst: |
| 33 | user: ${_param:galera_server_sst_user} |
| 34 | password: ${_param:galera_server_sst_password} |
| Petr Michalec | bafff1b | 2018-03-23 12:40:13 +0100 | [diff] [blame] | 35 | members: |
| 36 | - host: ${_param:single_address} |
| 37 | port: 4567 |
| 38 | max_connections: ${_param:galera_max_connections} |
| 39 | innodb_buffer_pool_size: ${_param:galera_innodb_buffer_pool_size} |
| Vasyl Saienko | c50ffc7 | 2018-11-15 10:58:50 +0000 | [diff] [blame] | 40 | innodb_read_io_threads: ${_param:galera_innodb_read_io_threads} |
| 41 | innodb_write_io_threads: ${_param:galera_innodb_write_io_threads} |
| 42 | wsrep_slave_threads: ${_param:galera_wsrep_slave_threads} |
| 43 | xtrabackup_parallel: ${_param:galera_xtrabackup_parallel} |
| Petr Michalec | bafff1b | 2018-03-23 12:40:13 +0100 | [diff] [blame] | 44 | error_log_enabled: ${_param:galera_error_log_enabled} |
| Michal Kobus | 6a33c42 | 2018-09-28 14:32:57 +0200 | [diff] [blame] | 45 | error_log_path: ${_param:galera_error_log_path} |
| Petr Michalec | bafff1b | 2018-03-23 12:40:13 +0100 | [diff] [blame] | 46 | mysql: |
| 47 | server: |
| 48 | users: |
| 49 | - name: haproxy |
| 50 | host: localhost |
| 51 | - name: haproxy |
| 52 | host: '%' |
| 53 | - name: haproxy |
| 54 | host: ${_param:single_address} |
| Stanislav Riazanov | 7205cbf | 2018-12-18 14:38:29 +0400 | [diff] [blame^] | 55 | - name: ${_param:galera_server_sst_user} |
| 56 | password: ${_param:galera_server_sst_password} |
| 57 | host: localhost |
| 58 | database: '*.*' |
| 59 | grants: |
| 60 | - PROCESS |
| 61 | - RELOAD |
| 62 | - LOCK TABLES |
| 63 | - REPLICATION CLIENT |