backup2s3.rb
2.68 KB
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
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
#
# Author:: Earth U (<sysadmin @ chromedia.com>)
# Cookbook Name:: cfe-mariadb
# Recipe:: backup2s3
#
# Copyright 2016, Chromedia Far East, Inc.
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#
# Sets up the shell script that backs up the databases
# and uploads them to a S3 bucket.
# Also sets up the cron job to regularly run this script.
# Set derived attributes inside recipe
node.default['cfe-mariadb']['backup']['script_dir'] =
::File.join(node['mariadb']['configuration']['path'], 'scripts') unless
node['cfe-mariadb']['backup']['script_dir']
package 'gzip'
include_recipe 'openssl::upgrade'
include_recipe 'awscli'
md = node['cfe-mariadb']
mdb = md['backup']
mdbc = mdb['cron']
mdbl = mdb['logrotate']
directory mdb['script_dir'] do
recursive true
end
pub_key_file = "#{mdb['script_dir']}/pub.key"
file pub_key_file do
content md['encrypt']['pub_key']
mode 0600
owner 'root'
group 'root'
only_if { md['encrypt']['pub_key'] }
end
directory mdb['log_dir'] do
recursive true
end
template "#{mdb['script_dir']}/backup_db_to_s3" do
variables(
:db_map => md['db_map'],
:db_ip => node['mariadb']['mysqld']['bind_address'],
:db_port => node['mariadb']['mysqld']['port'],
:s3_region => md['s3_region'],
:s3_bucket => md['s3_bucket'],
:aws_bin => mdb['aws_bin'],
:mysqldump_bin => mdb['mysqldump_bin'],
:pub_key_file => pub_key_file
)
end
# Chef built-in resource 'cron' seems to have a problem with
# the syntax here. But they suggest using 'cron_d', instead, from
# the cron cookbook (https://docs.chef.io/resource_cron.html).
sched = mdbc['sched'].split(' ')
cron_d 'backup_db_to_s3' do
command "bash #{mdb['script_dir']}/backup_db_to_s3 "\
">> #{mdb['log_dir']}/backup_db_to_s3.log 2>&1"
minute sched[0]
hour sched[1]
day sched[2]
month sched[3]
weekday sched[4]
mailto mdbc['mailto']
path '/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin'
end
package 'logrotate'
template "#{mdbl['conf_dir']}/backup_db_to_s3" do
source 'backup_db_to_s3_logrotate.erb'
only_if "test -d #{mdbl['conf_dir']} || mkdir -p #{mdbl['conf_dir']}"
variables(
:opts => mdbl['options']
)
end