Set connect_timeout in mysql

This sets the connect_timeout in mysqld, to work around issues with Heat
losing connection to MySQL in the undercloud under load.

Closes-Bug: #1783995
Change-Id: Ia3799cdaf171892431151e4f2f7d2095081b8242
This commit is contained in:
Thomas Herve 2018-07-26 17:45:32 +02:00
parent 41d04607df
commit 98592c2b07
2 changed files with 7 additions and 0 deletions

View File

@ -240,6 +240,7 @@ tripleo::profile::base::database::mysql::mysql_server_options:
'mysqld':
bind-address: "%{hiera('controller_host')}"
innodb_file_per_table: 'ON'
connect_timeout: 60
mysql::server::restart: true
mysql::server::root_password: {{UNDERCLOUD_DB_PASSWORD}}

View File

@ -0,0 +1,6 @@
---
fixes:
- |
Set the connect_timeout to 60s for mysql connections. This helps fix an
issue where undercloud services lose the mysql connection if it takes more
than 10s to complete (eg under high load).