From: Dan Nelson
Date: January 21 2004 5:48pm
Subject: Re: Shared Physical Database Question
List-Archive: http://lists.mysql.com/mysql/158093
Message-Id: <20040121174806.GA83679@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Jan 19), m.harris@stripped said:
> Could someone please tell me if tyhe following is possible or if a solution
> accomplishing the same thing is available?
> 
> I would like to build a database using two MySQL servers accessing
> the same physical file on a common Drive attached to each computer
> via a SAN.  Can this be done or is there data integrity issues and
> database file locking issues?.  Our main goal is to provide the data
> gathered on a secure network and allow it to be seen on an insecure
> network.  I do understand that this can be accomplished using
> firewalls and other networking tools, but our management has been
> very firm in their insistence that a user has no direct network
> access to our internal/secure LAN.

You might want to check out replication, so that you can push a
read-only copy of the tables to a mysqld running on the web server.

-- 
	Dan Nelson
	dnelson@stripped