From: Rick James
Date: May 3 2012 4:21pm
Subject: RE: using the bin-log approach on the master side, how can I
 accomplish my replication objectives
List-Archive: http://lists.mysql.com/mysql/227309
Message-Id: <2E7DD7ADE53B044C8C8BCD9C5829E1EB1485A7E13E@SP2-EX07VS01.ds.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64

VGhhdCBzdXJwcmlzZSBoYXBwZW5zIHdoZXRoZXIgeW91IGZpbHRlciBpdCBvbiB0aGUgbWFzdGVy
IG9yIG9uIHRoZSBzbGF2ZS4gIFRoZSBwcm9ibGVtIGlzIHRoYXQgc29tZSB0YWJsZXMgZ290IHVw
ZGF0ZWQ7IHNvbWUgZGlkIG5vdC4NCg0KVGhlIG9ubHkgdmlhYmxlIHdvcmthcm91bmQgKHRoYXQg
SSBrbm93IG9mKSBpcyB0byB1c2UgdGhlICJ3aWxkIiBmaWx0ZXJpbmcgLS0gdGhpcyBmb3JjZXMg
dGhlIGZpbHRlcmluZyB0byBhY3R1YWxseSBsb29rIGF0IHRoZSBxdWVyeSwgbm90IHNpbXBseSB1
c2UgdGhlIFVTRS4NCg0KPiAtLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KPiBGcm9tOiBOaXRp
biBNZWh0YSBbbWFpbHRvOm50bm1odEB5YWhvby5jb21dDQo+IFNlbnQ6IFdlZG5lc2RheSwgTWF5
IDAyLCAyMDEyIDk6MjUgUE0NCj4gVG86IEJyb3duLCBDaGFybGVzDQo+IENjOiBteXNxbEBsaXN0
cy5teXNxbC5jb20NCj4gU3ViamVjdDogUmU6IHVzaW5nIHRoZSBiaW4tbG9nIGFwcHJvYWNoIG9u
IHRoZSBtYXN0ZXIgc2lkZSwgaG93IGNhbiBJDQo+IGFjY29tcGxpc2ggbXkgcmVwbGljYXRpb24g
b2JqZWN0aXZlcw0KPiANCj4gSGkgQ2hhcmxlcywNCj4gSSBiZWxpZXZlIHlvdSB3b3VsZCBhbHJl
YWR5IGhhdmUgYmluLWxvZyBjb25maWd1cmVkLCBpcyB0aGF0IHJpZ2h0PyBJZg0KPiBub3QsIHlv
dSBuZWVkIHRvLg0KPiBTZWNvbmRseSwgSWYgeW91IHRoaW5rIHRoZSBiaW4tbG9nIGdlbmVyYXRl
ZCBmb3IgdGhlIGVudGlyZSBzdGFjayBvZg0KPiBkYXRhYmFzZXMvc2NoZW1hcyBpcyB0b28gYmln
LCB5b3UgbWF5IHdhbnQgdG8gcmVzdHJpY3QgaXQgdXNpbmcNCj4gImJpbmxvZy1kby1kYiIgQlVU
IHRoYXQgbWF5IGNyZWF0ZSBwcm9ibGVtIGlmIHlvdSBoYXZlIGFueSBETUxzIHdoaWNoDQo+IHJ1
biBpbiB0aGUgYmVsb3cgbWFubmVyOg0KPiBteXNxbD4gdXNlIGRiMTsNCj4gbXlzcWw+IHVwZGF0
ZSBkYjIudGIyIC4uLi4NCj4gWW91IG1heSBiZSBzdXJwcmlzZWQgdG8gZmluZCB0aGF0IHRoaXMg
dXBkYXRlIHdpbGwgbm90IGJlIHJlY29yZGVkIGluDQo+IG1hc3RlcidzIGJpbi1sb2cgaWYgeW91
IGhhdmUgc2V0ICJiaW5sb2ctZG8tZGI9ZGIyIi4NCj4gVG8gc3VtIGl0IHVwLCBpZiB5b3UncmUg
bm90IHZlcnkgc3VyZSwgc2ltcGx5IGVuYWJsZSBiaW4tbG9nIG9uIG1hc3Rlcg0KPiBhbmQgdXNl
ICJyZXBsaWNhdGUtZG8tdGFibGUiIG9uIHNsYXZlLiBTbyBpbiBvbmUgd29yZCByZXNwb25zZSB0
byB5b3VyDQo+IHF1ZXN0aW9uLCBubyENCj4gSG9wZSB0aGF0IGhlbHBzIQ0KPiBBbHNvLCBwbGVh
c2XCoHJlcGx5IHRvIGFsbCBzbyB0aGUgcGVvcGxlLCBoZWxwaW5nIHlvdSwga25vdyBhYm91dCB0
aGUNCj4gc3RhdHVzIG9mIHlvdXIgcHJvYmxlbS4NCj4gDQo+IA0KPiBSZWdhcmRzLA0KPiANCj4g
DQo+IA0KPiBfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXw0KPiAgRnJvbTogIkJyb3du
LCBDaGFybGVzIiA8Q0Jyb3duQEJNSS5jb20+DQo+IFRvOiBOaXRpbiBNZWh0YSA8bnRubWh0QHlh
aG9vLmNvbT4NCj4gU2VudDogVGh1cnNkYXksIE1heSAzLCAyMDEyIDk6MjcgQU0NCj4gU3ViamVj
dDogUkU6IHVzaW5nIHRoZSBiaW4tbG9nIGFwcHJvYWNoIG9uIHRoZSBtYXN0ZXIgc2lkZSwgaG93
IGNhbiBJDQo+IGFjY29tcGxpc2ggbXkgcmVwbGljYXRpb24gb2JqZWN0aXZlcw0KPiANCj4gDQo+
IEhlbGxvIE5pdGluLA0KPiBIZWxwIE1lIcKgIFVzaW5nIHlvdXIgYXBwcm9hY2gsIGRvIEkgaGF2
ZSB0byBwdXQgYW55dGhpbmcgb24gwqB0aGUgbWFzdGVyDQo+IOKAnG15LmNuZuKAnS4NCj4gDQo+
IFRoYW5rcw0KPiANCj4gDQo+IEZyb206Tml0aW4gTWVodGEgW21haWx0bzpudG5taHRAeWFob28u
Y29tXQ0KPiBTZW50OiBXZWRuZXNkYXksIE1heSAwMiwgMjAxMiAxMDo1MSBQTQ0KPiBUbzogQnJv
d24sIENoYXJsZXM7IFJpY2sgSmFtZXM7IGEuc21pdGhAdWtncmlkLm5ldDsNCj4gbXlzcWxAbGlz
dHMubXlzcWwuY29tDQo+IFN1YmplY3Q6IFJlOiB1c2luZyB0aGUgYmluLWxvZyBhcHByb2FjaCBv
biB0aGUgbWFzdGVyIHNpZGUsIGhvdyBjYW4gSQ0KPiBhY2NvbXBsaXNoIG15IHJlcGxpY2F0aW9u
IG9iamVjdGl2ZXMNCj4gDQo+IEkgZ3Vlc3MsIGl0IG9ubHkgbWFrZXMgdGhpbmdzIGV2ZW4gbW9y
ZSBzaW1wbGUuDQo+IA0KPiBZb3Ugc2hvdWxkIHVzZSAicmVwbGljYXRlLWRvLXRhYmxlPWRiMS50
YjEiIGFuZCBzbyBvbmXCoGluIHNsYXZlJ3MgY25mDQo+IHRvIGVuc3VyZSB0aGF0IG9ubHkgdGhp
cyBwYXJ0aWN1bGFyIHRhYmxlIGdldHMgcmVwbGljYXRlZC4gSG93ZXZlciwgYWxsDQo+IHRoZSBk
YXRhYmFzZXMgb24gbWFzdGVyIHdpbGwgZ2V0IGJpbi1sb2dnZWQgYW5kIHlvdSBtYXkgb3IgbWF5
IG5vdCB3YW50DQo+IHRvIGRvIHRoYXQuDQo+IA0KPiBTbyBtYWtpbmcgaXQgZXZlbiBzaW1wbGVy
Og0KPiANCj4gb24gdGhlIHNsYXZlOg0KPiANCj4gcmVwbGljYXRlLWRvLXRhYmxlPWRiMS50YjEN
Cj4gcmVwbGljYXRlLWRvLXRhYmxlPWRiMi50YjINCj4gcmVwbGljYXRlLWRvLXRhYmxlPWRiMy50
YjMNCj4gWW91IG1pZ2h0IHdhbnQgdG8gaGF2ZSBhIGxvb2sgYXQgOg0KPiBodHRwOi8vZGV2Lm15
c3FsLmNvbS9kb2MvcmVmbWFuLzUuNS9lbi9yZXBsaWNhdGlvbi1vcHRpb25zLQ0KPiBzbGF2ZS5o
dG1sI29wdGlvbl9teXNxbGRfcmVwbGljYXRlLWRvLXRhYmxlDQo+IGh0dHA6Ly9kZXYubXlzcWwu
Y29tL2RvYy9yZWZtYW4vNS41L2VuL3JlcGxpY2F0aW9uLXJ1bGVzLmh0bWwNCj4gDQo+IEhvcGUg
dGhpcyBoZWxwcyENCj4gDQo+IEZyb206IkJyb3duLCBDaGFybGVzIiA8Q0Jyb3duQEJNSS5jb20+
DQo+IFRvOiBSaWNrIEphbWVzIDxyamFtZXNAeWFob28taW5jLmNvbT47ICJhLnNtaXRoQHVrZ3Jp
ZC5uZXQiDQo+IDxhLnNtaXRoQHVrZ3JpZC5uZXQ+OyAibXlzcWxAbGlzdHMubXlzcWwuY29tIiA8
bXlzcWxAbGlzdHMubXlzcWwuY29tPg0KPiBTZW50OiBUaHVyc2RheSwgTWF5IDMsIDIwMTIgODo1
MSBBTQ0KPiBTdWJqZWN0OiB1c2luZyB0aGUgYmluLWxvZyBhcHByb2FjaCBvbiB0aGUgbWFzdGVy
IHNpZGUsIGhvdyBjYW4gSQ0KPiBhY2NvbXBsaXNoIG15IHJlcGxpY2F0aW9uIG9iamVjdGl2ZXMN
Cj4gDQo+IEhlbGxvIFJpY2ssDQo+IA0KPiBJIHRoaW5rIEknbGwgZ28gd2l0aCB5b3VyIHJlY29t
bWVuZGF0aW9ucyAtIGJ1dCBoZWxwIG1lIGhlcmUgYSBsaXR0bGUNCj4gYml0LiBCZWNhdXNlIGFs
bCBsb29rIGZ1enp5IGxpa2UgYSBicmFpbiBzdXJnZXJ5LiBTbyBtYWtlIGl0IHNpbXBsZSBhbmQN
Cj4gY2xlYW4gZm9yIG1lLg0KPiANCj4gDQo+IA0KPiBGb3IgdGhlIHNha2Ugb2Ygc2ltcGxpY2l0
eSwgaGVyZSBpcyB3aGF0IG15IG1hc3RlciBoYXM6DQo+IA0KPiBEYXRhYmFzZTogZGIxDQo+IA0K
PiBUYWJsZXM6IGRiMXRiMSwgZGIxdGIyLCBkYjF0YjMNCj4gDQo+IA0KPiANCj4gRGF0YWJhc2U6
IGRiMg0KPiANCj4gVGFibGVzOiBkYjJ0YjEsIGRiMnRiMiwgZGIydGIzDQo+IA0KPiANCj4gDQo+
IERhdGFiYXNlOiBkYjMNCj4gDQo+IFRhYmxlczogZGIzdGIxLCBkYjN0YjIsIGRiM3RiMw0KPiAN
Cj4gDQo+IA0KPiBOb3csIEkgd291bGQgbGlrZSB0byByZXBsaWNhdGUgb25seSB0aGVzZSB0YWJs
ZXMgdGhhdCBiZWxvbmcgdG8NCj4gcmVzcGVjdGl2ZSBkYXRhYmFzZXM6DQo+IA0KPiBkYjF0YjEs
IGRiMnRiMiwgYW5kIGRiM3RiMw0KPiANCj4gDQo+IA0KPiBNeSBxdWVzdGlvbiBpczogdXNpbmcg
dGhlIGJpbi1sb2cgYXBwcm9hY2ggb24gdGhlIG1hc3RlciBzaWRlLCBob3cgY2FuDQo+IEkgYWNj
b21wbGlzaCBteSByZXBsaWNhdGlvbiBvYmplY3RpdmVzPyBIZWxwIG1lDQo+IA0KPiANCj4gDQo+
IEJlc3QgcmVnYXJkcyBhbmQgdGhhbmtzDQo+IA0KPiANCj4gDQo+IA0KPiANCj4gDQo+IA0KPiAq
KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKg0KPiBUaGlzIG1lc3Nh
Z2UgaXMgaW50ZW5kZWQgb25seSBmb3IgdGhlIHVzZSBvZiB0aGUgQWRkcmVzc2VlIGFuZA0KPiBt
YXkgY29udGFpbiBpbmZvcm1hdGlvbiB0aGF0IGlzIFBSSVZJTEVHRUQgYW5kIENPTkZJREVOVElB
TC4NCj4gDQo+IElmIHlvdSBhcmUgbm90IHRoZSBpbnRlbmRlZCByZWNpcGllbnQsIHlvdSBhcmUg
aGVyZWJ5IG5vdGlmaWVkDQo+IHRoYXQgYW55IGRpc3NlbWluYXRpb24gb2YgdGhpcyBjb21tdW5p
Y2F0aW9uIGlzIHN0cmljdGx5IHByb2hpYml0ZWQuDQo+IA0KPiBJZiB5b3UgaGF2ZSByZWNlaXZl
ZCB0aGlzIGNvbW11bmljYXRpb24gaW4gZXJyb3IsIHBsZWFzZSBlcmFzZQ0KPiBhbGwgY29waWVz
IG9mIHRoZSBtZXNzYWdlIGFuZCBpdHMgYXR0YWNobWVudHMgYW5kIG5vdGlmeSB1cw0KPiBpbW1l
ZGlhdGVseS4NCj4gDQo+IFRoYW5rIHlvdS4NCj4gKioqKioqKioqKioqKioqKioqKioqKioqKioq
KioqKioqKioqKioqKioqKioNCj4gDQo+IA0KPiAqKioqKioqKioqKioqKioqKioqKioqKioqKioq
KioqKioqKioqKioqKioqKg0KPiBUaGlzIG1lc3NhZ2UgaXMgaW50ZW5kZWQgb25seQ0KPiBmb3Ig
dGhlIHVzZSBvZiB0aGUgQWRkcmVzc2VlIGFuZA0KPiBtYXkgY29udGFpbiBpbmZvcm1hdGlvbiB0
aGF0IGlzIFBSSVZJTEVHRUQNCj4gYW5kIENPTkZJREVOVElBTC4NCj4gSWYgeW91IGFyZSBub3Qg
dGhlIGludGVuZGVkIHJlY2lwaWVudCwgeW91IGFyZSBoZXJlYnkgbm90aWZpZWQNCj4gdGhhdCBh
bnkNCj4gZGlzc2VtaW5hdGlvbiBvZiB0aGlzIGNvbW11bmljYXRpb24gaXMgc3RyaWN0bHkgcHJv
aGliaXRlZC4NCj4gSWYgeW91IGhhdmUgcmVjZWl2ZWQgdGhpcyBjb21tdW5pY2F0aW9uIGluIGVy
cm9yLCBwbGVhc2UgZXJhc2UNCj4gYWxsIGNvcGllcw0KPiBvZiB0aGUgbWVzc2FnZSBhbmQgaXRz
IGF0dGFjaG1lbnRzIGFuZCBub3RpZnkgdXMNCj4gaW1tZWRpYXRlbHkuDQo+IFRoYW5rIHlvdS4N
Cj4gKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioNCg==