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

RE: [Linux-cluster] Re: Multiple Active MySQL instances

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 redhat com
[mailto:linux-cluster-bounces 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 engineyard com> wrote:
>> David Brieck Jr. wrote:
>> > On 9/18/06, David Brieck Jr. <dbrieck 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 redhat com

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