The one major design spec, my management has requested, is lack of TCP/IP connectivity between the two servers using the data. One network is completely isolated from the outside world/internet, however we are trying to find a secure way to allow outside users to query historical data that currently resides on the isolated network.
Thanks, Matthew Harris Systems Engineer Peoples Energy - Gas Control (312) 240-4752 [EMAIL PROTECTED] -----Original Message----- From: Dan Nelson [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 11:48 AM To: Harris, Matt Cc: [EMAIL PROTECTED] Subject: Re: Shared Physical Database Question In the last episode (Jan 19), [EMAIL PROTECTED] 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 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]