I am in the process of switching a MySQL table from MyISAM to InnoDB and I do not want the slave to perform the alter table command until I execute it manually. The intention is to have a backup for a few hours in case there is an issue that I have not addressed already. Is there a way to tell the MySQL slave to not process alter table commands from the Master for a period of time?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
If you want to prevent any
What this does is prevent the Master from recording the
If you have multiple tables to convert and not replicate, then you can do this: