metadata/service/master/container.yml

parameters:
  _param:
    galera_server_cluster_name: galeracluster
    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: 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
  kubernetes:
    control:
      configmap:
        galera-master:
          grains:
            os_family: Debian
          pillar:
            galera:
              master:
                enabled: true
                name: ${_param:galera_server_cluster_name}
                bind:
                  address: 0.0.0.0
                  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:mysql_service_host01}
                  port: 4567
                - host: ${_param:mysql_service_host02}
                  port: 4567
                - host: ${_param:mysql_service_host03}
                  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: ${_param:galera_server_sst_user}
                  password: ${_param:galera_server_sst_password}
                  host: localhost
                  database: '*.*'
                  grants:
                    - PROCESS
                    - RELOAD
                    - LOCK TABLES
                    - REPLICATION CLIENT