Re: [zones-discuss] zones & databases
Jeff Victor wrote: Carisdad wrote: [EMAIL PROTECTED] wrote: On Fri, Aug 18, 2006 at 08:52:29AM +0200, Robert Milkowski wrote: Hello Brian, Wednesday, July 26, 2006, 8:31:06 PM, you wrote: BK> With the performance boosts included in recent solaris versions I'm BK> told that there's not much of a difference between handing the database BK> raw devices vs. using a filesystem anymore. BK> To test this out, my customer would like to try both ufs and vxfs BK> filesystems in the global zone and lofs mount them to a local zone BK> and test the database on that lofs mount. BK> Are there any options that should be supplied for the lofs mount and BK> are there any options for the ufs and/or vxfs mounts that should be BK> employed to assure the performance should be close to raw devices? 1. lofs is probably a bad idea - mount them directly into a zone lofs is the only supported option for vxfs. przemol ___ While lofs is the only officially supported option, mounting directly in the zone can be accomplished with a work-around. see: http://seer.entsupport.symantec.com/docs/276134.htm That's interesting. Do you know if there is also a work-around that allows you to assign a VxVM device into a non-global zone, and then mount it with VxFS when the zone boots? -- Jeff VICTOR Sun Microsystemsjeff.victor @ sun.com OS AmbassadorSr. Technical Specialist Solaris 10 Zones FAQ: http://www.opensolaris.org/os/community/zones/faq -- I hadn't tried this, or even thought of it, really. Playing around, though, it doesn't seem like it would be easy to do. I tried creating a zone and adding various device resources (/dev/vx/*, /dev/vx/dsk/*, /dev/vx/dsk/mydg/*, ...) to the zonecfg, but they don't get created when the zone boots. I then manually created the directories for /dev/vx/(dsk|rdsk)/mydg and used mknod to create the devices from the global zone. This gave me raw access to the devices I can then run /usr/bin mount, but it complains about not being the correct fstyp (vxfs). So I added an lofs mount for /etc/fs/vxfs to the local zone, and ran /etc/fs/vxfs/mount directly and get "UX:vxfs mount: ERROR: V-3-25791: mount: is not supported on a localzone". I looked a little bit further into trying to use dtrace to watch for the fbt::zone_lookup:entry/return call or syscall::zone:entry/return and using destructive actions to trick mount into believing it was in the global, but couldn't quite get it worked out. At that point I decided it was maybe a bit too complicated to really call anything a work-around. ;-) But it was fun to try -Andy ___ zones-discuss mailing list zones-discuss@opensolaris.org
Re: [zones-discuss] zones & databases
Jeff Victor wrote: Brian Kolaci wrote: Carisdad wrote: [EMAIL PROTECTED] wrote: On Fri, Aug 18, 2006 at 08:52:29AM +0200, Robert Milkowski wrote: Hello Brian, Wednesday, July 26, 2006, 8:31:06 PM, you wrote: BK> With the performance boosts included in recent solaris versions I'm BK> told that there's not much of a difference between handing the database BK> raw devices vs. using a filesystem anymore. BK> To test this out, my customer would like to try both ufs and vxfs BK> filesystems in the global zone and lofs mount them to a local zone BK> and test the database on that lofs mount. BK> Are there any options that should be supplied for the lofs mount and BK> are there any options for the ufs and/or vxfs mounts that should be BK> employed to assure the performance should be close to raw devices? 1. lofs is probably a bad idea - mount them directly into a zone lofs is the only supported option for vxfs. While lofs is the only officially supported option, mounting directly in the zone can be accomplished with a work-around. see: http://seer.entsupport.symantec.com/docs/276134.htm The customer will only accept officially supported options on this (i.e. lofs). Why exactly would lofs be a bad idea? What is the downside to lofs rather than directly using VxFS? With lofs they get the benefit of the ability to share one filesystem among multiple zones (not at the same mount point in the global zone). But is there anything that would increase/decrease performance by using lofs? Is there a major performance difference to running a database with its storage on lofs vs. VxFS vs. RAW? Not an answer, just a clarification: LOFS essentially re-mounts an existing filesystem onto an additional mount-point. When using LOFS, there is always the original fs type to consider. The comparison would then be "a LOFS-mount of a UFS filesystem" vs. "a UFS filesystem" vs. "a raw device." Of course, VxFS can be substituted for UFS. I guess the direct question would be "a LOFS-mount of a VxFS filesystem with QuickIO enabled". Typically databases want either QuickIO or forcedirectio (on UFS) enabled so that writes aren't buffered. Is that still the case if LOFS is mounted on another filesystem? The DBA's say that writing to a raw device is somewhat equivalent to writing a file on a filesystem with QuickIO enabled. ___ zones-discuss mailing list zones-discuss@opensolaris.org
Re: [zones-discuss] zones & databases
Brian Kolaci wrote: Carisdad wrote: [EMAIL PROTECTED] wrote: On Fri, Aug 18, 2006 at 08:52:29AM +0200, Robert Milkowski wrote: Hello Brian, Wednesday, July 26, 2006, 8:31:06 PM, you wrote: BK> With the performance boosts included in recent solaris versions I'm BK> told that there's not much of a difference between handing the database BK> raw devices vs. using a filesystem anymore. BK> To test this out, my customer would like to try both ufs and vxfs BK> filesystems in the global zone and lofs mount them to a local zone BK> and test the database on that lofs mount. BK> Are there any options that should be supplied for the lofs mount and BK> are there any options for the ufs and/or vxfs mounts that should be BK> employed to assure the performance should be close to raw devices? 1. lofs is probably a bad idea - mount them directly into a zone lofs is the only supported option for vxfs. While lofs is the only officially supported option, mounting directly in the zone can be accomplished with a work-around. see: http://seer.entsupport.symantec.com/docs/276134.htm The customer will only accept officially supported options on this (i.e. lofs). Why exactly would lofs be a bad idea? What is the downside to lofs rather than directly using VxFS? With lofs they get the benefit of the ability to share one filesystem among multiple zones (not at the same mount point in the global zone). But is there anything that would increase/decrease performance by using lofs? Is there a major performance difference to running a database with its storage on lofs vs. VxFS vs. RAW? Not an answer, just a clarification: LOFS essentially re-mounts an existing filesystem onto an additional mount-point. When using LOFS, there is always the original fs type to consider. The comparison would then be "a LOFS-mount of a UFS filesystem" vs. "a UFS filesystem" vs. "a raw device." Of course, VxFS can be substituted for UFS. -- -- Jeff VICTOR Sun Microsystemsjeff.victor @ sun.com OS AmbassadorSr. Technical Specialist Solaris 10 Zones FAQ:http://www.opensolaris.org/os/community/zones/faq -- ___ zones-discuss mailing list zones-discuss@opensolaris.org
Re: [zones-discuss] zones & databases
On 8/22/06, Brian Kolaci <[EMAIL PROTECTED]> wrote: The customer will only accept officially supported options on this (i.e. lofs). Why exactly would lofs be a bad idea? What is the downside to lofs rather than directly using VxFS? With lofs they get the benefit of the ability to share one filesystem among multiple zones (not at the same mount point in the global zone). But is there anything that would increase/decrease performance by using lofs? Is there a major performance difference to running a database with its storage on lofs vs. VxFS vs. RAW? Not with a database (yet), but I have been benchmarking the following: UFS in the global zone via a disk device (/dev/dsk/cntndnsn) UFS in the global zone via a metadevice (/dev/md/dsk/dmm) UFS in a non-global zone via LOFS and a metadevice ... and found very little statistical difference between global (UFS) and non-global (LOFS) performance... on the other hand, we have seen, under certain circumstances, a noticeable performance loss using metadevices. We are still analyzing to try to figure out _why_. -- Paul Kraus ___ zones-discuss mailing list zones-discuss@opensolaris.org
Re: [zones-discuss] zones & databases
Carisdad wrote: [EMAIL PROTECTED] wrote: On Fri, Aug 18, 2006 at 08:52:29AM +0200, Robert Milkowski wrote: Hello Brian, Wednesday, July 26, 2006, 8:31:06 PM, you wrote: BK> With the performance boosts included in recent solaris versions I'm BK> told that there's not much of a difference between handing the database BK> raw devices vs. using a filesystem anymore. BK> To test this out, my customer would like to try both ufs and vxfs BK> filesystems in the global zone and lofs mount them to a local zone BK> and test the database on that lofs mount. BK> Are there any options that should be supplied for the lofs mount and BK> are there any options for the ufs and/or vxfs mounts that should be BK> employed to assure the performance should be close to raw devices? 1. lofs is probably a bad idea - mount them directly into a zone lofs is the only supported option for vxfs. przemol While lofs is the only officially supported option, mounting directly in the zone can be accomplished with a work-around. see: http://seer.entsupport.symantec.com/docs/276134.htm The customer will only accept officially supported options on this (i.e. lofs). Why exactly would lofs be a bad idea? What is the downside to lofs rather than directly using VxFS? With lofs they get the benefit of the ability to share one filesystem among multiple zones (not at the same mount point in the global zone). But is there anything that would increase/decrease performance by using lofs? Is there a major performance difference to running a database with its storage on lofs vs. VxFS vs. RAW? ___ zones-discuss mailing list zones-discuss@opensolaris.org
Re: [zones-discuss] zones & databases
Carisdad wrote: [EMAIL PROTECTED] wrote: On Fri, Aug 18, 2006 at 08:52:29AM +0200, Robert Milkowski wrote: Hello Brian, Wednesday, July 26, 2006, 8:31:06 PM, you wrote: BK> With the performance boosts included in recent solaris versions I'm BK> told that there's not much of a difference between handing the database BK> raw devices vs. using a filesystem anymore. BK> To test this out, my customer would like to try both ufs and vxfs BK> filesystems in the global zone and lofs mount them to a local zone BK> and test the database on that lofs mount. BK> Are there any options that should be supplied for the lofs mount and BK> are there any options for the ufs and/or vxfs mounts that should be BK> employed to assure the performance should be close to raw devices? 1. lofs is probably a bad idea - mount them directly into a zone lofs is the only supported option for vxfs. przemol ___ While lofs is the only officially supported option, mounting directly in the zone can be accomplished with a work-around. see: http://seer.entsupport.symantec.com/docs/276134.htm That's interesting. Do you know if there is also a work-around that allows you to assign a VxVM device into a non-global zone, and then mount it with VxFS when the zone boots? -- Jeff VICTOR Sun Microsystemsjeff.victor @ sun.com OS AmbassadorSr. Technical Specialist Solaris 10 Zones FAQ:http://www.opensolaris.org/os/community/zones/faq -- ___ zones-discuss mailing list zones-discuss@opensolaris.org
Re: [zones-discuss] zones & databases
[EMAIL PROTECTED] wrote: On Fri, Aug 18, 2006 at 08:52:29AM +0200, Robert Milkowski wrote: Hello Brian, Wednesday, July 26, 2006, 8:31:06 PM, you wrote: BK> With the performance boosts included in recent solaris versions I'm BK> told that there's not much of a difference between handing the database BK> raw devices vs. using a filesystem anymore. BK> To test this out, my customer would like to try both ufs and vxfs BK> filesystems in the global zone and lofs mount them to a local zone BK> and test the database on that lofs mount. BK> Are there any options that should be supplied for the lofs mount and BK> are there any options for the ufs and/or vxfs mounts that should be BK> employed to assure the performance should be close to raw devices? 1. lofs is probably a bad idea - mount them directly into a zone lofs is the only supported option for vxfs. przemol ___ zones-discuss mailing list zones-discuss@opensolaris.org While lofs is the only officially supported option, mounting directly in the zone can be accomplished with a work-around. see: http://seer.entsupport.symantec.com/docs/276134.htm ___ zones-discuss mailing list zones-discuss@opensolaris.org
Re: [zones-discuss] zones & databases
On Fri, Aug 18, 2006 at 08:52:29AM +0200, Robert Milkowski wrote: > Hello Brian, > > Wednesday, July 26, 2006, 8:31:06 PM, you wrote: > > BK> With the performance boosts included in recent solaris versions I'm > BK> told that there's not much of a difference between handing the database > BK> raw devices vs. using a filesystem anymore. > > BK> To test this out, my customer would like to try both ufs and vxfs > BK> filesystems in the global zone and lofs mount them to a local zone > BK> and test the database on that lofs mount. > > BK> Are there any options that should be supplied for the lofs mount and > BK> are there any options for the ufs and/or vxfs mounts that should be > BK> employed to assure the performance should be close to raw devices? > > > 1. lofs is probably a bad idea - mount them directly into a zone lofs is the only supported option for vxfs. przemol ___ zones-discuss mailing list zones-discuss@opensolaris.org
Re: [zones-discuss] zones & databases
Hello Brian, Wednesday, July 26, 2006, 8:31:06 PM, you wrote: BK> With the performance boosts included in recent solaris versions I'm BK> told that there's not much of a difference between handing the database BK> raw devices vs. using a filesystem anymore. BK> To test this out, my customer would like to try both ufs and vxfs BK> filesystems in the global zone and lofs mount them to a local zone BK> and test the database on that lofs mount. BK> Are there any options that should be supplied for the lofs mount and BK> are there any options for the ufs and/or vxfs mounts that should be BK> employed to assure the performance should be close to raw devices? 1. lofs is probably a bad idea - mount them directly into a zone 2. with UFS mount with directio option, there's an equivalent for VxFS 3. ZFS could also be interesting with recordsize lowered to match db block size Have you got any results you can share yet? -- Best regards, Robertmailto:[EMAIL PROTECTED] http://milek.blogspot.com ___ zones-discuss mailing list zones-discuss@opensolaris.org
Re: [zones-discuss] zones & databases
On Wed, 26 Jul 2006, Brian Kolaci wrote: > To test this out, my customer would like to try both ufs and vxfs > filesystems in the global zone and lofs mount them to a local zone > and test the database on that lofs mount. I'd also recommend that your customer tries the tests on ZFS too. -- Rich Teer, SCNA, SCSA, OpenSolaris CAB member President, Rite Online Inc. Voice: +1 (250) 979-1638 URL: http://www.rite-group.com/rich ___ zones-discuss mailing list zones-discuss@opensolaris.org