Re: Temporary table issue

[ANIL YADAV]

Sorry for bad English.

 Dear Team/Group

I am facing a weired problem. I have a M-S replication setup.  Application
using temporary table on master server.  Normally Replication running fine,
But when ever MySQL instance is down(Either By crash or Scheduled Downtime),
Replication breaks giving error (Table not exist).

What is the solution/Fix for this error, so i can ensure replication is up
and there is no data loss.

Any help will be appreciated.


On Fri, Oct 28, 2011 at 3:09 PM, ANIL YADAV <uranil@stripped> wrote:

> Dear Team/Group
>
> I am facing a weired proble. I have a M-S replication setup.  Application
> useing temporary table on master server.  Normally Replication running fine,
> But when ever MySQL instance is down(Either By carsh or Scheduled Downtime),
> Replication breaks giving error (Table not exist).
>
> What is the solution/Fix for this error, so i can ensure replication is up
> and there is no data loss.
>
> Any help will be appriciated.
>
> --
> -------------------
> Thanks & Regards
> -------------------
>    ANIL  YADAV
>  *[phone]*
> LinkedIn:-http://www.linkedin.com/in/anilyadav
> ----------------------------------------------------
> "We judge ourselves by what we feel capable of doing,
> while others judge us by what we have already done."
> ----------------------------------------------------
>



-- 
-------------------
Thanks & Regards
-------------------
   ANIL  YADAV
 *[phone]*
LinkedIn:-http://www.linkedin.com/in/anilyadav
----------------------------------------------------
"We judge ourselves by what we feel capable of doing,
while others judge us by what we have already done."
----------------------------------------------------