Quick start

Install xtrabackup and qpress on MySQL server

apt-get install qpress

Download gox on our backup server

mv gox_0.1.0_linux-amd64 gox

Create a config file corresponding to the backup/remote task

# Remote MySQL hosthost:mysql.explample.com# Mysql userdbuser:root# Mysql passworddbpassword:# SSH configssh:# SSH useruser:root# Private key for ssh userkey:/home/jdoe/.ssh/id_rsa# Remote path of xtrabsckup binaryxtrabackup:/usr/bin/xtrabackup# The number of threads to use to copy multiple data files concurrently when creating a backupparallel:2# Compressioncompress:# Compress ?active:true# This option specifies the number of worker threads used by xtrabackup for parallel data compressionthreads:2# This option when specified will remove .qp, .xbcrypt and .qp.xbcrypt files after decryption and decompression.remove-original:true# This options creates the xtrabackup_galera_info file which contains the local node state at the time of the backup.galera:false# Storage path for backupbackup-dir:/tmp/# Remove backups older than 'keep'# A duration string is a possibly signed sequence of decimal numbers, each with optional fraction and a unit suffix,# such as "300ms", "-1.5h" or "2h45m". Valid time units are "ns", "us" (or "µs"), "ms", "s", "m", "h".keep:168h

Backup

gox backup --config /path/to/mysql.host.com.yaml

Restore

gox restore --config /path/to/mysql.host.com.yaml --from 2018-01-31--08-32-49

Support this project

Bitcoin

Ethereum