LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Enterprise (http://www.linuxquestions.org/questions/linux-enterprise-47/)
-   -   Clustering without external storage (http://www.linuxquestions.org/questions/linux-enterprise-47/clustering-without-external-storage-594847/)

ajatiti 10-26-2007 01:58 PM

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

GoodOmens 10-26-2007 02:28 PM

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.

ajatiti 10-26-2007 03:39 PM

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

complich8 10-28-2007 11:56 AM

Quote:

Originally Posted by GoodOmens (Post 2938003)
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 (Post 2938075)
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.

GoodOmens 10-31-2007 09:38 PM

Quote:

Originally Posted by complich8 (Post 2939870)
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.


All times are GMT -5. The time now is 12:31 AM.