Temporary tables on slave

  • Filter
  • Time
  • Show
Clear All
new posts

  • Temporary tables on slave

    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.

  • #2
    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.


    • #3
      That is what I was hoping to hear. Thanks.