Many backup tools including Percona Xtrabackup, MyLVMBackup and others use FLUSH TABLES WITH READ LOCK to temporary make MySQL read only. In …’re just using Innodb tables and you’re not actively changing users, stored procedures etc (which are stored in MyISAM tables anyway) you can…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
…single table). Percona XtraBackup…and running Percona XtraBackup against debug versions of InnoDB. This is only for very advanced users. The new features in Percona XtraBackup…XtraBackup and tools around it: Percona XtraBackup: install, usage, tricks tutorial, Tuesday 10th April Introducing XtraBackup…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… speak about Innodb tables and backup with Xtrabackup or LVM we do not really need it. What we need is MyISAM tables flushed and read only so they can be copied and Innodb tables can be written to but we… to take place. But indeed this might go beyond flush tables with readlock fixes.
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
… problem and would like to recover a single table # xtrabackup_55 –backup –innodb-file-per-table –target-dir=/mnt/mysql/export/ –tables=data # xtrabackup_55 –prepare –export –innodb-file-per-table –target-dir…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
… the innodb_file_per_table directive set in the my.cnf configuration file. I have the backup folder which contains xtrabackup log files, xtrabackup checkpoint file and…
Post: Best kept MySQLDump Secret
March 23, 2012 By 11 Comments
…transaction to get consistent backup for their Innodb tables without making database read only. In …table with modified structure, copy data to that table and when drop original table and rename such temporary table… operation. You can also use Percona Xtrabackup, LVM or other database backup approach…
Comment: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
With xtrabackup, it only has to lock tables that aren’t InnoDB, it has the ability to take backups of InnoDB tables *without* taking locks and without any overhead of block device or filesystem snapshots.
Post: Percona welcomes Drizzle 7.1
April 10, 2012 By Leave a Comment
…XtraBackup included IPv6 data type ZeroMQ plugin Log output to syslog is enabled by default Updated DEB and…and auth_schema JS plugin: execute JavaScript code as a Drizzle function HTTP JSON API (experimental) Some of the Percona InnoDB… plugin, authentication via tables (similar to MySQL), RabbitMQ…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 25, 2012 By 20 Comments
… file and binlog postion information. And if we ensure the following requirements, we can do a hot backup without using FLUSH TABLES WITH… use InnoDB as our engine, no other engines used. 3. get binlog file and binlog postion information from xtrabackup_binlog_pos_innodb file since InnoDB…
Post: Copying InnoDB tables between servers
July 31, 2009 By 10 Comments
…/08/impossible-possible-moving-innodb-tables-between-servers/ is now available in our latest releases of XtraBackup 0.8.1 and XtraDB-6. Now…. To export table you need XtraBackup, and you can just specify table or table by mask: xtrabackup –defaults-file=/etc/my.reg.cnf –backup –tables=tpcc.order…
