I am running mysql 5.1.41 on a master and slave server using MyISAM tables. Could creating temporary tables on the slave server itself result in any issues with the replication process from the master? I have done tests without having replication break but don’t want to miss any unforeseen possible issues with this.
I would say no, not unless your temporary tables fill up the disk.
The only possible issue is that the slave might temporarily get a little behind due to the slow down due to high load of the temporary tables.
In fact a scenario where you have a master->slave setup and you choose to run heavy reporting queries against the slave is very often a good solution to avoid performance issues with the OLTP role the master has.
That is what I was hoping to hear. Thanks.