Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 20th March 2008, 23:06
vincentthe vincentthe is offline
Member
 
Join Date: Oct 2006
Posts: 43
Thanks: 0
Thanked 0 Times in 0 Posts
Default High Availability Lamp cluster

Hi there,

I'm in the situation that I need a new HA-cluster in operation, but I want to limit the needed resources to a minimum.
After reading the series on the high availability nfs/apache/mysql clusters + loadbalancer I have a couple of questions, I wonder if anyone could give me a hand in this.

I'm going to run a php/mysql web-application with several interactive elements (= heavy DB usage) and some data-hogs (movies on demand). At this moment I think that fail-over is more important than pure performance so the setup I have in mind at this moment consists of:
2x loadbalancer
2x webserver
2x db-server + nfs server

My questions:
- Is this the logical combination or is it better to combine webserver & nfs server on 1 box?
- The MySQL clustering solution has loadbalancer 1 as the management node. Shouldn't it be installed on loadbalancer 2 as well? It seems to me that the approach from the tutorial still creates a single point of failure. What happens to the Cluster if LB 1 crashes and DB1 crashes after that?

Thanks in advance!
Reply With Quote
Sponsored Links
  #2  
Old 20th March 2008, 23:47
vincentthe vincentthe is offline
Member
 
Join Date: Oct 2006
Posts: 43
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Could it be an option to purchase 3(?) faster machines and use Virtualization and Xen to obtain the same goal? It would save on co-location costs...
Reply With Quote
  #3  
Old 21st March 2008, 15:00
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
Default

I'd use MySQL Master-Master replication ( http://www.howtoforge.com/mysql5_mas...on_debian_etch ) instead of a MySQL cluster. A MySQL cluster holds all data in memory, so if there's a power failure, your data is lost.

If you want to save costs, you can get just two physical servers and set up Xen VMs on them.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #4  
Old 21st March 2008, 15:19
vincentthe vincentthe is offline
Member
 
Join Date: Oct 2006
Posts: 43
Thanks: 0
Thanked 0 Times in 0 Posts
Default

From the tutorial it seems to me that downtime from one of the master requires quite a lot of manual intervention to get the system up again? In short, how is disaster recovery managed in this case?
Is it still possible to use mysql load balancing in this setup?
Reply With Quote
  #5  
Old 22nd March 2008, 16:52
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
 
Default

Quote:
Originally Posted by vincentthe
From the tutorial it seems to me that downtime from one of the master requires quite a lot of manual intervention to get the system up again?
Once the systems gets up again, it should catch up with the other master again, provided that the relevant logs still exist on the other master (look at the expire_log_days setting in my.cnf). You can check with the
Code:
SHOW SLAVE STATUS;
command if both systems are in sync. If they aren't, you must set up replication again as shown in the tutorial.


Quote:
Originally Posted by vincentthe
Is it still possible to use mysql load balancing in this setup?
You can put a load balancer in front of the MySQL server, e.g. HAProxy.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
high availability loadbalanced apache cluster: does it handle sessions? tiny HOWTO-Related Questions 2 5th August 2008 21:09
Public and private network + High Availability Apache Cluster teleted HOWTO-Related Questions 11 28th January 2008 14:29
Question About High Available Apache Cluster 4nDr3s HOWTO-Related Questions 3 16th November 2007 17:19
Help With High Availability Apache Cluster 4nDr3s HOWTO-Related Questions 4 10th September 2007 08:19
High Availability Samba cluster - DRBD + Heartbeat djalex Server Operation 58 25th May 2007 19:38


All times are GMT +2. The time now is 17:16.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.