[stable/2023.1] Tune database values (#1773)
This is an automated cherry-pick of #1744
/assign mnaser
diff --git a/roles/barbican/vars/main.yml b/roles/barbican/vars/main.yml
index 701df96..19677f8 100644
--- a/roles/barbican/vars/main.yml
+++ b/roles/barbican/vars/main.yml
@@ -24,8 +24,10 @@
DEFAULT:
log_config_append: null
database:
- connection_recycle_time: 10
- max_pool_size: 1
+ connection_recycle_time: 600
+ max_overflow: 50
+ max_pool_size: 5
+ pool_timeout: 30
oslo_messaging_notifications:
driver: noop
simple_crypto_plugin:
diff --git a/roles/cinder/vars/main.yml b/roles/cinder/vars/main.yml
index dc9aa4d..4917bd9 100644
--- a/roles/cinder/vars/main.yml
+++ b/roles/cinder/vars/main.yml
@@ -46,8 +46,10 @@
cors:
allowed_origins: "*"
database:
- connection_recycle_time: 10
- max_pool_size: 1
+ connection_recycle_time: 600
+ max_overflow: 50
+ max_pool_size: 5
+ pool_timeout: 30
oslo_messaging_notifications:
driver: noop
manifests:
diff --git a/roles/designate/vars/main.yml b/roles/designate/vars/main.yml
index 5e4e174..b6e14bd 100644
--- a/roles/designate/vars/main.yml
+++ b/roles/designate/vars/main.yml
@@ -19,8 +19,10 @@
conf:
designate:
database:
- connection_recycle_time: 10
- max_pool_size: 1
+ connection_recycle_time: 600
+ max_overflow: 50
+ max_pool_size: 5
+ pool_timeout: 30
service:central:
managed_resource_tenant_id: "{{ _designate_project_info.openstack_projects[0].id }}"
pools: "{{ designate_pools | to_yaml }}"
diff --git a/roles/glance/vars/main.yml b/roles/glance/vars/main.yml
index 37c8c20..4e0ac0f 100644
--- a/roles/glance/vars/main.yml
+++ b/roles/glance/vars/main.yml
@@ -44,8 +44,10 @@
cors:
allowed_origins: "*"
database:
- connection_recycle_time: 10
- max_pool_size: 1
+ connection_recycle_time: 600
+ max_overflow: 50
+ max_pool_size: 5
+ pool_timeout: 30
image_format:
disk_formats: aki,ari,qcow2,raw
oslo_messaging_notifications:
diff --git a/roles/heat/vars/main.yml b/roles/heat/vars/main.yml
index 10202f3..b9f37b0 100644
--- a/roles/heat/vars/main.yml
+++ b/roles/heat/vars/main.yml
@@ -36,8 +36,10 @@
clients_keystone:
endpoint_type: publicURL
database:
- connection_recycle_time: 10
- max_pool_size: 1
+ connection_recycle_time: 600
+ max_overflow: 50
+ max_pool_size: 5
+ pool_timeout: 30
ec2authtoken:
auth_uri: http://keystone-api.openstack.svc.cluster.local:5000
heat_api:
diff --git a/roles/keystone/vars/main.yml b/roles/keystone/vars/main.yml
index f40d858..df86c62 100644
--- a/roles/keystone/vars/main.yml
+++ b/roles/keystone/vars/main.yml
@@ -39,8 +39,10 @@
cors:
allowed_origins: "*"
database:
- connection_recycle_time: 10
- max_pool_size: 1
+ connection_recycle_time: 600
+ max_overflow: 50
+ max_pool_size: 5
+ pool_timeout: 30
openid:
remote_id_attribute: HTTP_OIDC_ISS
federation:
diff --git a/roles/magnum/vars/main.yml b/roles/magnum/vars/main.yml
index cfa67a3..99ef849 100644
--- a/roles/magnum/vars/main.yml
+++ b/roles/magnum/vars/main.yml
@@ -36,8 +36,10 @@
conductor:
workers: 4
database:
- connection_recycle_time: 10
- max_pool_size: 1
+ connection_recycle_time: 600
+ max_overflow: 50
+ max_pool_size: 5
+ pool_timeout: 30
drivers:
verify_ca: false
glance_client:
diff --git a/roles/manila/vars/main.yml b/roles/manila/vars/main.yml
index 40e738f..ce2175d 100644
--- a/roles/manila/vars/main.yml
+++ b/roles/manila/vars/main.yml
@@ -48,8 +48,10 @@
host: manila-share-worker
osapi_share_workers: 4
database:
- connection_recycle_time: 10
- max_pool_size: 1
+ connection_recycle_time: 600
+ max_overflow: 50
+ max_pool_size: 5
+ pool_timeout: 30
generic:
connect_share_server_to_tenant_network: true
limit_ssh_access: true
diff --git a/roles/neutron/vars/main.yml b/roles/neutron/vars/main.yml
index ed551e0..d205166 100644
--- a/roles/neutron/vars/main.yml
+++ b/roles/neutron/vars/main.yml
@@ -37,8 +37,10 @@
cors:
allowed_origin: "*"
database:
- connection_recycle_time: 10
- max_pool_size: 1
+ connection_recycle_time: 600
+ max_overflow: 50
+ max_pool_size: 5
+ pool_timeout: 30
designate:
url: http://designate-api.openstack.svc.cluster.local:9001/v2
auth_url: http://keystone-api.openstack.svc.cluster.local:5000
diff --git a/roles/nova/vars/main.yml b/roles/nova/vars/main.yml
index 42ffe9f..ca4d3e0 100644
--- a/roles/nova/vars/main.yml
+++ b/roles/nova/vars/main.yml
@@ -73,8 +73,10 @@
allowed_origin: "*"
allow_headers: "X-Auth-Token,X-OpenStack-Nova-API-Version"
database:
- connection_recycle_time: 10
- max_pool_size: 1
+ connection_recycle_time: 600
+ max_overflow: 50
+ max_pool_size: 5
+ pool_timeout: 30
filter_scheduler:
available_filters:
type: multistring
diff --git a/roles/octavia/vars/main.yml b/roles/octavia/vars/main.yml
index 5cb3f1d..8423aba 100644
--- a/roles/octavia/vars/main.yml
+++ b/roles/octavia/vars/main.yml
@@ -106,8 +106,10 @@
volume_driver: volume_cinder_driver
workers: 4
database:
- connection_recycle_time: 10
- max_pool_size: 1
+ connection_recycle_time: 600
+ max_overflow: 50
+ max_pool_size: 5
+ pool_timeout: 30
glance:
endpoint_type: internalURL
haproxy_amphora:
diff --git a/roles/placement/vars/main.yml b/roles/placement/vars/main.yml
index 58082d8..ef5e1ef 100644
--- a/roles/placement/vars/main.yml
+++ b/roles/placement/vars/main.yml
@@ -24,9 +24,10 @@
DEFAULT:
log_config_append: null
database:
- connection_recycle_time: 10
- max_pool_size: 1
- max_retries: -1
+ connection_recycle_time: 600
+ max_overflow: 50
+ max_pool_size: 5
+ pool_timeout: 30
oslo_messaging_notifications:
driver: noop
manifests:
diff --git a/roles/staffeln/vars/main.yml b/roles/staffeln/vars/main.yml
index d23c9b1..6e84cde 100644
--- a/roles/staffeln/vars/main.yml
+++ b/roles/staffeln/vars/main.yml
@@ -26,8 +26,10 @@
backup_metadata_key: "{{ staffeln_backup_metadata_key }}"
retention_metadata_key: "{{ staffeln_retention_metadata_key }}"
database:
- connection_recycle_time: 10
- max_pool_size: 1
+ connection_recycle_time: 600
+ max_overflow: 50
+ max_pool_size: 5
+ pool_timeout: 30
manifests:
ingress_api: false
service_ingress_api: false