[Linux-cluster] Multiple Active MySQL instances

[David Brieck Jr.]

I've been trying to find more information about using GFS  and MySQL
to create a simple active-active mysql cluster without the need for
the actual mysql cluster (wouldn't work for our situation).

The only thing I've seen on the mailing list is the following:

-----
It is possible to use mysql on shared storage with enabled external locking
and also disabling the query cache and few other things:

enable-locking
query_cache_wlock_invalidate
query_cache_size= 0
query_cache_type= 0
delay_key_write = OFF
flush

in mysqld section


this configuration worked for my 10 node cluster .
----

but other than that no one has posted anything. I also found this press release:
http://www.mysql.com/news-and-events/press-release/release_2005_13.html

from mysql and redhat that says:

"MySQL and Red Hat plan to test the MySQL database with Red Hat's
Cluster Suite and Global File System (GFS). Red Hat GFS allows a
cluster of MySQL servers to simultaneously read and write data to a
single shared file system on a SAN, achieving high performance and
reducing the complexity and overhead of managing redundant data
copies. With Red Hat Cluster Suite and GFS, MySQL customers can get a
highly available clustered database solution based on all open source
technologies."

But once again I can't find any follow up to this. Can anyone give me
a hand? I'd want to run 3 active mysql servers at least on one set of
data shared with GFS.

Thanks.