liuxinwang/backup

TwinDB Backup

TwinDB Backup

TwinDB Backup is a multipurpose tool for backing up MySQL and file system. It can store backup copies on a remote SSH server, Amazon S3 or Google Cloud Storage.

TwinDB Backup accepts a backup copy stream from any of supported sources (MySQL Server, Percona Server, Percona XtraDB Cluster, or file system) and redirects the stream to a series of configurable modifiers.

The modifiers can compress the stream, encrypt it, and save a copy of the stream on the local disk.

Compression options:

• gzip
• bzip2
• lbzip2
• pigz

Encryption options:

• Public/private key encryption

Because TwinDB Backup encrypts the stream itself it ensures transfer encryption as well as encryption at rest.

After the stream passed all modifiers it is sent to one of configured backup destination. It can be:

• Amazon S3 bucket
• Google Cloud Storage bucket
• Any server with SSH demon

TwinDB Backup Architecture

The tool can easily restore the backup copies. Read full documentation on https://twindb-backup.readthedocs.io.

Features

TwinDB Backup key features:

• MySQL full and incremental backups
• Zero seconds Recovery Point Objective (RPO) with MySQL binary log backups
• Percona Xtradb Cluster backups
• Files/directories backups
• Backups verification

• Backups monitoring and alerting:

  • Recovery Time Objective (RTO)
  • Backups heartbeat
  • Backups verification heartbeat

• PCI-DSS compliant:

  • Transfers encryption
  • Encryption at rest

• GDPR compliant:

  • Strictly enforced retention policy

TwinDB Backup storage options:

• Amazon S3
• Google Cloud Storage
• Remote SSH server
• Optional local copy

Other features:

• Retention policy defines how many hourly/daily/weekly/monthly/yearly copies to keep
• Separate retention policy for remote and local backup copies
• Email notifications
• Datadog integration
• cron configuration comes with a package

How do I get set up?

TwinDB Backup is distributed via package repositories.

See installation instruction on https://packagecloud.io/twindb/main/install. Once the repository for your operating system is configured, install the twindb-backup package.

On CentOS and RedHat

# curl -s https://packagecloud.io/install/repositories/twindb/main/script.rpm.sh | sudo bash
# yum install twindb-backup

On Debian and Ubuntu

# curl -s https://packagecloud.io/install/repositories/twindb/main/script.deb.sh | sudo bash
# apt-get install twindb-backup

Configuration

Configuration is stored in /etc/twindb/twindb-backup.cfg. See https://twindb-backup.readthedocs.io/ for more details.

Credits

• This package was created with Cookiecutter and the audreyr/cookiecutter-pypackage project template.
• TwinDB Backup uses Percona Xtrabackup for MySQL backups.
• Contributors (in alphabetical order):
  • Andrew Ernst
  • Arda Beyazoğlu
  • Egor Lyutov
  • fonthead
  • Maksym Kryva
  • Manjot Singh
  • Michael Rikmas
  • Ovais Tariq
  • Pim Widdershoven

TwinDB Backup uses Percona Xtrabackup for MySQL backups.