Kaushal, When you set it to MASTER/MASTER replication then everything that happens on the MASTER happens on the SLAVE. Remember they are both master and slave.
My situation is as fallows, I have 2 node (servers) and I have then configured for HA (high availability) failover. When node 1 goes down, node 2 takes over and when node 1 comes back up then node 1 will becomes the main node. For this I am using RHEL cluster suite but you could set up HEARTBEAT to handle the High Availability, see ha-linux.org The above is separate\ from my replication. The DB replication is handled by mysql by following the process explained on the links. Take care, Néstor :-) On Mon, Apr 7, 2008 at 11:44 AM, Kaushal Shriyan <[EMAIL PROTECTED]> wrote: > On Tue, Apr 8, 2008 at 12:02 AM, Néstor <[EMAIL PROTECTED]> wrote: > > > Kaushal, > > > > That worked. I found out that my problem was that my firewall was not > > allowing my to computers to talk to each other on port 3306. I use the > > link you sent but this are th eoriginal links I used: > > 1) Master/Slave replication > > > > > > http://crazytoon.com/2008/01/29/mysql-how-do-you-set-up-masterslave-replication-in-mysql-centos-rhel-fedora/ > > 2) Master/Master replication > > > > > > http://crazytoon.com/2008/02/29/mysql-how-do-you-set-up-mastermaster-replication-in-mysql-centos-rhel-fedora/ > > > > Thanks, > > > > Néstor :-) > > > > > > On Sun, Apr 6, 2008 at 11:28 PM, Kaushal Shriyan < > > [EMAIL PROTECTED]> > > wrote: > > > > > On Mon, Apr 7, 2008 at 11:32 AM, Néstor <[EMAIL PROTECTED]> wrote: > > > > Kaushal, > > > > > > > > > > > > I will try it tomorrow to see if it works. It is similar to > > something I > > > > tried > > > > a couple of weeks ago and it work but when I changed the ip address > > it > > > stop > > > > working. > > > > > > > > I will try this tomorrow and let you know. > > > > > > > > > > > > Néstor :-) > > > > > > > > > > > > > > > > On Sun, Apr 6, 2008 at 10:52 PM, Kaushal Shriyan < > > > [EMAIL PROTECTED]> > > > > wrote: > > > > > > > > > > > > > > > > > > > > hi > > > > > > > > > > is this a correct documentation > > > > > http://howtoforge.com/mysql_master_master_replication for Master > > Slave > > > > > Replication > > > > > > > > > > Thanks and Regards > > > > > > > > > > Kaushal > > > > > > > > > > -- > > > > > MySQL General Mailing List > > > > > For list archives: http://lists.mysql.com/mysql > > > > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > Hi Nestor > > > > > > Thanks for the quick reply > > > > > > My requirement was if the Master goes down, the slave should take care > > > and act as Master. the Master should acts as slave and reversing of > > > this role. > > > > > > is this possible. > > > > > > Thanks and Regards > > > > > > Kaushal > > > > > > > Hi Nestor > > My requirement was if the Master goes down, the slave should take care and > act as Master. the Master should acts as slave and reversing of this > role.is it possible > > Also what are the test cases which you followed while doing the Master > Slave Replication setup. > > Thanks and Regards > > Kaushal >
