From: Rick James Date: February 14 2013 11:13pm Subject: RE: slave replication with lots of 'duplicate entry' errors List-Archive: http://lists.mysql.com/mysql/228970 Message-Id: <582AFBFC517D194489EF570FE21694CF13628FF1@GQ1-EX10-MB03.y.corp.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 UmVjb21tZW5kLCBmb3Igc2VjdXJpdHkgcmVhc29ucywgeW91IHJlY3RpZnkgdGhhdC4NCklmIHlv dSBuZWVkIHNvbWUgU1VQRVIgYWN0aW9uLCBjcmVhdGUgYSBzdG9yZWQgcHJvY2VkdXJlIHdpdGgg cHJpdmlsZWdlcyAnY3JlYXRvcicsIHNvIHRoZSBzZWN1cml0eSBob2xlIGlzIHN0aWxsIG1vc3Rs eSBjb250YWluZWQuDQoNCj4gLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCj4gRnJvbTogUm9i ZXJ0IENpdGVrIFttYWlsdG86cm9iZXJ0LmNpdGVrQGdtYWlsLmNvbV0NCj4gU2VudDogVGh1cnNk YXksIEZlYnJ1YXJ5IDE0LCAyMDEzIDI6NTkgUE0NCj4gVG86IFJpY2sgSmFtZXMNCj4gQ2M6IG15 c3FsDQo+IFN1YmplY3Q6IFJlOiBzbGF2ZSByZXBsaWNhdGlvbiB3aXRoIGxvdHMgb2YgJ2R1cGxp Y2F0ZSBlbnRyeScgZXJyb3JzDQo+IA0KPiBPbiBUaHUsIEZlYiAxNCwgMjAxMyBhdCA1OjQ2IFBN LCBSaWNrIEphbWVzIDxyamFtZXNAeWFob28taW5jLmNvbT4NCj4gd3JvdGU6DQo+ID4+IElzIGl0 IGluIHJlYWQgb25seSBtb2RlPw0KPiA+IEZ1cnRoZXJtb3JlLCBhcmUgYWxsIHVzZXJzIGxvZ2dp bmcgaW4gYXMgbm9uLVNVUEVSIHVzZXJzPyAgTm90ZToNCj4gcm9vdCBieXBhc3NlcyB0aGUgcmVh ZG9ubHkgZmxhZyENCj4gDQo+IE5vLiAgVGhlIHVzZXIgdGhhdCBpcyBjb21tb25seSB1c2VkIGRv ZXMgaGF2ZSBTdXBlciBwcml2aWxlZ2VzLiAgSSBhbQ0KPiBub3Qgc3VyZSB3aHksIGJ1dCBpdCBk b2VzLg0KPiANCj4gUmVnYXJkcywNCj4gLSBSb2JlcnQNCg==