I have a mysql database master and slave in production. I want to setup additional mysql slave. There is around 15 Terabyte of data in the database and there are MYISAM and InnoDB tables in the database.
I am thinking of below options:
- Shutdown master database and copy the mysql data folder to secondary slave. Can Innodb tables be copied like this?
- Run flush table with read lock, scp the file to new slave and unlock the table and this is possible for myisam tables, can I do the same for innodb tables too?
Thanks for looking at the question.