List:Replication« Previous MessageNext Message »
From:Johan De Meersman Date:October 28 2011 5:26pm
Subject:Re: Temporary table issue (with replication)
View as plain text  
David,

It would be a bug if temporary tables don't get replicated at all (and I think that was,
indeed a bug), but if the replication slave stops somewhere in the middle of a session
(not a transaction) there is no way for it to know what temporary tables should still be
there when it resumes.

Well... technically it should be possible to save state for open sessions, but as far as
I've seen session information is entirely absent from the binary logs - that concerns
itself merely with transactions.

/johan

-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
Thread
Re: Temporary table issue (with replication)ANIL YADAV28 Oct
  • Re: Temporary table issue (with replication)Johan De Meersman28 Oct