From owner-freebsd-stable@FreeBSD.ORG Fri Feb 13 09:05:20 2009 Return-Path: Delivered-To: freebsd-stable@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id E0AF2106566C for ; Fri, 13 Feb 2009 09:05:20 +0000 (UTC) (envelope-from goran.lowkrantz@ismobile.com) Received: from mail.ismobile.com (mail.ismobile.com [62.119.44.68]) by mx1.freebsd.org (Postfix) with ESMTP id 5D4118FC1A for ; Fri, 13 Feb 2009 09:05:20 +0000 (UTC) (envelope-from goran.lowkrantz@ismobile.com) Received: from mail.ismobile.com (localhost [127.0.0.1]) by mail.ismobile.com (Postfix) with ESMTP id 4CB194B4; Fri, 13 Feb 2009 09:40:29 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=ismobile.com; h=date:from :to:cc:subject:message-id:in-reply-to:references:mime-version :content-type:content-transfer-encoding; s=selector1; bh=rpNujB6 OMD5qlBpC0dhQF64TPjk=; b=DSdC6aUffUT6tA8TNXCjaisrFLjgz+BrrezWPY8 PPuxzA3CDRB7nEjKS194C04N716v8oMOdoDKRqX2rr1/T4eIal3MpiAd9Yag7Szz XErjoznoCCJq2gQxd1GCaGb6PT12EK2FK7xe1AVHjb97GkLeXWqZSGelv9z7q2ls PKw4= Received: from [172.16.2.105] (unknown [172.16.2.105]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.ismobile.com (Postfix) with ESMTPSA id 9A5574B3; Fri, 13 Feb 2009 09:40:28 +0100 (CET) Date: Fri, 13 Feb 2009 09:40:27 +0100 From: Goran Lowkrantz To: d@delphij.net Message-ID: <2CA7DE699281AFA5DF2BD851@syn> In-Reply-To: <499526E9.3090804@bit0.com> References: <4994CD7B.7040302@denninger.net> <4994D603.2060406@delphij.net> <4994D931.4060508@denninger.net> <4994DACC.1040801@delphij.net> <4994DBC1.2000309@denninger.net> <4994DFB0.3060704@delphij.net> <499526E9.3090804@bit0.com> X-Mailer: Mulberry/4.0.8 (Mac OS X) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Cc: freebsd-stable@freebsd.org, Mike Andrews , Karl Denninger Subject: Re: Upgrade from 32-bit to AMD-64? X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 13 Feb 2009 09:05:21 -0000 Hi, When have done this, MySQL is OK but Berkley and PostgreSQL need=20 dump/restore. /glz --On February 13, 2009 2:53:13 -0500 Mike Andrews = wrote: > Xin LI wrote: >> -----BEGIN PGP SIGNED MESSAGE----- >> Hash: SHA1 >> >> Karl Denninger wrote: >> [...] >>> I guess I need to schedule the 2-3 hours of downtime..... the reason = for >>> this, by the way, is that I have a dbms app on there that is getting = too >>> RAM hungry for its own good (its a Quadcore CPU) and I'm up against the >>> RAM limit for 32-bit code. The board will support more but 32-bit code >>> won't; ergo, the only way to get beyond this is to go to 64-bit. >> >> Oh wait! One thing you wanted to know is that, some database *can* have >> different on-disk format for 32-bit and 64-bit binaries. Be sure to >> have a dump handy. Last time I hit this on a MySQL "upgrade" between >> two servers, and I end up using its replication functionality. The >> operation took longer time than I expected at the beginning. > > For what it's worth, I did an in-place source upgrade on our MySQL server > (for the same lack-of-memory reason) and didn't have any on-disk format > problems. In fact later on when troubleshooting data corruption problems > that turned out to be bad hardware, I switched between 32-bit and 64-bit > mysqld binaries without rebooting or dumping/reimporting the database. > > BUT... there was no replication involved. It wouldn't surprise me if the > binlog or relay logs were in an architecture specific format. InnoDB and > MyISAM tables don't appear to be. This was over a year ago though, so > test on a scratch box first and you may save yourself a bit of downtime. > > The upgrade is a pain, and does have a lot of potential foot-shooting, > and you have to immediately recompile ALL of your installed ports (and > anything else not built from ports) to avoid mixing 32-bit and 64-bit > shared libraries... and that rebuilding ports time is where most of your > downtime comes from if it's a production box. > > If you're feeling lucky, the procedure's in the list archives somewhere > and the super-short version is you turn your swap partition into a > temporary amd64 root filesystem, installworld/kernel into that, boot into > that, then mount and installworld/kernel on top of the old i386 root > filesystem from there, then boot into it and recompile all your ports > (after reclaiming your swap partition for swap). Or, the way I did it > last time was to boot into a PXE diskless FreeBSD/amd64 install and use > that to mount/install over the i386 stuff. > > Definitely practice on a scratch system first. :) > > > -- > Mike Andrews > Server Monkey > Fark, Inc > mandrews@fark.com > _______________________________________________ > freebsd-stable@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-stable > To unsubscribe, send any mail to "freebsd-stable-unsubscribe@freebsd.org" ................................................... the future isMobile Goran Lowkrantz System Architect, isMobile AB Sandviksgatan 81, PO Box 58, S-971 03 Lule=E5, Sweden Mobile: +46(0)70-587 87 82 http://www.ismobile.com ...............................................