I am regularly dumping 10GB DB, which is now too much to restore via regular methods so I decided to try XtraBackup.
I have a DB which is a mix of InnoDB (file-per-table) and MyISAM tables
Looking at the xtrabackup output gave me some doubts:
- It begins with dumping InnoDB tables and logs.
- Then it proceeds to MyISAM tables, and here occurs the “FLUSH TABLES WITH READ LOCK”. Isn’t it too late? Won’t MyISAM tables be newer than already dumped InnoDB ones?
Can you explain me if somehow InnoDB tables are then updated from the transaction log to the position where FLUSH TABLES WITH READ LOCK happened?
Regards, Tomasz Kraus