….0. MySQL 5.1 + standard InnoDB / InnoDB-plugin also are supported. It can fully work as drop-in replacement of innodbackup tool and InnoDB Hot Backup… the binaries for xtrabackup-0.3 New version of xtrabackup contains the feature which is missed in InnoDB Hot Backup – the backup can be produced as…
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… drive. The file decompresses in 3.7 seconds which gives 105MB/…. The file compressed in 10.0 seconds (102MB/sec) and was 385MB …
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… Server and copying data, using LVM, Using Innodb Hot Backup Tool, Using another Slave, using backup image etc but in all the cases you…_Behind_Master: 0 1 row in set (0.00 sec) As you can see in this output there are 3 log file names… “internal instructions” for cloning the slave or slave recovery from backup using this value. Infact Master_Log_File will work in…
Post: My "hot" list for next InnoDB features
March 30, 2009 By 18 Comments
Many InnoDB scalability problems seem fixed in InnoDB-plugin-1.0.3 and I expect InnoDB-plugin will run fine on 16-24 cores boxes… soon: Fast recovery. Both recovery after crash and recovery from backup can take unacceptable long time, especially if you crashed with… – copying whole 500GB backup while you need to restore only single 20GB table is very non-productive Open InnoDB tables in parallel…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… master for serving some SELECT queries, taking backups, etc as usual. However, if you…(*) from information_schema.innodb_buffer_pool_content group by 1, 2, 3 into outfile ‘/tmp…30 5.73 1.32 . 3.13 0.94 0.50 site.user_actions 2…will usually have some different hot spot or mixture of hot spots, so it’ll…
