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

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



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

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