MySQL over NFS: performance?

2003-06-27 Thread honema
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

Re: MySQL over NFS: performance?

2003-06-27 Thread Jeremy Zawodny
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

MySQL over NFS

2002-08-20 Thread Luis Calero
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

Re: MySQL over NFS

2002-08-20 Thread Tod Harter
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

Re: MySQL over NFS

2002-08-20 Thread Brian Moon
, 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

Re: MySQL over NFS

2002-08-20 Thread Brian Moon
] 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

Re: MySQL over NFS

2002-08-20 Thread Thomas Seifert
: 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

Re: MySQL over NFS

2002-08-20 Thread lcalero
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

Re: MySQL over NFS

2002-08-20 Thread Brian Moon
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

mysql over nfs on netapp filer

2001-03-29 Thread Sven Huster
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

Re: mysql over nfs on netapp filer

2001-03-29 Thread Joshua Chamas
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

Re: mysql over nfs on netapp filer

2001-03-29 Thread Sven Huster
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

Re: mysql over nfs on netapp filer

2001-03-29 Thread Antonio Gulli
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

Re: mysql over nfs on netapp filer

2001-03-29 Thread Antonio Gulli
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

Mysql over NFS

2001-02-06 Thread Nathan Cook
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

Re: Mysql over NFS

2001-02-06 Thread Peter Skipworth
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