Hi Johan
Thanks for your mail.
Is there no way to deal the situation ? As change is application Will take a
long time..
On Fri, Oct 28, 2011 at 4:50 PM, Johan De Meersman <vegivamp@stripped>wrote:
> ----- Original Message -----
> > From: "ANIL YADAV" <uranil@stripped>
> >
> > 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).
>
> Yes, temporary tables (CREATE TEMPORARY TABLE ...) are session-dependent
> (only the creating session can see them) and vanish when you log out (or the
> mysqld stops).
>
> You may want to use memory tables (CREATE TABLE ... ENGINE=MEMORY) which
> are also in-memory; they are not session-dependent (everyone sees them and
> they do not vanish at logout) and their structure remains intact after a
> service restart (although the table will be empty).
>
>
>
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>
--
-------------------
Thanks & Regards
-------------------
ANIL YADAV
*+91-9871047883*
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."
----------------------------------------------------
