Database backup process

Steps to create an export of the CloudSQL database into Google Storage bucket:

1. Create Google bucket for exports:

gsutil mb -p sourcegraph-dev -l us gs://prod-database-export

2. List SQL instances:

gcloud sql instances list

3. Get service account for SQL instance:

gcloud sql instances describe <instance ID> | grep service

4. Add database instance permission to create objects in the bucket:

gcloud projects add-iam-policy-binding sourcegraph-dev --member=serviceAccount:p323384348006-s6zx3o@gcp-sa-cloud-sql.iam.gserviceaccount.com --role=roles/storage.objectCreator

5. Export the database into the bucket:

gcloud sql export sql --async --offload <instance ID> gs://prod-database-export/<instance ID>-$(date +%s).gz --database=sg

Meaning of the flags:

• --async: return immediately, without waiting for the operation in progress to complete
• --offload: offload an export to a temporary instance. Doing so reduces strain on source instances and allows other operations to be performed while the export is in progress

6. Check status of export, as with async flag, it returns immediately after invoking export command in previous point:

gcloud sql operations list  --instance=<instance ID> --limit=10

Note: Export has to be in status: DONE

7. Verify that the database dump was created:

gsutil ls gs://prod-database-export/

Database restore process

1. Create a CloudSQL database instance either via the terraform module

2. Create user:

gcloud sql users create sgdr --instance=<instance ID> --password=testdr

3. Create database schema:

gcloud sql databases create sgdr --instance=<instance ID>

4. Check available import files:

gsutil ls gs://prod-database-export/

5. Import file from the bucket:

gcloud sql import sql <instance ID> gs://prod-database-export/<backup name>.gz --database=sgdr --user=sgdr

6. Verify all tables are available:

• download SQLProxy
• start SQLProxy:

./cloud_sql_proxy -instances=sourcegraph-dev:us-central1:<instance ID>=tcp:0.0.0.0:5432

• connect to the database in another terminal tab:

psql "host=127.0.0.1 dbname=sgdr user=sgdr" (password: testdr)

• invoke commands in psql client

\c sgdr
\dt

Note: last command should list all available tables in the sgdr database.

Google Secret Manager backup process

Steps to create backup of all existing secrets in Google Secret Manager:

1. List all existing secrets:

SECRETS=$(gcloud secrets list | awk '!/NAME/ {print $1}')

2. Iterate over secrets and make a copy of the latest version of the secret into the files:

for secret_name in $SECRETS; do
  VERSIONS=$(gcloud secrets versions list $secret_name --limit 1 | awk '!/NAME/ {print $1}')
  for secret_version in $VERSIONS; do
    gcloud secrets versions access $secret_version --secret=$secret_name >$secret_name
  done
done

Google Secret Manager restore process

Note: Restore process iterates over files in the folder and creates Google Manager Secrets from them.

Steps to restore Google Secret Manager secrets from files in the current folder:

for secret_name in *; do gcloud secrets create $secret_name --data-file=$secret_name; done

How to install Velero in GKE Kubernetes

Note: original documentation from Velero

1. Set project:

gcloud config set project sourcegraph-dev

2. Create bucket for cluster snapshot:

gsutil mb gs://sg-velero-prod-backup

3. Export project ID:

PROJECT_ID=$(gcloud config get-value project)

4. Create ServiceAccount for Velero:

gcloud iam service-accounts create velero --display-name "Velero service account"

5. Export ServiceAccount email:

SERVICE_ACCOUNT_EMAIL=$(gcloud iam service-accounts list --filter="displayName:Velero service account" --format 'value(email)')

6. Export permissions required for GCP:

ROLE_PERMISSIONS=(
    compute.disks.get
    compute.disks.create
    compute.disks.createSnapshot
    compute.snapshots.get
    compute.snapshots.create
    compute.snapshots.useReadOnly
    compute.snapshots.delete
    compute.zones.get
)

7. Create role for velero.server:

gcloud iam roles create velero.server \
  --project $PROJECT_ID \
  --title "Velero Server" \
  --permissions "$(IFS=","; echo "${ROLE_PERMISSIONS[*]}")"

8. Connect Velero ServiceAccount with Velero server role:

gcloud projects add-iam-policy-binding $PROJECT_ID \
  --member serviceAccount:$SERVICE_ACCOUNT_EMAIL \
  --role projects/$PROJECT_ID/roles/velero.server

9. Add Velero ServiceAccount permissions to the snapshot bucket:

gsutil iam ch serviceAccount:$SERVICE_ACCOUNT_EMAIL:objectAdmin gs://sg-velero-prod-backup

10. Create Velero ServiceAccount keys needed for installation on GKE Kubernetes:

gcloud iam service-accounts keys create credentials-velero --iam-account $SERVICE_ACCOUNT_EMAIL

11. Install Velero on GKE Kubernetes:

velero install \
  --provider gcp \
  --plugins velero/velero-plugin-for-gcp:v1.4.0 \
  --bucket sg-velero-prod-backup \
  --secret-file ./credentials-velero \
  --velero-pod-cpu-limit=1 \
  --velero-pod-cpu-request=1 \
  --velero-pod-mem-limit=512Mi \
  --velero-pod-mem-request=512Mi \
  --pod-annotations "cluster-autoscaler.kubernetes.io/safe-to-evict"="true"

12. To prevent Velero from blocking cluster autoscaling, the pod should be deployed with a QoS of Guaranteed. To achieve this, the initContainer needs to have its resources set as well, which cannot be done with CLI flags, so patch the deployment:

kubectl patch deploy velero -n velero --type json -p='[{"op": "replace", "path": "/spec/template/spec/initContainers/0/resources/requests/memory", "value":"512Mi"},{"op": "replace", "path": "/spec/template/spec/initContainers/0/resources/limits/memory", "value":"512Mi"},{"op": "replace", "path": "/spec/template/spec/initContainers/0/resources/requests/cpu", "value":"1"},{"op": "replace", "path": "/spec/template/spec/initContainers/0/resources/limits/cpu", "value":"1"}]'

Note: installation instructions for Velero cli

GKE Kubernetes backup process

GKE Kubernetes backup process is performed by Velero tool.

velero install \
 --provider gcp \
 --plugins velero/velero-plugin-for-gcp:v1.4.0 \
 --bucket sg-velero-prod-backup \
 --secret-file ./credentials-velero

velero backup create sgdr<timestamp> --snapshot-volumes --wait

velero backup get

gcloud compute snapshots list

velero install \
  --provider gcp \
  --plugins velero/velero-plugin-for-gcp:v1.4.0 \
  --bucket sg-velero-prod-backup \
  --secret-file ./credentials-velero

velero schedule create prod-daily --schedule="0 0 * * *" --snapshot-volumes=true

GKE Kubernetes restore process

Important:

• new GKE Kubernetes cluster was created via terraform
• if Velero is going to restore a snapshot in a DIFFERENT GCP project, all steps from How to install velero in the GKE cluster have to be performed in the new GCP project.

1. Connect to new GKE cluster:

gcloud container clusters get-credentials prod-dr --region us-central1 --project sourcegraph-dev

2. Install Velero on GKE Kubernetes:

velero install \
  --provider gcp \
  --plugins velero/velero-plugin-for-gcp:v1.4.0 \
  --bucket sg-velero-prod-backup \
  --secret-file ./credentials-velero

3. Add backup location to Velero (required if in previous step –bucket is not the same as the bucket used to make snapshot from origin cluster):

velero backup-location create prod-backups --provider gcp --access-mode=ReadOnly --bucket sg-velero-prod-backup

4. Add disks snapshots location:

velero snapshot-location create prod-snapshots --provider gcp

5. Check available backups and choose appropriate:

velero backup get

6. Restore applications into new cluster (this will also create PV disks from GCP snapshots):

velero restore create prod-dr --from-backup sgdr<timestamp> --include-namespaces prod,ingress-nginx --wait

7. Check if restore was successful:

velero restore describe prod-dr

Update nginx ingress controller

Note: if nginx ingress controller was also restored by Velero, please follow the steps to update it.

Fix nginx ingress controller after restore (only if restoring from running cluster):

1. Remove Google LB IP from nginx configuration (cannot use a static IP that is already in use):

kubectl patch svc sg-nginx-ingress-nginx-controller --type=json -p="[{'op': 'remove', 'path': '/spec/loadBalancerIP'}]" -n ingress-nginx

2. Login to original cluster and invoke (cluster roles are not restored by Velero):

kubectl get clusterroles sg-nginx-ingress-nginx -o yaml > cr_backup.yaml && kubectl get clusterrolebinding sg-nginx-ingress-nginx -o yaml > crb_backup.yaml

3. Login to new cluster and invoke:

kubectl apply -f cr_backup.yaml && kubectl apply -f crb_backup.yaml

4. Test Sourcegraph via public IP:

curl -ki https://$(kubectl get services -n ingress-nginx sg-nginx-ingress-nginx-controller --output jsonpath='{.status.loadBalancer.ingress[0].ip}')/search -H "Host: sourcegraph.com"

5. Change CloudFlare to point to the new IP:

preview.sgdev.dev -> kubectl get services -n ingress-nginx sg-nginx-ingress-nginx-controller --output jsonpath='{.status.loadBalancer.ingress[0].ip}'