From fe1c86b8f938283e9dd8196a8b11a9648f4b49e6 Mon Sep 17 00:00:00 2001
From: Silvio Rhatto <rhatto@riseup.net>
Date: Fri, 12 Apr 2013 17:09:03 -0300
Subject: Major refactor

---
 manifests/subsystems/database.pp | 52 ----------------------------------------
 1 file changed, 52 deletions(-)
 delete mode 100644 manifests/subsystems/database.pp

(limited to 'manifests/subsystems/database.pp')

diff --git a/manifests/subsystems/database.pp b/manifests/subsystems/database.pp
deleted file mode 100644
index beedfa6..0000000
--- a/manifests/subsystems/database.pp
+++ /dev/null
@@ -1,52 +0,0 @@
-class database {
-  class { '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  => absent,
-    owner   => root,
-    group   => root,
-    mode    => 0644,
-    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 = 500000\n",
-    notify  => Service['mysql'],
-  }
-
-  backupninja::mysql { "all_databases":
-    backupdir      => '/var/backups/mysql',
-    compress       => true,
-    sqldump        => true,
-    sqldumpoptions => '--lock-tables --complete-insert --add-drop-table --quick --quote-names --single-transaction',
-  }
-
-  # Database definitions
-  define instance($password, $ensure = 'present', $privileges = "all") {
-    include mysql::server
-
-    mysql_database { "${name}":
-      ensure  => $ensure,
-      require => Service['mysql'],
-    }
-
-    mysql_user { "${name}@%":
-      ensure        => $ensure,
-      password_hash => mysql_password($password),
-      require       => Mysql_database["${name}"],
-    }
-
-    if $ensure == 'present' {
-      mysql_grant { "${name}@%/${name}":
-        privileges => $privileges,
-        require    => Mysql_user["${name}@%"],
-      }
-    }
-  }
-}
-- 
cgit v1.2.3