[stable/2024.1] Tune database values (#1771)

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