openstack
/
charm-percona-cluster
Code Issues Proposed changes

Increase max_connect_errors for older PXC releases 

Ubuntu 14.04 ships with PXC 5.5, which has a lower default
value for max_connect_errors (10 vs 100); bump this value
inline with later 5.6 release to avoid issues with connections
from clients getting blacklisted due to connection problems.

(NOTE: my.cnf is used on trusty, mysqld.cnf on xenial or later).

Change-Id: I5475c4e1b10cb638d0694c380714c468f8d78d46
Closes-Bug: 1564083
This commit is contained in:
James Page 2017-03-02 12:56:28 +00:00
parent 3bd97a245c
commit 8a6c49f249
1 changed files with 3 additions and 0 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

3
templates/my.cnf
View File

@ -70,6 +70,9 @@ wsrep_sst_auth="sstuser:{{ sst_password }}"
max_connections = {{ max_connections }}
{% endif %}
# Align 5.5. behaviour with later 5.6 releases
max_connect_errors = 100
# Seconds before clearing idle connections
{% if wait_timeout != -1 %}
wait_timeout = {{ wait_timeout }}