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.
-
New Member- Apr 2012
- 1
-
MySQL Sage
- Mar 2007
- 329
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. -
New Member
- Apr 2012
- 1
Comment
Comment