As always with these things, horses for courses. In my situation, I have a mysql server mounted off a netapp, It is the backend for a website serving 10m+ page impressions per month.
I wanted to put the data on a netapp for easy backup ( I can shutdown the server do a snapshot and bring it back up in a few seconds). We started off with 2 servers - a master and slave replication pair, but the early versions of replication proved to be far too unstable. With the latest version, replication seems to be stable and I hope to reimplement the original architecture - (selects off the slaves on local disk, updates on the master off NFS) The database is not huge ( 5-6GB ), everything works pretty well. The website is PHP/Zend Cache based. All the best, John. "Matthew Darcy" wrote: > I have done oracle on NFS and it is not really the best option due to NFS > locking. > > ie a poor network or if the NFS server drops, or the NIS/NIS+ (assuming you > are using automount maps) dies this will hold your development/production up > no end. Also oracle's table locking (not sure if mysql has this) causes > problems over NFS. > > The only time I have seen it work ok was on a veritas cluster using the > Oracle/NFS export as a failover and it worked BAD the machine failed over > quite a few times and picked up but the machines had to be very powerfull as > there was tons of rollbacks and non commited transactions, and non bound > variables over NFS was soooo slow. > > I am sure you could do it but it is not wise. > > I have stored Oracle binarys on NFS so that clients could access oracle and > manage it over NFS but never had good performance keeping the data on NFS. > > Matt. > > > -----Original Message----- > From: Shen, Lei (CIT) [mailto:[EMAIL PROTECTED]] > Sent: 12 December 2001 14:28 > To: [EMAIL PROTECTED] > Subject: Mysql in NFS > > > Hi! Dose anyone has a experience to building mysql database in network files > system? and php? can you get me some information? thank you > > -----Original Message----- > From: Marek Kustka [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 12, 2001 8:23 AM > To: [EMAIL PROTECTED] > Subject: Embedded MySQL server && the outside world > > > Hi folks, > > does embedded server tcp-listen to the outside world i.e. it could > be used by another app or perhaps been accessed by the same app > using ODBC? > > OR > > is MySQL C API the only way to control it? > > Thanks, Marek > > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- > 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 > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
