[Linux-cluster] Re: Multiple Active MySQL instances

[Tom Mornini]

Two nodes, but I'm quite certain more would have worked fine.

On Oct 13, 2006, at 2:10 PM, Michael Will wrote:

> 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)

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