/tidb-cloud-backup

Primary LanguageGo

TiDB cloud backup

Build

uploader

go build -o bin/uploader upload/main.go

downloader

go build -o bin/downloader download/main.go

build image

docker build -t pingcap/tidb-cloud-backup .

Run

Ref here to get google application credentials with cloud storage permission.

And then go to GCP console to create a cloud storage bucket.

ts=$(date +%Y-%m-%dT%H%M%S)

docker run -v $PWD/tidb_backup_${ts}:/backup pingcap/tidb-cloud-backup /mydumper \
    --outputdir=/backup \
    --host=<tidb-host> \
    --port=4000 \
    --user=root \
    --password=<password>

docker run -v $PWD/tidb_backup_${ts}:/tidb_backup_${ts} \
    -v /path/to/google-application-credentials:/gcp-credentials.json
    -e GOOGLE_APPLICATION_CREDENTIALS=/gcp-credentials.json
    pingcap/tidb-cloud-backup uploader \
    --cloud=gcp \
    --bucket=<bucket-name> \
    --backup-dir=/tidb_backup_${ts}

docker run -v /path/to/google-application-credentials:/gcp-credentials.json \
    -v /path/to/destDir:/data \
    -e GOOGLE_APPLICATION_CREDENTIALS=/gcp-credentials.json
    pingcap/tidb-cloud-backup downloader \
    --cloud=gcp \
    --bucket=<bucket-name> \
    --srcDir=<src-dir-in-bucket> \
    --destDir=/data