…for this, but can quite slow on larger schemas. One of the downsides to mysqldump is the need to scan the full tables…, you have a consistent binary backup at a…TABLE `’, table_name, ‘` IMPORT TABLESPACE;’) AS _ddl FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB‘; EOF For…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… blog post. Mydumper for logical backups Strong Points: Very fast for logical backups – compared to mysqldump Consistent backups between myisam and innodb tables. Global read lock only held until myisam tables are dumped. We…
Post: Best kept MySQLDump Secret
March 23, 2012 By 13 Comments
Many people use mysqldump –single-transaction to get consistent backup for their Innodb tables without making database read only. In most cases it works, … know the potential cause for it. What are potential solutions for this problem ? you can use mysqldump –lock-all-tables instead which does not…
Comment: How much space does empty Innodb table take ?
April 30, 2009 By 7 Comments
…Innodb tables and finding that the mix of federated and innodb makes any attempt at reporting on innodb…consistently and completely broken. I’ve tried to dump the entire set of databases with triggers and functions (-R) to search for…
Post: 10 things you need to know about backup solutions for MySQL
March 3, 2009 By 23 Comments
…pollution, etc? What technique is used for the backup? Is it mysqldump or a custom product that… up InnoDB by simply copying its files? Does the backup use FLUSH TABLES, LOCK TABLES, or FLUSH TABLES…? How does the system guarantee consistency with the binary log, InnoDB logs, and replication? Can you …
Comment: An argument for not using mysqldump
November 8, 2010 By 26 Comments
…just running innodb, you can run mysqldump with the –singletransaction flag which will get you a consistent logical backup….way to get a “hot” consistent dump. You can issue flush tables with read lock, but to do… You’re locked up for flush time + snap time. If you’re pure innodb, I generally trust …
Comment: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
…only three ways to get a consistent backup of myisam suitable for a replication seed. Maybe one of… use mysqldump with the lock all tables option (this is an outage) 3) if you’re using LVM, FLUSH TABLES…a large number of myisam tables that we’re seriously considering moving to innodb; myisam has a lot…
Comment: Test Drive of Solid
September 29, 2006 By 5 Comments
… Innodb sense not in ANSI Sense. This Will look like double bug to most MySQL/Innodb users. Most applications written for MySQL/Innodb rely… MySQL tools rely on it. Ie mysqldump –single-transaction is used to dump transactional tables in consistent snapshot using repeatable-read isolation. This…
