From 35613fe0e9de8e8229862c939d3c9fb8890a1db2 Mon Sep 17 00:00:00 2001
From: Silvio Rhatto <rhatto@riseup.net>
Date: Wed, 5 Sep 2012 13:22:48 -0300
Subject: Including mysql backup at database class; adding --single-transaction
 sql dump option to avoid 'out of resources' error

---
 manifests/subsystems/database.pp | 7 +++++++
 1 file changed, 7 insertions(+)

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

diff --git a/manifests/subsystems/database.pp b/manifests/subsystems/database.pp
index d205ad6..17500ff 100644
--- a/manifests/subsystems/database.pp
+++ b/manifests/subsystems/database.pp
@@ -20,6 +20,13 @@ class database {
     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') {
     mysql_database { "$name":
-- 
cgit v1.2.3