diff options
| author | Silvio Rhatto <rhatto@riseup.net> | 2012-08-15 19:20:56 -0300 |
|---|---|---|
| committer | Silvio Rhatto <rhatto@riseup.net> | 2012-08-15 19:20:56 -0300 |
| commit | c1bbd2a6e6cd20b983027ac25dea1316c666737d (patch) | |
| tree | 2dec89889e2980fe69d2ea9cf5ea6354d8694b19 /manifests/subsystems/database.pp | |
| parent | f3edea23f731662f38179b248bb5cb54881fb3ce (diff) | |
| download | puppet-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.pp | 10 |
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": |