From owner-freebsd-isp@FreeBSD.ORG Wed Mar 15 18:34:13 2006 Return-Path: X-Original-To: freebsd-isp@freebsd.org Delivered-To: freebsd-isp@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 4D20416A425 for ; Wed, 15 Mar 2006 18:34:13 +0000 (UTC) (envelope-from cody@wilkshire.net) Received: from mail.wilkshire.net (mail.wilkshire.net [12.111.120.20]) by mx1.FreeBSD.org (Postfix) with ESMTP id A711643D58 for ; Wed, 15 Mar 2006 18:34:12 +0000 (GMT) (envelope-from cody@wilkshire.net) Received: (qmail 21998 invoked by uid 0); 15 Mar 2006 13:34:11 -0500 Received: from unknown (HELO ?10.200.208.146?) (cody@wilkshire.net@143.206.208.118) by mail.wilkshire.net with ESMTPA; 15 Mar 2006 13:34:11 -0500 Message-ID: <44185E23.1090809@wilkshire.net> Date: Wed, 15 Mar 2006 13:34:11 -0500 From: Cody Baker User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: freebsd-isp@freebsd.org References: <44183340.4060903@infinityprosports.com> <8eea04080603150915m18ff7c6cld9fdf761258759a3@mail.gmail.com> In-Reply-To: <8eea04080603150915m18ff7c6cld9fdf761258759a3@mail.gmail.com> X-Enigmail-Version: 0.94.0.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Subject: Re: MySQL Clustering X-BeenThere: freebsd-isp@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Internet Services Providers List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 15 Mar 2006 18:34:13 -0000 If you're database is simply read only then the load balancer situation should work fine. If your database is read/write then your load balancer could cause you problems under certain circumstances. If your updates are not time critical then it should be fine. If, however, your databases are used for a time critical updates (ex. session data for a web page) then it's important that your users always hit the same database server because the replication can become delayed at times. If the user has a random chance of hitting any of your database servers then for example your user may add something to their cart, and refresh the page connecting to another server, and find the item missing from their cart. Other no-nos for replicated databases especially on mysql < 5, are auto-incrementing fields in tables. 5.x has a solution for this ( http://dev.mysql.com/doc/refman/5.0/en/replication-auto-increment.html ). Thank You, Cody Baker cody@wilkshire.net http://www.wilkshire.net Jon Simola wrote: > On 3/15/06, James Ryan wrote: > >> Not sure if this is the right list for this (I apologize if its not), >> but has anybody ran a MySQL 2+ node cluster under FreeBSD 5.x behind a >> load balancer; and if so, could you offer any tips or warnings? >> > > If you're talking about the actual MySQL clustering server setup, I've > never had a chance to try it as our dataset is too large. > > I've run a pair of MySQL servers in a round-robin master setup (A > slaves from B, B slaves from A) and that worked rather well, > replication was impressively quick. > > -- > Jon Simola > Systems Administrator > ABC Communications > _______________________________________________ > freebsd-isp@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-isp > To unsubscribe, send any mail to "freebsd-isp-unsubscribe@freebsd.org" >