[Linux-cluster] Re: Multiple Active MySQL instances

[Robert Peterson]

David Brieck Jr. wrote:
> On 9/18/06, David Brieck Jr. <dbrieck at gmail.com> wrote:
>> 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.
> Is anyone able to help me find more information on this?
Hi David,

Here is everything I know about it at this time:
http://sources.redhat.com/cluster/faq.html#gfs_mysql

Regards,

Bob Peterson
Red Hat Cluster Suite