[stable/zed] Tune database values (#1774)

This is an automated cherry-pick of #1744
/assign mnaser
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 }}"