From: Nitin Mehta Date: May 3 2012 3:51am 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/227302 Message-Id: <1336017062.18358.YahooMailNeo@web161602.mail.bf1.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="406169123-562225160-1336017062=:18358" --406169123-562225160-1336017062=:18358 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable I guess, it only makes things even more simple.=0A=A0=0AYou should use "rep= licate-do-table=3Ddb1.tb1" and so one=A0in slave's cnf to ensure that only = this particular table gets replicated. However, all the databases on master= will get bin-logged and you may or may not want to do that.=0A=A0=0ASo mak= ing it even simpler:=0A=A0=0Aon the slave:=0A=A0=0Areplicate-do-table=3Ddb1= .tb1=0Areplicate-do-table=3Ddb2.tb2=0Areplicate-do-table=3Ddb3.tb3=0A=0AYou= might want to have a look at :=0Ahttp://dev.mysql.com/doc/refman/5.5/en/re= plication-options-slave.html#option_mysqld_replicate-do-table=0Ahttp://dev.= mysql.com/doc/refman/5.5/en/replication-rules.html=0A=A0=0AHope this helps!= =0A=A0 =0A=0A________________________________=0A From: "Brown, Charles" =0ATo: Rick James ; "a.smith@stripped"= ; "mysql@stripped" =0AS= ent: Thursday, May 3, 2012 8:51 AM=0ASubject: using the bin-log approach on= the master side, how can I accomplish my replication objectives=0A =0AHel= lo Rick,=0A=0AI think I'll go with your recommendations - but help me here = a little bit. Because all look fuzzy like a brain surgery. So make it simpl= e and clean for me.=0A=0A=0A=0AFor the sake of simplicity, here is what my = master has:=0A=0ADatabase: db1=0A=0ATables: db1tb1, db1tb2, db1tb3=0A=0A=0A= =0ADatabase: db2=0A=0ATables: db2tb1, db2tb2, db2tb3=0A=0A=0A=0ADatabase: d= b3=0A=0ATables: db3tb1, db3tb2, db3tb3=0A=0A=0A=0ANow, I would like to repl= icate only these tables that belong to respective databases:=0A=0Adb1tb1, d= b2tb2, and db3tb3=0A=0A=0A=0AMy question is: using the bin-log approach on = the master side, how can I accomplish my replication objectives? Help me=0A= =0A=0A=0ABest regards and thanks=0A=0A=0A=0A=0A=0A=0A=0A*******************= *************************=0AThis message is intended only for the use of th= e Addressee and=0Amay contain information that is PRIVILEGED and CONFIDENTI= AL.=0A=0AIf you are not the intended recipient, you are hereby notified=0At= hat any dissemination of this communication is strictly prohibited.=0A=0AIf= you have received this communication in error, please erase=0Aall copies o= f the message and its attachments and notify us=0Aimmediately.=0A=0AThank y= ou.=0A******************************************** --406169123-562225160-1336017062=:18358--