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

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

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

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)

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