toasters

toasters@lists.teaparty.net

13531 discussions

Re: MySQL or PostgreSQL with Filer storage?
by slinkymax0r 09 Dec '06

09 Dec '06

> We'd like to have our database storage resident on a Filer with > NFS. Do any of you have experience or insight into this for MySQL or > PostgreSQL? I understand Oracle's happy to work like this but my > google searches seem to indicate it's a bad idea to use NFS storage > for PostgreSQL or MySQL. As long as you're not sharing the data files between multiple database servers, this should work fine, with the understanding that it "won't be as fast" (greater latency) necessarily as local/block disk. The normal caveats for DB stuff applies, no softmounts, use TCP, Use GbE etc. etc. etc. Regards, Max > > Thanks. > > http://www.postgresql.org/files/documentation/books/aw_pgsql/hw_performance… > > NFS and other remote file systems are not recommended for use by > POSTGRESQL. NFS does not have the same file system semantics as a > local file system, and these inconsistencies can cause data > reliability or crash recovery problems. > > http://dev.mysql.com/doc/refman/5.0/en/multiple-servers.html > > The warning against sharing a data directory among servers also > applies in an NFS environment. Allowing multiple MySQL servers to > access a common data directory over NFS is a very bad idea. > > * The primary problem is that NFS is the speed bottleneck. It is > not meant for such use. >

1 0

MySQL or PostgreSQL with Filer storage?
by Chris Shenton 08 Dec '06

08 Dec '06

We'd like to have our database storage resident on a Filer with NFS. Do any of you have experience or insight into this for MySQL or PostgreSQL? I understand Oracle's happy to work like this but my google searches seem to indicate it's a bad idea to use NFS storage for PostgreSQL or MySQL. Thanks. http://www.postgresql.org/files/documentation/books/aw_pgsql/hw_performance… NFS and other remote file systems are not recommended for use by POSTGRESQL. NFS does not have the same file system semantics as a local file system, and these inconsistencies can cause data reliability or crash recovery problems. http://dev.mysql.com/doc/refman/5.0/en/multiple-servers.html The warning against sharing a data directory among servers also applies in an NFS environment. Allowing multiple MySQL servers to access a common data directory over NFS is a very bad idea. * The primary problem is that NFS is the speed bottleneck. It is not meant for such use.

1 0

user permissions
by John Sfetsoris 08 Dec '06

08 Dec '06

hello everybody there is a filer fas960 with ontap 7.0.4. I want to create an account that only can monitor volume and snapshot spaces, and in case of volume full, to be able to delete snapshots, and all these only via http. However , if i create an account using useradmin comand with allowed capabilities only login-http-admin, this account, among other things, can perform volume and aggregate deletion, have access to etc/hosts, etc/hosts.equiv, e.t.c. Is somehow possible to restrict this account to specified capabilities? It is possible via telnet, but what about http? thnks in advance John Sfetsoris

2 1

RE: user permissions
by Holloway, Chris 08 Dec '06

08 Dec '06

I had the exact same problem where the restrictions were perfect using the CLI but had no effect on FilerView. Turned out to be bug id 167183 which is still not fixed. Chris -----Original Message----- From: owner-toasters(a)mathworks.com on behalf of John Sfetsoris Sent: Thu 07/12/2006 14:15 To: toasters(a)mathworks.com Cc: Subject: user permissions hello everybody there is a filer fas960 with ontap 7.0.4. I want to create an account that only can monitor volume and snapshot spaces, and in case of volume full, to be able to delete snapshots, and all these only via http. However , if i create an account using useradmin comand with allowed capabilities only login-http-admin, this account, among other things, can perform volume and aggregate deletion, have access to etc/hosts, etc/hosts.equiv, e.t.c. Is somehow possible to restrict this account to specified capabilities? It is possible via telnet, but what about http? thnks in advance John Sfetsoris Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Employees of the company are expressly required not to make defamatory statements and not to infringe or authorize any infringement of copyright or any other legal right by email communications. Any such communication is contrary to company policy and outside the scope of the employment of the individual concerned. The company will not accept any liability in respect of such communication, and the employee responsible will be personally liable for any damages or other liability arising.

1 0

RE: NFS shares suddenly giving permission denied
by Glenn Walker 08 Dec '06

08 Dec '06

For what it's worth, CIFS probably continued to function for already connected clients because of existing(cached) WAFL credentials and SID cache. If the clients had disconnected, waited 20 minutes and reconnected, I would have expected failure. Domain issues would also explain failure to connect via MMC. Glenn -----Original Message----- From: owner-toasters(a)mathworks.com [mailto:owner-toasters@mathworks.com] On Behalf Of Myles Uyema Sent: Thursday, December 07, 2006 9:45 PM To: Sto Rage(c) Cc: Maglinger, Paul; NetApps list server Subject: Re: NFS shares suddenly giving permission denied bug 139351 does not affect 6.4.5 because it didn't use the same export cache method that 6.5.x does. 6.4 does forward dns lookups the moment you run exportfs -a 6.5 does reverse dns lookups the moment a client sends an RPC, then matches it according to the exportfs access list. Then it addes the IP to its exports cache. It sounds like trying 'cifs resetdc' might be something to do next time, as it looks like it had trouble communicating with the domain controller. On Thu, 7 Dec 2006, Sto Rage(c) wrote: 6.4.5?? Looks like you hit the bug we saw in 2004. Upgrading to 6.5.2 fixed it. Workaround was to add entries in the /etc/hosts file of the filer. look for Bug 139351 related to name resolution. -G On 12/7/06, Maglinger, Paul <PMAGLINGER(a)scvl.com> wrote: > NetApps 740 running 6.4.5. > > All of a sudden starting to get permission denied errors on some of our > NFS shares from our Tru64 Unix servers, not all of them but just some of > them. And with some other weirdness where we could go into the top > level but then get permission denied when trying to list the contents. > The messages file had the following: > > SamrGetGroupsForUsers: Exception rpc_s_unknown_reject caught. > SamrCloseHandle: Exception rpc_s_connection_closed caught. > > and then had a bunch of the following afterwards: > > LsaOpenPolicy2: Exception rpc_s_assoc_grp_max_exceeded caught. > SamrConnect2: Exception rpc_s_assoc_grp_max_exceeded caught. > > CIFS was working fine, but I couldn't hit the filer throught the > Computer Management console on the MMC. I checked processes and > auditing on the Unix side and couldn't tie it down to a specific > instance. Though I hated to do it, we ended up rebooting to restore > services. > I've tried Googling for this in reference to a NetApp box but am coming > up empty handed. Can someone enlighten me on what might have occurred? > > > ________________________________ > > Paul Maglinger, A+, CA, CCA, CET, MCSE > > Systems Administrator > Shoe Carnival Inc. > (812)867-4674 > pmaglinger(a)scvl.com > > > ________________________________ > > > > >

1 0

NFS shares suddenly giving permission denied
by Maglinger, Paul 08 Dec '06

08 Dec '06

NetApps 740 running 6.4.5. All of a sudden starting to get permission denied errors on some of our NFS shares from our Tru64 Unix servers, not all of them but just some of them. And with some other weirdness where we could go into the top level but then get permission denied when trying to list the contents. The messages file had the following: SamrGetGroupsForUsers: Exception rpc_s_unknown_reject caught. SamrCloseHandle: Exception rpc_s_connection_closed caught. and then had a bunch of the following afterwards: LsaOpenPolicy2: Exception rpc_s_assoc_grp_max_exceeded caught. SamrConnect2: Exception rpc_s_assoc_grp_max_exceeded caught. CIFS was working fine, but I couldn't hit the filer throught the Computer Management console on the MMC. I checked processes and auditing on the Unix side and couldn't tie it down to a specific instance. Though I hated to do it, we ended up rebooting to restore services. I've tried Googling for this in reference to a NetApp box but am coming up empty handed. Can someone enlighten me on what might have occurred? ________________________________ Paul Maglinger, A+, CA, CCA, CET, MCSE Systems Administrator Shoe Carnival Inc. (812)867-4674 pmaglinger(a)scvl.com ________________________________

3 2

Lotus Notes
by Andrew Guerra 07 Dec '06

07 Dec '06

Has anyone installed, implemented, deployed Lotus Notes with a NetApp filer? I know there "SnapManager for Lotus Notes" doesn't exist so how can I do this with the same functionality and SME, and SMBR for that matter. I would appreciate any suggestions. Thanks

5 4

RE: Max number of NFS deamons in a FAS270c
by Alan.McLachlan＠ipaustralia.gov.au 07 Dec '06

07 Dec '06

Hi Brian, Number of NFS daamons used by Data OnTAP on any NetApp filer is, and has always been, exactly zero. Note on all NetApp specsfs submissions (www.spec.org/sfs97r1): "NetApp's embedded operating system processes NFS requests from the network layer without any NFS daemons, and uses non-volatile memory to improve performance." Data OnTAP is not Unix, and is not even "based on" any particular Unix, despite a large number of CLI similarities. The microkernal is developed from the ground up as special-purpose. (i.e. this is not a "stripped down" or modified Linux or FreeBSD product like so many others out there). So you can't directly apply many Unix considerations for performance management to Data OnTAP. Alan McLachlan Network and Storage Services, ITI/BIMS IP Australia Ph: (02) 6283 7945 Fax: (02) 6281 1353 Mobile: 0428 655 644 PO Box 200 Woden ACT 2606 website www.ipaustralia.gov.au -----Original Message----- From: owner-toasters(a)mathworks.com [mailto:owner-toasters@mathworks.com] On Behalf Of brian(a)kbsl.lk Sent: Wednesday, 6 December 2006 9:08 PM To: toasters(a)mathworks.com; owner-toasters(a)mathworks.com Subject: Max number of NFS deamons in a FAS270c Does anyone has a figure of max number of NFS deamons supported in a FAS270c. Need to increase number of BOID's in an AIX box. does anyone already have figures of BOID's & NFSD's in a FAS270c with Ontap 7.0.4 with IBM p570 AIX 5.3ML4 or an idea about a max supported figures in terms of max I/O performance for a NAS hosted Oracle 9i database. Thanks Brian. This Mail Has Been Scanned For Virus By Scanmail For Lotus Notes Enterprise/Kbsl -- This message contains privileged and confidential information only for use by the intended recipient. If you are not the intended recipient of this message, you must not disseminate, copy or use it in any manner. If you have received this message in error, please advise the sender by reply e-mail. Please ensure all e-mail attachments are scanned for viruses prior to opening or using.

1 0

SnapVault - Question on hourly vaults
by scott.belisle＠americas.bnpparibas.com 06 Dec '06

06 Dec '06

Hello all, We use a single SnapVault filer as a repository for 6 separate filers. With the nightly SnapVault schedules we are able to balance source filer connection limits by staggering the vaults in between 10pm-6am as the business requirement doesn't dictate a specific time for these to occur overnight. We would like to also move the hourly snapshot schedule to this SnapVault filer. However, the standard daytime snap schedule is at 8,12,16 for all filers, and it can't deviate. We have about 400 qtree's to vault so at 8am when they all try to vault at once I get lots of failures due to source connection limits. We can't stagger these times since the business areas all expect their snap to be from those specific times. We could keep the hourly's on the source filers rather than moving them to our SnapVault filer, but we would like to recoup that expensive FC disk for non-snapshot duties by moving the snaps to cheaper ATA on the SnapVault filer. Any suggestions? The retries are set at 2 and bandwidth is throttled at 100MB/s. Thanks! Scott This message and any attachments (the "message") is intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet can not guarantee the integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the message if modified.

1 0

RE: Lotus Notes
by Oliver Bassett 06 Dec '06

06 Dec '06

Thanks for the CIFS info, I remembered someone mentioning this, but had a hard time finding any documentation on this. You are making out the iSCSI thing out to be a lot worse than it really is. You can mount snapshots as writeable volumes to the server and copy of files out of them into the main LUN. This is particularly easy with SnapDrive, and takes all of 5 minutes to have a snapshot mounted. You can then copy the files off. This makes recovery of individual mailboxes easy, without requiring a lot of space. Additionally to backup, you mount the snapshot of the LUN to a server and read the files off using a host agent rather than just backing up the LUN files, this allows quicker recovery from tape for individual nsf files. All of this is easy to accomplish with SnapDrive. I like the CIFS method as recovery from snapshots is easy, but if you have a lot of traffic this can be an issue (CIFS isn't a particularly fast protocol compared to iSCSI). Anyway just wanted to clear that up a little. Thanks Oliver Bassett Senior Systems Engineer Infinity Solutions Ltd P O Box 3323, Auckland Ph: +64 9 921 8123, Mob: +64 21 574 994 Fax: +64 9 309 4142 www.infinitysolutions.co.nz -----Original Message----- From: Turner, Bryan (Infrastructure) [mailto:Bryan.Turner2@dkib.com] Sent: Wednesday, 6 December 2006 8:18 p.m. To: Oliver Bassett; toasters(a)mathworks.com; Andrew Guerra Subject: RE: Lotus Notes I used to work at a place where we deployed Domino over CIFS. The application worked extremely well and setting this up is almost as easy as using DAS storage. As far as I remember NetApp recommend you use the AUTOEXNT.EXE (resource kit tool) to run a batch file which maps your drive/s when the server starts and you must also run domino as a service rather than an application (a choice during install). Domino is happy to access data files on mapped drives. Don't forget if you decide to use iSCSI you have to have an area big enough on your filer to restore the entire LUN just to retrieve one email (potentially). Also, your user would have to wait for the entire LUN to be restored from tape if you don't have a snapshot available. Flexclone may help with this but I'm not sure as I've not used it. The beauty of this is that restore can be done easily and quickly from regular snapshots as .NSF files are pretty robust. As far as clustering goes I would recommend using Domino application clustering over windows clustering especially if you have more than one site with decent bandwidth between them. It will give you a full DR solution and means you don't have to buy a snapmirror license if your using the filer exclusively for Domino as domino can handle replication pretty efficiently. I also recommend that if you have roaming profiles hosted on a filer you keep your users personal notes data files (there are about 4 or 5 main ones such as address book) somewhere in the profile. Just means you can recover these just as easily. Hope that helps. -----Original Message----- From: owner-toasters(a)mathworks.com [mailto:owner-toasters@mathworks.com] On Behalf Of Oliver Bassett Sent: 05 December 2006 21:49 To: toasters(a)mathworks.com; Andrew Guerra Subject: RE: Lotus Notes Andrew, I worked with a customer here to deploy NetApp storage with their existing Notes on Windows installation. The Notes databases are effectively files rather than open databases, so SnapDrive initiated snapshots are sufficient for recovery without having to quiesce them. The implementation we used was a LUN mapped to the Windows host with SnapDrive. We then created a Windows Scheduled Task to take regular snapshots using SnapDrive. To recover an individual mailbox, you just mount the snapshot of the LUN and copy that users mailbox file out and back into the main LUN, to recover all of Notes to a point in time, you just shut down Notes and do a LUN SnapRestore then remount the LUN and restart Notes. There used to be some TR's for Lotus Domino, but I can't seem to find them anymore. Regards Oliver Bassett Senior Systems Engineer Infinity Solutions Ltd P O Box 3323, Auckland Ph: +64 9 921 8123, Mob: +64 21 574 994 Fax: +64 9 309 4142 www.infinitysolutions.co.nz -----Original Message----- From: owner-toasters(a)mathworks.com [mailto:owner-toasters@mathworks.com] On Behalf Of Scott Lowe Sent: Wednesday, 6 December 2006 9:30 a.m. To: toasters(a)mathworks.com; Andrew Guerra Subject: Re: Lotus Notes Andrew, I could be wrong, but without application-specific support to quiesce the Notes databases (which is what SME/SMSQL/SMO do), then you won't be able to get guaranteed consistent snapshots. In addition, even if you do get good snapshots, you would still need some level of application-specific software (like SMBR) that understands the Notes database format and has the ability to reach into a snapshot and retrieve specific pieces of information. Without these application-specific pieces, you are left with the ability to take "ordinary" snapshots (I would assume of a LUN, since Notes probably doesn't support mounting databases over CIFS or NFS) and then using SnapRestore to restore those snapshots as needed. I'm not intimately familiar with Lotus Notes, but if you could restore the database from snapshot to an alternate location you could then use Notes-specific software to retrieve specific items from there. Hope this helps, Scott Lowe Senior Engineer ePlus Technology, Inc. slowe(a)eplus.com Office: 919.326.3641 Fax: 919.326.3691 Mobile: 919.274.0462 On Dec 5, 2006, at 2:37 PM, Andrew Guerra wrote: > Has anyone installed, implemented, deployed Lotus Notes with a NetApp > filer? I know there "SnapManager for Lotus Notes" doesn't exist so > how can I do this with the same functionality and SME, and SMBR for > that matter. I would appreciate any suggestions. > > > > Thanks > > > > > > > > > > > > > > The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. ------------------------------------------------------------------------ -------- The information contained herein is confidential and is intended solely for the addressee. Access by any other party is unauthorised without the express written permission of the sender. If you are not the intended recipient, please contact the sender either via the company switchboard on +44 (0)20 7623 8000, or via e-mail return. If you have received this e-mail in error or wish to read our e-mail disclaimer statement and monitoring policy, please refer to http://www.dresdnerkleinwort.com/disc/email/ or contact the sender. ------------------------------------------------------------------------ -------- The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated.

1 0

Jump to page:

2026

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