Percona is glad to announce the release of Percona XtraBackup 2.4.14 on May 1, 2019. You can download it from our download site and apt and yum repositories.
Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source solution, it drives down backup costs while providing unique features for MySQL backups.
Percona XtraBackup 2.4.14 enables saving backups to an Amazon S3, MinIO, and Google Cloud Storage (using interoperability mode) when using xbcloud. The following example demonstrates how to use an Amazon S3 storage to make a full backup:
1 2 3 4 5 6 7 8 | $ xtrabackup --backup --stream=xbstream --extra-lsndir=/tmp --target-dir=/tmp | \ xbcloud put --storage=s3 \ --s3-endpoint='s3.amazonaws.com' \ --s3-access-key='YOUR-ACCESSKEYID' \ --s3-secret-key='YOUR-SECRETACCESSKEY' \ --s3-bucket='mysql_backups' --parallel=10 \ ${date -I}-full_backup |
All Percona software is open-source and free.
New Features
- Amazon S3 is now supported in xbcloud. More information in PXB-1813.
Bugs Fixed
- When the row format was changed during the backup, xtrabackup could crash
during the incremental prepare stage. Bug fixed PXB-1824. - If compressed InnoDB undo tablespaces were not removed beforehand, the
incremental backup could crash at the prepare stage. Bug fixed PXB-1552.
Other bugs fixed: PXB-1771, PXB-1809, PXB-1837.
Release notes with all the improvements for version 2.4.14 are available in our online documentation. Please report any bugs to the issue tracker.
The xtrabackup will only work on-prem, right ? There are no solutions for backup in aws ?
Percona Xtrabackup will work in the cloud if you deploy MySQL or Percona Server yourself, It will not work in DBaaS environment as it does not have physical access to the data.
You can also restore backups made with Percona Xtrabackup to Amazon RDS as described here
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.html
The page with installation instructions are not working anymore:
$docker run -it mysql:5.7 bash
$cat /etc/os-release | grep VERSION
VERSION=”9 (stretch)”
$apt-get update
$apt-get install wget lsb-release
$wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb
$dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb
$apt-get update
$apt-get install percona-xtrabackup-24
Reading package lists… Done
Building dependency tree
Reading state information… Done
E: Unable to locate package percona-xtrabackup-24
Update the docker images?
Would you please add support for IAM roles in xbcloud?