aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-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":