… works. Until this issue is fixed getting Crash Safe replication with MySQL is not impossible but surely more complicated and has much… do traditional and recommended way with FLUSH TABLES WITH READ LOCK for snapshot creation. This happens when you have large amount of tables or your load pattern…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… to switch back and forth between galera and built-in mysql replication (asynchronous) for a given node, it’s not possible… script called innobackupex, and not xtrabackup itself while holding a lock using FLUSH TABLES WITH READ LOCK. MyISAM support is experimental. Apart from some very special…
Comment: Hacking to make ALTER TABLE online for certain changes
May 22, 2008 By 26 Comments
…, I ran:: (using world.sql) mysql> FLUSH TABLE WITH READ LOCK; mysql> ALTER TABLE City ENGINE=InnoDB; mysql> CREATE TABLE Citytmp LIKE City; mysql> ALTER TABLE Citytmp MODIFY ID INT UNSIGNED NOT…/lib/mysql/world/City.frm mysql> UNLOCK TABLES; I then did it on a customers box that had 2^31 rows in Innodb with…
Comment: Using LVM for MySQL Backup and Replication Setup
August 15, 2008 By 53 Comments
CARP! Wordpress ate my lines that were supposed to have: /data/dev/mysql# mysql << MYSQL > FLUSH TABLES WITH READ LOCK;
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 26, 2012 By 20 Comments
… under FLUSH TABLES WITH READ LOCK (I believe it should work even without that). We are using CentOS 5.x, LVM2, XFS and Oracle MySQL 5… we have been experiencing this with many versions of MySQL. We are now using ‘service mysql stop’ instead of FLUSH TABLES WITH READ LOCK to get reliable snapshots…
Comment: How fast is FLUSH TABLES WITH READ LOCK?
February 24, 2012 By 30 Comments
… post http://www.geeksww.com/tutorials/database_management_systems/mysql/installation/mysql_tablecache_informationschema_and_open_files_limit.php says… to take online backups of MyISAM tables without issuing FLUSH TABLES WITH READ LOCK command and/or setting flush_time (performance killer)? As far as…
Comment: Estimating Undo Space needed for LVM Snapshot
June 10, 2008 By 5 Comments
… versus when its time to look for more table storage) but it definitely allows mysql snapshots to be a lot smaller. I…, so the flush tables w/ read lock doesn’t interfere with any queries or anything) flush tables with read lock; (it loops until slave_open_temp_tables=0) flush logs; show master…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
Even killing FLUSH TABLES WITH READ LOCK won’t resolve the deadlock as of MySQL 5.5 – other queries will still be stuck in ‘Waiting for table flush‘ even after the FLUSH TABLES WITH READ LOCK goes away. 
http://bugs.mysql.com/bug.php?id=44884
Comment: How fast is FLUSH TABLES WITH READ LOCK?
April 25, 2010 By 30 Comments
…. I agree, however, that using FLUSH TABLES WITH READ LOCK for backups is a misnomer. This entire command is a MySQL and MyISAM specific hack. To help the matters a little bit in 5.5 we implement FLUSH TABLES WITH READ LOCK, so that you at least don’t have to wait for all tables for your backups, which…
Comment: 10 things you need to know about backup solutions for MySQL
March 4, 2009 By 23 Comments
… engine!) or does a FLUSH TABLES WITH READ LOCK and copies the files, because whoever wrote the software didn’t read that FLUSH TABLES WITH READ LOCK doesn’t stop InnoDB… test that you have a recoverable backup is to start MySQL on the backup, and let InnoDB’s recovery process run…
