From owner-freebsd-questions@freebsd.org Thu Jul 9 21:25:48 2015 Return-Path: Delivered-To: freebsd-questions@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id A99DE9977BB for ; Thu, 9 Jul 2015 21:25:48 +0000 (UTC) (envelope-from cswiger@mac.com) Received: from mail-in5.apple.com (mail-out5.apple.com [17.151.62.27]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 85616145D for ; Thu, 9 Jul 2015 21:25:47 +0000 (UTC) (envelope-from cswiger@mac.com) Received: from relay4.apple.com (relay4.apple.com [17.128.113.87]) by mail-in5.apple.com (Apple Secure Mail Relay) with SMTP id 7D.33.12430.5D6EE955; Thu, 9 Jul 2015 14:25:41 -0700 (PDT) X-AuditID: 11973e13-f79d56d00000308e-3b-559ee6d51ff9 Received: from [17.149.228.60] (Unknown_Domain [17.149.228.60]) (using TLS with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client did not present a certificate) by relay4.apple.com (Apple SCV relay) with SMTP id B8.6B.11814.5D6EE955; Thu, 9 Jul 2015 14:25:41 -0700 (PDT) Content-Type: text/plain; charset=windows-1252 Mime-Version: 1.0 (Mac OS X Mail 8.2 \(2102\)) Subject: Re: Gmirror/graid or hardware raid? From: Charles Swiger In-Reply-To: <7F08761C-556E-4147-95DB-E84B4E5179A5@kraus-haus.org> Date: Thu, 9 Jul 2015 14:25:41 -0700 Cc: FreeBSD - Content-Transfer-Encoding: quoted-printable Message-Id: <0B66BF03-53F6-4CDD-8530-6CFFA89D04EE@mac.com> References: <917A821C-02F8-4F96-88DA-071E3431C335@mac.com> <7F08761C-556E-4147-95DB-E84B4E5179A5@kraus-haus.org> To: Paul Kraus X-Mailer: Apple Mail (2.2102) X-Brightmail-Tracker: H4sIAAAAAAAAA+NgFlrPLMWRmVeSWpSXmKPExsUi2FAYrnv12bxQg7PXzSxeft3EYjGxfTK7 A5PHjE/zWTymvt7EFMAUxWWTkpqTWZZapG+XwJUx/80l5oID/BXvPu5ibGCcxNPFyMkhIWAi cebba0YIW0ziwr31bF2MXBxCAnsZJdZ9n8YIU3T032JGiMRUJomfL36zgSSYBfQkdlz/xQpi 8wLZPee+gDUIC+hIbHrzjamLkYODTUBNYsJEsGWcAk4SE8/+BguzCKhINB/VhpiiK9F04y0j hK0tsWzha2aIiVYSXSvuMUGs3coo0XJ9EhNIQgSod/nRg6wQt8lKbH3TClYkIfCRVaKp7zzr BEahWUjOm4XkvFlIlixgZF7FKJSbmJmjm5lnqpdYUJCTqpecn7uJERTC0+2EdzCeXmV1iFGA g1GJh1dj+9xQIdbEsuLK3EOM0hwsSuK8f67MCxUSSE8sSc1OTS1ILYovKs1JLT7EyMTBKdXA mPZ37m/eD3GtV2/VRrHO78yfobbqoq+ZbNnxp4V/1yf2RCTNntgw3/XB9lsVVyYULFhS82sh +6Jrj/9xTvvcxP/4x4yoM2qVcd9TGL9pR3c5PDK0lf1fY5fLdZqXYdWCC/Mj8s0O7Ly8m0/n 1YNwTeOjtnIVH13Ocd3sYHL/7SVl+u/DhAuzpJVYijMSDbWYi4oTAbjJUPBCAgAA X-Brightmail-Tracker: H4sIAAAAAAAAA+NgFlrELMWRmVeSWpSXmKPExsUiOPWJje7VZ/NCDbauNLF4+XUTi8XE9sns DkweMz7NZ/GY+noTUwBTFJdNSmpOZllqkb5dAlfG/DeXmAsO8Fe8+7iLsYFxEk8XIyeHhICJ xNF/ixkhbDGJC/fWs3UxcnEICUxlkvj54jcbSIJZQE9ix/VfrCA2L5Ddc+4LWIOwgI7Epjff mLoYOTjYBNQkJkwEm8kp4CQx8exvsDCLgIpE81FtiCm6Ek033jJC2NoSyxa+ZoaYaCXRteIe E8TarYwSLdcnMYEkRIB6lx89yApxm6zE1jetTBMY+WchuWgWkotmIZm7gJF5FaNAUWpOYqWJ XmJBQU6qXnJ+7iZGUMg1FIbvYPy3zOoQowAHoxIPr8b2uaFCrIllxZW5hxglOJiVRHjn358X KsSbklhZlVqUH19UmpNafIhRmoNFSZxXc8qUUCGB9MSS1OzU1ILUIpgsEwenVAPjxZyuYu/O mXrXFodrB08RXCRUnpf48tb8IDPGpMTG6dtqJCW4rtWdUuuSuVm5Jf7PkQ2uVn4RkiEPp66Y FlTx/sb/x/P3fGy21WkNCjLSZjLp8GezM5XwmdPiOpHtHu+3gEArh59M9Y0hKzk1AusnSvbc 3m517dgKs3ts+nUrz3Ia9NmlmSqxFGckGmoxFxUnAgDlY0KQNQIAAA== X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.20 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 09 Jul 2015 21:25:48 -0000 On Jul 9, 2015, at 7:32 AM, Paul Kraus wrote: > On Jul 8, 2015, at 17:21, Charles Swiger wrote: [ ... ] >> Most of the PROD databases I know of working from local storage have = heaps of >> RAID-1 mirrors, and sometimes larger volumes created as RAID-10 or = RAID-50. >> Higher volume shops use dedicated SAN filers via redundant Fibre = Channel mesh >> or similar for their database storage needs. >=20 > Many years ago I had a client buy a couple racks FULL of trays of 36 = GB SCSI drives (yes, it was that long ago) and partition them so that = they only used the first 1 GB of each. This was purely for performance. = They were running a relatively large Oracle database and lots of OLTP = transactions. I seem to have memories of very expensive 18GB and 36GB 15K RPM Seagate = Barracuda drives with SCA-2 connectors filling racks full of Sun E450s = serving similar roles. :-) >>> I thought about zfs but I won't have lots of RAM avaliable >>=20 >> ZFS wants to be run against bare metal. I've never seen anyone setup = ZFS within >> a VM; it consumes far too much memory and it really wants to talk = directly to the >> hardware for accurate error detection. >=20 > ZFS runs fine in a VM and the notion that it _needs_ lots of RAM is = mostly false. I have run a FBSD Guest with ZFS and only 1 GB RAM. No doubt FreeBSD + ZFS + low memory has improved from what it once was. = But I also suspect that if you did something on the system which put a = significant amount of memory pressure on that 1GB VM, it would handle = such a load significantly better using UFS than using ZFS. That's a = claim without #s, but someone with such a setup could run some = benchmarks if they wanted to compare. [ ...The rest of your post was informative, and hopefully helpful to the = OP as well-- but snipped since I don't have more specific things to say = in reply.... ] Regards, --=20 -Chuck