List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:May 23 2002 6:16am
Subject:Re: MySQL on iSCSI or IPSAN?
View as plain text  
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
Thread
MySQL on iSCSI or IPSAN?Patrick Hsieh17 May
  • Re: MySQL on iSCSI or IPSAN?Dan Nelson17 May
    • Re: MySQL on iSCSI or IPSAN?Patrick Hsieh22 May
      • Re: MySQL on iSCSI or IPSAN?Jeremy Zawodny23 May
        • Re: MySQL on iSCSI or IPSAN?Dan Nelson23 May
          • Re: MySQL on iSCSI or IPSAN?Patrick Hsieh23 May