MySQL Replication - Master-Slave crash

--=_256ggn00ruw0
Content-Type: text/plain;
charset=UTF-8
Content-Description: Plaintext Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit

Hi All,

I have kept
Replicate_Wild_Ignore_Table = mydb%.temp_%

this is temporary table which i want should not be replicated. But still it is getting replicated and slave is getting crashed.

any input will be a great help.

--
Thanks and Regards,
Manasi Save
Artificial Machines Private Limited
manasi.save@artificialmachines.com
Ph:-9833537392

--=_256ggn00ruw0
Content-Type: multipart/related;
boundary="=_2criznbfxlc0";
start="2csdh367h8ow@mail.artificialmachines.com"
Content-Transfer-Encoding: 7bit

This message is in MIME format.

--=_2criznbfxlc0
Content-Type: text/html;
charset=UTF-8
Content-Description: HTML Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
Content-ID: 2csdh367h8ow@mail.artificialmachines.com

Hi All,

 

I have kept 

Replicate_Wild_Ignore_Table = mydb%.temp_%

 

this is temporary table  which i want should not be replicated. But still
it is getting replicated and slave is getting crashed.

 

 

any input will be a great help.


--
Thanks and Regards,
Manasi Save
Artificial Machines
Private Limited
manasi.save@artificialmachines.com
Ph:-9833537392 />
--=_2criznbfxlc0--

--=_256ggn00ruw0--

Re: MySQL Replication - Master-Slave crash

Hi Manasi,

Please try with this one.
Replicate_Wild_Ignore_Table = mydb\temp_.%

Regards,
Nilnandan Joshi

Manasi Save wrote:
> Hi All,
>
> I have kept
> Replicate_Wild_Ignore_Table = mydb%.temp_%
>
> this is temporary table which i want should not be replicated. But
> still it is getting replicated and slave is getting crashed.
>
>
> any input will be a great help.
>
> --
> Thanks and Regards,
> Manasi Save
> Artificial Machines Private Limited
> manasi.save@artificialmachines.com
> Ph:-9833537392

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: MySQL Replication - Master-Slave crash

Dear Nilnandan,
 
Thanks for the quick reply. 
 
But this particular variable is not working in only one proc call...but
rest all procedures creating temporary tables, does not affect my
replication slaves.
 
So I am not able to identify the problem.
 
Here's the snapshot of my procedure which is causing a problem.
 
Drop Temporary Table If Exists norep_Temp3;
Create Temporary Table norep_Temp3
(
  UserID BigInt,
  FirstName Varchar(45),
  LastName Varchar(45)

);
 
Insert into norep_Temp3(UserID, FirstName, LastName)
Select UserID From tbl1;
 
Update norep_Temp3 T3, tbl2
Set T3.FirstName =3D tbl2.FirstName,
T3.LastName =3D tbl2.LastName
Where T3.UserID =3D tbl2.UserID;
 
Insert into MyTbl(UserID, Name)
Select UserID, Concat(FirstName,' ',LastName) From norep_Temp3;

--
Regards,
Manasi Save 

On Wed, 23 Jun 2010 18:47:19 0530, Nilnandan Joshi wrote:
Hi Manasi,
>
> Please try with this one.
> Replicate_Wild_Ignore_Table =3D mydb\temp_.%
>
> Regards,
> Nilnandan Joshi
>
> Manasi Save wrote:
> > Hi All,
> >
> > I have kept
> > Replicate_Wild_Ignore_Table =3D mydb%.temp_%
> >
> > this is temporary table which i want should not be replicated. But
> > still it is getting replicated and slave is getting crashed.
> >
> >
> > any input will be a great help.
> >
> > --
> > Thanks and Regards,
> > Manasi Save
 >
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg