Lower sql_idle_timeout to 180s
HAProxy has default timout 300s so we need to lower it bellow this limit
by default.
Change-Id: I95c1f0f64dba16c086075246944ba8d1d5471ae3
diff --git a/README.rst b/README.rst
index 970ef1d..0ed5ade 100644
--- a/README.rst
+++ b/README.rst
@@ -137,7 +137,8 @@
MySQL uses a default `wait_timeout` of 8 hours, after which it will drop
idle connections. This can result in 'MySQL Gone Away' exceptions. If you
notice this, you can lower `sql_idle_timeout` to ensure that SQLAlchemy
-reconnects before MySQL can drop the connection.
+reconnects before MySQL can drop the connection. If you run MySQL with HAProxy
+you need to consider haproxy client/server timeout parameters.
.. code-block:: yaml
@@ -152,7 +153,7 @@
name: barbican
user: barbican
password: password
- sql_idle_timeout: 1200
+ sql_idle_timeout: 180
Configuring plugins
diff --git a/metadata/service/server/cluster.yml b/metadata/service/server/cluster.yml
index 9ca3660..beeaef5 100644
--- a/metadata/service/server/cluster.yml
+++ b/metadata/service/server/cluster.yml
@@ -23,7 +23,7 @@
name: barbican
user: barbican
password: ${_param:mysql_barbican_password}
- sql_idle_timeout: 1200
+ sql_idle_timeout: 180
identity:
engine: keystone
host: ${_param:cluster_vip_address}
diff --git a/metadata/service/server/single.yml b/metadata/service/server/single.yml
index d5c4cf2..8ba73ca 100644
--- a/metadata/service/server/single.yml
+++ b/metadata/service/server/single.yml
@@ -23,7 +23,7 @@
name: barbican
user: barbican
password: ${_param:mysql_barbican_password}
- sql_idle_timeout: 1200
+ sql_idle_timeout: 180
identity:
engine: keystone
host: ${_param:single_address}