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@xxxxxxxxxx [mailto:linux-cluster-bounces@xxxxxxxxxx] On Behalf Of Tom Mornini Sent: Friday, October 13, 2006 2:07 PM To: linux clustering Subject: Re: Re: Multiple Active MySQL instances 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 -- Linux-cluster mailing list Linux-cluster@xxxxxxxxxx https://www.redhat.com/mailman/listinfo/linux-cluster
