Hosting Provided By

Re: Fixing gaps in replication

From: Wayne Gemmell <waynetg(at)telkomsa.net>
Date: Fri Jun 29 2007 - 05:50:23 EDT

On Thursday 28 June 2007 19:49, Rick James wrote:
> CHANGE MASTER ... (same master, diff position)
>
> 3 masters in a ring? I think you found the reason not to use circular
> replication.

No, Only 2 masters. The problem is that setting the position back causes a million 1062 errors. And since the skip-errors function doesn't work (at least on my servers) this causes huge problems...

Cheers
Wayne

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

Received on Fri Jun 29 05:50:59 2007

This message: [ Message body ]
Next message: Todd Reed: "HA topology and replication techniques"
Previous message: Rick James: "RE: Fixing gaps in replication"
In reply to: Rick James: "RE: Fixing gaps in replication"
Next in thread: Jochen Billen [Smartbit]: "Re: Fixing gaps in replication"
Maybe reply: Jochen Billen [Smartbit]: "Re: Fixing gaps in replication"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Fri Jun 29 2007 - 06:00:02 EDT