| Ales Komarek | 72da805 | 2015-04-30 13:57:30 +0200 | [diff] [blame] | 1 | applications: |
| 2 | - galera |
| Simon Pasquier | a9c7114 | 2016-10-25 07:06:35 +0200 | [diff] [blame] | 3 | classes: |
| 4 | - service.galera.support |
| Ales Komarek | 72da805 | 2015-04-30 13:57:30 +0200 | [diff] [blame] | 5 | parameters: |
| 6 | _param: |
| 7 | galera_server_cluster_name: galeracluster |
| 8 | galera_server_bind_address: ${_param:cluster_local_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} |
| Dmitry Kalashnik | d4e5f47 | 2017-08-09 14:28:17 +0400 | [diff] [blame] | 13 | galera_max_connections: 20000 |
| 14 | galera_innodb_buffer_pool_size: 3138M |
| Vasyl Saienko | c50ffc7 | 2018-11-15 10:58:50 +0000 | [diff] [blame] | 15 | galera_innodb_read_io_threads: 0 |
| 16 | galera_innodb_write_io_threads: 0 |
| 17 | galera_wsrep_slave_threads: 0 |
| 18 | galera_xtrabackup_parallel: 0 |
| Michal Kobus | 6a33c42 | 2018-09-28 14:32:57 +0200 | [diff] [blame] | 19 | galera_error_log_enabled: true |
| 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 |
| Ales Komarek | 72da805 | 2015-04-30 13:57:30 +0200 | [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} |
| Ales Komarek | 63b99f4 | 2015-04-30 14:03:45 +0200 | [diff] [blame] | 31 | maintenance_password: ${_param:galera_server_maintenance_password} |
| Ales Komarek | 72da805 | 2015-04-30 13:57:30 +0200 | [diff] [blame] | 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} |
| Ales Komarek | 72da805 | 2015-04-30 13:57:30 +0200 | [diff] [blame] | 38 | members: |
| 39 | - host: ${_param:cluster_node01_address} |
| 40 | port: 4567 |
| 41 | - host: ${_param:cluster_node02_address} |
| 42 | port: 4567 |
| 43 | - host: ${_param:cluster_node03_address} |
| 44 | port: 4567 |
| Dmitry Kalashnik | d4e5f47 | 2017-08-09 14:28:17 +0400 | [diff] [blame] | 45 | max_connections: ${_param:galera_max_connections} |
| 46 | innodb_buffer_pool_size: ${_param:galera_innodb_buffer_pool_size} |
| Vasyl Saienko | c50ffc7 | 2018-11-15 10:58:50 +0000 | [diff] [blame] | 47 | innodb_read_io_threads: ${_param:galera_innodb_read_io_threads} |
| 48 | innodb_write_io_threads: ${_param:galera_innodb_write_io_threads} |
| 49 | wsrep_slave_threads: ${_param:galera_wsrep_slave_threads} |
| 50 | xtrabackup_parallel: ${_param:galera_xtrabackup_parallel} |
| Dennis Dmitriev | 2c57289 | 2018-03-05 23:32:34 +0200 | [diff] [blame] | 51 | error_log_enabled: ${_param:galera_error_log_enabled} |
| Michal Kobus | 6a33c42 | 2018-09-28 14:32:57 +0200 | [diff] [blame] | 52 | error_log_path: ${_param:galera_error_log_path} |
| Kostiantyn Ovchynnykov | 18e6828 | 2021-01-22 16:22:38 +0200 | [diff] [blame] | 53 | innodb_io_capacity: ${_param:galera_innodb_io_capacity} |
| 54 | innodb_io_capacity_max: ${_param:galera_innodb_io_capacity_max} |
| 55 | innodb_flush_neighbors: ${_param:galera_innodb_flush_neighbors} |
| Ales Komarek | b7667f6 | 2015-05-05 15:51:37 +0200 | [diff] [blame] | 56 | mysql: |
| 57 | server: |
| 58 | users: |
| Stanislav Riazanov | 7205cbf | 2018-12-18 14:38:29 +0400 | [diff] [blame] | 59 | - name: ${_param:galera_server_sst_user} |
| 60 | password: ${_param:galera_server_sst_password} |
| 61 | host: localhost |
| 62 | database: '*.*' |
| 63 | grants: |
| 64 | - PROCESS |
| 65 | - RELOAD |
| 66 | - LOCK TABLES |
| 67 | - REPLICATION CLIENT |