>> 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)? >> > > 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 I use a MySQL high-availability setup in a 800-1000 concurrent connection environment. We use DRBD and Heartbeat and it's bulletproof. See http://marksitblog.blogspot.com/2007/07/mysql-5-high-availability-with-drbd-8.html for an example configuration.