At this point it is pure academic curiousity. I am putting together a cheap
cluster to play with shared drive failover, and thought I would see what
happens when I point two MySQL machines at the same drive while I'm at it.
> -----Original Message-----
> From: Jeremy Zawodny [mailto:jzawodn@thermal]On Behalf Of Jeremy Zawodny
> Sent: Thursday, September 11, 2003 5:17 PM
> To: mhillyer@stripped
> Cc: mysql@stripped; Jeremy Zawodny
> Subject: Re: Question about InnoDB and external locking
> On Thu, Sep 11, 2003 at 03:41:21PM -0700, mhillyer@stripped wrote:
> > Ok, here's another question. Given effective external locking
> by the OS, could
> > MyISAM tables achieve this?
> > If so, do you know any operating systems that would have reliable
> > external locking?
> I'm not sure what the state of file locking is in various OSes. I
> believe it's generally not a problem unless you also throw NFS into
> the mix...
> Out of curiosity, why do you need to do this? I've found that it's a
> rare need.
> Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
> <Jeremy@stripped> | http://jeremy.zawodny.com/