aboutsummaryrefslogtreecommitdiff
path: root/manifests
diff options
context:
space:
mode:
authorSilvio Rhatto <rhatto@riseup.net>2012-08-15 18:20:53 -0300
committerSilvio Rhatto <rhatto@riseup.net>2012-08-15 18:20:53 -0300
commit8bea60fb10b63d310720d6f5b1566156412242fc (patch)
treef1c33b2737873cb848b799cd6d395d92989921e4 /manifests
parent92c48a507350b90aaa37ce58868e6aeb28ed6b3a (diff)
downloadpuppet-nodo-8bea60fb10b63d310720d6f5b1566156412242fc.tar.gz
puppet-nodo-8bea60fb10b63d310720d6f5b1566156412242fc.tar.bz2
Fixing Out of Resource Problem with MySQL (Errcode: 24)
Diffstat (limited to 'manifests')
-rw-r--r--manifests/subsystems/database.pp9
1 files changed, 9 insertions, 0 deletions
diff --git a/manifests/subsystems/database.pp b/manifests/subsystems/database.pp
index 87e5162..deb905c 100644
--- a/manifests/subsystems/database.pp
+++ b/manifests/subsystems/database.pp
@@ -1,6 +1,15 @@
class database {
include mysql::server
+ # See http://www.smilecouple.org/2011/03/01/fix-out-of-resource-problem-with-mysql
+ file { '/etc/security/limits.d/mysql.conf':
+ ensure => present,
+ owner => root,
+ group => root,
+ mode => 0644,
+ content => "mysql soft nofile 24000\nmysql hard nofile 32000\n",
+ }
+
# Database definitions
define instance($password, $ensure = 'present', $privileges = 'all') {
mysql_database { "$name":