to correct mysql error.
[joid.git] / ci / config_tpl / juju2 / bundle_tpl / mysql.yaml
1     mysql:
2       charm: "./{{ ubuntu.release }}/percona-cluster"
3       num_units: {{ unit_qty() }}
4 {% if os.service.bindings %}
5       bindings:
6         access: internal-api
7         shared-db: internal-api
8 {% endif %}
9       options:
10 {% if os.ha.mode == 'ha' %}
11         innodb-buffer-pool-size: 1G
12         max-connections: 4000
13 {% else %}
14         innodb-buffer-pool-size: 1G
15         max-connections: 4000
16 {% endif %}
17         #performance-schema: true
18         #source: "deb http://repo.percona.com/apt xenial main"
19         #key: "8507EFA5"
20         root-password: {{ get_password('mysql_root') }}
21         sst-password: {{ get_password('mysql_sst') }}
22         sst-method: rsync
23 {% if os.network.ipv6 %}
24         prefer-ipv6: {{ os.network.ipv6 }}
25 {% endif %}
26 {% if os.ha.mode == 'ha' %}
27         vip: {{ opnfv.vip.mysql }}
28 {% endif %}
29         min-cluster-size: {{ unit_qty() }}
30       to:
31 {% for unit_id in to_select() %}
32         - "lxd:nodes/{{ unit_id }}"
33 {% endfor %}