diff options
author | Silvio Rhatto <rhatto@riseup.net> | 2012-09-05 13:22:48 -0300 |
---|---|---|
committer | Silvio Rhatto <rhatto@riseup.net> | 2012-09-05 13:22:48 -0300 |
commit | 35613fe0e9de8e8229862c939d3c9fb8890a1db2 (patch) | |
tree | 36dd3b9fdf6e92bfe8fb40d45e73448702cbefbf /manifests/subsystems | |
parent | 126e34605a20b8134719e036bef68568bbc102cb (diff) | |
download | puppet-nodo-35613fe0e9de8e8229862c939d3c9fb8890a1db2.tar.gz puppet-nodo-35613fe0e9de8e8229862c939d3c9fb8890a1db2.tar.bz2 |
Including mysql backup at database class; adding --single-transaction sql dump option to avoid 'out of resources' error
Diffstat (limited to 'manifests/subsystems')
-rw-r--r-- | manifests/subsystems/database.pp | 7 |
1 files changed, 7 insertions, 0 deletions
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": |