Re: Clustering MySQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]




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.


_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos


[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux