in infinite wisdom Yashpal Nagar spoke thus On 10/20/2006 03:46 PM: > Hi Raj, > We are going to SUSE 10 Enterprise linux, i am thinking of the following. > > Heartbeat http://www.linux-ha.org which comes already bundled with > SUSE and seems to be quite stable. > http://www.continuent.com/ really have no idea how much stable it is.
I have not used either suse or the linux-ha. The point I am trying to make is - if you are going to use linux-ha to just have 2 instances of mysql running, then you can do that by having one mysql replicate from another (master-slave) on any stock linux distribution. You don't have to have the linux-ha running on top just for having high availability mysql. > I am not suppose to change the architecture here by puting all read to > one server and write to other, i am looking a two node active/passive > cluster for linux. By active/passive I assume you mean hot/cold i.e. only one of the machines will be active at any time and the application will connect to just one machine ? If that is the case, you can set up replication and have the slave as standby. When master fails, take the master offline and you point your application to use the slave instead of the master. Repair the master and then point your application back to the master instead of the slave. caveat: If you are having the slave just as a cold standby for the master, I think that is wasting a machine. OTOH, it is your money :-) . -- raj shekhar facts: http://rajshekhar.net | opinions: http://rajshekhar.net/blog WE APOLOGIZE FOR THE INCONVENIENCE -- God's Last Message to his Creation _______________________________________________ ilugd mailinglist -- [email protected] http://frodo.hserus.net/mailman/listinfo/ilugd Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/[email protected]/
