Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 1st August 2013, 07:12
pcolomes pcolomes is offline
Junior Member
 
Join Date: Aug 2013
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 2 servers for HA + MySQL + iSCSI shared storage??

Hi everyone,

This is my very first post here and I'm asking because I cannot find the right answer to a problem we have.

I have one customer who has a unique server running Linux + MySQL + Apache on the local disk but he wants to improve his systems because of the load (more than 3.000 users simultaneosly accessing the website).

The thing is he has bought two servers (both identical) with 24GB RAM each and a local disk to install the OS (saying Debian) plus a storage appliance for centralized storage of the DBs. (this one: http://go.iomega.com/en-us/products/..._specsItem_tab)

He basically needs a High Availability cluster for MySQL. How can this be done? I've read about using GFS but I'm not so sure how to make it work with an iSCSI device for HA.

I attach a pic with the physical topology (sorry, only MSPAINT technology this time )
If you can help, I would appreciate it.
Attached Images
 
Reply With Quote
Sponsored Links
  #2  
Old 21st February 2014, 04:25
byau byau is offline
Junior Member
 
Join Date: Feb 2014
Location: Los Angeles, CA
Posts: 5
Thanks: 0
Thanked 1 Time in 1 Post
 
Default

Wow, surprised no answer? Was just reading up on some clustering stuff and found this thread.

It depends on how you want to do this. If you want an active/passive type cluster, then I would OS cluster (CentOS/Redhat or SLES). All things that need to failover is on shared storage.

If you need to run active/active, the power of 2 servers masquerading as 1, you will need to cluster MySQL and Apache at the app level.

From your diagram, only having two servers, I would run on an OS cluster and run it active/passive with two resource groups, mysql as one active/passive (active on node01) and apache as active/passive (active on node02).

That way you are using both servers, and you also have failover for redundancy. Then you need to figure out the resources needed by one node to carry both applications (apache/mysql) for X amount of time if one node does fail.

Does that help?
__________________
Boss: "My boss says we need some Eunuch Programmers"
Dilbert: "I think he means UNIX not Eunuchs. And I already know UNIX"
Boss: "If the company nurse drops by, tell her I said 'Never Mind'
http://geekswing.com/geek/the-evolut...-a-programmer/
Reply With Quote
Reply

Bookmarks

Tags
cluster, linux, mysql, san, storage

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
ISPConfig 3 - MultiServer Setup - With Dedicated Control Panel - How? SuperJC Installation/Configuration 4 16th October 2012 21:03
Unable send receive emails vassilis3 Installation/Configuration 15 19th May 2007 15:34
APACHE AND MYSQL on different Servers? linux_padawan Server Operation 3 22nd February 2007 00:54
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 13:17
Howto suggestion suse PhP ver 4 + Ver 5 wwparrish Suggest HOWTO 11 7th August 2006 14:29


All times are GMT +2. The time now is 01:57.


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