LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Enterprise Linux Forums > Linux - Enterprise
User Name
Password
Linux - Enterprise This forum is for all items relating to using Linux in the Enterprise.

Notices

Reply
 
Search this Thread
Old 10-26-2007, 02:58 PM   #1
ajatiti
Member
 
Registered: Jun 2007
Posts: 45

Rep: Reputation: 15
Clustering without external storage


I want to have MySQL database on two Linux servers (RHEL AS-4.
Can I have cluster of these two servers without using shared storage?
I have 2*300 GB SCSI hard drive with RAID1 on each server.

I want to have failover between these two servers. Please suggest.

Thanks,
Ajatiti
 
Old 10-26-2007, 03:28 PM   #2
GoodOmens
LQ Newbie
 
Registered: Aug 2004
Location: Washinton, D.C.
Distribution: Fedora Core 3
Posts: 11

Rep: Reputation: 0
You could do a master/slave relationship. I know you can set it up in php to failover to the slave if no response comes from the main database.

Essentially the slave database pulls queries from the main database to get its updates. Not ideal but should work in your case.

Last edited by GoodOmens; 10-26-2007 at 03:29 PM.
 
Old 10-26-2007, 04:39 PM   #3
ajatiti
Member
 
Registered: Jun 2007
Posts: 45

Original Poster
Rep: Reputation: 15
What about using MySQL cluster?
It doesn't require external storage but it requires one server each for MySQL node, Data node and management node.

Is it possible to have MySQL node, data node and management node on the same server with Linux? Then have backup server with MySQL, data node and management node on same server. So in this case we can have only two physical servers and no external storage.

Is this possible?

Thanks,
Ajay
 
Old 10-28-2007, 12:56 PM   #4
complich8
Member
 
Registered: Oct 2007
Distribution: rhel, fedora, gentoo, ubuntu, freebsd
Posts: 104

Rep: Reputation: 15
Quote:
Originally Posted by GoodOmens View Post
You could do a master/slave relationship. I know you can set it up in php to failover to the slave if no response comes from the main database.

Essentially the slave database pulls queries from the main database to get its updates. Not ideal but should work in your case.
An improvement to this would be to set them up in a "circular replication" config, wherein each is both a master and a slave to the other. There's some implementation issues to be aware of, but the howtos you'll find generally make that pretty clear.

Quote:
Originally Posted by ajatiti View Post
What about using MySQL cluster?
It doesn't require external storage but it requires one server each for MySQL node, Data node and management node.

Is it possible to have MySQL node, data node and management node on the same server with Linux? Then have backup server with MySQL, data node and management node on same server. So in this case we can have only two physical servers and no external storage.
It's probably possible, but it's definitely not a good idea. If you're talking about a setup with less than 4 hosts in it, then you should be able to come up with a replication architecture that accomplishes what you want without resorting to misusing the cluster engine, I'd expect.
 
Old 10-31-2007, 10:38 PM   #5
GoodOmens
LQ Newbie
 
Registered: Aug 2004
Location: Washinton, D.C.
Distribution: Fedora Core 3
Posts: 11

Rep: Reputation: 0
Quote:
Originally Posted by complich8 View Post
An improvement to this would be to set them up in a "circular replication" config, wherein each is both a master and a slave to the other. There's some implementation issues to be aware of, but the howtos you'll find generally make that pretty clear.

Cool I'll keep that in mind.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Scalable Storage Clustering with redundancy? What to use? humbletech99 Linux - Server 2 07-03-2007 05:04 AM
External Storage advice please (UK) bigjohn Linux - Hardware 1 05-23-2006 05:32 PM
10.1 and external Storage device goudi Mandriva 3 10-16-2004 06:57 AM
External Storage problem pacevedo Mandriva 0 05-14-2004 08:10 PM
Proliant CL1850 - External Storage MarkFred Linux - Hardware 0 01-22-2003 07:10 AM


All times are GMT -5. The time now is 05:37 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration