615653570aff36b0a906f2fbb5f6538b8e71e2ed
[apex-tripleo-heat-templates.git] / docker / services / database / mysql.yaml
1 heat_template_version: pike
2
3 description: >
4   MySQL service deployment using puppet
5
6 parameters:
7   DockerNamespace:
8     description: namespace
9     default: 'tripleoupstream'
10     type: string
11   DockerMysqlImage:
12     description: image
13     default: 'centos-binary-mariadb:latest'
14     type: string
15   DockerMysqlConfigImage:
16     description: The container image to use for the mysql config_volume
17     default: 'centos-binary-mariadb:latest'
18     type: string
19   EndpointMap:
20     default: {}
21     description: Mapping of service endpoint -> protocol. Typically set
22                  via parameter_defaults in the resource registry.
23     type: json
24   ServiceNetMap:
25     default: {}
26     description: Mapping of service_name -> network name. Typically set
27                  via parameter_defaults in the resource registry.  This
28                  mapping overrides those in ServiceNetMapDefaults.
29     type: json
30   DefaultPasswords:
31     default: {}
32     type: json
33   RoleName:
34     default: ''
35     description: Role name on which the service is applied
36     type: string
37   RoleParameters:
38     default: {}
39     description: Parameters specific to the role
40     type: json
41   MysqlRootPassword:
42     type: string
43     hidden: true
44     default: ''
45
46 resources:
47
48   MysqlPuppetBase:
49     type: ../../../puppet/services/database/mysql.yaml
50     properties:
51       EndpointMap: {get_param: EndpointMap}
52       ServiceNetMap: {get_param: ServiceNetMap}
53       DefaultPasswords: {get_param: DefaultPasswords}
54       RoleName: {get_param: RoleName}
55       RoleParameters: {get_param: RoleParameters}
56
57 outputs:
58   role_data:
59     description: Containerized service MySQL using composable services.
60     value:
61       service_name: {get_attr: [MysqlPuppetBase, role_data, service_name]}
62       config_settings:
63         map_merge:
64           - {get_attr: [MysqlPuppetBase, role_data, config_settings]}
65           # Set PID file to what kolla mariadb bootstrap script expects
66           - tripleo::profile::base::database::mysql::mysql_server_options:
67               mysqld:
68                 pid-file: /var/lib/mysql/mariadb.pid
69               mysqld_safe:
70                 pid-file: /var/lib/mysql/mariadb.pid
71       step_config: &step_config
72         list_join:
73           - "\n"
74           - - "['Mysql_datadir', 'Mysql_user', 'Mysql_database', 'Mysql_grant', 'Mysql_plugin'].each |String $val| { noop_resource($val) }"
75             - {get_attr: [MysqlPuppetBase, role_data, step_config]}
76       # BEGIN DOCKER SETTINGS #
77       puppet_config:
78         config_volume: mysql
79         puppet_tags: file # set this even though file is the default
80         step_config: *step_config
81         config_image: &mysql_config_image
82           list_join:
83             - '/'
84             - [ {get_param: DockerNamespace}, {get_param: DockerMysqlConfigImage} ]
85       kolla_config:
86         /var/lib/kolla/config_files/mysql.json:
87           command: /usr/bin/mysqld_safe
88           config_files:
89             - source: "/var/lib/kolla/config_files/src/*"
90               dest: "/"
91               merge: true
92               preserve_properties: true
93           permissions:
94             - path: /var/lib/mysql
95               owner: mysql:mysql
96               recurse: true
97       docker_config:
98         # Kolla_bootstrap runs before permissions set by kolla_config
99         step_1:
100           mysql_init_logs:
101             image: &mysql_image
102               list_join:
103                 - '/'
104                 - [ {get_param: DockerNamespace}, {get_param: DockerMysqlImage} ]
105             privileged: false
106             user: root
107             volumes:
108               - /var/log/containers/mysql:/var/log/mariadb
109             command: ['/bin/bash', '-c', 'chown -R mysql:mysql /var/log/mariadb']
110         step_2:
111           mysql_bootstrap:
112             detach: false
113             image: *mysql_image
114             net: host
115             # Kolla bootstraps aren't idempotent, explicitly checking if bootstrap was done
116             command: ['bash', '-c', 'test -e /var/lib/mysql/mysql || kolla_start']
117             volumes: &mysql_volumes
118               - /var/lib/kolla/config_files/mysql.json:/var/lib/kolla/config_files/config.json
119               - /var/lib/config-data/puppet-generated/mysql/:/var/lib/kolla/config_files/src:ro
120               - /etc/localtime:/etc/localtime:ro
121               - /etc/hosts:/etc/hosts:ro
122               - /var/lib/mysql:/var/lib/mysql
123               - /var/log/containers/mysql:/var/log/mariadb
124             environment:
125               - KOLLA_CONFIG_STRATEGY=COPY_ALWAYS
126               - KOLLA_BOOTSTRAP=True
127               # NOTE(mandre) skip wsrep cluster status check
128               - KOLLA_KUBERNETES=True
129               -
130                 list_join:
131                   - '='
132                   - - 'DB_ROOT_PASSWORD'
133                     -
134                       yaql:
135                         expression: $.data.passwords.where($ != '').first()
136                         data:
137                           passwords:
138                             - {get_param: MysqlRootPassword}
139                             - {get_param: [DefaultPasswords, mysql_root_password]}
140           mysql:
141             start_order: 2
142             image: *mysql_image
143             restart: always
144             net: host
145             volumes: *mysql_volumes
146             environment:
147               - KOLLA_CONFIG_STRATEGY=COPY_ALWAYS
148       docker_puppet_tasks:
149         # MySQL database initialization occurs only on single node
150         step_2:
151           config_volume: 'mysql_init_tasks'
152           puppet_tags: 'mysql_database,mysql_grant,mysql_user'
153           step_config: 'include ::tripleo::profile::base::database::mysql'
154           config_image: *mysql_config_image
155           volumes:
156             - /var/lib/mysql:/var/lib/mysql/:ro
157             - /var/log/containers/mysql:/var/log/mariadb
158             - /var/lib/config-data/mysql/root:/root:ro #provides .my.cnf
159       host_prep_tasks:
160         - name: create persistent directories
161           file:
162             path: "{{ item }}"
163             state: directory
164           with_items:
165             - /var/log/containers/mysql
166             - /var/lib/mysql
167       upgrade_tasks:
168         - name: Stop and disable mysql service
169           tags: step2
170           service: name=mariadb state=stopped enabled=no