… (based on gcomm://node1 of node2) through Xtrabackup SST (state snapshot transfer). Node3 subsequently joins the cluster with node1 and node2… also get its benefits like compression, parallel streaming, encryption, compact backups which can be used for SST (Note, the wsrep_sst…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… are just too useful for backups (most apply also for btrfs). Let’s review them. Snapshots ZFS does snapshot, like LVM but… since it is a copy on write filesystem, the snapshots are free, no… have: one snapshot per day for the last 30 days one snapshot per hour for the last 2 days one snapshot per 5min…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… I used: Locate an existing snapshot that contains the schema you are interested in (/tmp/snapshot/2013-06-03_11-30/orig… = 1 (dynamic variable) Prepare the backup using the –export flag: innobackupex –apply-log –export /tmp/snapshot/2013-06-03_11-30 For… the .exp and .ibd files from the snapshot to the new instance: cp /tmp/snapshot/2013-06-03_11-30/orig/*[.exp…
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
… Percona XtraBackup 2.1.2 would hang when performing State Snapshot Transfer. Bug fixed #1182698. Release notes with all the …: Backups that complete quickly and reliably Uninterrupted transaction processing during backups Savings on disk space and network bandwidth Automatic backup verification …
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
… backup impact on server performance may well be). We also assume backup is done on physical level here (cold backup, slave backup, innodb hot backup or snapshot backup) as this is only…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… snapshot based MySQL backups are great ? There are number of reasons: Almost Hot backup In most cases you can perform this type of backup… commercial tools as Innodb Hot Backup are required to perform backup. Are there any downsides ? Need to have snapshot campatibility – this is obvious… and skip binary logs in your backup process. 7) Unmount filesystem umount /mnt/backup 8) Remove snapshot: lvremove -f /dev/Main/dbbackup If…
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
… MySQL Backups. Quite frequently I find LVM installed on the system but no free space left to be used as snapshot undo space, which means LVM is pretty much unusable for backups or required space is very… you better to use your experience – run the backup and see how snapshot growths during the process so you can see how…
Post: Disaster: LVM Performance in Snapshot Mode
February 5, 2009 By 55 Comments
… LVM gives very high penalty when snapshots are enabled (leave along if you try to run backup at this time) and so… run I got approximately 200 ios/sec without LVM snapshot enabled while with snapshot I got: 33.20 Requests/sec executed 46… of this behavior you may consider not starting backups instantly after LVM snapshot is creating but allowing it to settle a bit…
Post: Living with backups
November 6, 2008 By 28 Comments
…: /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… database work so much. ionice -c3 /root/backup-tools/tar … ionice -c2 -n7 /root/backup-tools/tar … Please cosult ionice man page…
Post: Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas
February 24, 2009 By 20 Comments
For long time as main backup solution for MySQL on Linux we have been using LVM snapshots. Performance concerns from performance critical… looking to implement advanced functionality like incremental backup (copy only changes from last backup),table-level backup (copy only specified tables), streaming and…
