From owner-freebsd-database@FreeBSD.ORG Tue Nov 29 20:26:13 2011 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 1D155106566B for ; Tue, 29 Nov 2011 20:26:13 +0000 (UTC) (envelope-from list@sprymed.com) Received: from mail-bw0-f54.google.com (mail-bw0-f54.google.com [209.85.214.54]) by mx1.freebsd.org (Postfix) with ESMTP id A5DB88FC16 for ; Tue, 29 Nov 2011 20:26:12 +0000 (UTC) Received: by bkbzs8 with SMTP id zs8so13187122bkb.13 for ; Tue, 29 Nov 2011 12:26:11 -0800 (PST) MIME-Version: 1.0 Received: by 10.204.154.7 with SMTP id m7mr52063956bkw.71.1322598371215; Tue, 29 Nov 2011 12:26:11 -0800 (PST) Received: by 10.204.15.75 with HTTP; Tue, 29 Nov 2011 12:26:11 -0800 (PST) Date: Tue, 29 Nov 2011 15:26:11 -0500 Message-ID: From: "list, mailing" To: freebsd-database@freebsd.org Content-Type: text/plain; charset=ISO-8859-1 X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Subject: MySQL on RAID 1 X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 29 Nov 2011 20:26:13 -0000 I'm setting up a HW RAID 1 mirror setup with two 500 GB Drives. How much slower will MySQL run? (Installing whole OS on the RAID) Not noticeable or very slow? Also if a drive fails will I simply be able to shutdown drop in a new drive boot up. Having MBR working fine and auto build RAID on new drive? -- Ben Adams http://www.SpryMed.com/ From owner-freebsd-database@FreeBSD.ORG Tue Nov 29 21:25:33 2011 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 595DE106566B for ; Tue, 29 Nov 2011 21:25:33 +0000 (UTC) (envelope-from 000.fbsd@quip.cz) Received: from elsa.codelab.cz (elsa.codelab.cz [94.124.105.4]) by mx1.freebsd.org (Postfix) with ESMTP id 1793B8FC08 for ; Tue, 29 Nov 2011 21:25:32 +0000 (UTC) Received: from elsa.codelab.cz (localhost [127.0.0.1]) by elsa.codelab.cz (Postfix) with ESMTP id B684F28422; Tue, 29 Nov 2011 22:08:15 +0100 (CET) Received: from [192.168.1.2] (ip-86-49-61-235.net.upcbroadband.cz [86.49.61.235]) (using TLSv1 with cipher DHE-RSA-CAMELLIA256-SHA (256/256 bits)) (No client certificate requested) by elsa.codelab.cz (Postfix) with ESMTPSA id EB74928424; Tue, 29 Nov 2011 22:08:14 +0100 (CET) Message-ID: <4ED549BE.9010604@quip.cz> Date: Tue, 29 Nov 2011 22:08:14 +0100 From: Miroslav Lachman <000.fbsd@quip.cz> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.9.1.19) Gecko/20110420 Lightning/1.0b1 SeaMonkey/2.0.14 MIME-Version: 1.0 To: "list, mailing" References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: freebsd-database@freebsd.org Subject: Re: MySQL on RAID 1 X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 29 Nov 2011 21:25:33 -0000 list, mailing wrote: > I'm setting up a HW RAID 1 mirror setup with two 500 GB Drives. > > How much slower will MySQL run? (Installing whole OS on the RAID) We are running MySQL on gmirrored SATA II disks (500GB or 1TB). It is somewhat slower on writes compared to single disk (I don't have exact numbers), but it is running fine and date is more secure. > Not noticeable or very slow? > > Also if a drive fails will I simply be able to shutdown drop in a new drive > boot up. > Having MBR working fine and auto build RAID on new drive? I am able to replace failed disk drive without shutdown. Faild disk drive is already datached from gmirror, so then it must be detached from ATA chanel by atacontrol detach command. After inserting new drive, you can do `atacontrol attach ata2` + `gmirror forget gm0` and `gmirror insert gm0 ad4` (for example) Miroslav Lachman