Re: MySQL Database and NAS

2001-03-15 Thread Steve Ruby 

Patrick Calkins wrote:
 
 Hello all;
 Are there any known problems with storing the database files on a NAS
 (network attached storage) device??
 
 also, can you run multiple MySQL daemons pointing to one common database, so
 you could have a "cluster" of database servers and one database??
 
 Thanks!
 Patrick


You can only have one data repository and multiple servers if you
never write to your database..  Unfortunately unless you use replication
mysql doesn't handle mutliple servers pointing at the same data,
one server has no way of knowing that cached indexes are out
of date based on updates by another server.

-
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

Re: MySQL Database and NAS

2001-03-15 Thread Jeremy D. Zawodny 

On Thu, Mar 15, 2001 at 05:07:08PM -0700, Steve Ruby wrote:
 Patrick Calkins wrote:
  
  Hello all;
  Are there any known problems with storing the database files on a NAS
  (network attached storage) device??
  
  also, can you run multiple MySQL daemons pointing to one common database, so
  you could have a "cluster" of database servers and one database??
  
  Thanks!
  Patrick
 
 You can only have one data repository and multiple servers if you
 never write to your database..  Unfortunately unless you use
 replication mysql doesn't handle mutliple servers pointing at the
 same data, one server has no way of knowing that cached indexes are
 out of date based on updates by another server.

Even with it's external locking support?

Jeremy
-- 
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878Fax: (408) 530-5454
Cell: (408) 439-9951

-
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