From 6433cd51b05ba7a2edfbccb38db0e7c996819560 Mon Sep 17 00:00:00 2001 From: Instrumental Date: Mon, 16 Apr 2018 14:28:44 -0500 Subject: Create Cassandra Backup Scripts Issue-ID: AAF-249 Change-Id: I014a925545b9be1171e625dfd751e77350843405 Signed-off-by: Instrumental --- auth/auth-cass/docker/backup/backup.sh | 28 ++++++++++++++++++++++++++++ auth/auth-cass/docker/backup/cbackup.sh | 8 ++++++++ 2 files changed, 36 insertions(+) create mode 100644 auth/auth-cass/docker/backup/backup.sh create mode 100644 auth/auth-cass/docker/backup/cbackup.sh (limited to 'auth/auth-cass') diff --git a/auth/auth-cass/docker/backup/backup.sh b/auth/auth-cass/docker/backup/backup.sh new file mode 100644 index 00000000..db59d16e --- /dev/null +++ b/auth/auth-cass/docker/backup/backup.sh @@ -0,0 +1,28 @@ +# BEGIN Store prev +if [ -e "6day" ]; then + rm -Rf 6day +fi + +PREV=6day +for D in 5day 4day 3day 2day yesterday; do + if [ -e "$D" ]; then + mv "$D" "$PREV" + fi + PREV="$D" +done + +if [ -e "today" ]; then + mv today yesterday + gzip yesterday/* +fi + +# END Store prev +date +docker exec -t aaf_cass bash -c "mkdir -p /opt/app/cass_backup" +docker container cp cbackup.sh aaf_cass:/opt/app/cass_backup/backup.sh +# echo "login as Root, then run \nbash /opt/app/cass_backup/backup.sh" +docker exec -t aaf_cass bash /opt/app/cass_backup/backup.sh +mkdir today +docker container cp aaf_cass:/opt/app/cass_backup/. today + +date diff --git a/auth/auth-cass/docker/backup/cbackup.sh b/auth/auth-cass/docker/backup/cbackup.sh new file mode 100644 index 00000000..9c91d0c6 --- /dev/null +++ b/auth/auth-cass/docker/backup/cbackup.sh @@ -0,0 +1,8 @@ +cd /opt/app/cass_backup +DATA="ns role perm ns_attrib user_role cred cert x509 delegate approval approved future notify artifact health history" +PWD=cassandra +CQLSH="cqlsh -u cassandra -k authz -p $PWD" +for T in $DATA ; do + echo "Creating $T.dat" + $CQLSH -e "COPY authz.$T TO '$T.dat' WITH DELIMITER='|'" +done -- cgit 1.2.3-korg