backup2s3.rb 2.3 KB
#
# 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']

include_recipe 'awscli'

md   = node['cfe-mariadb']
mdb  = md['backup']
mdbc = mdb['cron']
mdbl = mdb['logrotate']

template "#{mdb['script_dir']}/backup_db_to_s3" do
  only_if "test -d #{mdb['script_dir']} || mkdir -p #{mdb['script_dir']}"
  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']
  )
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).
cron_d 'backup_db_to_s3' do
  command "bash #{mdb['script_dir']}/backup_db_to_s3"
  minute  mdbc['min']
  hour    mdbc['hour']
  day     mdbc['day']
  month   mdbc['mon']
  weekday mdbc['wday']
  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