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