#!/bin/sh

source /app/tools/common/lib/.shell_globals

EXEC=1

schema=$1
dd=$(date "+%Y%m%d")
yy=$(date "+%Y")
mm=$(date "+%m")

ldir="/mnt/mysql/backup/mydumper/${dd}/logs"
lfile="${ldir}/${schema}_dumper.log"
pdir="/mnt/mysql/backup/mydumper/${dd}"
odir="${pdir}/${schema}"
host="localhost"

if [[ ${schema} == "RSCOMMON" ]]; then
   host="rpsdb20"
fi

start_time=$(date +%s)

runit "mkdir -p ${ldir}"
runit "mkdir -p ${odir}"

runit "mydumper \
--database ${schema} \
--host ${host} \
--threads 16 \
--regex '^(?!(${schema}\.agg_.*$|${schema}\.zz_.*$))' \
--rows 5000000 \
--events \
--triggers \
--no-locks \
--verbose=3 \
--long-query-guard=10800 \
--logfile=${lfile} \
--outputdir=${odir}"

runit "cd ${pdir}"

runit "echo \"## run this command in the ${schema} directory - to restore from backup\" >${odir}/README.txt"
runit "echo \"myloader --verbose=3 -t 8 -o -d . -s ${schema}\" >>${odir}/README.txt"

tarfile="${schema}_${dd}.tar.gz"
runit "tar --remove-files -cf - ${schema} |pigz --fast --force > ${tarfile}"

runit "aws s3 cp --quiet --storage-class STANDARD_IA ${tarfile} \
s3://royaltyshare-db-backups/mydumper/${yy}/${mm}/${dd}/${tarfile}"

end_time=$(date +%s)
elapsed=$(( end_time - start_time ))

runit "cd /app/tools/admin/bin/bman"

runit "./schema-dumper-commit.pl -s ${schema} -d ${dd} -t ${elapsed}"
 
runit "echo \"Complete $(date) - ${elapsed} secs elapsed \" >>${lfile}"