Trying to setup the right values of mysql for cluster.
[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: 16M
12         max-connections: 200
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 {% if os.network.ipv6 %}
23         prefer-ipv6: {{ os.network.ipv6 }}
24 {% endif %}
25 {% if os.ha.mode == 'ha' %}
26         vip: {{ opnfv.vip.mysql }}
27 {% endif %}
28         min-cluster-size: {{ unit_qty() }}
29       to:
30 {% for unit_id in to_select() %}
31         - "lxd:nodes/{{ unit_id }}"
32 {% endfor %}