| 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 |
| Kostiantyn Ovchynnykov | 18e6828 | 2021-01-22 16:22:38 +0200 | [diff] [blame] | 21 | galera_innodb_io_capacity: 500 |
| 22 | galera_innodb_io_capacity_max: 2000 |
| 23 | galera_innodb_flush_neighbors: 1 |
| Petr Michalec | bafff1b | 2018-03-23 12:40:13 +0100 | [diff] [blame] | 24 | galera: |
| 25 | master: |
| 26 | enabled: true |
| 27 | name: ${_param:galera_server_cluster_name} |
| 28 | bind: |
| 29 | address: ${_param:galera_server_bind_address} |
| 30 | port: ${_param:galera_server_bind_port} |
| 31 | maintenance_password: ${_param:galera_server_maintenance_password} |
| 32 | admin: |
| 33 | user: ${_param:galera_server_admin_user} |
| 34 | password: ${_param:galera_server_admin_password} |
| Stanislav Riazanov | 7205cbf | 2018-12-18 14:38:29 +0400 | [diff] [blame] | 35 | sst: |
| 36 | user: ${_param:galera_server_sst_user} |
| 37 | password: ${_param:galera_server_sst_password} |
| Petr Michalec | bafff1b | 2018-03-23 12:40:13 +0100 | [diff] [blame] | 38 | members: |
| 39 | - host: ${_param:single_address} |
| 40 | port: 4567 |
| 41 | max_connections: ${_param:galera_max_connections} |
| 42 | innodb_buffer_pool_size: ${_param:galera_innodb_buffer_pool_size} |
| Vasyl Saienko | c50ffc7 | 2018-11-15 10:58:50 +0000 | [diff] [blame] | 43 | innodb_read_io_threads: ${_param:galera_innodb_read_io_threads} |
| 44 | innodb_write_io_threads: ${_param:galera_innodb_write_io_threads} |
| 45 | wsrep_slave_threads: ${_param:galera_wsrep_slave_threads} |
| 46 | xtrabackup_parallel: ${_param:galera_xtrabackup_parallel} |
| Petr Michalec | bafff1b | 2018-03-23 12:40:13 +0100 | [diff] [blame] | 47 | error_log_enabled: ${_param:galera_error_log_enabled} |
| Michal Kobus | 6a33c42 | 2018-09-28 14:32:57 +0200 | [diff] [blame] | 48 | error_log_path: ${_param:galera_error_log_path} |
| Kostiantyn Ovchynnykov | 18e6828 | 2021-01-22 16:22:38 +0200 | [diff] [blame] | 49 | innodb_io_capacity: ${_param:galera_innodb_io_capacity} |
| 50 | innodb_io_capacity_max: ${_param:galera_innodb_io_capacity_max} |
| 51 | innodb_flush_neighbors: ${_param:galera_innodb_flush_neighbors} |
| Petr Michalec | bafff1b | 2018-03-23 12:40:13 +0100 | [diff] [blame] | 52 | mysql: |
| 53 | server: |
| 54 | users: |
| 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 |