From: Rick James
Date: January 8 2013 6:19pm
Subject: RE: Replicating on multiple Slaves DB from one Master
List-Archive: http://lists.mysql.com/replication/2411
Message-Id: <582AFBFC517D194489EF570FE21694CF07095B7E@GQ1-EX10-MB03.y.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64

TWFrZSBzdXJlIEdhbGVyYSB3aWxsIG11bHRpLXRocmVhZCBtdWx0aXBsZSB0YWJsZXMgaW4gdGhl
IHNhbWUgZGIuICBFbHNlLCB0aGF0IHdvdWxkIGJlIGEgd2FzdGUgb2YgZWZmb3J0Lg0KDQppbm5v
ZGJfZmx1c2hfbWV0aG9kID1PX0RTWU5DDQotLT4gT19ESVJFQ1Qgb3IgT19BTExfRElSRUNUDQoN
CllvdSBhcmUgc2F5aW5nIHRoYXQgdGhlIGRpc2sgaXMgMzAlIGJ1c3kgb24gdGhlIFNsYXZlPyAg
V2hhdCBpcyBpdCBvbiB0aGUgTWFzdGVyPw0KQnV0LCAzMCUgaW1wbGllcyB0aGF0IHlvdSBhcmUg
YWJvdXQgMzAlIG9mIHRoZSBtYXggdGhhdCBpdCBjYW4gaGFuZGxlLg0KDQo3MCUgb2YgX29uZV8g
Y29yZSAtLSBzb3VuZHMgcmVhc29uYWJsZS4NCg0KKFNvcnJ5OyBJIGRvbid0IGhhdmUgYSBsaW5r
IGZvciBQbGFuIEQuKSANCg0KU1NEIGluc3RlYWQgb2YgNnggUkFJRC0xMCBvbiBzbGF2ZSAtLSB0
aGlzIG1pZ2h0IGJlIHR3aWNlIGFzIGZhc3QuICBJdCB3b3VsZCBiZSB0cmlja3kgKGFuZCBjb3N0
bHkpIHRvIGdldCBhIGJpZyBlbm91Z2ggU1NEIGZvciA4MDBHQiBkYi4NCg0KUG9uZGVyIGFwcGxp
Y2F0aW9uIGNoYW5nZXMgdGhhdCB3b3VsZCBkZWNyZWFzZSB0aGUgMTAwMCsxMDAwMCBxcHMuICBC
YXRjaGluZy4gIFNhdmluZyB1cGRhdGVzIChldmVuIGZvciBhIHNlY29uZCksIHRoZW4gcGVyZm9y
bWluZyB0aGVtIGluIGEgYmF0Y2guICBNb3JlIHRoaW5ncyBpbiBhIEJFR0lOLi4uQ09NTUlUIG1p
Z2h0IGhlbHAuICBFdGMuICAoV2l0aG91dCBhIGZlZWwgZm9yIHRoZSBxdWVyaWVzIHlvdSBhcmUg
cGVyZm9ybWluZywgSSBjYW4gb25seSBiZSB2YWd1ZS4pDQoNCj4gLS0tLS1PcmlnaW5hbCBNZXNz
YWdlLS0tLS0NCj4gRnJvbTogc2hheW5lLmFsb25lQGdtYWlsLmNvbSBbbWFpbHRvOnNoYXluZS5h
bG9uZUBnbWFpbC5jb21dDQo+IFNlbnQ6IFR1ZXNkYXksIEphbnVhcnkgMDgsIDIwMTMgMTI6MjEg
QU0NCj4gVG86IHJlcGxpY2F0aW9uQGxpc3RzLm15c3FsLmNvbQ0KPiBTdWJqZWN0OiBSZTogUmVw
bGljYXRpbmcgb24gbXVsdGlwbGUgU2xhdmVzIERCIGZyb20gb25lIE1hc3Rlcg0KPiANCj4gREVB
UiBhbGV4Og0KPiANCj4gd2UgaGF2ZSAxNDRHQiAgbWVtb3J5DQo+IGl0J3MgYSBEVUFMIFhlb24g
RzcgSFANCj4gDQo+IG9mIHdpbGwgdHJ5IFBFUkNPTkEgQWdhaW4uKCBjb3Mgd2UgSGFkIGEgZmFp
bGVkIHRyeSBvbmUgeWVhciBhZ28gd2l0aA0KPiBpdA0KPiA6XykgKQ0KPiANCj4gDQo+IE9uIFR1
ZSwgSmFuIDgsIDIwMTMgYXQgOTo1NCBBTSwgQWxleCBZdXJjaGVua28gPA0KPiBhbGV4ZXkueXVy
Y2hlbmtvQGNvZGVyc2hpcC5jb20+IHdyb3RlOg0KPiANCj4gPiBIaSwNCj4gPg0KPiA+IEkgc2Vl
IHRoYXQgeW91IGFyZSB1c2luZyBJbm5vREIgYW5kIGl0IHJlYWxseSBzZWVtcyBsaWtlIHlvdXIg
c2xhdmVzDQo+ID4gYXJlIElPIGJvdW5kLiBJbiB0aGF0IGNhc2UgeW91IG1heSB3YW50IHRvIHRy
eSBHYWxlcmEgcmVwbGljYXRpb24gZm9yDQo+ID4gTXlTUUwgKGUuZy4gUGVyY29uYSBYdHJhREIg
Q2x1c3RlcikgLSBpdCBjYW4gZG8gInBhcmFsbGVsDQo+IHJlcGxpY2F0aW9uIg0KPiA+ICh3aGlj
aCBpcywgbW9yZSBwcmVjaXNlbHksIHBhcmFsbGVsIHJlcGxpY2F0aW9uIHN0cmVhbSBhcHBseWlu
ZykgZXZlbg0KPiA+IG9uIGEgc2luZ2xlIHRhYmxlLiBQbHVzIGl0IGhhcyBvdGhlciBuaWNlIHBy
b3BlcnRpZXMuIEEgZHJhd2JhY2sgaXMNCj4gPiB0aGF0IHlvdSBjYW4ndCBqdXN0IHRyeSBpdCBv
biBhIHNpbmdsZSBzbGF2ZSwgeW91J2xsIGhhdmUgdG8gbWlncmF0ZQ0KPiBtYXN0ZXIgdG9vLg0K
PiA+DQo+ID4NCj4gPiBPbiAyMDEzLTAxLTA4IDA3OjIzLCBzaGF5bmUuYWxvbmVAZ21haWwuY29t
IHdyb3RlOg0KPiA+DQo+ID4+IERlYXIgUmljazsNCj4gPj4gdGhhbmtzIGZvciB5b3UgcmVwbHku
DQo+ID4+IEkgd2lsbCB0cnkgdG8gZXhwbGFpbiB3aGF0IEkgZGlkIGJlZm9yZSwgZGVwZW5kIG9u
IHlvdXIgaWRlYToNCj4gPj4NCj4gPj4gSSB1c2UgeGZzIGFzIGZpbGUgc3lzdGVtIHRvIG1heGlt
aXplIHRoZSBJL08gcGVyZm9ybWFuY2Ugb24gZGlzaw0KPiBEaXNrDQo+ID4+IGFyZSBoYXJkd2Fy
ZSByYWlkZWQgd2l0aCBCQkNXIDJ4IDYwMEdCIChSQUlEIDEpIDE1Sw0KPiA+PiAqKiBvcGVyYXRp
b24gc3lzdGVtDQo+ID4+ICoqIHJhbGF5IGxvZ3MNCj4gPj4gNnggMzAwR0IgKFJBSUQgMTApIDE1
Sw0KPiA+PiAqKiBNeXNxbCBEQVRBIChpYmRhdGEgYW5kIHRhYmxlcyBkYXRhKQ0KPiA+Pg0KPiA+
PiBJIGhhZCBiZWVuIGVuYWJsZWQgZmlsZV9wZXJfdGFibGUgYW5kIHBhcnRpdGlvbmVkIHRoZSBs
YXJnZSB0YWJsZXMNCj4gdG8NCj4gPj4gbG9va3VwIGZhc3Rlcg0KPiA+PiBpbm5vZGJfZmx1c2hf
bG9nX2F0X3RyeF9jb21taXQgPSAwICAgKCB0byBub3QgdG8gY29tbWl0IHBlcg0KPiB0cmFuc2Fj
dGlvbiApDQo+ID4+IGlubm9kYl9mbHVzaF9zdXBwb3J0X3hhID0gMCAgKCB0byBub3QgdG8gc3lu
YyBmaWxlIHN5c3RlbSBhbmQgbG9nDQo+ID4+IGZpbGVzIHBlciB0cmFuc2FjdGlvbiApIGlubm9k
Yl9mbHVzaF9tZXRob2QgPU9fRFNZTkMgKCB0byBpbXBvcnQNCj4gZGlzaw0KPiA+PiB1dGlsaXph
dGlvbiApIGFuZCBlbmFibGVkIHRoZSBMYXJnZSBGaWxlIGxhcmdlLXBhZ2VzIGNhdA0KPiA+PiAv
cHJvYy9tZW1pbmZvIHwgZ3JlcCAtaSBodWdlDQo+ID4+IEFub25IdWdlUGFnZXM6ICAgNjMyNjI3
MiBrQg0KPiA+PiBIdWdlUGFnZXNfVG90YWw6ICAgNjE0NDANCj4gPj4gSHVnZVBhZ2VzX0ZyZWU6
ICAgIDU5NzI3DQo+ID4+IEh1Z2VQYWdlc19Sc3ZkOiAgICA1MTEwNg0KPiA+PiBIdWdlUGFnZXNf
U3VycDogICAgICAgIDANCj4gPj4gSHVnZXBhZ2VzaXplOiAgICAgICAyMDQ4IGtCDQo+ID4+IGFu
ZCBzZXQgdGhlIGlubm9kYiBidWZmZXIgcG9vbCB0byAxMDBHQiAoIHdoaWNoIGlzIHVzaW5nIGh1
Z2UgYmxvY2sNCj4gPj4gaXMgbWVtb3J5IGFzIG1lbnRpb25lZCBhYm92ZSkNCj4gPj4NCj4gPg0K
PiA+IFdoYXQgaXMgdGhlIHRvdGFsIHNpemUgb2YgUkFNIG9uIHRoZSBzbGF2ZT8gSXMgaXQgc3dh
cHBpbmc/IFlvdQ0KPiBzaG91bGQNCj4gPiBzZXQgaW5ub2RiX2J1ZmZlcl9wb29sX3NpemUgdG8g
cm91Z2hseSA4MC05MCUgb2YgUkFNIGJ1dCBtYWtlIHN1cmUNCj4gPiB0aGF0IGluIG5vIGV2ZW50
IGl0IHRyaWVzIHRvIHN3YXAuDQo+ID4NCj4gPg0KPiA+ICB3cml0ZSBub3cgd2hlbiBJIHN0YXJ0
IHRoZSByZXBsaWNhdGlvbiwgZGlzayB1dGlsaXphdGlvbiBpcyBmaW5hbGx5DQo+ID4gc29tZQ0K
PiA+PiBhYm91dCAlMzANCj4gPj4gYW5kIGp1c3Qgb25lIG9mIHRoZSAyNENvcmVzIGFyZSB1bmRl
ciB0aGUgbG9hZCBvZiBhYm91dCAoNzAlIDotUyAmJg0KPiBJDQo+ID4+IGRvbid0IGtub3cgd2h5
IGl0IGRvc2Ugbm90IHJlYWQgMTAwJSBsb2FkICggdGhpcyBjb3JlIHNlZW0gdG8gYmUgaW4NCj4g
Pj4gdXNlIHdpdGggU1FMDQo+ID4+IHRocmVhZCAgICkNCj4gPj4gY29zIEkgaGF2ZSBqdXN0IG9u
ZSBEQiB0byBiZSByZXBsaWNhdGlvbiAoIHRvdGFsbHkgYWJvdXQgODAwR0IgKSB0aGUNCj4gPj4g
bmV3IG11bHRpIHRocmVhZCBjYXBhYmlsaXR5IGRvc2Ugbm90IGNoYW5nZWQgYW55IHRoaW5ncyBm
b3IgbWUuDQo+ID4+DQo+ID4+DQo+ID4+IHJlZ2FyZCB0byB3aGF0IEkgZXhwbGFpbmVkOg0KPiA+
PiBQbGFuIEEgaXMgRG9uZQ0KPiA+PiBQbGFuIEIgaXMgRG9uZQ0KPiA+PiBQbGFuIEMgaXMgaW4g
cHJvZ3Jlc3MNCj4gPj4gICAqKiBidXQgSSBkaWRuJ3Qgc3RpbGwgc3BsaXQgdGFibGVzIGlzIHNl
cHRhdGUgREIgKCBzb2Z0d2FyZSB0ZWFtDQo+ID4+IGNoYWxsZW5nZXMgOi0pICkgUGFuIEQgdGhp
cyBpcyB3aGF0IEkgYW0gcmVhZGluZyBzb21lIGFib3V0DQo+IHllc3RlcmRheQ0KPiA+PiBhbmQg
bGlrZSB0byB0ZXN0DQo+ID4+DQo+ID4+DQo+ID4+DQo+ID4+DQo+ID4+DQo+ID4+DQo+ID4+IE9u
IFR1ZSwgSmFuIDgsIDIwMTMgYXQgMTo0NSBBTSwgUmljayBKYW1lcyA8cmphbWVzQHlhaG9vLWlu
Yy5jb20+DQo+IHdyb3RlOg0KPiA+Pg0KPiA+PiAgUGxhbiBBOiAgTWluaW1pemUgSS9PIG9uIFNs
YXZlczoNCj4gPj4+IGlubm9kYl9mbHVzaF9sb2dfYXRfdHJ4X2NvbW1pdCA9IDINCj4gPj4+IHN5
bmNfYmlubG9nID0gMA0KPiA+Pj4gaW5ub2RiX2RvdWJsZXdyaXRlID0gT0ZGDQo+ID4+PiAoSWYg
YSBzbGF2ZSBjcmFzaGVzLCBpdCBtYXkgYmUgYmVzdCB0byByZWNsb25lIGl0IHJhdGhlciB0aGFu
IGhvcGUNCj4gPj4+IHRoYXQgdGhlc2UgcGVyZm9ybWFuY2Ugc2V0dGluZ3MgZGlkIG5vdCBsb3Nl
IGRhdGEuKQ0KPiA+Pj4NCj4gPj4+IFBsYW4gQjogIEZhc3RlciBIYXJkd2FyZSBvbiBTbGF2ZXMu
DQo+ID4+Pg0KPiA+Pj4gUGxhbiBDOiAgUGF2ZSB0aGUgd2F5IGZvciA1LjY6DQo+ID4+PiBNb3Zl
IHRhYmxlcyB0byBkaWZmZXJlbnQgZGF0YWJhc2VzLg0KPiA+Pj4gQ2hhbmdlIHRoZSBjb2RlIHRv
IHJlZmVyZW5jZSB0aGUgdGFibGVzIHRodXM6ICBkYm5hbWUudGJsbmFtZQ0KPiA+Pj4NCj4gPj4+
IFBsYW4gRDogIElmIHRoZSBTbGF2ZXMgYXJlIEkvTy1ib3VuZDoNCj4gPj4+IFNlZW1zIGxpa2Ug
dGhlcmUgaXMgYSBzY3JpcHQgKGluIFB5dGhvbj8pIHRoYXQgcGVla3MgaW4gdGhlIHJlbGF5DQo+
ID4+PiBsb2csIHR1cm5zIHF1ZXJpZXMgaW50byBTRUxFQ1RzLCBkb2VzIHRoZSBTRUxFQ1RzIC0t
IHRoZXJlYnkNCj4gcHJpbWluZw0KPiA+Pj4gdGhlIGJ1ZmZlcl9wb29sIHVzaW5nIGEgc2VwYXJh
dGUgdGhyZWFkLg0KPiA+Pj4NCj4gPj4+ID4gLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCj4g
Pj4+ID4gRnJvbTogc2hheW5lLmFsb25lQGdtYWlsLmNvbSBbbWFpbHRvOnNoYXluZS5hbG9uZUBn
bWFpbC5jb20qKl0NCj4gPj4+ID4gU2VudDogTW9uZGF5LCBKYW51YXJ5IDA3LCAyMDEzIDEyOjI5
IFBNDQo+ID4+PiA+IFRvOiByZXBsaWNhdGlvbkBsaXN0cy5teXNxbC5jb20NCj4gPj4+ID4gU3Vi
amVjdDogUmVwbGljYXRpbmcgb24gbXVsdGlwbGUgU2xhdmVzIERCIGZyb20gb25lIE1hc3Rlcg0K
PiA+Pj4gPg0KPiA+Pj4gPiBEZWFyczsNCj4gPj4+ID4NCj4gPj4+ID4gSSBoYXZlIGJlZW4gZmFj
ZWQgd2l0aCBhIGNhc2Ugb2YgcmVwbGljYXRpb24gd2hpY2ggbWF5IG1vc3Qgb2YNCj4geW91DQo+
ID4+PiA+IGhhZCBiZWVuIGZhY2VkIGJlZm9yZS4uLg0KPiA+Pj4gPiBJIGRpZCBzb21lIGNoZWNr
cyBhbmQgdGVzdCB0byBmaW5kIG91dCB0aGUgd2F5cyB0byBzb2x2ZSwgYnV0IEknbQ0KPiA+Pj4g
PiBub3QgcHJldHR5IHN1cmUgYWJvdXQgdGhlIGNvbnMgYW5kIHByb24uDQo+ID4+PiA+IHByb2Js
ZW1zIGlzIGFzIGZhbGxvdzoNCj4gPj4+ID4gTWFzdGVyOg0KPiA+Pj4gPiBTaW5nbGUgTXlzcWwg
d2l0aCBhYm91dCB+MzBLIFFQUywgbWFpbmx5IGp1c3Qgd29yayBhcyBBQUEgZGF0YQ0KPiA+Pj4g
PiBiYWNrIGVuZC4NCj4gPj4+ID4gbm90IGFsbCBidXQgbG90cyBvZiB0aGVzZSBxdWVyaWVzIGFy
ZSB3cml0ZXMgKElOU0VSVC9VUERBVEUpLg0KPiA+Pj4gPiB0aGUgbWF0dGVyIGlzIHRoYXQgd2hl
biB0aGUgc2xhdmUgd2FudHMgdG8gZXhlY3V0ZSBUcmFuc2FjdGlvbnMNCj4gPj4+ID4gd2l0aCBv
bmUgdGhyZWFkISB0aGlzIHdpbGwgbGVhZCB0byBhIGxvdHMgb2YgcmVwbGljYXRpb24gZGVsYXku
Li4NCj4gPj4+ID4NCj4gPj4+ID4gSSdtIGxvb2tpbmcgZm9yIGEgd2F5IHRvIHJld3JpdGUgREIg
dXNlciBmb3IgcXVlcmllcyBkZXBlbmQgb24NCj4gPj4+ID4gdGFibGUgbmFtZSBhbmQgbm90IGp1
c3QgcmVuYW1lIHdob2xlIG9mIHN0YXRlbWVudHMuDQo+ID4+PiA+IGlzIHN1Y2ggYXdheSEgaSBo
b3BlIGJlIGFibGUgdG8gdXNlIE11bHRpIHRocmVhZCByZXBsaWNhdGlvbg0KPiA+Pj4gPiBhYmls
aXR5IG9mDQo+ID4+PiA+IG15c3FsNS42IGZvciBhIHNpbmdsZSBEQiBhbmQgbXVsdGlwbGUgaW5k
ZXBlbmRlbnQgdGFibGVzLg0KPiA+Pj4gPg0KPiA+Pj4gPg0KPiA+Pj4gPiAtLQ0KPiA+Pj4gPiBS
ZWdhcmRzLA0KPiA+Pj4gPiBBbGkgUi4gVGFsZWdoYW5pIDxhLnRhbGVnaGFuaUBhdXQuYWMuaXI+
DQo+ID4+Pg0KPiA+Pj4NCj4gPiAtLQ0KPiA+IEFsZXhleSBZdXJjaGVua28sDQo+ID4gQ29kZXJz
aGlwIE95LCB3d3cuY29kZXJzaGlwLmNvbQ0KPiA+IFNreXBlOiBhbGV4ZXkueXVyY2hlbmtvLCBQ
aG9uZTogKzM1OC00MDAtNTE2LTAxMQ0KPiA+DQo+ID4gLS0NCj4gPiBNeVNRTCBSZXBsaWNhdGlv
biBNYWlsaW5nIExpc3QNCj4gPiBGb3IgbGlzdCBhcmNoaXZlczoNCj4gaHR0cDovL2xpc3RzLm15
c3FsLmNvbS8qKnJlcGxpY2F0aW9uPGh0dHA6Ly9saXN0cy5teXNxbC5jb20vcmVwbGljYXRpb24N
Cj4gPg0KPiA+IFRvIHVuc3Vic2NyaWJlOg0KPiBodHRwOi8vbGlzdHMubXlzcWwuY29tLyoqcmVw
bGljYXRpb248aHR0cDovL2xpc3RzLm15c3FsLmNvbS9yZXBsaWNhdGlvbg0KPiA+DQo+ID4NCj4g
Pg0KPiANCj4gDQo+IC0tDQo+IFJlZ2FyZHMsDQo+IEFsaSBSLiBUYWxlZ2hhbmkNCg==