From owner-freebsd-questions@FreeBSD.ORG Thu Mar 16 14:00:37 2006 Return-Path: X-Original-To: questions@freebsd.org Delivered-To: freebsd-questions@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id B149D16A401 for ; Thu, 16 Mar 2006 14:00:37 +0000 (UTC) (envelope-from dave.list@pixelhammer.com) Received: from ecluster4.tls.net (ecluster4.tls.net [65.196.224.134]) by mx1.FreeBSD.org (Postfix) with SMTP id DD0BE43D46 for ; Thu, 16 Mar 2006 14:00:35 +0000 (GMT) (envelope-from dave.list@pixelhammer.com) Received: (qmail 70321 invoked by uid 89); 16 Mar 2006 14:00:35 -0000 Received: from unknown (HELO ?192.168.0.102?) (ldg%tls.net@204.8.13.41) by auth-ecluster4.tls.net with SMTP; 16 Mar 2006 14:00:35 -0000 Message-ID: <44196F7A.4050709@pixelhammer.com> Date: Thu, 16 Mar 2006 09:00:26 -0500 From: DAve User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: grog@mysql.com, questions@freebsd.org References: <20060316101845.GA3776@eucla.lemis.com> <4419694E.3090805@pixelhammer.com> In-Reply-To: <4419694E.3090805@pixelhammer.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: Subject: Re: Do you use MySQL? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 16 Mar 2006 14:00:37 -0000 DAve wrote: > Greg 'groggy' Lehey wrote: >> - If you're not running MySQL 5.0, why not? >> > Also we have many older pieces of hardware that cannot run a newer > version because the older hardware cannot support the newer OS, which in > turn is required to run the newest MySQL. The new MySQL, if not > compatible with the old MySQL, does me no good. > > Example, we have many old Sparc boxes, still going strong, running > Solaris 2.5 and MySQL 3.23. If I use MySQL 5.0 I can no longer use > replication. So an upgrade to MySQL 5.0 means new hardware. It's a hard > sell upstairs unless the new combination offers substantial improvement. > (Yes the Sparcs are old, but they run, and they run, and they run. > Sometimes we forget to check on them they are so reliable, I wish my new > hardware was as good). I should rephrase that, it sounds like I am complaining which I am not. We use a lot of replication to push management changes from tech support down to Radius, DNS, FTP servers running MySQL. If we install MySQL 5.0 on my new servers, we cannot use replication to my MySQL 3.23 servers, many of which are the old Sparcs. Of course any replacement for the old servers will use a newer version of MySQL, and eventually we will get all our servers running version 4.X. But by then you will be asking if anyone is running MySQL 7, and if not, why not. Also, keep in mind, if MySQL runs for months on end as a Radius backend, or DNS, or FTP. If we never have to do anything because a script optimizes the tables once a week and the logs rotate out based on size, and it never ever ever ever lets us down. Why would we want to upgrade? My pager has never beeped because of MySQL. DAve -- This message was checked by forty monkeys and found to not contain any SPAM whatsoever. Your monkeys may vary