Re: Possible perlmonks mirrors?

I know MySQL won't do two way replication, so that option is out. Another option to improve performance would be clustering. I did a brief search at mysql.com and found that there are cluster solutions available on Solaris, AIX and SCO. I also did a google search but I didn't come up with much. Anyone know if there is a BSD + MySQL clustering solution? If anyone found one I would be more than willing to help out.
I know that we run on BSD now but if we ever switched to Linux there are two(warning that’s a pdf) solutions we could use.
<disclaimer>
1. This is more of a curiosity question than anything else, as I think a cluster / the effort required to maintain one would be overstepping our bounds with the gracious service that pair provides us.
2. Just to keep everything on the up and up, I do work for one of the companys I linked to. But am I in no way suggesting that PM buy into a proprietary, closed source, (maintenance nightmare) solution.
</disclaimer>

Comment on Re: Possible perlmonks mirrors?

Replies are listed 'Best First'.
Re: Possible perlmonks mirrors? by Abigail-II (Bishop) on Feb 14, 2003 at 10:28 UTC
The link to mysql.com discusses a HA-cluster. That's a cluster where you have at least two nodes in a cluster, but a package (which contains one of more applications) will only run on one node at the time. That's very different from load balancing. Also the PDF file from Red Hat talks about a HA cluster. I can't get to the Veritas site, but our company gets hired to do consulting jobs for Veritas, and I've done their course about their cluster solution. That's also a high availability cluster. I think it should be doable to do load balancing on the front end (the webserver), as I don't think I get the impressions there's any session handling going on. (You can still do load balancing with session handling, but that requires specialized software). But load-balancing on the database end is a totally different ballpark. If you have lots of money, you could buy Oracle Parallel Server, that is capable of running more than one server on the same database. But MySQL isn't that smart by a long shot. Abigail	[reply]
Re: Re: Possible perlmonks mirrors? by krujos (Curate) on Feb 14, 2003 at 15:58 UTC
Every cluster is an HA cluster (crevat: a beowulf cluster, but that's a totally different ballpark), that's the most basic, and arugably the best reason to use one. Load ballancing could happen in the cluster. The cluster server would control it and ferry requests to the approiprate node. It is true that MySQL would need to be able to handle running in an active active configuration before this would work. There is some software that would allow it to do it. I found this which appears to use some trickery to do it. Josh	[reply]


Come for the quick hacks, stay for the epiphanies.
	PerlMonks