summaryrefslogtreecommitdiffstats
path: root/auth/auth-cass/docker/backup
diff options
context:
space:
mode:
authorInstrumental <jcgmisc@stl.gathman.org>2018-04-16 14:28:44 -0500
committerInstrumental <jcgmisc@stl.gathman.org>2018-04-16 14:28:56 -0500
commit6433cd51b05ba7a2edfbccb38db0e7c996819560 (patch)
treef41be9499c4dddd25bc71530671f28cc05a1ab6f /auth/auth-cass/docker/backup
parented39a027a78a0ca08230b1d34c5dac5421819018 (diff)
Create Cassandra Backup Scripts
Issue-ID: AAF-249 Change-Id: I014a925545b9be1171e625dfd751e77350843405 Signed-off-by: Instrumental <jcgmisc@stl.gathman.org>
Diffstat (limited to 'auth/auth-cass/docker/backup')
-rw-r--r--auth/auth-cass/docker/backup/backup.sh28
-rw-r--r--auth/auth-cass/docker/backup/cbackup.sh8
2 files changed, 36 insertions, 0 deletions
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