The effect of temporary tables on MySQL's replication

The other day I needed to set up a new set of MySQL instances at work what would replicate from an existing node. I was setting these up because the master node is running out of disk space and is very slow. Usually, when you need to restore a database you do it in three parts: Install the binaries Load the initial data from the most recent MySQL backup. Set it replicating from one of the nodes by specifying the binary log file and position from which you want it to replicate (which usually corresponds to the day you took the backup).