On Fri, Dec 07, 2001 at 09:43:08AM +0100, Chemolli Francesco (USI) wrote: > > I have a GFS/OpenGFS-based cluster I intend to use for an HA mysql > setup. Just for fun, I tried running two instances of MySQL over > the same table files, and you can imagine my surprise when it mostly > worked....
Heh, "mostly"... > I "only" got an "error in table handler" when when inserting row #8k > of a concurrent 5k+5k insertion from both nodes. The tables do NOT > seem to be corrupt. > > The point is, how much did this work by chance? 100% > Or can it somehow work, e.g. provided that the concurrent > insertions are not too frequent? Unless you tell MySQL to do "external" (file) locking, it assumes that it is the only thing writing to the tables. So you're likely to end up with corrupt tables at some point if you don't tell it to do locking. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 7 days, processed 171,341,081 queries (249/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
