Re: [ilugd] linux clustering
in infinite wisdom Yashpal Nagar spoke thus On 10/18/2006 02:59 PM: Hi Can anyone please suggest me a two nodes of cluster on Linux preferbly with Suse enterprise linux 10 as active and passive nodes. This cluster will host a mysql database only. We have investigated a mysql based cluster as well but really don't know how much stable/robust it is. Why do you need a linux cluster to load balance mysql ? Just setup replication between 2 (or n) machines, make one of them a master, send all writes to the master, send all reads to any of the machines. I think this topic is covered in the book 'high performance mysql'. Check it out. -- 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 -- ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/ilugd@lists.linux-delhi.org/
Re: [ilugd] linux clustering
in infinite wisdom Raj Shekhar spoke thus On 10/20/2006 11:55 AM: I think this topic is covered in the book 'high performance mysql'. Check it out. Yes, it is covered there. Chapter 8. Load Balancing and High Availability -- 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 -- ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/ilugd@lists.linux-delhi.org/
Re: [ilugd] linux clustering
On Friday 20 October 2006 12:12, Raj Shekhar wrote: in infinite wisdom Raj Shekhar spoke thus On 10/20/2006 11:55 AM: Apne moonh miya mitthu? (Rough translation for the Hindi-challenged: Blowing your own trumpet) ___ ilugd mailinglist -- ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/ilugd@lists.linux-delhi.org/
Re: [ilugd] linux clustering
in infinite wisdom Raj Mathur spoke thus On 10/20/2006 01:32 PM: On Friday 20 October 2006 12:12, Raj Shekhar wrote: in infinite wisdom Raj Shekhar spoke thus On 10/20/2006 11:55 AM: Apne moonh miya mitthu? (Rough translation for the Hindi-challenged: Blowing your own trumpet) Heh! I noticed that just now :-) -- 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 -- ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/ilugd@lists.linux-delhi.org/
Re: [ilugd] linux clustering
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 -- ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/ilugd@lists.linux-delhi.org/
Re: [ilugd] linux clustering
Raj Shekhar wrote: 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. yes, but using a proper clustering or server management setup wont require this sort of manual app changeover stuff, and in most cases will mean zero downtime :) just my 0.015p worth .. -- Karanbir Singh : http://www.karan.org/ : [EMAIL PROTECTED] ___ ilugd mailinglist -- ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/ilugd@lists.linux-delhi.org/
Re: [ilugd] linux clustering
On 10/20/06, Yashpal Nagar [EMAIL PROTECTED] wrote: 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. i've seen a heartbeat cluster with 4 nodes working perfectly at mumbai university for web/mail/dns. i've been told its been working flawlessly for an year now. -- Anurag http://www.gnuer.org ___ ilugd mailinglist -- ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/ilugd@lists.linux-delhi.org/
[ilugd] linux clustering
Hi Can anyone please suggest me a two nodes of cluster on Linux preferbly with Suse enterprise linux 10 as active and passive nodes. This cluster will host a mysql database only. We have investigated a mysql based cluster as well but really don't know how much stable/robust it is. The cluster would be hosting a booking database of a tour and travel company with shared disks on SAN. Is linux OS based cluster stable enough now a days to host live databases? Please help! Regards Yashpal ___ ilugd mailinglist -- ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/ilugd@lists.linux-delhi.org/
