From: Dan Nelson
Date: May 23 2002 6:16am
Subject: Re: MySQL on iSCSI or IPSAN?
List-Archive: http://lists.mysql.com/mysql/109951
Message-Id: <20020523061635.GH34640@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (May 22), Jeremy Zawodny said:
> On Wed, May 22, 2002 at 03:52:33PM +0800, Patrick Hsieh wrote:
> > Hello Dan Nelson <dnelson@stripped>,
> > 
> > Is there any lock problem on iSCSI or SAN environment? Say,
> > mutliple mysql server mount the backend iSCSI or SAN storage
> > device. Is it safe?
> 
> It is safe if you use MySQL's external (file) locking.

You will also need a filesystem that supports shared storage. 
Sistina's Global File System (GFS) is the only such filesystem
available for Linux, afaik (at only $995 per node; shared storage is
NOT easy to implement).  If you do not have such a filesystem, you will
most likely completely trash your filesystem when you mount it from the
2nd machine.

iSCSI/FibreChannel is not NFS.  It is block-level access to raw storage
just like SCSI or IDE.

-- 
	Dan Nelson
	dnelson@stripped