1 heat_template_version: pike
4 MySQL service deployment using puppet
10 DockerMysqlConfigImage:
11 description: The container image to use for the mysql config_volume
15 description: Mapping of service endpoint -> protocol. Typically set
16 via parameter_defaults in the resource registry.
20 description: Dictionary packing service data
24 description: Mapping of service_name -> network name. Typically set
25 via parameter_defaults in the resource registry. This
26 mapping overrides those in ServiceNetMapDefaults.
33 description: Role name on which the service is applied
37 description: Parameters specific to the role
47 default: '/etc/ipa/ca.crt'
49 description: Specifies the default CA cert to use if TLS is used for
50 services in the internal network.
54 internal_tls_enabled: {equals: [{get_param: EnableInternalTLS}, true]}
59 type: ../../../puppet/services/database/mysql.yaml
61 EndpointMap: {get_param: EndpointMap}
62 ServiceData: {get_param: ServiceData}
63 ServiceNetMap: {get_param: ServiceNetMap}
64 DefaultPasswords: {get_param: DefaultPasswords}
65 RoleName: {get_param: RoleName}
66 RoleParameters: {get_param: RoleParameters}
70 description: Containerized service MySQL using composable services.
72 service_name: {get_attr: [MysqlPuppetBase, role_data, service_name]}
75 - {get_attr: [MysqlPuppetBase, role_data, config_settings]}
76 # Set PID file to what kolla mariadb bootstrap script expects
77 - tripleo::profile::base::database::mysql::mysql_server_options:
79 pid-file: /var/lib/mysql/mariadb.pid
81 pid-file: /var/lib/mysql/mariadb.pid
82 logging_source: {get_attr: [MysqlPuppetBase, role_data, logging_source]}
83 logging_groups: {get_attr: [MysqlPuppetBase, role_data, logging_groups]}
84 step_config: &step_config
87 - - "['Mysql_datadir', 'Mysql_user', 'Mysql_database', 'Mysql_grant', 'Mysql_plugin'].each |String $val| { noop_resource($val) }"
88 - {get_attr: [MysqlPuppetBase, role_data, step_config]}
89 # BEGIN DOCKER SETTINGS #
92 puppet_tags: file # set this even though file is the default
93 step_config: *step_config
94 config_image: &mysql_config_image {get_param: DockerMysqlConfigImage}
96 /var/lib/kolla/config_files/mysql.json:
97 command: /usr/bin/mysqld_safe
99 - source: "/var/lib/kolla/config_files/src/*"
102 preserve_properties: true
103 - source: "/var/lib/kolla/config_files/src-tls/*"
106 preserve_properties: true
109 - path: /var/lib/mysql
112 - path: /etc/pki/tls/certs/mysql.crt
115 - path: /etc/pki/tls/private/mysql.key
119 # Kolla_bootstrap runs before permissions set by kolla_config
122 image: &mysql_image {get_param: DockerMysqlImage}
126 - /var/log/containers/mysql:/var/log/mariadb
127 command: ['/bin/bash', '-c', 'chown -R mysql:mysql /var/log/mariadb']
135 # Kolla bootstraps aren't idempotent, explicitly checking if bootstrap was done
142 - - 'if [ -e /var/lib/mysql/mysql ]; then exit 0; fi'
143 - 'echo -e "\n[mysqld]\nwsrep_provider=none" >> /etc/my.cnf'
144 - 'sudo -u mysql -E kolla_start'
145 - 'mysqld_safe --skip-networking --wsrep-on=OFF &'
146 - 'timeout ${DB_MAX_TIMEOUT} /bin/bash -c ''until mysqladmin -uroot -p"${DB_ROOT_PASSWORD}" ping 2>/dev/null; do sleep 1; done'''
147 - 'mysql -uroot -p"${DB_ROOT_PASSWORD}" -e "CREATE USER ''mysql''@''localhost'';"'
148 - 'mysql -uroot -p"${DB_ROOT_PASSWORD}" -e "REVOKE ALL PRIVILEGES, GRANT OPTION FROM ''mysql''@''localhost'';"'
149 - 'timeout ${DB_MAX_TIMEOUT} mysqladmin -uroot -p"${DB_ROOT_PASSWORD}" shutdown'
150 volumes: &mysql_volumes
153 - /var/lib/kolla/config_files/mysql.json:/var/lib/kolla/config_files/config.json
154 - /var/lib/config-data/puppet-generated/mysql/:/var/lib/kolla/config_files/src:ro
155 - /etc/localtime:/etc/localtime:ro
156 - /etc/hosts:/etc/hosts:ro
157 - /var/lib/mysql:/var/lib/mysql
158 - /var/log/containers/mysql:/var/log/mariadb
160 - internal_tls_enabled
164 - - {get_param: InternalTLSCAFile}
165 - {get_param: InternalTLSCAFile}
167 - /etc/pki/tls/certs/mysql.crt:/var/lib/kolla/config_files/src-tls/etc/pki/tls/certs/mysql.crt:ro
168 - /etc/pki/tls/private/mysql.key:/var/lib/kolla/config_files/src-tls/etc/pki/tls/private/mysql.key:ro
171 - KOLLA_CONFIG_STRATEGY=COPY_ALWAYS
172 - KOLLA_BOOTSTRAP=True
173 # NOTE(mandre) skip wsrep cluster status check
174 - KOLLA_KUBERNETES=True
179 - - 'DB_ROOT_PASSWORD'
182 expression: $.data.passwords.where($ != '').first()
185 - {get_param: MysqlRootPassword}
186 - {get_param: [DefaultPasswords, mysql_root_password]}
192 volumes: *mysql_volumes
194 - KOLLA_CONFIG_STRATEGY=COPY_ALWAYS
196 # MySQL database initialization occurs only on single node
198 config_volume: 'mysql_init_tasks'
199 puppet_tags: 'mysql_database,mysql_grant,mysql_user'
200 step_config: 'include ::tripleo::profile::base::database::mysql'
201 config_image: *mysql_config_image
205 - /var/lib/mysql:/var/lib/mysql/:ro
206 - /var/log/containers/mysql:/var/log/mariadb
207 - /var/lib/config-data/mysql/root:/root:ro #provides .my.cnf
209 - internal_tls_enabled
213 - - {get_param: InternalTLSCAFile}
214 - {get_param: InternalTLSCAFile}
216 - /etc/pki/tls/certs/mysql.crt:/var/lib/kolla/config_files/src-tls/etc/pki/tls/certs/mysql.crt:ro
217 - /etc/pki/tls/private/mysql.key:/var/lib/kolla/config_files/src-tls/etc/pki/tls/private/mysql.key:ro
220 get_attr: [MysqlPuppetBase, role_data, metadata_settings]
222 - name: create persistent directories
227 - /var/log/containers/mysql
230 - name: Stop and disable mysql service
232 service: name=mariadb state=stopped enabled=no