From ba321657e0e724082df206857f80ca08c4d999dc Mon Sep 17 00:00:00 2001
From: Evgeny Zinoviev <me@ch1p.io>
Date: Sun, 11 Jun 2023 04:29:14 +0300
Subject: misc/scripts: reorganize files

---
 .../usr/local/bin/clickhouse_backup.sh             | 31 ++++++++++++++++++++++
 .../usr/local/bin/remove_old_recordings.sh         |  5 ++++
 2 files changed, 36 insertions(+)
 create mode 100755 misc/remote_server/usr/local/bin/clickhouse_backup.sh
 create mode 100755 misc/remote_server/usr/local/bin/remove_old_recordings.sh

(limited to 'misc/remote_server/usr/local')

diff --git a/misc/remote_server/usr/local/bin/clickhouse_backup.sh b/misc/remote_server/usr/local/bin/clickhouse_backup.sh
new file mode 100755
index 0000000..6e938e4
--- /dev/null
+++ b/misc/remote_server/usr/local/bin/clickhouse_backup.sh
@@ -0,0 +1,31 @@
+#!/bin/bash
+
+DIR=/var/lib/clickhouse/backup
+MAX_COUNT=3
+NAME=backup_$(date -u +%Y-%m-%d)
+
+create() {
+	local name="$1"
+	clickhouse-backup create "$name"
+}
+
+del() {
+	local name="$1"
+	clickhouse-backup delete local "$name"
+}
+
+# create a backup
+create "$NAME"
+
+# compress backup
+cd "$DIR"
+tar czvf $NAME.tar.gz $NAME
+
+# delete uncompressed files
+del "$NAME"
+
+# delete old backups
+for file in $(ls -t "${DIR}" | tail -n +$(( MAX_COUNT+1 ))); do
+	echo "removing $file..."
+	rm "$file"
+done
\ No newline at end of file
diff --git a/misc/remote_server/usr/local/bin/remove_old_recordings.sh b/misc/remote_server/usr/local/bin/remove_old_recordings.sh
new file mode 100755
index 0000000..d376572
--- /dev/null
+++ b/misc/remote_server/usr/local/bin/remove_old_recordings.sh
@@ -0,0 +1,5 @@
+#!/bin/bash
+
+# to be launched by cron on remote server
+
+find /var/recordings -type f -mtime +14 -delete
-- 
cgit v1.2.3