On Oct 13, 2006, at 1:32 PM, David Brieck Jr. wrote:
On 10/13/06, Tom Mornini <tmornini@xxxxxxxxxxxxxx> wrote:
David Brieck Jr. wrote:
> On 9/18/06, David Brieck Jr. <dbrieck@xxxxxxxxx> 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@xxxxxxxxxx
https://www.redhat.com/mailman/listinfo/linux-cluster
