Fix mysql with adding ulimit -n 102400
Bug: After deployment of linux formulas and salt states
/etc/security/limits.conf are not applying, as result connections
to mysql failed with error (pymysql.err.OperationalError)
(1040, u'Too many connections')
Solution: create mysql.overide, where ulimit is set to 102400
Closed-bug: PROD-8427
diff --git a/galera/master.sls b/galera/master.sls
index efde836..07797b6 100644
--- a/galera/master.sls
+++ b/galera/master.sls
@@ -47,8 +47,17 @@
galera_purge_init:
file.absent:
- - name: /etc/init/mysql.conf
- - require:
+ - name: /etc/init.d/mysql
+ - require:
+ - pkg: galera_packages
+
+galera_overide:
+ file.managed:
+ - name: /etc/init/mysql.override
+ - contents: |
+ limit nofile 102400 102400
+ exec /usr/bin/mysqld_safe
+ - require:
- pkg: galera_packages
galera_conf_debian:
diff --git a/galera/slave.sls b/galera/slave.sls
index 5a58186..7d1872e 100644
--- a/galera/slave.sls
+++ b/galera/slave.sls
@@ -47,7 +47,16 @@
galera_purge_init:
file.absent:
- - name: /etc/init/mysql.conf
+ - name: /etc/init.d/mysql
+ - require:
+ - pkg: galera_packages
+
+galera_overide:
+ file.managed:
+ - name: /etc/init/mysql.override
+ - contents: |
+ limit nofile 102400 102400
+ exec /usr/bin/mysqld_safe
- require:
- pkg: galera_packages