Linux - EnterpriseThis forum is for all items relating to using Linux in the Enterprise.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
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.
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.
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
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.
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.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.