I have a number of large databases, 350Gb+ each with over 100 tables in each. They are mainly MyISAM tables, with a few InnoDB tables thrown in for good measure.
Platform :- Linux, MySQL 5.1, MyISAM + InnoDB tables (with file_per_table option turned on)
I need to duplicate these database on the master and have the duplication correctly reflected on the slave server, and am running into some issues.
Doing a mysqldump and then a restore is successful, but extremely slow, and takes a long time for the slave to catch up.
Doing a straight disk copy of the data files does not seem to work as the information_schema does not accurately reflect the copied database - in some instances the tables don't even seem to exist in the target database, even though myisamchk is able to check and repair the indexes successfully.
Is there a way of performing the disk copy of the data files and having the information_schema accurately reflect the copied database, or am I just going to have to lump it and persevere with the dump/restore option? And if I can duplicate the databases in this way, can I perform the same steps on the slave without breaking the replication status?
Thanks in advance, Dave