[CentOS] Clustering MySQL

Wed Dec 12 10:07:12 UTC 2007
Luke Dudney <listmail at lukedudney.com>

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