… to run an incremental on top of a compressed full backup (or a compressed incremental) is to extract the xtrabackup_checkpoints…/977652 This combined with the inability to create streamed tar backups has made 2.0.0 a fairly painful experience for…
Post: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 9 Comments
… you start all nodes from the same sources (i.e. backup) Ability to pass list of IP addresses for a new…
Comment: ext4 vs xfs on SSD
May 8, 2012 By 23 Comments
quick question – the xfs_freeze feature is really killer when one wants to do consistent snapshots/backup of database directories, etc. Is there anything similar in ext4 or is the benchmark of ext4 +lvm (which I know allows this) on par with xfs_freeze (without lvm) ?
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… the –galera-info option to innobackupex. XtraBackup now supports compressed backups. These backups can be done in a parallel way, thus utilizing… now supports streaming incremental backups. In previous versions streaming backups were performed by the innobackupex script but incremental backups were done by the…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… mimic that of the master. Streaming incremental backups. It is now possible to stream incremental backups, lifting a limitation from previous versions… XtraBackup can now use multiple CPUs to perform a compressed backup, significantly reducing the amount of time needed. Parallel compression (‘–compress…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… run away select can effectively cause downtime if you use backup solution which does FLUSH TABLES WITH READ LOCK which is… TABLES WITH READ LOCK and fail backup or kill long running SELECT queries to let backup to proceed, but resolving server gridlock… when backing up data from the slave with –safe-slave-backup option, as preventing writes to the slave can be done…
Post: Best kept MySQLDump Secret
March 23, 2012 By 11 Comments
Many people use mysqldump –single-transaction to get consistent backup for their Innodb tables without making database read only. In … cases when you can get table entirely missing from the backup if you use this technique ? The problem comes from the… you get some empty tables in your mysqldump –single-transaction backups you will know the potential cause for it. What are…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
LVM snapshots is one powerful way of taking a consistent backup of your MySQL databases – but did you know that you… snapshots can affect performance, this is not really an advisable backup solution. If your server somehow blew up in flames, hardware… this is still a valid backup method of course on top of your regularly tested (offsite) backups. Another ideal use case for…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 25, 2012 By 20 Comments
Hi, Peter These days, i have discussed the hot backup problems with my friends, for percona xtrabackup, i think there … we ensure the following requirements, we can do a hot backup without using FLUSH TABLES WITH READ LOCK: 1. do not do any ddl operations in the progress of hot backup, frm files are consistent. 2. we only use InnoDB as…
Comment: Percona XtraDB Cluster Feature 1: High Availability
March 9, 2012 By 18 Comments
Hi, We are using percona mysql server and percona xtrabackup for backup.Let me know how to tack full backup without using the lock file and backup‘s are in .sql format.Can you please help me on this.
