Mike, you cannot run two mysqld instances on the same InnoDB data files. Think what happens with the indexes cached in the buffer pool.
The same holds for MyISAM, because its indexes are in the key buffer, unless you flush the table after each access to it, and prevent simultaneous accesses with the Unix file locking! The performance will be extremely bad. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for MySQL ----- Original Message ----- From: ""Mike Hillyer"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, September 12, 2003 3:33 AM Subject: RE: Question about InnoDB and external locking > 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. > > Mike > > > -----Original Message----- > > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Behalf Of Jeremy Zawodny > > Sent: Thursday, September 11, 2003 5:17 PM > > To: [EMAIL PROTECTED] > > Cc: [EMAIL PROTECTED]; Jeremy Zawodny > > Subject: Re: Question about InnoDB and external locking > > > > > > On Thu, Sep 11, 2003 at 03:41:21PM -0700, [EMAIL PROTECTED] wrote: > > > > > > Ok, here's another question. Given effective external locking > > by the OS, could > > > MyISAM tables achieve this? > > > > Yes. > > > > > 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 > > -- > > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
