[Linux-cluster] Re: Multiple Active MySQL instances

[Michael Will]

So what was the result?

A two node active/active mysql setup operating on the same tables, or
more than just two? 

-----Original Message-----
From: linux-cluster-bounces at redhat.com
[mailto:linux-cluster-bounces at redhat.com] On Behalf Of Tom Mornini
Sent: Friday, October 13, 2006 2:07 PM
To: linux clustering
Subject: Re: [Linux-cluster] Re: Multiple Active MySQL instances

On Oct 13, 2006, at 1:32 PM, David Brieck Jr. wrote:

> On 10/13/06, Tom Mornini <tmornini at engineyard.com> wrote:
>> 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
>>
>> I too found this, and tried it. It worked well, except for the HUGE 
>> problem (in my case) that it only works for MyISAM tables.
>>
>> Additionally, I didn't test it all that well, as it was unsuitable 
>> otherwise.
>
> Thanks for your response, I'm trying it as well right now. Not having 
> InnoDB tables isn't a huge problem for us, we can certainly work 
> around that with an additional server that just does innodb if we 
> absolutely need them.

You're lucky!

> Where there any other configurations you made to get it to work 
> properly? I'm using LVS to route traffic to the real servers in my 
> tests.

No. My my.cnf has those exact lines in it.

--
-- Tom Mornini, CTO
-- Engine Yard, Ruby on Rails Hosting
-- Reliability, Ease of Use, Scalability
-- (866) 518-YARD (9273)


--
Linux-cluster mailing list
Linux-cluster at redhat.com
https://www.redhat.com/mailman/listinfo/linux-cluster