toasters

toasters@lists.teaparty.net

13520 discussions

RE: SQL Database on Filer ??
by Tom "Mad Dog" Yergeau 06 Jun '01

06 Jun '01

We've typically seen performance increases when moving from local storage to the filer. What kind of pipe are you using? If you're using 100 Mbps Ethernet, you'll see a performance hit since that's at best 8 MB/sec network throughput, which is trivial compared to local attach. If you are using gigabit Ethernet you should see excellent performance. Also how many disks are you using? Just like with local storage, more spindles = better performance. Are you using a private (or at least dedicated) network connection for the SQL Server to filer connection? If you're sending SQL queries to the box on the same interface that is talking to the filer that could cause significant performance degradation. Finally are you using OLTP or OLAP databases with the filer? (i.e. random or sequential reads?) NetApp folks might disagree but I think WAFL is a bad thing to mix with OLAP if you're using snapshots. It's great, absolutely phenomenal for OLTP, but sequential reads are not a filer's strong point (that's why it's called write ANYWHERE file layout, not "Write In Order and Minimize Fragmentation File Layout"). (Please no flames on how WAFL minimizes fragmentation--if you're using snapshots and you change any data in a database, the new data will be written elsewhere than the original disk location, causing the head to jump around like mad during what should be sequential reads. A copy-on-write snapshot would be MUCH better in this scenario.) Tell us more about your configuration so we can try to figure out why you're seeing problems. Also try pinging your sales rep, NetApp has people dedicated to making SQL Server work well with filers and I'm sure you could get some pointers from them. MD -----Original Message----- From: Dale Wolf [mailto:wolfd@agcs.com] Sent: Tuesday, June 05, 2001 7:32 PM To: toasters(a)mathworks.com Subject: SQL Database on Filer ?? Has anyone placed a SQL database on a filer and seen a significant performance increase of 10% or more or a performance decrease of 10% or more? Our initial test of a source change management application using a SQL database on our filer showed a significant decrease in performance to the tune of 2-3 times slower than a local storage array. We understand ours wasn't an apples to apples comparison but we weren't expecting the difference to be this great. Has anyone else experienced a similar story where they have seen negative/positive results they would like to share? Our filer is a model F840.

3 2

Changing UIDs on LOTS of files
by Tom "Mad Dog" Yergeau 06 Jun '01

06 Jun '01

You might remember my bringing up a lot of questions about dealing with huge numbers of inodes to support an application we use. Well, now that application has another interesting need. They are starting to use NIS on a bunch of the application servers and so have the change the UIDs on MILLIONS of files and directories on our F840. Obviously the usual methods (chmod, chgrp) are exceedingly slow for something like this.. we could be at it for weeks. Can anyone suggest a method to change the uid and gid on massive quantities of files/directories more quickly? Thanks! Tom

4 3

list delays
by fubar＠pir.net 06 Jun '01

06 Jun '01

People may have noticed some rather lengthy delays on the mailing list. The MathWorks recently deployed a virus scanning solution between their real mail server and The Rest of The World. This seems to be slowing things down rather a lot; hopefully, this won't last too long, but I'll try to keep everyone up to date... K. owner-toasters

1 0

SQL Database on Filer ??
by Dale Wolf 05 Jun '01

05 Jun '01

Has anyone placed a SQL database on a filer and seen a significant performance increase of 10% or more or a performance decrease of 10% or more? Our initial test of a source change management application using a SQL database on our filer showed a significant decrease in performance to the tune of 2-3 times slower than a local storage array. We understand ours wasn't an apples to apples comparison but we weren't expecting the difference to be this great. Has anyone else experienced a similar story where they have seen negative/positive results they would like to share? Our filer is a model F840.

1 0

RE: Renaming a Qtree
by Fox, Adam 05 Jun '01

05 Jun '01

You can rename a qtree by simply rename the top level directory. So if you're qtree is /vol/vol0/mytree. >From an NFS or CIFS client, rename that mytree directory to something else. Just watch your /etc/exports, CIFS share points, and your /etc/quotas file since you've changed something underneath them. But you should be able to avoid moving data from one tree to another. -- Adam Fox NetApp Professional Services, NC adamfox(a)netapp.com > -----Original Message----- > From: Dale Wolf [mailto:wolfd@agcs.com] > Sent: Tuesday, June 05, 2001 4:15 PM > To: toasters(a)mathworks.com > Subject: Renaming a Qtree > > > The web interface doesn't provide a Qtree rename option. Is > there a way > to rename a Qtree > without having to create a new Qtree, copy the data, and deleting the > old Qtree? I have been told this copy process is the only > way to rename > a Qtree. > >

1 0

RE: ndmpcopy
by White, Lance 05 Jun '01

05 Jun '01

Have you enabled NDMPD on both Filers? "ndmpd on" as per http://now.netapp.com/NOW/knowledge/docs/ontap/rel61r1/html/dpg/ndmp4.htm -----Original Message----- From: Joseph Foy [mailto:Joseph.Foy@worldwidepackets.com] Sent: Tuesday, June 05, 2001 10:15 AM To: 'toasters(a)mathworks.com' Subject: ndmpcopy Thanks to all who sent me references to where to get ndmpcopy! Now I'm having another brainless moment - when I run it as shown below giving it source and destination passwords, and having all machines (the sun and both filer1 and filer2) in each other's hosts, hosts.equiv, and .rhosts files, I still get the error message shown at the bottom. I can rsh the filers all day and dump between filers works fine. example: ======================= mysun# ./ndmpcopy Source and destination filer names and paths are required. Usage: ndmpcopy src_filer:/src/dir dest_filer:/dest/dir [-sa none | user:password] [-da none | user:password] [-sport ndmp_src_port] [-dport ndmp_dest_port] [-dhost ndmp_dest_ip_addr] [-level ndmp_dump_level] [-v] [-q] [-dpass] [-h] Defaults: src_auth_type = text src_auth_user = root src_auth_password = dest_auth_type = text dest_auth_user = root dest_auth_password = ndmp_src_port = 0 (0 means NDMP default, usually 10000) ndmp_dest_port = 0 (0 means NDMP default, usually 10000) ndmp_dump_level = 0 (valid range: 0 - 9) ndmp_dest_ip_addr = (no default: user needs to override dest_filer value) verbosity = noisy different_passwords = no mysun# ./ndmpcopy filer1:/home/tools filer2:/home/tools -sa root:rootpass -da root:rootpass -level 0 -v Connecting to filer1. Connecting to filer2. Error starting backup, error: Error: Connection has not been authorized mysun# _____________________________________________________ Joseph Foy / Systems Administrator / World Wide Packets Beaverton, Oregon / 503-748-0521 / joseph.foy(a)wwp.com fax # 503-748-0510 http://www.wwp.com

1 0

ndmpcopy
by Joseph Foy 05 Jun '01

05 Jun '01

Thanks to all who sent me references to where to get ndmpcopy! Now I'm having another brainless moment - when I run it as shown below giving it source and destination passwords, and having all machines (the sun and both filer1 and filer2) in each other's hosts, hosts.equiv, and .rhosts files, I still get the error message shown at the bottom. I can rsh the filers all day and dump between filers works fine. example: ======================= mysun# ./ndmpcopy Source and destination filer names and paths are required. Usage: ndmpcopy src_filer:/src/dir dest_filer:/dest/dir [-sa none | user:password] [-da none | user:password] [-sport ndmp_src_port] [-dport ndmp_dest_port] [-dhost ndmp_dest_ip_addr] [-level ndmp_dump_level] [-v] [-q] [-dpass] [-h] Defaults: src_auth_type = text src_auth_user = root src_auth_password = dest_auth_type = text dest_auth_user = root dest_auth_password = ndmp_src_port = 0 (0 means NDMP default, usually 10000) ndmp_dest_port = 0 (0 means NDMP default, usually 10000) ndmp_dump_level = 0 (valid range: 0 - 9) ndmp_dest_ip_addr = (no default: user needs to override dest_filer value) verbosity = noisy different_passwords = no mysun# ./ndmpcopy filer1:/home/tools filer2:/home/tools -sa root:rootpass -da root:rootpass -level 0 -v Connecting to filer1. Connecting to filer2. Error starting backup, error: Error: Connection has not been authorized mysun# _____________________________________________________ Joseph Foy / Systems Administrator / World Wide Packets Beaverton, Oregon / 503-748-0521 / joseph.foy(a)wwp.com fax # 503-748-0510 http://www.wwp.com

1 0

Please help with this "simple" problem.
by Bokkelkamp Ernst SBS ITS GDP 2 14 05 Jun '01

05 Jun '01

I "playing" with an F760 and NDMP backup, but I am only the backup administrator, my filer knowledge is limited. I doing a three-way NDMP session, the source is the F760 and the tapes are on a Celerra. All machines have 100TX and GigE, normal network connection is the 100TX network which is registered in WINS and DNS, the GigE is a private backup network that is normally used to mount the CIFS shares on a Networker Storage Node for a CIFS based backup. Can somebody tell me how I can see on the filer which interface is being used to transfer the data between the machines ? I am looking for something similar to sysstat but instead to display the information on transfer rate of each interface at regular intervals. Bye Ernst

1 0

RE: compiled version of ndmpcopy
by Coartney, Paul 05 Jun '01

05 Jun '01

The makefile at the root doesn't work, compile cd into the lib directory and compile the libraries, and then cd into src and compile the source. My preference is to make a bin directory and mv or ln the binary there. Paul P.S. Let me know if this doesn't work for you and I will send you the compiled version. -----Original Message----- From: Joseph Foy [mailto:Joseph.Foy@worldwidepackets.com] Sent: Tuesday, June 05, 2001 9:22 AM To: 'toasters(a)mathworks.com' Subject: compiled version of ndmpcopy Greetings all, Does anyone know of a source for ndmpcopy that is a compiled binary for Solaris? I have been trying to compile all of the versions of ndmpcopy that I can find at www.ndmp.org on my Sun server, but using gcc and several different versions of make hasn't worked. I cannot use vol copy as both my source and destination filers have only one volume, and the root volume can't be taken offline for the destination. Joseph Foy / Systems Administrator / World Wide Packets Beaverton, Oregon / 503-748-0521 / joseph.foy(a)wwp.com fax # 503-748-0510 http://www.wwp.com

1 0

RE: compiled version of ndmpcopy
by Smith, A Michael (CS) 05 Jun '01

05 Jun '01

Yes. ftp.netapp.com/pub/ndmpcopy/ download the file called ndmpcopy.Z uncompress the file on your solaris platform. chomd u+x ndmpcopy to make it executable. Then to test to make sure it works you can just execute "ndmpcopy" you should see a usage statement returned. Mike Smith -----Original Message----- From: Joseph Foy [mailto:Joseph.Foy@worldwidepackets.com] Sent: Tuesday, June 05, 2001 9:22 AM To: 'toasters(a)mathworks.com' Subject: compiled version of ndmpcopy Greetings all, Does anyone know of a source for ndmpcopy that is a compiled binary for Solaris? I have been trying to compile all of the versions of ndmpcopy that I can find at www.ndmp.org on my Sun server, but using gcc and several different versions of make hasn't worked. I cannot use vol copy as both my source and destination filers have only one volume, and the root volume can't be taken offline for the destination. Joseph Foy / Systems Administrator / World Wide Packets Beaverton, Oregon / 503-748-0521 / joseph.foy(a)wwp.com fax # 503-748-0510 http://www.wwp.com

1 0

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

2000

1999

1998

1997

toasters