aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorAlexandru Avadanii <Alexandru.Avadanii@enea.com>2017-09-14 17:27:06 +0000
committerGerrit Code Review <gerrit@opnfv.org>2017-09-14 17:27:06 +0000
commit563d01057dc2d24619843460ca8b89b156a8e87f (patch)
tree1589ecd7b1abb688bb30920ff4655fe87638ad32
parent9facc6fd0f6fc844d10f5f1d75bd02bae0f104d8 (diff)
parent92c7b08944b804e10b23ac26330149b039361fa4 (diff)
Merge "Tune up mysql options"
-rw-r--r--mcp/reclass/classes/cluster/baremetal-mcp-ocata-odl-ha/openstack/database.yml2
-rw-r--r--mcp/reclass/classes/cluster/baremetal-mcp-ocata-ovs-dpdk-ha/openstack/database.yml2
-rw-r--r--mcp/reclass/classes/cluster/baremetal-mcp-ocata-ovs-ha/openstack/database.yml2
-rw-r--r--mcp/reclass/classes/cluster/virtual-mcp-ocata-common/openstack_control.yml7
4 files changed, 13 insertions, 0 deletions
diff --git a/mcp/reclass/classes/cluster/baremetal-mcp-ocata-odl-ha/openstack/database.yml b/mcp/reclass/classes/cluster/baremetal-mcp-ocata-odl-ha/openstack/database.yml
index 6c26d26f1..e61a4699f 100644
--- a/mcp/reclass/classes/cluster/baremetal-mcp-ocata-odl-ha/openstack/database.yml
+++ b/mcp/reclass/classes/cluster/baremetal-mcp-ocata-odl-ha/openstack/database.yml
@@ -19,6 +19,8 @@ parameters:
keepalived_vip_interface: ens3
keepalived_vip_virtual_router_id: 80
galera_server_cluster_name: openstack_cluster
+ galera_max_connections: 3072
+ galera_innodb_buffer_pool_size: 2048M
cluster_vip_address: ${_param:openstack_database_address}
cluster_local_address: ${_param:single_address}
cluster_node01_hostname: dbs01
diff --git a/mcp/reclass/classes/cluster/baremetal-mcp-ocata-ovs-dpdk-ha/openstack/database.yml b/mcp/reclass/classes/cluster/baremetal-mcp-ocata-ovs-dpdk-ha/openstack/database.yml
index d600403e7..b0b462ad8 100644
--- a/mcp/reclass/classes/cluster/baremetal-mcp-ocata-ovs-dpdk-ha/openstack/database.yml
+++ b/mcp/reclass/classes/cluster/baremetal-mcp-ocata-ovs-dpdk-ha/openstack/database.yml
@@ -19,6 +19,8 @@ parameters:
keepalived_vip_interface: ens3
keepalived_vip_virtual_router_id: 80
galera_server_cluster_name: openstack_cluster
+ galera_max_connections: 3072
+ galera_innodb_buffer_pool_size: 2048M
cluster_vip_address: ${_param:openstack_database_address}
cluster_local_address: ${_param:single_address}
cluster_node01_hostname: dbs01
diff --git a/mcp/reclass/classes/cluster/baremetal-mcp-ocata-ovs-ha/openstack/database.yml b/mcp/reclass/classes/cluster/baremetal-mcp-ocata-ovs-ha/openstack/database.yml
index dabda49dc..4cb7397f2 100644
--- a/mcp/reclass/classes/cluster/baremetal-mcp-ocata-ovs-ha/openstack/database.yml
+++ b/mcp/reclass/classes/cluster/baremetal-mcp-ocata-ovs-ha/openstack/database.yml
@@ -19,6 +19,8 @@ parameters:
keepalived_vip_interface: ens3
keepalived_vip_virtual_router_id: 80
galera_server_cluster_name: openstack_cluster
+ galera_max_connections: 3072
+ galera_innodb_buffer_pool_size: 2048M
cluster_vip_address: ${_param:openstack_database_address}
cluster_local_address: ${_param:single_address}
cluster_node01_hostname: dbs01
diff --git a/mcp/reclass/classes/cluster/virtual-mcp-ocata-common/openstack_control.yml b/mcp/reclass/classes/cluster/virtual-mcp-ocata-common/openstack_control.yml
index 64e6f4d00..6ac8f6d62 100644
--- a/mcp/reclass/classes/cluster/virtual-mcp-ocata-common/openstack_control.yml
+++ b/mcp/reclass/classes/cluster/virtual-mcp-ocata-common/openstack_control.yml
@@ -107,6 +107,13 @@ parameters:
version: '5.7'
bind:
address: ${_param:cluster_local_address}
+ key_buffer: 8
+ max_allowed_packet: 128
+ max_connections: 2048
+ thread_stack: 512
+ thread_cache_size: 12
+ query_cache_limit: 2
+ query_cache_size: 0
mongodb:
server:
bind: