MySQL Forums
Forum List  »  InnoDB

Creating non-locking temporary tables
Posted by: Billy Gilbert
Date: October 29, 2016 02:03PM

Hi there! I am having an issues with temporary tables that I was curious if anyone else had encountered before.

In our environment, we have slave servers that we are utilizing for the purposes of reporting. On those slave servers, we are creating temporary tables to stage data. If we happen to get a transaction from the master server that affects one of those rows, it is causing a deadlock that is breaking replication.

Is there a safe way to create temporary tables on a slave server that would not break replication should this situation occur?

Thank you!

Options: ReplyQuote

Written By
Creating non-locking temporary tables
October 29, 2016 02:03PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.