Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 10 Next »

As we are using kubernetes to host databases, so approach is different to restore database

Refer the following link to take backup of the databases:

Neo4j Restore

  1. copy backup folder from the azure storage account to the pod which you will create with the below manifest, this pod will mount same pv where data is present of neo4j.

apiVersion: apps/v1
kind: Deployment
metadata:
  name: ubuntu-deployment
  labels:
    app: ubuntu
spec:
  replicas: 1
  selector:
    matchLabels:
      app: ubuntu
  template:
    metadata:
      labels:
        app: ubuntu
    spec:
      containers:
      - name: ubuntu
        image: ubuntu
        command: ["sleep", "123456"]
        volumeMounts:
        - mountPath: /data
          name: neo4j-data
      volumes:
      - name: neo4j-data
        persistentVolumeClaim:
          claimName: neo4j-claim

  1. scale neo4j deployment to 0 

    kubectl command

  2. Go inside the pod which you created with the manifest, navigate to /data/databases, rename graph.db to graph.db.backup and paste the graph.db folder at same location. Exit from the pod 

    kubectl command to login
cd /data/databases
mv 
cp

  3. Scale again neo4j pod to 1 which will load the data from the backup data 

    kubectl command to setup replicas to 1

  4. Remove deployment which was created to restore neo4j backup

Elasticsearch Restore

As we took elasticsearch backup with help of azure plugin

Commands to login to the pod

create repository with following command

curl -XPUT 'http://localhost:9200/_snapshot/azurebackup' -H 'Content-Type: application/json' -d '{ "type": "azure", "settings": { "container": "<blob_name>", "base_path": "<storage_account_name>"} }'

restore the snapshot with below command

curl -XPOST 'http://localhost:9200/_snapshot/azurebackup/snapshot_1/_restore'

checking status of the snapshot restore

curl -s "http://localhost:9200/_snapshot/azurebackup/snapshot_1/_status?pretty"

Cassandra Restore

  1. Download restore script from below url

    https://sunbirdstagingpublic.blob.core.windows.net/dbrestorescripts/restore.py

  2. Download backup from storage account and untar the backup

  3. Copy backup folder to pod at location /bitnami/cassandra

    kubectl cp backupfolder sunbird/cassandra-0:/bitnami/cassandra/

  4. Copy restore script also which you have downloaded from the url to the pod and place it to /bitnami/cassandra 

    kubectl cp restore.py sunbird/cassandra-0:/bitnami/cassandra/

  5. Restore schema got to backupfolder eg. /bitnami/cassandra/cassandrabackup, you will find db_schema.cql. Use below command

    cqlsh -f db_schema.cql

  6. Use below command to restore

    python3 restore.py --snapshotdir /bitnami/cassandra/cassandrabackupfolder --datadirectory /bitnami/cassandra/data/data/

  7. Restart the statefulset once operations is done

    kubectl rollout restart statefulsets cassandra -n sunbird

  8. Validate data by using cqlsh

  9. Delete backup folder which you have copied earlier you can delete restore.py script

Redis Restore

1.

Postgres Restore

  • No labels