[CentOS] Clustering MySQL
Luke Dudney
listmail at lukedudney.com
Wed Dec 12 10:07:12 UTC 2007
On 11/12/2007 17:18, Steve Campbell wrote:
> I'm just beginning to consider using the Clustering available with
> CentOS. We are going to spec out some new hardware, and after reading
> most of the Clustering manuals, I have a small question about MySQL.
>
> I would like to run High Availability MySQL, in other words, similar
> to how you can run HA HTTPD and the like. The catch seems to be if I
> run MySQL on an individual server, with common MySQL replication to
> another server, how do failovers work? I see a real problem with table
> locking and the like. Is there a way to run multiple MySQL servers
> that get removed from the cluster as opposed to failing over when
> using the newer MySQL versions (I am running 3.23 now, so a little
> behind)?
>
> Thanks for any insights.
>
> Steve Campbell
After all the discussions regarding MySQL-style clustering (multi-master
etc), what about a "classic" HA cluster for MySQL? Since the OP
mentioned high availability, wouldn't the simplest solution be failover
clustering (ie. single master with failover, shared storage, fenced
nodes etc) via Centos CS?
As I haven't done this myself I can't really comment further, but does
anyone else on the list have experience engineering a Centos Cluster
Suit failover cluster for MySQL?
cheers
Luke
More information about the CentOS
mailing list