aboutsummaryrefslogtreecommitdiff
path: root/manifests/subsystems/database.pp
diff options
context:
space:
mode:
authorSilvio Rhatto <rhatto@riseup.net>2012-08-15 19:20:56 -0300
committerSilvio Rhatto <rhatto@riseup.net>2012-08-15 19:20:56 -0300
commitc1bbd2a6e6cd20b983027ac25dea1316c666737d (patch)
tree2dec89889e2980fe69d2ea9cf5ea6354d8694b19 /manifests/subsystems/database.pp
parentf3edea23f731662f38179b248bb5cb54881fb3ce (diff)
downloadpuppet-nodo-c1bbd2a6e6cd20b983027ac25dea1316c666737d.tar.gz
puppet-nodo-c1bbd2a6e6cd20b983027ac25dea1316c666737d.tar.bz2
Fixing Out of Resource Problem with MySQL (Errcode: 24) (2)
Diffstat (limited to 'manifests/subsystems/database.pp')
-rw-r--r--manifests/subsystems/database.pp10
1 files changed, 10 insertions, 0 deletions
diff --git a/manifests/subsystems/database.pp b/manifests/subsystems/database.pp
index 7b5398f..f5ae446 100644
--- a/manifests/subsystems/database.pp
+++ b/manifests/subsystems/database.pp
@@ -10,6 +10,16 @@ class database {
content => "mysql soft nofile 24000\nmysql hard nofile 32000\n",
}
+ # Avoid Errcode: 24
+ file { '/etc/mysql/conf.d/mysqld_open_files_limit.cnf':
+ ensure => present,
+ owner => root,
+ group => root,
+ mode => 0644,
+ content => "[mysqld]\nopen-files-limit = 5000\n",
+ notify => Service['mysql'],
+ }
+
# Database definitions
define instance($password, $ensure = 'present', $privileges = 'all') {
mysql_database { "$name":