Also, what we have done is used a replicating box as a select only server. This requires you to write your code in such a way that only selects get sent to the slave. A simple function wrapper in PHP is all we needed.
Brian. ----- Original Message ----- From: "Brian Moon" <[EMAIL PROTECTED]> To: "Luis Calero" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, August 20, 2002 8:07 AM Subject: Re: MySQL over NFS | This is an interesting idea. I would be a happy man if it would actually | work. My experiences with NFS would lead me to believe that this would not | help and could hurt the performance of existing MySQL server even more. My | use has been limited to a file server for our web nodes, so, this is a bit | different. | | Let us know if you try it and how it turns out. | | ----- Original Message ----- | From: "Luis Calero" <[EMAIL PROTECTED]> | To: <[EMAIL PROTECTED]> | Sent: Tuesday, August 20, 2002 5:39 AM | Subject: MySQL over NFS | | | | | | Hi... I've got the folowing question, our servers are running pretty | | busy these days and our main DB server is taking high load peaks (memory | | is OK but the cpu has almost no idle time). We have another spare server | | and I'm thinking about mounting the database over NFS (100mb LAN) to the | | spare server and using both as frontends to the DB. Both servers are | | supposed to do reads and updates to the DB, but i'm concerned with the | | updates of the server using NFS. | | | | Are NFS locks safe enough to run this kind of setup? Is this going to be | | an advantage or will suffer from other kinds of problems? Both boxes are | | PIII dual 1Ghz / 1Gb ram, Linux 2.4.16, MySQL 3.23.52 | | | | Thanx | | | | -- | | L | | | | | | --------------------------------------------------------------------- | | 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
