1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
# optimize mysql databases regurarely
class mysql::server::cron::optimize (
$optimize_hour,
$optimize_minute,
$optimize_day,
$ensure = present,
) {
file { 'mysql_optimize_script':
ensure => $ensure,
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':
ensure => $ensure,
command => '/usr/local/sbin/optimize_mysql_tables.rb',
user => 'root',
minute => $optimize_minute,
hour => $optimize_hour,
weekday => $optimize_day,
require => [ Exec['mysql_set_rootpw'],
File['mysql_root_cnf'],
File['mysql_optimize_script'] ],
}
}
|
