manifests/server/cron/optimize.pp


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

# optimize mysql databases regurarely
class mysql::server::cron::optimize {

  file { 'mysql_optimize_script':
    path    => '/usr/local/sbin/optimize_mysql_tables.rb',
    source  => 'puppet:///modules/mysql/scripts/optimize_tables.rb',
    owner   => root,
    group   => 0,
    mode    => '0700';
  }

  cron { 'mysql_optimize_cron':
    command => '/usr/local/sbin/optimize_mysql_tables.rb',
    user    => 'root',
    minute  => 40,
    hour    => 6,
    weekday => 7,
    require => [  Exec['mysql_set_rootpw'],
                  File['mysql_root_cnf'],
                  File['mysql_optimize_script'] ],
  }
}