From ae2fbce7ac58d2f6bb33b350aee6482fd5a94df7 Mon Sep 17 00:00:00 2001
From: Gabriel Filion <gabster@lelutin.ca>
Date: Thu, 6 Mar 2014 18:38:20 -0500
Subject: Randomize time of execution for optimize script.

By default, time will be between midnight and 7:00 any day of the week.

The values are currently hard-coded. This can have serious I/O
repercussions on a server with multiple VMs that run mysql since they
will all run their optimizations simultaneously.
---
 manifests/server/cron/optimize.pp | 12 ++++++++----
 1 file changed, 8 insertions(+), 4 deletions(-)

(limited to 'manifests/server/cron/optimize.pp')

diff --git a/manifests/server/cron/optimize.pp b/manifests/server/cron/optimize.pp
index d1d0257..5d4fa98 100644
--- a/manifests/server/cron/optimize.pp
+++ b/manifests/server/cron/optimize.pp
@@ -1,5 +1,9 @@
 # optimize mysql databases regurarely
-class mysql::server::cron::optimize {
+class mysql::server::cron::optimize (
+  $optimize_hour,
+  $optimize_minute,
+  $optimize_day
+) {
 
   file { 'mysql_optimize_script':
     path    => '/usr/local/sbin/optimize_mysql_tables.rb',
@@ -12,9 +16,9 @@ class mysql::server::cron::optimize {
   cron { 'mysql_optimize_cron':
     command => '/usr/local/sbin/optimize_mysql_tables.rb',
     user    => 'root',
-    minute  => 40,
-    hour    => 6,
-    weekday => 7,
+    minute  => $optimize_minute,
+    hour    => $optimize_hour,
+    weekday => $optimize_day,
     require => [  Exec['mysql_set_rootpw'],
                   File['mysql_root_cnf'],
                   File['mysql_optimize_script'] ],
-- 
cgit v1.2.3