forked from mtusi2026/mtusi2026lab2
107 lines
3.6 KiB
Bash
Executable File
107 lines
3.6 KiB
Bash
Executable File
#!/bin/sh
|
|
set -eu
|
|
|
|
project_root=$(CDPATH= cd -- "$(dirname -- "$0")/.." && pwd)
|
|
cd "$project_root"
|
|
|
|
env_file=${ENV_FILE:-.env}
|
|
run_id="$(date +%s)_$$"
|
|
source_db="track2_source_$run_id"
|
|
restore_db="track2_restore_$run_id"
|
|
recovery_project="mtusi2026lab2_recovery_$run_id"
|
|
temp_dir=$(mktemp -d)
|
|
backup_file="$temp_dir/track2.dump"
|
|
source_fingerprint="$temp_dir/source.fingerprint"
|
|
restore_fingerprint="$temp_dir/restore.fingerprint"
|
|
source_created=0
|
|
|
|
cleanup() {
|
|
status=$?
|
|
trap - EXIT HUP INT TERM
|
|
|
|
docker compose -p "$recovery_project" --env-file "$env_file" \
|
|
--profile recovery down --volumes --remove-orphans >/dev/null 2>&1 || true
|
|
|
|
if [ "$source_created" -eq 1 ]; then
|
|
docker compose --env-file "$env_file" exec -T \
|
|
-e TARGET_DB="$source_db" postgres sh -ec \
|
|
'dropdb --if-exists -U "$POSTGRES_USER" "$TARGET_DB"' \
|
|
>/dev/null 2>&1 || true
|
|
fi
|
|
|
|
rm -f "$backup_file" "$source_fingerprint" "$restore_fingerprint"
|
|
rmdir "$temp_dir" 2>/dev/null || true
|
|
exit "$status"
|
|
}
|
|
trap cleanup EXIT
|
|
trap 'exit 129' HUP
|
|
trap 'exit 130' INT
|
|
trap 'exit 143' TERM
|
|
|
|
source_created=1
|
|
docker compose --env-file "$env_file" exec -T \
|
|
-e TARGET_DB="$source_db" postgres sh -ec \
|
|
'createdb -U "$POSTGRES_USER" "$TARGET_DB"'
|
|
|
|
docker compose --env-file "$env_file" exec -T \
|
|
-e TARGET_DB="$source_db" postgres sh -ec \
|
|
'exec psql -v ON_ERROR_STOP=1 -U "$POSTGRES_USER" -d "$TARGET_DB"' \
|
|
< migrations/000001_initial.up.sql
|
|
|
|
echo "Running isolated 100000-message query/index experiment."
|
|
docker compose --env-file "$env_file" exec -T \
|
|
-e TARGET_DB="$source_db" postgres sh -ec \
|
|
'exec psql -v ON_ERROR_STOP=1 -U "$POSTGRES_USER" -d "$TARGET_DB"' \
|
|
< tests/track2_experiment.sql
|
|
|
|
docker compose --env-file "$env_file" exec -T \
|
|
-e TARGET_DB="$source_db" postgres sh -ec \
|
|
'exec psql -v ON_ERROR_STOP=1 -U "$POSTGRES_USER" -d "$TARGET_DB"' \
|
|
< tests/track2_fingerprint.sql > "$source_fingerprint"
|
|
|
|
backup_started=$(date +%s%N)
|
|
docker compose --env-file "$env_file" exec -T \
|
|
-e TARGET_DB="$source_db" postgres sh -ec \
|
|
'exec pg_dump -U "$POSTGRES_USER" -d "$TARGET_DB" \
|
|
--format=custom --compress=6 --no-owner --no-privileges' \
|
|
> "$backup_file"
|
|
backup_finished=$(date +%s%N)
|
|
|
|
recovery_started=$(date +%s%N)
|
|
docker compose -p "$recovery_project" --env-file "$env_file" --profile recovery \
|
|
up -d --wait postgres-restore
|
|
|
|
docker compose -p "$recovery_project" --env-file "$env_file" \
|
|
--profile recovery exec -T \
|
|
-e TARGET_DB="$restore_db" postgres-restore sh -ec \
|
|
'createdb -U "$POSTGRES_USER" "$TARGET_DB"'
|
|
|
|
docker compose -p "$recovery_project" --env-file "$env_file" \
|
|
--profile recovery exec -T \
|
|
-e TARGET_DB="$restore_db" postgres-restore sh -ec \
|
|
'exec pg_restore --exit-on-error -U "$POSTGRES_USER" -d "$TARGET_DB" \
|
|
--no-owner --no-privileges' \
|
|
< "$backup_file"
|
|
|
|
docker compose -p "$recovery_project" --env-file "$env_file" \
|
|
--profile recovery exec -T \
|
|
-e TARGET_DB="$restore_db" postgres-restore sh -ec \
|
|
'exec psql -v ON_ERROR_STOP=1 -U "$POSTGRES_USER" -d "$TARGET_DB"' \
|
|
< tests/track2_fingerprint.sql > "$restore_fingerprint"
|
|
|
|
cmp -s "$source_fingerprint" "$restore_fingerprint"
|
|
recovery_finished=$(date +%s%N)
|
|
|
|
backup_ms=$(( (backup_finished - backup_started) / 1000000 ))
|
|
recovery_ms=$(( (recovery_finished - recovery_started) / 1000000 ))
|
|
backup_bytes=$(wc -c < "$backup_file" | tr -d ' ')
|
|
|
|
echo "BACKUP_RESTORE_RESULT"
|
|
echo "backup_bytes=$backup_bytes"
|
|
echo "backup_ms=$backup_ms"
|
|
echo "recovery_ms=$recovery_ms"
|
|
echo "fingerprints_match=true"
|
|
echo "source_and_restored_fingerprint:"
|
|
cat "$source_fingerprint"
|
|
echo "PASS: Track 2 query/index and backup-to-separate-storage experiment completed."
|