We were using replication to deal with certain queries that were producing table scans. I realize this is not a great long term solution but we were migrating a web site that was set up this way, so it wasn’t really a choice. We had a database that was a mix of InnoDB and a few MyISAM tables. The MyISAM tables were used for fulltext searches. To get a database dump, we were using the command mysqldump --all-databases --single-transaction --master-data=1 > dumpfile.