diff options
| author |   Michael Polenchuk <mpolenchuk@mirantis.com> | 2017-09-14 13:01:34 +0400 |
|---|---|---|
| committer | Michael Polenchuk <mpolenchuk@mirantis.com> | 2017-09-14 14:03:23 +0400 |
| commit | 92c7b08944b804e10b23ac26330149b039361fa4 (patch) | |
| tree | 69a81615f6f698b581f2dfaa8744aa40abf18eb1 | |
| parent | 6d90d3be1fbb7526587a305167e3295bc956d5d4 (diff) | |
Tune up mysql options
Change-Id: Ib4d787c45434243d0dc29d517a73224cf4f9d1c1
Signed-off-by: Michael Polenchuk <mpolenchuk@mirantis.com>
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: |