MySQL and NFS
Hi All I have read through some previous threads on this topic and I was unable to find any to answer my question... Can I install MySQL on a NFS mount and use its executables on multiple machines simultaneously? The data will be NOT be on a NFS mount, just the install. Thanks Gabe * The jokes on him, I'll be dead by then - HJS Gabe Tucker Bloomberg LP P 609 750 6668 F 646 268 5681 * -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL and NFS
HI! yes you can! as long as the data is no on a nfs volume go ahead! =) Best Regards! On Wed, 2004-03-10 at 15:16, Tucker, Gabriel wrote: Hi All I have read through some previous threads on this topic and I was unable to find any to answer my question... Can I install MySQL on a NFS mount and use its executables on multiple machines simultaneously? The data will be NOT be on a NFS mount, just the install. Thanks Gabe * The jokes on him, I'll be dead by then - HJS Gabe Tucker Bloomberg LP P 609 750 6668 F 646 268 5681 * -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|ext. 325 - Tél: +58-241-8507325 | ||geek by nature - linux by choice | |...|
MySQL over NFS: performance?
I have an installation of MySQL where the data directory is located on an NFS share. Client and server are connected by Full Duplex Gigabit Ethernet (both hosts run Linux 2.4.21). The NFS is exported with sync option. Read performance is really fine, but when it comes to writing e.g. an ALTER TABLE writes the temporary table it creates with a speed of ~25KB/sec. - Is the poor write performance in sync mode related to how MySQL does its write accesses (I guess, because for a plain file copy I get write rates of ~10MB/sec, which is 400 times faster than MySQL writes)? - Is there any possibility of speeding up things? - What would be the risks of exporting the NFS share with the async option (the MySQL write rate improves nearly by factor 1000 to ~20MB/sec then)? __ UNICEF bittet um Spenden fur die Kinder im Irak! Hier online an UNICEF spenden: https://spenden.web.de/unicef/special/?mc=021101 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL over NFS: performance?
On Fri, Jun 27, 2003 at 09:20:45AM +0200, [EMAIL PROTECTED] wrote: I have an installation of MySQL where the data directory is located on an NFS share. Client and server are connected by Full Duplex Gigabit Ethernet (both hosts run Linux 2.4.21). The NFS is exported with sync option. Read performance is really fine, but when it comes to writing e.g. an ALTER TABLE writes the temporary table it creates with a speed of ~25KB/sec. - Is the poor write performance in sync mode related to how MySQL does its write accesses (I guess, because for a plain file copy I get write rates of ~10MB/sec, which is 400 times faster than MySQL writes)? Wow. Perhaps MySQL is writing in significantly smaller blocks than when you copy a file. - Is there any possibility of speeding up things? Apparently so... - What would be the risks of exporting the NFS share with the async option (the MySQL write rate improves nearly by factor 1000 to ~20MB/sec then)? The risk is lost data if the NFS server dies. The MySQL server may think that data was committed to disk that was not. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 24 days, processed 772,847,148 queries (365/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
Re: MySQL over NFS
On Tuesday 20 August 2002 06:39 am, Luis Calero wrote: NFS locking is ALWAYS problematical. You might have no problems, you might also be instantly in hell. Its really hard actually to answer your question. NFS implementations vary greatly in their quality. In addition it depends on the NICs you have. Some NICs create a lot more CPU load than others. 1st thing to do would be to test with a dummy database and see if the setup will work at all. Then you'd need to load test your NFS server, tune it, and see what you can get out of it for throughput. Finally you'd have to test the actual setup and find out if it really works better. Needless to say most sysadmins find this sort of thing to be too much trouble and just upgrade their hardware! 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 - 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
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
Re: MySQL over NFS
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
Re: MySQL over NFS
Isn't that what the MySQL-Replication is for? Thomas On Tue, 20 Aug 2002 08:07:24 -0500 Brian Moon [EMAIL PROTECTED] wrote: 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
Re: MySQL over NFS
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. I've been thinking of this idea too but it's a bit of a problem because we open one connection for every page request and it makes from 10 to 100 querys (selects and updates). So it would be either opening and closing the connection for each query (not good I guess) or opening two connections, one to each server, at the beginning and then randomly serving them to both boxes if they're selects or to one of them if they're updates. Anyway if anyone has more insights about this I'd love to hear them. Cheers. -- 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
Re: MySQL over NFS
We use a class for all our MySQL stuff that has some error stuff and commonly used function combinations (like do a query then do a numrows). In that we create a connection only when the query method is called. So, until a query is run, no connection is made. If the update server name does not equal the select server name we make two connections. The load saved on the main server is well worth the connection. MySQL is pretty fast with connections compared to other DBMS I have used. Brian. - Original Message - From: [EMAIL PROTECTED] To: Brian Moon [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 8:57 AM Subject: Re: MySQL over NFS | | 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. | | I've been thinking of this idea too but it's a bit of a problem because | we open one connection for every page request and it makes from 10 to 100 | querys (selects and updates). So it would be either opening and closing | the connection for each query (not good I guess) or opening two | connections, one to each server, at the beginning and then randomly | serving them to both boxes if they're selects or to one of them if they're | updates. | | Anyway if anyone has more insights about this I'd love to hear them. | | Cheers. | | -- | 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
RE: Mysql in NFS
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 s 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
Re: Mysql in NFS
For mysql, if your datafiles will not fit in ram, I would highly recommend not putting it on nfs. Mysql doesn't have any data caching, so every query will have to go thru the network to get the data. if, however, you do have enough ram on the machine to store all the datafiles in memory, then we have not seen this problem. But the other points that Matthew brought up about network connectivity till apply. OT, Matthew, we've got oracle running over NFS on NetAPP filers and we've had extremely good performance. Of course we have 100Meg or GigE between them, but the only problems we ever have is when we have queries that do full table scans. Anyways just my couple pennies.. --shak 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 s 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 -- Shakeel Sorathia Systems Administrator (626) 660-3502 - 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
Re: Mysql in NFS
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 s 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
MySQL vs. NFS locking
How dependent is MySQL on proper NFS locking between threads of the same server? Some background: I have a small application with lots of data that stores recent RADIUS records for lookup by techs to help diagnose dialup problems. The application runs with MySQL 3.23.10 (yes, I know, I ought to upgrade, but it's currently working fine) on a small Alpha system running OSF 4.0D. The application is write-mostly read-occasionally (at least 95% of the activity is REPLACE). The problem: managers want to keep records for a much longer time, and this machine doesn't have the disk space. Further, it probably can't be expanded within reasonable cost. Proposed solution: use this big NFS server we've got and put the database on that. We can do striped and mirrored filesystems, and set up more storage. There is *NO* intent to run multiple instances of the server using the same database (we might switch to a more powerful CPU) and I think it is possible to effectively threaten the admins (I get to handle problems with this app most of the time) with dire consequences if they run myisamchk while the server is still running. Problems: NFS locking doesn't seem to work. First try: copy databases over, run myisamchk. Fails with no locks available. Start up rpc.lockd and rpc.statd. Run myisamchk. Hangs indefinitely. The server is *NOT* running on this copy yet, and if myisamchk won't work, it won't ever be. Assuming that NFS locking can be gotten to work at all, it will probably be flakey. Does MySQL depend on NFS locking (when database is on NFS filesystem) to do table locking between different queries sent to the same server? Does anyone see any problems with *ONE* instance (but multiple threads at times) of the server running with the database on a NFS filesystem, with manual locking between the server and myisamchk? Gordon L. Burditt - 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
Re: MySQL vs. NFS locking
At 9:11 AM -0500 10/2/01, [EMAIL PROTECTED] wrote: How dependent is MySQL on proper NFS locking between threads of the same server? Running MySQL over NFS is a bad idea. -- Paul DuBois, [EMAIL PROTECTED] - 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
Re: MySQL on NFS?
On Fri, Jun 29, 2001 at 03:33:16PM -0400, Web Mailing List wrote: Hi, everybody here, Anybody can help with telnet to Linux and login to mySQL, show information about current mysql setting, create new DB, and table? What on earth does this have to do with MySQL on NFS? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 15 days, processed 117,652,545 queries (86/sec. avg) - 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
Re: MySQL on NFS?
On Sun, Jul 01, 2001 at 08:04:41PM -0700, Jeremy Zawodny wrote: On Fri, Jun 29, 2001 at 03:33:16PM -0400, Web Mailing List wrote: Hi, everybody here, Anybody can help with telnet to Linux and login to mySQL, show information about current mysql setting, create new DB, and table? What on earth does this have to do with MySQL on NFS? I wondered about that too. I managed to find the list archives so I answered my own questions. -- Kelsey Cummings - [EMAIL PROTECTED] sonic.net System Administrator300 B Street, Ste 101 707.522.1000 (Voice)Santa Rosa, CA 95404 707.547.2199 (Fax) http://www.sonic.net/ Fingerprint = 7F 59 43 1B 44 8A 0D 57 91 08 73 73 7A 48 90 C5 - 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
Re: MySQL on NFS?
On Sun, Jul 01, 2001 at 08:12:37PM -0700, Kelsey Cummings wrote: On Sun, Jul 01, 2001 at 08:04:41PM -0700, Jeremy Zawodny wrote: On Fri, Jun 29, 2001 at 03:33:16PM -0400, Web Mailing List wrote: Hi, everybody here, Anybody can help with telnet to Linux and login to mySQL, show information about current mysql setting, create new DB, and table? What on earth does this have to do with MySQL on NFS? I wondered about that too. I managed to find the list archives so I answered my own questions. Great. I was just about to answer you. :-) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 15 days, processed 117,765,548 queries (86/sec. avg) - 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
Re: MySQL on NFS?
On Sun, Jul 01, 2001 at 08:21:39PM -0700, Jeremy Zawodny wrote: On Sun, Jul 01, 2001 at 08:12:37PM -0700, Kelsey Cummings wrote: On Sun, Jul 01, 2001 at 08:04:41PM -0700, Jeremy Zawodny wrote: On Fri, Jun 29, 2001 at 03:33:16PM -0400, Web Mailing List wrote: Hi, everybody here, Anybody can help with telnet to Linux and login to mySQL, show information about current mysql setting, create new DB, and table? What on earth does this have to do with MySQL on NFS? I wondered about that too. I managed to find the list archives so I answered my own questions. Great. I was just about to answer you. :-) Well, just to be clear then, lots of people are using NetApp NFS backends to thier MySQL servers and I didn't read of one 'problem' with it. So, go ahead and do it, right? -- Kelsey Cummings - [EMAIL PROTECTED] sonic.net System Administrator300 B Street, Ste 101 707.522.1000 (Voice)Santa Rosa, CA 95404 707.547.2199 (Fax) http://www.sonic.net/ Fingerprint = 7F 59 43 1B 44 8A 0D 57 91 08 73 73 7A 48 90 C5 - 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
Re: MySQL on NFS?
On Sun, Jul 01, 2001 at 08:25:01PM -0700, Kelsey Cummings wrote: I wondered about that too. I managed to find the list archives so I answered my own questions. Great. I was just about to answer you. :-) Well, just to be clear then, lots of people are using NetApp NFS backends to thier MySQL servers and I didn't read of one 'problem' with it. So, go ahead and do it, right? Exactly. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 15 days, processed 118,851,917 queries (86/sec. avg) - 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
MySQL on NFS?
I'm sure this is been covered before but I couldn't find any list archives. I've just aquired a pair of clustered NetApp 740's for a steal of a deal and now I'm trying to figure out what I can migrate to them. The thought occured to me that since Oracle performs so well on NetApps over NFS that perhaps I could move my MySQL databases. The documentation has the expected warnings against NFS and file locking, but doesn't really get into any details. Are people running MySQL with a NFS backend? Any comments? -- Kelsey Cummings - [EMAIL PROTECTED] sonic.net System Administrator300 B Street, Ste 101 707.522.1000 (Voice)Santa Rosa, CA 95404 707.547.2199 (Fax) http://www.sonic.net/ Fingerprint = 7F 59 43 1B 44 8A 0D 57 91 08 73 73 7A 48 90 C5 - 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
Re: MySQL on NFS?
Hi, everybody here, Anybody can help with telnet to Linux and login to mySQL, show information about current mysql setting, create new DB, and table? Since, I am using MSSQL under NT platform, it is pretty much different.. Thanks lot Amy - Original Message - From: Kelsey Cummings [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 29, 2001 3:21 PM Subject: MySQL on NFS? I'm sure this is been covered before but I couldn't find any list archives. I've just aquired a pair of clustered NetApp 740's for a steal of a deal and now I'm trying to figure out what I can migrate to them. The thought occured to me that since Oracle performs so well on NetApps over NFS that perhaps I could move my MySQL databases. The documentation has the expected warnings against NFS and file locking, but doesn't really get into any details. Are people running MySQL with a NFS backend? Any comments? -- Kelsey Cummings - [EMAIL PROTECTED] sonic.net System Administrator300 B Street, Ste 101 707.522.1000 (Voice)Santa Rosa, CA 95404 707.547.2199 (Fax) http://www.sonic.net/ Fingerprint = 7F 59 43 1B 44 8A 0D 57 91 08 73 73 7A 48 90 C5 - 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
mysql over nfs on netapp filer
Hi there, i anybody out there running mysql on a netapp filer as data storage? regards Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - 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
Re: mysql over nfs on netapp filer
Sven Huster wrote: Hi there, i anybody out there running mysql on a netapp filer as data storage? Yes, I've done this for a client from a linux server. Worked fine as long as there was only one mysql server accessing the data. The network as 100 Mbs, and the SQL volume was pretty low. --Josh _ Joshua Chamas Chamas Enterprises Inc. NodeWorks free web link monitoring Huntington Beach, CA USA http://www.nodeworks.com1-714-625-4051 - 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
Re: mysql over nfs on netapp filer
Am 00:20 30.03.2001 schrieb Joshua Chamas: *This message was transferred with a trial version of CommuniGate(tm) Pro* Sven Huster wrote: Hi there, i anybody out there running mysql on a netapp filer as data storage? Yes, I've done this for a client from a linux server. Worked fine as long as there was only one mysql server accessing the data. The network as 100 Mbs, and the SQL volume was pretty low. Hi, my problem is that now the second time the performance of my f740 goes down every day. i solved the prob with increasing maxfiles (no to the max for the volume). after that the cpu of the filer, which went up from 25% peak to 90% peak in 5 days, goes down again. any ideas why this happens? next time i will have no possiblity to increase maxfiles again. i am sure it depends on mysql cause the other things running there at the moment are doing nearly nothing. thanks regards Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - 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
Re: mysql over nfs on netapp filer
Yep, what do you need ?
Sven Huster wrote:
Hi there,
i anybody out there running mysql on a netapp filer as data storage?
regards
Sven Huster
Senior Unix System Administrator
*BSD, Linux, Solaris
-
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
--
--
Antonio Gulli'Ideare S.p.a tel: (+39) 050 575300
[EMAIL PROTECTED] Lungarno Mediceo 56 fax: (+39) 050 575583
whois: AG2-ORG I-56126 Pisa, Italy http://www.ideare.com net:
print pack"C*",split/\D+/,`echo "16iII*o\U@{$/=$z;[(pop,pop,unpack"H*",
)]}\EsMsKsN0[lN*1lK[d2%Sa2/d0X+d*lMLa^*lN%0]dsXx++lMlN/dsM0J]dsJxp"|dc`
-
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
Re: mysql over nfs on netapp filer
Hi, my problem is that now the second time the performance of my f740 goes down every day. i solved the prob with increasing maxfiles (no to the max for the volume). after that the cpu of the filer, which went up from 25% peak to 90% peak in 5 days, goes down again. any ideas why this happens? next time i will have no possiblity to increase maxfiles again. i am sure it depends on mysql cause the other things running there at the moment are doing nearly nothing. thanks regards Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris Sven, 1) what is ther server you are using? 2) what kind of nfs ? 3) have you played with read_buffer and write_buffer nfs options ? 4) What kind of tables are you defining ? - 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
Mysql over NFS
I am trying to setup some sort of loadbalancing and more importantly fail-over-services for my mysql servers. I would like to have all the data stored on a RAID interface that will mirror the data and provide the data to two separate mysql daemons on two separate boxes. That way if one daemon or machine fails the other daemon can access the independent RAID. Is this possible and will two mysql daemons play nicely with each other when accessing data on a drive shared between the two computers? Essentially, can two mysql daemons play nicely with mysql data over a RAID or NFS? TIA, Nathan Cook [ [EMAIL PROTECTED] ] - 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
Re: Mysql over NFS
Nope... It's stated explicitly in the docs that this is a *Bad Idea* (with caps, even! *grin*). You'll need to look at other options - replication, possibly, either on to the same machine with your db on a different drive, or (probably preferable) onto a seperate box. regards, P On Tue, 6 Feb 2001, Nathan Cook wrote: I am trying to setup some sort of loadbalancing and more importantly fail-over-services for my mysql servers. I would like to have all the data stored on a RAID interface that will mirror the data and provide the data to two separate mysql daemons on two separate boxes. That way if one daemon or machine fails the other daemon can access the independent RAID. Is this possible and will two mysql daemons play nicely with each other when accessing data on a drive shared between the two computers? Essentially, can two mysql daemons play nicely with mysql data over a RAID or NFS? TIA, Nathan Cook [ [EMAIL PROTECTED] ] - 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
