----- Original Message -----
From: "Zachary Denison" <[EMAIL PROTECTED]>
To: "MySQL ListServe" <[EMAIL PROTECTED]>
Sent: Sunday, October 21, 2001 11:11 AM
Subject: shared datafiles.

> I know this is probably a recipe for disaster, but
> would I be able to have 2 instances of mysql running,
> both pointing to the same set of datafiles?
>
> Before you ask, my reasoning for doing this would be
> so that I could get some sort of underlying shared
> mirrored filesystem and this way I could have 2
> read/write copies of mysql running in 2 different locations.

Why not just create two connection objects within your language of choice?
Assuming that your current MySQL server has its own IP address, you can use
an ODBC connection, via the IP, and connect to the same MySQL db from
virtually anywhere. From an efficiency standpoint, you're much better off
creating two connections rather than having two simulatneous servers.

Good Luck,

Dennis Salguero
**********************************************
Beridney Computer Services
[EMAIL PROTECTED]
http://www.beridney.com


---------------------------------------------------------------------
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

Reply via email to