1 heat_template_version: pike
4 MySQL service deployment with pacemaker bundle
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.
35 MysqlClustercheckPassword:
40 description: Role name on which the service is applied
44 description: Parameters specific to the role
50 type: ../../containers-common.yaml
53 type: ../../../../puppet/services/pacemaker/database/mysql.yaml
55 EndpointMap: {get_param: EndpointMap}
56 ServiceData: {get_param: ServiceData}
57 ServiceNetMap: {get_param: ServiceNetMap}
58 DefaultPasswords: {get_param: DefaultPasswords}
59 RoleName: {get_param: RoleName}
60 RoleParameters: {get_param: RoleParameters}
64 description: Containerized service MySQL using composable services.
66 service_name: {get_attr: [MysqlPuppetBase, role_data, service_name]}
69 - {get_attr: [MysqlPuppetBase, role_data, config_settings]}
70 - tripleo::profile::pacemaker::database::mysql_bundle::mysql_docker_image: &mysql_image {get_param: DockerMysqlImage}
71 tripleo::profile::pacemaker::database::mysql_bundle::control_port: 3123
72 tripleo.mysql.firewall_rules:
73 '104 mysql galera-bundle':
83 # BEGIN DOCKER SETTINGS #
86 puppet_tags: file # set this even though file is the default
90 - - "['Mysql_datadir', 'Mysql_user', 'Mysql_database', 'Mysql_grant', 'Mysql_plugin'].each |String $val| { noop_resource($val) }"
91 - "exec {'wait-for-settle': command => '/bin/true' }"
92 - "include ::tripleo::profile::pacemaker::database::mysql_bundle"
93 config_image: {get_param: DockerMysqlConfigImage}
95 /var/lib/kolla/config_files/mysql.json:
96 command: /usr/sbin/pacemaker_remoted
98 - dest: /etc/libqb/force-filesystem-sockets
102 - source: "/var/lib/kolla/config_files/src/*"
105 preserve_properties: true
108 mysql_data_ownership:
114 # Kolla does only non-recursive chown
115 command: ['chown', '-R', 'mysql:', '/var/lib/mysql']
117 - /var/lib/mysql:/var/lib/mysql
123 # Kolla bootstraps aren't idempotent, explicitly checking if bootstrap was done
130 - - 'if [ -e /var/lib/mysql/mysql ]; then exit 0; fi'
132 - 'mysqld_safe --skip-networking --wsrep-on=OFF &'
133 - 'timeout ${DB_MAX_TIMEOUT} /bin/bash -c ''until mysqladmin -uroot -p"${DB_ROOT_PASSWORD}" ping 2>/dev/null; do sleep 1; done'''
134 - 'mysql -uroot -p"${DB_ROOT_PASSWORD}" -e "CREATE USER ''clustercheck''@''localhost'' IDENTIFIED BY ''${DB_CLUSTERCHECK_PASSWORD}'';"'
135 - 'mysql -uroot -p"${DB_ROOT_PASSWORD}" -e "GRANT PROCESS ON *.* TO ''clustercheck''@''localhost'' WITH GRANT OPTION;"'
136 - 'timeout ${DB_MAX_TIMEOUT} mysqladmin -uroot -p"${DB_ROOT_PASSWORD}" shutdown'
137 volumes: &mysql_volumes
139 - {get_attr: [ContainersCommon, volumes]}
141 - /var/lib/kolla/config_files/mysql.json:/var/lib/kolla/config_files/config.json
142 - /var/lib/config-data/puppet-generated/mysql/:/var/lib/kolla/config_files/src:ro
143 - /var/lib/mysql:/var/lib/mysql
145 - KOLLA_CONFIG_STRATEGY=COPY_ALWAYS
146 - KOLLA_BOOTSTRAP=True
147 # NOTE(mandre) skip wsrep cluster status check
148 - KOLLA_KUBERNETES=True
153 - - 'DB_CLUSTERCHECK_PASSWORD'
154 - {get_param: MysqlClustercheckPassword}
158 - - 'DB_ROOT_PASSWORD'
161 expression: $.data.passwords.where($ != '').first()
164 - {get_param: MysqlRootPassword}
165 - {get_param: [DefaultPasswords, mysql_root_password]}
179 - - "cp -a /tmp/puppet-etc/* /etc/puppet; echo '{\"step\": 2}' > /etc/puppet/hieradata/docker.json"
180 - "FACTER_uuid=docker puppet apply --tags file,file_line,concat,augeas,TAGS -v -e 'CONFIG'"
182 TAGS: 'pacemaker::resource::bundle,pacemaker::property,pacemaker::resource::ocf,pacemaker::constraint::order,pacemaker::constraint::colocation,galera_ready,mysql_database,mysql_grant,mysql_user'
183 CONFIG: 'include ::tripleo::profile::base::pacemaker;include ::tripleo::profile::pacemaker::database::mysql_bundle'
186 - /etc/hosts:/etc/hosts:ro
187 - /etc/localtime:/etc/localtime:ro
188 - /etc/puppet:/tmp/puppet-etc:ro
189 - /usr/share/openstack-puppet/modules:/usr/share/openstack-puppet/modules:ro
190 - /etc/corosync/corosync.conf:/etc/corosync/corosync.conf:ro
191 - /dev/shm:/dev/shm:rw
192 - /var/lib/mysql:/var/lib/mysql:rw
194 - name: create /var/lib/mysql
199 - name: get bootstrap nodeid
201 command: hiera -c /etc/puppet/hiera.yaml bootstrap_nodeid
202 register: bootstrap_node
203 - name: set is_bootstrap_node fact
205 set_fact: is_bootstrap_node={{bootstrap_node.stdout|lower == ansible_hostname|lower}}
206 - name: Disable the galera cluster resource
211 wait_for_resource: true
212 when: is_bootstrap_node
213 - name: Delete the stopped galera cluster resource.
218 wait_for_resource: true
219 when: is_bootstrap_node
220 - name: Disable mysql service
222 service: name=mariadb enabled=no