On Wednesday 07 November 2007, Charles Jardine wrote:
> I am planning to set up a system in which mysql servers access
> their data via NFS. All the computers involved run Solaris 10.
> NFS version 4 will be used.
>
> I plan to ensure that no NFS share is ever mounted by more th
Hi Charles, all !
Charles Jardine wrote:
I am planning to set up a system in which mysql servers access
their data via NFS. [[...]]
If you want to use this for testing or development - fine.
If you want to run performance measurements on this - silly.
If you want to use it for "produ
Charles Jardine wrote:
I am planning to set up a system in which mysql servers access
their data via NFS. All the computers involved run Solaris 10.
NFS version 4 will be used.
I plan to ensure that no NFS share is ever mounted by more than
one client computer, and that no client computer ever
I am planning to set up a system in which mysql servers access
their data via NFS. All the computers involved run Solaris 10.
NFS version 4 will be used.
I plan to ensure that no NFS share is ever mounted by more than
one client computer, and that no client computer ever runs more
than one mysql
Thanks for the help Michael,
The data directory is really configured to /var/lib/mysql, and the
database name is area2.
I'm mounting the subdirectory of the database.
When I mount the nfs file system I don't get any error.
Thanks,
Douglas
2007/7/6, Michael Dykman <[EMAIL PROT
2/*
>
> on your mySQL host, what are the permissions and ownership of the
> files? These can get a little tricky under NFS as th on-disk file
> will store the owner's UID. That UID may have different meaning on
> the file host as opposed to the SQL host if the users and groups
<[EMAIL PROTECTED]>:
Again, I have no light-bulb on this but let's try a few things.
if you do
$ ls -ld /var/lib/mysql/area2
$ ls -ld /var/lib/mysql/area2/*
on your mySQL host, what are the permissions and ownership of the
files? These can get a little tricky under NFS as th on-disk file
Again, I have no light-bulb on this but let's try a few things.
if you do
$ ls -ld /var/lib/mysql/area2
$ ls -ld /var/lib/mysql/area2/*
on your mySQL host, what are the permissions and ownership of the
files? These can get a little tricky under NFS as th on-disk file
will store the owner&
ory is the default point, /var/lib/mysql.
>
> I have a NFS mount point in /var/lib/mysql/area2, that mounts the
> directory of a storage, when I mount the NFS, the MySQL server don't
> show the database.
>
> Anyone can help me?
>
> Thanks,
>
> Douglas
>
>
What i the error you seeing the error log file.
Please let us know
On 7/5/07, Douglas Araujo <[EMAIL PROTECTED]> wrote:
Hi everybody,
I have a MySQL 4.1 running on a Red Hat Linux Enterprise 4 that the
databases directory is the default point, /var/lib/mysql.
I have a NFS mount po
Hi everybody,
I have a MySQL 4.1 running on a Red Hat Linux Enterprise 4 that the
databases directory is the default point, /var/lib/mysql.
I have a NFS mount point in /var/lib/mysql/area2, that mounts the
directory of a storage, when I mount the NFS, the MySQL server don't
show the dat
ginal Message-
From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
Sent: Monday, March 26, 2007 12:06 PM
To: 'David Ruggles'; mysql@lists.mysql.com
Subject: RE: Select into outfile on nfs mount point
Can you "touch" the file name? It might be a permission issue at the
dire
, March 26, 2007 12:37 PM
To: David Ruggles
Subject: RE: Select into outfile on nfs mount point
>>> Date: Monday, March 26, 2007 11:50:59 AM -0400
>>> From: David Ruggles <[EMAIL PROTECTED]>
>>> To: mysql@lists.mysql.com
>>> Subject: Select into outfile
ECTED]
[mailto:[EMAIL PROTECTED]
Sent: Monday, March 26, 2007 12:01 PM
To: David Ruggles
Subject: Re: Select into outfile on nfs mount point
the file on the mount point has to be able to be created, and
read/write by the user that is invoking the mysql call. e.g., if this
is begin done at the comman
m: David Ruggles [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 26, 2007 11:51 AM
> To: mysql@lists.mysql.com
> Subject: Select into outfile on nfs mount point
>
> I'm unable to select into an outfile, the path is in an nfs
> mount point. I'm
> sure it's some s
I'm unable to select into an outfile, the path is in an nfs mount point. I'm
sure it's some sort of permissions issue or something, but I can't figure it
out. I've googled everything I can think of and haven't found anything. Any
help or suggestions would be great
At 02:05 PM 7/25/2006, Winn Johnston wrote:
after talking to a few people on the #mysql irc
someone suggested using NFS to create a ramfs to get
100GB+ RAM shared memory to load the entire database
into the RAM. Can anyone offer any Pros or Cons to
this setup, drawing from personal expierence
o
> use shared memory spread out over a few machines.
>
> scenerio,
>
> Huge database, over 7 million records. And a high
> ratio of writes vs reads. Idealy i would like to
> have
> the entire database in RAM. Does anyone have any
> experience running a database this big? c
Actually - I have some more details to make this clearer:
We will be using UnixODBC - already installed on a NFS mount, and the MySQL
drivers. So, could we install the MySQL drivers on the NFS Mount?
Thanks again - Gabe
-Original Message-
From: [EMAIL PROTECTED]
Sent: Wednesday, May
Hello All
I am about to set up ODBC for MySQL (iODBC) on our UNIX systems. We have many
machines that will need to use this installation. I would like to leverage a
NFS mount that is available to all the machines. We currently leverage the NFS
mount for a MySQL Client.
I am wondering if
It means totally read only. File locking in general is sketchy at
best. Over NFS it's a train wreck.
-Eric
On Tue, 12 Oct 2004 11:03:06 -0700, Steve Francis
<[EMAIL PROTECTED]> wrote:
> I'd like to have the data store on a netapp NFS server.
> One writer mysql machine,
I'd like to have the data store on a netapp NFS server.
One writer mysql machine, with external-locking, and one (or more)
machines that do read only queries.
Will the read-only machines get consistent data from their queries?
The docs say only " Make it easy for yourself: Forget about
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 31 May 2004 12:08 pm, Kirti S. Bajwa wrote:
> Hello List:
>
> I want to setup two servers (later more servers added) sharing mysql data
> as a NFS Server & Client relationship;
There is a document on the mysql web site th
Hello List:
I want to setup two servers (later more servers added) sharing mysql data as
a NFS Server & Client relationship;
Server-A:
--
RH9, mysql-4.0.20, NFS Master
This server is a DATA server. All data for the entire site is kept on this
server in "/usr/local/mysql/var&
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
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
On Mon, 1 Sep 2003 15:40:09 +0100
Simon Green <[EMAIL PROTECTED]> wrote:
> Hi
> I know that there are two problems when using NFS and MySQL.
> One is speed.
> My question is that with a good filer like a Netapps with Gig Ethernet would
> speed stop being a problem?
>
Hi
I know that there are two problems when using NFS and MySQL.
One is speed.
My question is that with a good filer like a Netapps with Gig Ethernet would
speed stop being a problem?
Two locking.
Why is this a problem? Do locks get missed when righting from the system to
the filer?
Thanks for
Steven,
Don't use NFS, bad idea.
You can do the master writer/multi reader, but it's always been a
problem making sure every reader is up to date. You need to have a way
to verify this manually.
If your really going to max out your platform there's other platforms to
look at
I am mildly surprised that nobody has answered this yet - bit you did post
on the weekend - so I will put in my $0.02.
On http://www.mysql.com/doc/en/Multiple_servers.html your NFS idea is
described as "a bad idea". I concur. I believe that MySQL makes a lot of
use of cacheing - locki
there a
simple tool to use to determine the actual ratio.
2. When I want to scale up the mysql server what are the pros/cons of each of the
following:
a. Create an NFS server on the backend and load balance several mysql servers
all accessing
the same database files via NFS (is this even
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
> wit
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..
I have mysql installed and working on Solaris 9 using the binaries from the
mysql site. I have an NFS server running under Debian GNU/Linux 3.0. I am
able to mount NFS mounts on the Solaris box from the Linux box without any
problems. I'm able to read/write without incident.
Now here come
MAIL 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
> 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 becau
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 tha
AIL 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 believ
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
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
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
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
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 m
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 mysq
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 MyS
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 p
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
e 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-7
; > > 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
h 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
g, 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 St
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?
mings" <[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 stea
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
:47:27AM +0200, Stepan Havel wrote:
>
> The answers I find are on the one hand: Yes, it works perfectly, I
> run mysql on a Netapp filer for hunderts of years! , or on the other
> hand: It simply does not work with nfs and locking it core dumps
> inconsistent isam files and so on!
>
On Tue, Jun 19, 2001 at 09:47:27AM +0200, Stepan Havel wrote:
>
> The answers I find are on the one hand: Yes, it works perfectly, I
> run mysql on a Netapp filer for hunderts of years! , or on the other
> hand: It simply does not work with nfs and locking it core dumps
> inconsis
The answers I find are on the one hand: Yes, it works perfectly, I run mysql
on a Netapp filer for hunderts of years! , or on the other hand: It simply
does not work with nfs and locking it core dumps inconsistent isam files and
so on!
Do you feel my problem? :-)
Stepan
-Ursprungliche
On Tue, Jun 19, 2001 at 09:27:15AM +0200, Stepan Havel wrote:
> Hi Ladies and Gents,
>
> does anybody has experience with mysql + nfs, or mysql + Nettapp
> Storage?
Several folks on this list (or who *were* on this list) do, yes. Check
the list archives and see if you find the answ
Hi Ladies and Gents,
does anybody has experience with mysql + nfs, or mysql + Nettapp Storage?
thx for feedback,
Stepan
Stepan Havel
Nextra Telekom GmbH
Kirchberggasse 33
1070 Vienna
Tel: +43-1-52533-837
Fax: +43-1-52533-100
Mobile: +43-699-15253-837
ious,
Harmen
> > > > As far as i know, DON'T DO THIS
> > > > mysql with serveral instances accessing the same database will not work
> > > > as expected.
> > > >
> > > > check
> > > > http://www.mysql.com/doc/M/u/Multiple_serve
gt; > > As far as i know, DON'T DO THIS
> > > mysql with serveral instances accessing the same database will not work
> > > as expected.
> > >
> > > check
> > > http://www.mysql.com/doc/M/u/Multiple_servers.html
> >
> > Th
'll skip the plan. No load-balancing for me thus :>
> we run mysql over nfs but only with one instance.
> seems to be quite stable (db server freebsd - nfs server netapp filer)
>
> regards
>
> Sven Huster
> Senior IT Systems Engineer
>
>
>
> > -O
Hi
As far as i know, DON'T DO THIS
mysql with serveral instances accessing the same database will not work
as expected.
check
http://www.mysql.com/doc/M/u/Multiple_servers.html
we run mysql over nfs but only with one instance.
seems to be quite stable (db server freebsd - nfs server n
Hello,
I have an idea about setting up 1 machine that contains the var-directory (RAID5 for
backup, etc). Then I mount the var directory from 2 (to explain now :>) other servers,
via NFS, and run mysqld on those.
My question : is this going to work ? I mean, will mysqld allow me to hav
> 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 ?
-
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
>
>
> -
>
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. Wo
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
prett
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 (th
EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 4:18 PM
Subject: 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
ially, 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 (t
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
72 matches
Mail list logo
