aboutsummaryrefslogtreecommitdiff
path: root/modules/pkgs/rdsdump/rdsdump.bash
diff options
context:
space:
mode:
authorIgor Pashev <pashev.igor@gmail.com>2016-09-29 13:51:44 +0300
committerIgor Pashev <pashev.igor@gmail.com>2016-09-29 13:51:44 +0300
commit62f28d30a069135f9c48678507203958adfc334f (patch)
tree7f38af0c8d3f445ee8cc50906a639baec7011127 /modules/pkgs/rdsdump/rdsdump.bash
parent1af9e6589bdd18e6ba7eeabf073aa7d710020cdd (diff)
downloadnixsap-62f28d30a069135f9c48678507203958adfc334f.tar.gz
Moved everything into ./modules
Diffstat (limited to 'modules/pkgs/rdsdump/rdsdump.bash')
-rw-r--r--modules/pkgs/rdsdump/rdsdump.bash70
1 files changed, 70 insertions, 0 deletions
diff --git a/modules/pkgs/rdsdump/rdsdump.bash b/modules/pkgs/rdsdump/rdsdump.bash
new file mode 100644
index 0000000..6b8cbf1
--- /dev/null
+++ b/modules/pkgs/rdsdump/rdsdump.bash
@@ -0,0 +1,70 @@
+#!/usr/bin/env bash
+set -euo pipefail
+
+mysql_args=
+mysqldump_args=
+master_data=0
+while [ $# -gt 0 ]; do
+ case $1 in
+ --host=*|--password=*|--user=*|\
+ --defaults-file=*|--defaults-extra-file=*|\
+ --ssl=*|--ssl-ca=*|--ssl-key=*|--ssl-cert=*|\
+ -h?*|-u?*|-p?*)
+ mysql_args="$mysql_args $1"
+ mysqldump_args="$mysqldump_args $1"
+ shift 1;;
+ --host|--user|\
+ --defaults-file|--defaults-extra-file|\
+ --ssl-ca|--ssl-key|--ssl-cert|\
+ -h|-u)
+ mysql_args="$mysql_args $1 $2"
+ mysqldump_args="$mysqldump_args $1 $2"
+ shift 2;;
+ --master-data=*)
+ master_data=$(echo "$1" | cut -d= -f2)
+ shift;;
+ --master-data)
+ master_data=$2
+ shift 2;;
+ *)
+ mysqldump_args="$mysqldump_args $1"
+ shift;;
+ esac
+done
+
+replica () {
+ mysql $mysql_args "$@"
+}
+
+start_replication () {
+ replica -N -e "CALL mysql.rds_start_replication;" >&2
+}
+
+stop_replication () {
+ replica -N -e "CALL mysql.rds_stop_replication;" >&2
+}
+
+trap 'start_replication' EXIT
+stop_replication
+
+if [ "$master_data" -gt 0 ]; then
+if [ "$master_data" -eq 2 ]; then
+ printf '-- '
+fi
+replica -e 'SHOW SLAVE STATUS\G' | awk -f <(cat - <<- 'AWK'
+ /\<Exec_Master_Log_Pos\>/ { log_pos = $2 };
+ /\<Relay_Master_Log_File\>/ { log_file = $2 };
+ END {
+ printf "CHANGE MASTER TO MASTER_LOG_FILE='%s', MASTER_LOG_POS=%d;\n", log_file, log_pos
+ }
+AWK
+)
+fi
+
+mysqldump $mysqldump_args &
+sleep 30
+
+start_replication
+trap - EXIT
+
+wait