Use galera in aio model
In order to ensure mysql is configured with settings
close to production once we need to use galera in AIO
model in single master mode.
As was found during tempest tests runs Mysql DB doesn't
exceed 105 MB and there are no more than
120 concurrent connections to DB. So in order to have some
spare capacity for mysql - max connections are set to 1000
and pool size to 1024MB.
Change-Id: Ifc0189935a89222def3663b8fbbdcdb13d8dd9bf
Related-Prod: PROD-14716
diff --git a/classes/cluster/virtual-mcp11-aio/init.yml b/classes/cluster/virtual-mcp11-aio/init.yml
index 9768e1f..5e2071a 100755
--- a/classes/cluster/virtual-mcp11-aio/init.yml
+++ b/classes/cluster/virtual-mcp11-aio/init.yml
@@ -9,7 +9,6 @@
- system.salt.minion.ca.salt_master
- system.salt.minion.cert.proxy
- system.reclass.storage.salt
-- service.mysql.server.single
- system.mysql.client
- system.memcached.server.single
- system.rabbitmq.server.single
@@ -29,6 +28,7 @@
mysql_admin_user: root
mysql_admin_password: workshop
+ mysql_cluster_role: master
rabbitmq_secret_key: workshop
rabbitmq_admin_password: workshop
loopback_device_size: 20
@@ -69,10 +69,6 @@
proto: static
address: ${_param:openstack_public_neutron_subnet_gateway}
netmask: 255.255.255.0
- mysql:
- server:
- version: '5.6'
- max_connections: 20000
# override on this level
nova:
compute:
@@ -86,6 +82,11 @@
members:
- host: ${_param:single_address}
port: 11211
+ galera:
+ master:
+ members:
+ - host: ${_param:single_address}
+ port: 4567
neutron:
server:
message_queue: