… bandwidth Automatic backup verification Higher uptime due to faster restore time XtraBackup makes MySQL hot backups for all versions of Percona Server, MySQL, MariaDB, and Drizzle. It performs streaming, compressed, and incremental MySQL backups. Percona’s enterprise-grade commercial MySQL…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… the backups. The write load is not excessive so a single server can easily handle the write load of all the MySQL… data that doesn’t compress well showed a compression ration of 1.70 with gzip-1. Real data will compress much more. That… solution for MySQL backup servers. All backup solutions have an impact on performance with ZFS the impact is up front and the backups are…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… NIC ports should be bonded with active-backup or LACP (depending on your switching infrastructure). … slaves. You can also use the slave_compressed_protocol option in /etc/my.cnf if… file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db …
Post: Why use encrypted backup with Percona XtraBackup 2.1 for MySQL?
April 10, 2013 By 2 Comments
… of Percona XtraBackup 2.1 for MySQL and with it we included the ability to encrypt backups on the fly (full documentation…). You can also combine compression and encryption, each using multiple CPU cores. One advantage of encrypting your backups is it means you… are using cloud storage to store your backups but also applies to simple off-site backups. Percona XtraBackup 2.1.0-alpha1…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… to stream incremental backups, lifting a limitation from previous versions where it was only possible to stream full backups. Parallel compression Percona XtraBackup can now use multiple CPUs to perform a compressed backup, significantly reducing the amount of time needed. Parallel compression (‘–compress…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… information while performing a backup when given the –galera-info option to innobackupex. XtraBackup now supports compressed backups. These backups can be done in… be part of the topics at the upcoming Percona Live MySQL Conference and Expo (register now!). Specifically, there are the following…
Post: Announcing Percona XtraBackup 2.0.1
June 25, 2012 By 1 Comment
… full compressed backup, performing a compressed/uncompressed incremental backup would fail because xtrabackup_checkpoints was compressed. This has been fixed by omitting xtrabackup_checkpoints from compression, so that a full backup could be used for incremental backups without decompression. Bug fixed #977652 (Alexey Kopytov). Streaming backups with…
Post: Thoughs on Innodb Incremental Backups
November 10, 2008 By 8 Comments
… it only changes couple of percents per day. The solution MySQL offers – using binary log works in theory but it is… tool could both update the backup and store the rollback changes or if dealing with read-only compressed backup create the roll-forward recovery log, which also can be easily compressed. What tool would need…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… based MySQL backups are great ? There are number of reasons: Almost Hot backup In most cases you can perform this type of backup while…. Easy to Integrate Do you want to compress backup ? Backup it to tape, FTP or any network backup software – it is easy as you… to do to perform backup of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES…
Post: Living with backups
November 6, 2008 By 28 Comments
… compressed archive. For example: /root/backup-tools/tar –read-rate=15000000 -C /mnt/snapshot -c -z -v -f – mysql | ssh backup@storage-host /root/backup-tools/write_backup.sh This will read /mnt/snapshot/mysql directory at 15000000 bytes…
