RE: Fixing gaps in replication

CHANGE MASTER ... (same master, diff position)

3 masters in a ring? I think you found the reason not to use circular replication.

> -----Original Message-----
> From: Wayne Gemmell [mailto:waynetg@telkomsa.net]
> Sent: Thursday, June 28, 2007 2:08 AM
> To: replication@lists.mysql.com
> Subject: Fixing gaps in replication
>
> Hi all, is there any way I can get my slave to re-read the
> master servers
> binary log? I've got about 1000 transactions missing on my
> slave from when I
> was messing around trying to get replication re-started and I
> want it to
> re-read that part of the masters log without messing up my circular
> replication with 1062 errors.
>
> Any ideas?
>
> Cheers
> Wayne
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe:
> http://lists.mysql.com/replication?unsub=rjames@yahoo-inc.com
>
>

-- 
MySQL Replication Mailing List
For list archives: 
http://lists.mysql.com/replication
To unsubscribe:    
http://lists.mysql.com/replication?unsub=lists@pantek.com