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
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos
