RE: using the bin-log approach on the master side, how can I accomplish my replication objectives

2012-05-03 Thread Rick James
se the USE. > -Original Message- > From: Nitin Mehta [mailto:ntn...@yahoo.com] > Sent: Wednesday, May 02, 2012 9:25 PM > To: Brown, Charles > Cc: mysql@lists.mysql.com > Subject: Re: using the bin-log approach on the master side, how can I > accomplish my replication

Re: using the bin-log approach on the master side, how can I accomplish my replication objectives

2012-05-03 Thread Nitin Mehta
com] Sent: Wednesday, May 02, 2012 11:25 PM To: Brown, Charles Cc: mysql@lists.mysql.com Subject: Re: using the bin-log approach on the master side, how can I accomplish my replication objectives Hi Charles, I believe you would already have bin-log configured, is that right? If not, you need to. S

RE: using the bin-log approach on the master side, how can I accomplish my replication objectives

2012-05-03 Thread Brown, Charles
our problem. Regards, From: "Brown, Charles" mailto:cbr...@bmi.com>> To: Nitin Mehta mailto:ntn...@yahoo.com>> Sent: Thursday, May 3, 2012 9:27 AM Subject: RE: using the bin-log approach on the master side, how can I accomplish my replication objectives Hello Nitin, Hel

Re: using the bin-log approach on the master side, how can I accomplish my replication objectives

2012-05-02 Thread Nitin Mehta
s" To: Nitin Mehta Sent: Thursday, May 3, 2012 9:27 AM Subject: RE: using the bin-log approach on the master side, how can I accomplish my replication objectives Hello Nitin, Help Me!  Using your approach, do I have to put anything on  the master “my.cnf”.   Thanks     From:Nitin Mehta

Re: using the bin-log approach on the master side, how can I accomplish my replication objectives

2012-05-02 Thread Nitin Mehta
I guess, it only makes things even more simple.   You should use "replicate-do-table=db1.tb1" and so one in 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.   So making it even s