From owner-freebsd-database@FreeBSD.ORG Mon Jan 31 08:15:35 2005 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id A9F6116A4CE for ; Mon, 31 Jan 2005 08:15:35 +0000 (GMT) Received: from mail.uk.psi.com (mail.uk.psi.com [154.8.2.142]) by mx1.FreeBSD.org (Postfix) with ESMTP id 02CC443D41 for ; Mon, 31 Jan 2005 08:15:35 +0000 (GMT) (envelope-from alan.barrow@psinet.telstra.co.uk) Received: from camdev-01.ops.uk.psi.com ([154.8.22.17]) by mail.uk.psi.com with esmtp (Exim 4.41) id 1CvWib-0006u3-46 for freebsd-database@freebsd.org; Mon, 31 Jan 2005 08:15:33 +0000 User-Agent: Microsoft-Entourage/11.0.0.040405 Date: Mon, 31 Jan 2005 08:14:56 +0000 From: alan barrow To: Message-ID: Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit Subject: Oracle 10g installation problem X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 31 Jan 2005 08:15:35 -0000 Try this http://www.opennet.ru/docs/HOWTO/Oracle-8-HOWTO-3.html Yours a.r.b. ----------------------------------------------------------------------- Alan.R.Barrow OSS Development Manager PSINet, a Telstra Company. Brookmount Court Kirkwood Road Cambridge CB4-2QH Tel : - +44 (0) 1223 577 337 Fax : - +44 (0) 1223 577 138 Mobile : - +44 (0) 7771 597 509 Ext : - 2337 ICQ : - 337488837 - arb IRC : - irc.freenode.com - sarig ----------------------------------------------------------------------- The information in this email is confidential and may be legally privileged. It is intended solely for the addressee(s). Access to this email by anyone else is unauthorised. If you are not the intended recipient, please delete this e-mail and notify Telstra. Any disclosure of the contents or recipients, distribution of, copying of or decisions based on this email by unauthorised persons is prohibited and may be unlawful. Telstra Europe Ltd 3 Finsbury Square London EC2A 1AE ----------------------------------------------------------------------- From owner-freebsd-database@FreeBSD.ORG Wed Feb 2 00:38:27 2005 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 8658216A4CF for ; Wed, 2 Feb 2005 00:38:27 +0000 (GMT) Received: from web42107.mail.yahoo.com (web42107.mail.yahoo.com [66.218.93.200]) by mx1.FreeBSD.org (Postfix) with SMTP id 3121D43D5C for ; Wed, 2 Feb 2005 00:38:25 +0000 (GMT) (envelope-from drumslayer2@yahoo.com) Received: (qmail 12707 invoked by uid 60001); 2 Feb 2005 00:38:24 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=htea2KEOySBy9Ouk9VriN1w9MbASGSsU1JGP7PoFjhCI3oT8GRekjUOjENAlvGsbu+VuVOh+Wkp4YXLdrTcV2nlc8qTDQyvlX5un7bkqUa/vK2LF7gVAeX/m98TkUys7t0tw18LG1h8BD8kqfPmLFTdhfvBeeTK8822XeCXkvBA= ; Message-ID: <20050202003824.12705.qmail@web42107.mail.yahoo.com> Received: from [67.112.21.27] by web42107.mail.yahoo.com via HTTP; Tue, 01 Feb 2005 16:38:24 PST Date: Tue, 1 Feb 2005 16:38:24 -0800 (PST) From: Drumslayer To: questions MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii cc: FreeBSD Database Subject: MySql Load balancing Solutions? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 02 Feb 2005 00:38:27 -0000 Hi I have been running a fairly heavy duty server for MySQL on FreeBSD but its starting to peak. I would like to know what others have done as far as using a load balancing solution for MySQL or their success with replication. Also has anyone done a 64 bit build of MySQL on FreeBSD successfully? Thanks! M. __________________________________ Do you Yahoo!? The all-new My Yahoo! - What will yours do? http://my.yahoo.com From owner-freebsd-database@FreeBSD.ORG Wed Feb 2 00:51:25 2005 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 7A7BA16A4CE for ; Wed, 2 Feb 2005 00:51:25 +0000 (GMT) Received: from galilee.polands.org (CPE-24-208-53-189.new.rr.com [24.208.53.189]) by mx1.FreeBSD.org (Postfix) with ESMTP id B0FEF43D1D for ; Wed, 2 Feb 2005 00:51:24 +0000 (GMT) (envelope-from djp@polands.org) Received: from jericho.polands.org (jericho.polands.org [172.16.1.35]) by galilee.polands.org (8.12.9/8.12.9) with ESMTP id j120pNRZ085134; Tue, 1 Feb 2005 18:51:23 -0600 (CST) (envelope-from djp@polands.org) Received: from jericho.polands.org (localhost [127.0.0.1]) by jericho.polands.org (8.13.1/8.13.1) with ESMTP id j120pNue014842; Tue, 1 Feb 2005 18:51:23 -0600 (CST) (envelope-from djp@jericho.polands.org) Received: (from djp@localhost) by jericho.polands.org (8.13.1/8.13.1/Submit) id j120pMZm014841; Tue, 1 Feb 2005 18:51:22 -0600 (CST) (envelope-from djp) Date: Tue, 1 Feb 2005 18:51:22 -0600 From: Doug Poland To: Drumslayer Message-ID: <20050202005122.GA14791@polands.org> References: <20050202003824.12705.qmail@web42107.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20050202003824.12705.qmail@web42107.mail.yahoo.com> User-Agent: Mutt/1.5.6i cc: FreeBSD Database Subject: Re: MySql Load balancing Solutions? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 02 Feb 2005 00:51:25 -0000 On Tue, Feb 01, 2005 at 04:38:24PM -0800, Drumslayer wrote: > Hi > I have been running a fairly heavy duty server for MySQL on FreeBSD > but its starting to peak. I would like to know what others have done > as far as using a load balancing solution for MySQL or their success > with replication. Also has anyone done a 64 bit build of MySQL on > FreeBSD successfully? > I'd take a look at MySQL's own clustering solution: http://dev.mysql.com/doc/mysql/en/ndbcluster.html HTH, Doug From owner-freebsd-database@FreeBSD.ORG Wed Feb 2 00:55:55 2005 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 49F1C16A4CE for ; Wed, 2 Feb 2005 00:55:55 +0000 (GMT) Received: from flake.decibel.org (flake.decibel.org [66.143.173.58]) by mx1.FreeBSD.org (Postfix) with ESMTP id DB8CA43D3F for ; Wed, 2 Feb 2005 00:55:54 +0000 (GMT) (envelope-from decibel@decibel.org) Received: by flake.decibel.org (Postfix, from userid 1001) id 115AE1C90A; Tue, 1 Feb 2005 18:55:52 -0600 (CST) Date: Tue, 1 Feb 2005 18:55:51 -0600 From: "Jim C. Nasby" To: Doug Poland Message-ID: <20050202005551.GT32356@decibel.org> References: <20050202003824.12705.qmail@web42107.mail.yahoo.com> <20050202005122.GA14791@polands.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20050202005122.GA14791@polands.org> X-Operating-System: FreeBSD 4.10-RELEASE-p3 i386 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.6i cc: FreeBSD Database Subject: Re: MySql Load balancing Solutions? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 02 Feb 2005 00:55:55 -0000 On Tue, Feb 01, 2005 at 06:51:22PM -0600, Doug Poland wrote: > On Tue, Feb 01, 2005 at 04:38:24PM -0800, Drumslayer wrote: > > Hi > > I have been running a fairly heavy duty server for MySQL on FreeBSD > > but its starting to peak. I would like to know what others have done > > as far as using a load balancing solution for MySQL or their success > > with replication. Also has anyone done a 64 bit build of MySQL on > > FreeBSD successfully? > > > I'd take a look at MySQL's own clustering solution: > > http://dev.mysql.com/doc/mysql/en/ndbcluster.html Something to be aware of; if the binlog partition fills, the master will happily continue accepting transactions, which means your slaves are now useless. -- Jim C. Nasby, Database Consultant decibel@decibel.org Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?" From owner-freebsd-database@FreeBSD.ORG Wed Feb 2 02:21:53 2005 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id F3D2016A4CE; Wed, 2 Feb 2005 02:21:52 +0000 (GMT) Received: from server1.ultratrends.com (S01060004e20310fa.rd.shawcable.net [70.65.87.221]) by mx1.FreeBSD.org (Postfix) with ESMTP id D348543D2F; Wed, 2 Feb 2005 02:21:51 +0000 (GMT) (envelope-from trodat@ultratrends.com) Received: from server1.ultratrends.com (localhost [127.0.0.1]) j122Lotw061547; Tue, 1 Feb 2005 19:21:50 -0700 (MST) (envelope-from trodat@ultratrends.com) Received: from localhost (trodat@localhost)j122LoWs061544; Tue, 1 Feb 2005 19:21:50 -0700 (MST) (envelope-from trodat@ultratrends.com) X-Authentication-Warning: server1.ultratrends.com: trodat owned process doing -bs Date: Tue, 1 Feb 2005 19:21:50 -0700 (MST) From: Technical Director To: Drumslayer In-Reply-To: <20050202003824.12705.qmail@web42107.mail.yahoo.com> Message-ID: <20050201190017.D61397@server1.ultratrends.com> References: <20050202003824.12705.qmail@web42107.mail.yahoo.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Milter: Spamilter (Reciever: server1.ultratrends.com; Sender-ip: 127.0.0.1; Sender-helo: server1.ultratrends.com;) cc: FreeBSD Database cc: questions Subject: Re: MySql Load balancing Solutions? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 02 Feb 2005 02:21:53 -0000 Drumslayer, I am part of a team running MySQL 4.1.X on 5 machines in a replication setup. Our first way to help manage load is the use of useful rules in our connection classes to direct "W"rites to our big server with fast I/O and memory and directing "R"reads to our slower I/O less RAM slaves only. This one step in itself has done a LOT for keeping uptimes high and queries fast. A positive advantage is that the 5 machines allows us the opportunity to change the configuration if say one fails we can promote another slave to take that position or in the case of the "W"rite server we can promote a slave to a "W"rite server until the original "W"rite server can be recovered. As well whether you use C/C++, Java, PHP or some other scripting language to access your database it shouldn't be too hard to write some sort of algorithm in your connection to spread the connections across your host base. When it comes to management I won't lie, 4.0.XX's handling of Replication was tough. Since though we've made the move to 4.1.X our problems have become less and less. A final advantage to having seperate machines in a replication setup is the ability to upgrade a segment or machine to a newer MySQL version to see how it will operate on your hardware/OS and with your programs. We did this with our move from 4.0.XX to 4.1.X by taking 2 slaves out of the main loop, promoting one to the new 4.1.X master and the other slave to a new 4.1.X slave. After testing in pre-production we proceeded with the deployment on our other 3 boxes. INFO: Our 5 machine replication setup consists of: 1) 1 - 4 x P4 Xeon Compaq Server ("W"rite DB Server) 2) 4 - 1 x P3 Compaq Servers ("R"ead DB Server) NOTE: On a smaller scale on my home network I do the same on three machines all sub-server class. I still have great reliability and "robust" performance from such a simple design. I hope this information is helpful, I know it works well for us. Rob. On Tue, 1 Feb 2005, Drumslayer wrote: > Hi > I have been running a fairly heavy duty server for > MySQL on FreeBSD but its starting to peak. I would > like to know what others have done as far as using a > load balancing solution for MySQL or their success > with replication. > Also has anyone done a 64 bit build of MySQL on > FreeBSD successfully? > > Thanks! > > M. > > > > > > __________________________________ > Do you Yahoo!? > The all-new My Yahoo! - What will yours do? > http://my.yahoo.com > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org" > From owner-freebsd-database@FreeBSD.ORG Wed Feb 2 20:09:25 2005 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id B614F16A4CE for ; Wed, 2 Feb 2005 20:09:25 +0000 (GMT) Received: from web42103.mail.yahoo.com (web42103.mail.yahoo.com [66.218.93.196]) by mx1.FreeBSD.org (Postfix) with SMTP id 69AA243D48 for ; Wed, 2 Feb 2005 20:09:25 +0000 (GMT) (envelope-from drumslayer2@yahoo.com) Received: (qmail 35490 invoked by uid 60001); 2 Feb 2005 20:09:25 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=BHQzrtzOCmAzXJmTXru1nJ4awpLs6M/BscZxOOkpAmAIccNy4Ni0MGxmCtmuKJ/XP/VjMWaHb+ZPWG/z1DoCBYAFs/I+NFoEKBPjGUJxlLW7Kerp7Iliod+tfAYEVE6zZeeVVWQsNP7nn/cKcup7zo2NzhWkKQbJdGcH1bzjosw= ; Message-ID: <20050202200924.35488.qmail@web42103.mail.yahoo.com> Received: from [67.112.21.27] by web42103.mail.yahoo.com via HTTP; Wed, 02 Feb 2005 12:09:24 PST Date: Wed, 2 Feb 2005 12:09:24 -0800 (PST) From: Drumslayer To: Technical Director In-Reply-To: <20050201190017.D61397@server1.ultratrends.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii cc: FreeBSD Database cc: questions Subject: Re: MySql Load balancing Solutions? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 02 Feb 2005 20:09:25 -0000 --- Technical Director wrote: > > Drumslayer, > > I am part of a team running MySQL 4.1.X on 5 > machines in a replication > setup. Our first way to help manage load is the use > of useful rules in > our connection classes to direct "W"rites to our big > server with fast I/O > and memory and directing "R"reads to our slower I/O > less RAM slaves only. The only problem with this is that 4.1 is stil considered Beta ("not yet ready for production"). I see little chance in convincing managment to utilize something beta for something so important. :( I so far have only seen an alternative from a company called Emic. But it only runs any OS but freeBSD sadly. (it modifies the kernel so compat won't do it) Have you heard of any hardware solutions or FreeBSD friendly free or commercial products? I know basic clustering and such is supposed to be OK but everything that seems OS agnostic says it's Beta. We may wind up doing it this way but right now its a toss up of a Beta Solution or move to linux with Emic. Which I'm not fond of becouse its so convoluted and Well Not BSD :) Thanks M. > This one step in itself has done a LOT for keeping > uptimes high and > queries fast. > > A positive advantage is that the 5 machines allows > us the opportunity to > change the configuration if say one fails we can > promote another slave to > take that position or in the case of the "W"rite > server we can promote a > slave to a "W"rite server until the original "W"rite > server can be recovered. > > As well whether you use C/C++, Java, PHP or some > other scripting language > to access your database it shouldn't be too hard to > write some sort of > algorithm in your connection to spread the > connections across your host > base. > > When it comes to management I won't lie, 4.0.XX's > handling of Replication > was tough. Since though we've made the move to 4.1.X > our problems have > become less and less. > > A final advantage to having seperate machines in a > replication setup is > the ability to upgrade a segment or machine to a > newer MySQL version to > see how it will operate on your hardware/OS and with > your programs. We did > this with our move from 4.0.XX to 4.1.X by taking 2 > slaves out of the main > loop, promoting one to the new 4.1.X master and the > other slave to a new > 4.1.X slave. After testing in pre-production we > proceeded with the > deployment on our other 3 boxes. > > INFO: Our 5 machine replication setup consists of: > > 1) 1 - 4 x P4 Xeon Compaq Server ("W"rite DB Server) > 2) 4 - 1 x P3 Compaq Servers ("R"ead DB Server) > > NOTE: On a smaller scale on my home network I do the > same on three > machines all sub-server class. I still have great > reliability and "robust" > performance from such a simple design. > > I hope this information is helpful, I know it works > well for us. > > Rob. > > On Tue, 1 Feb 2005, Drumslayer wrote: > > > Hi > > I have been running a fairly heavy duty server > for > > MySQL on FreeBSD but its starting to peak. I would > > like to know what others have done as far as using > a > > load balancing solution for MySQL or their success > > with replication. > > Also has anyone done a 64 bit build of MySQL on > > FreeBSD successfully? > > > > Thanks! > > > > M. > > > > > > > > > > > > __________________________________ > > Do you Yahoo!? > > The all-new My Yahoo! - What will yours do? > > http://my.yahoo.com > > _______________________________________________ > > freebsd-questions@freebsd.org mailing list > > > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > > To unsubscribe, send any mail to > "freebsd-questions-unsubscribe@freebsd.org" > > > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to > "freebsd-questions-unsubscribe@freebsd.org" > __________________________________ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail From owner-freebsd-database@FreeBSD.ORG Wed Feb 2 20:27:44 2005 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 08FA816A4D0 for ; Wed, 2 Feb 2005 20:27:44 +0000 (GMT) Received: from galilee.polands.org (CPE-24-208-53-189.new.rr.com [24.208.53.189]) by mx1.FreeBSD.org (Postfix) with ESMTP id 324F643D49 for ; Wed, 2 Feb 2005 20:27:43 +0000 (GMT) (envelope-from djp@polands.org) Received: from jericho.polands.org (jericho.polands.org [172.16.1.35]) by galilee.polands.org (8.12.9/8.12.9) with ESMTP id j12KRfRZ087591; Wed, 2 Feb 2005 14:27:42 -0600 (CST) (envelope-from djp@polands.org) Received: from jericho.polands.org (localhost [127.0.0.1]) by jericho.polands.org (8.13.1/8.13.1) with ESMTP id j12KRfxH091977; Wed, 2 Feb 2005 14:27:41 -0600 (CST) (envelope-from djp@jericho.polands.org) Received: (from djp@localhost) by jericho.polands.org (8.13.1/8.13.1/Submit) id j12KRfk8091944; Wed, 2 Feb 2005 14:27:41 -0600 (CST) (envelope-from djp) Date: Wed, 2 Feb 2005 14:27:41 -0600 From: Doug Poland To: Drumslayer Message-ID: <20050202202740.GA19880@polands.org> References: <20050201190017.D61397@server1.ultratrends.com> <20050202200924.35488.qmail@web42103.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20050202200924.35488.qmail@web42103.mail.yahoo.com> User-Agent: Mutt/1.5.6i cc: FreeBSD Database Subject: Re: MySql Load balancing Solutions? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 02 Feb 2005 20:27:44 -0000 On Wed, Feb 02, 2005 at 12:09:24PM -0800, Drumslayer wrote: > > --- Technical Director wrote: > > > > > Drumslayer, > > > > I am part of a team running MySQL 4.1.X on 5 machines in a > > replication setup. Our first way to help manage load is the use of > > useful rules in our connection classes to direct "W"rites to our big > > server with fast I/O and memory and directing "R"reads to our slower > > I/O less RAM slaves only. > > The only problem with this is that 4.1 is stil > considered Beta ("not yet ready for production"). I > see little chance in convincing managment to utilize > something beta for something so important. :( > 4.1 is not beta anymore. I believe it became the production branch as of 4.1.7. Now they're up to 4.1.9 -- Regards, Doug From owner-freebsd-database@FreeBSD.ORG Wed Feb 2 20:28:25 2005 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id C00E016A4CE; Wed, 2 Feb 2005 20:28:25 +0000 (GMT) Received: from server1.ultratrends.com (S01060004e20310fa.rd.shawcable.net [70.65.87.221]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3BD9343D39; Wed, 2 Feb 2005 20:28:25 +0000 (GMT) (envelope-from trodat@server1.ultratrends.com) Received: from server1.ultratrends.com (localhost [127.0.0.1]) j12KSMSt063855; Wed, 2 Feb 2005 13:28:23 -0700 (MST) (envelope-from trodat@server1.ultratrends.com) Received: from localhost (trodat@localhost)j12KSMa7063852; Wed, 2 Feb 2005 13:28:22 -0700 (MST) (envelope-from trodat@server1.ultratrends.com) Date: Wed, 2 Feb 2005 13:28:22 -0700 (MST) From: Technical Director To: Drumslayer In-Reply-To: <20050202200924.35488.qmail@web42103.mail.yahoo.com> Message-ID: <20050202131948.C63837@server1.ultratrends.com> References: <20050202200924.35488.qmail@web42103.mail.yahoo.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Milter: Spamilter (Reciever: server1.ultratrends.com; Sender-ip: 127.0.0.1; Sender-helo: server1.ultratrends.com;) cc: FreeBSD Database cc: questions Subject: Re: MySql Load balancing Solutions? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 02 Feb 2005 20:28:25 -0000 Drumslayer, > The only problem with this is that 4.1 is stil > considered Beta ("not yet ready for production"). I > see little chance in convincing managment to utilize > something beta for something so important. :( Forgive me for being possibly naive but from what I understand 4.1.X moved off of beta into Generally Available with a "This is the current generally available (GA) release of the MySQL database server. It is recommended for most users." [ http://dev.mysql.com/downloads/mysql/4.1.html ] Not necessarily saying it's bomb proof but I don't know if they classify it as beta anymore. As well if it means anything to you we would never have moved our 'crticial' services to 4.1.X from 4.0.XX if we didn't believe it was ready. Our wait time was seemingly forever but appears to have paid off with the stability and strength of the system. My 2 cents. Rob. On Wed, 2 Feb 2005, Drumslayer wrote: > > --- Technical Director wrote: > > > > > Drumslayer, > > > > I am part of a team running MySQL 4.1.X on 5 > > machines in a replication > > setup. Our first way to help manage load is the use > > of useful rules in > > our connection classes to direct "W"rites to our big > > server with fast I/O > > and memory and directing "R"reads to our slower I/O > > less RAM slaves only. > > > I so far have only seen an alternative from a company > called Emic. But it only runs any OS but freeBSD > sadly. (it modifies the kernel so compat won't do it) > > Have you heard of any hardware solutions or FreeBSD > friendly free or commercial products? I know basic > clustering and such is supposed to be OK but > everything that seems OS agnostic says it's Beta. > > We may wind up doing it this way but right now its a > toss up of a Beta Solution or move to linux with Emic. > Which I'm not fond of becouse its so convoluted and > Well Not BSD :) > > Thanks > > M. > > > > This one step in itself has done a LOT for keeping > > uptimes high and > > queries fast. > > > > A positive advantage is that the 5 machines allows > > us the opportunity to > > change the configuration if say one fails we can > > promote another slave to > > take that position or in the case of the "W"rite > > server we can promote a > > slave to a "W"rite server until the original "W"rite > > server can be recovered. > > > > As well whether you use C/C++, Java, PHP or some > > other scripting language > > to access your database it shouldn't be too hard to > > write some sort of > > algorithm in your connection to spread the > > connections across your host > > base. > > > > When it comes to management I won't lie, 4.0.XX's > > handling of Replication > > was tough. Since though we've made the move to 4.1.X > > our problems have > > become less and less. > > > > A final advantage to having seperate machines in a > > replication setup is > > the ability to upgrade a segment or machine to a > > newer MySQL version to > > see how it will operate on your hardware/OS and with > > your programs. We did > > this with our move from 4.0.XX to 4.1.X by taking 2 > > slaves out of the main > > loop, promoting one to the new 4.1.X master and the > > other slave to a new > > 4.1.X slave. After testing in pre-production we > > proceeded with the > > deployment on our other 3 boxes. > > > > INFO: Our 5 machine replication setup consists of: > > > > 1) 1 - 4 x P4 Xeon Compaq Server ("W"rite DB Server) > > 2) 4 - 1 x P3 Compaq Servers ("R"ead DB Server) > > > > NOTE: On a smaller scale on my home network I do the > > same on three > > machines all sub-server class. I still have great > > reliability and "robust" > > performance from such a simple design. > > > > I hope this information is helpful, I know it works > > well for us. > > > > Rob. > > > > On Tue, 1 Feb 2005, Drumslayer wrote: > > > > > Hi > > > I have been running a fairly heavy duty server > > for > > > MySQL on FreeBSD but its starting to peak. I would > > > like to know what others have done as far as using > > a > > > load balancing solution for MySQL or their success > > > with replication. > > > Also has anyone done a 64 bit build of MySQL on > > > FreeBSD successfully? > > > > > > Thanks! > > > > > > M. > > > > > > > > > > > > > > > > > > __________________________________ > > > Do you Yahoo!? > > > The all-new My Yahoo! - What will yours do? > > > http://my.yahoo.com > > > _______________________________________________ > > > freebsd-questions@freebsd.org mailing list > > > > > > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > > > To unsubscribe, send any mail to > > "freebsd-questions-unsubscribe@freebsd.org" > > > > > _______________________________________________ > > freebsd-questions@freebsd.org mailing list > > > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > > To unsubscribe, send any mail to > > "freebsd-questions-unsubscribe@freebsd.org" > > > > > > > > __________________________________ > Do you Yahoo!? > Yahoo! Mail - You care about security. So do we. > http://promotions.yahoo.com/new_mail > From owner-freebsd-database@FreeBSD.ORG Wed Feb 2 20:46:24 2005 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id ABD3716A4CE for ; Wed, 2 Feb 2005 20:46:24 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.193]) by mx1.FreeBSD.org (Postfix) with ESMTP id BBB3843D5A for ; Wed, 2 Feb 2005 20:46:23 +0000 (GMT) (envelope-from linicks@gmail.com) Received: by rproxy.gmail.com with SMTP id 34so120448rns for ; Wed, 02 Feb 2005 12:46:22 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=V5pDzYUBqmkx0mMrn2O1xaMLgteQzfOwSij0IqL0yK/p3vs2eBspad3xreYMp1cYBIJu7UJ4NcVOkk6YHTe5OqPHjcMOsOZHuIvQ4J5kQkx5G0s5APNP4XV26fKwR8CoQ5WnOxCK+9Y0XbhDknd5oWfzEo73jQ7N7ZrZBih/Ing= Received: by 10.38.206.45 with SMTP id d45mr238526rng; Wed, 02 Feb 2005 12:46:22 -0800 (PST) Received: by 10.38.8.20 with HTTP; Wed, 2 Feb 2005 12:46:22 -0800 (PST) Message-ID: Date: Wed, 2 Feb 2005 13:46:22 -0700 From: Nick Pavlica To: Technical Director In-Reply-To: <20050202131948.C63837@server1.ultratrends.com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <20050202200924.35488.qmail@web42103.mail.yahoo.com> <20050202131948.C63837@server1.ultratrends.com> cc: FreeBSD Database cc: questions Subject: Re: MySql Load balancing Solutions? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: Nick Pavlica List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 02 Feb 2005 20:46:24 -0000 All, MySql 4.1 has been the production release since 4.1.7 and are currently at the 4.1.9 release. You could look into the seperate MySql Cluster product, but it is around $5k per cpu last time I checked. --Nick On Wed, 2 Feb 2005 13:28:22 -0700 (MST), Technical Director wrote: > > Drumslayer, > > > The only problem with this is that 4.1 is stil > > considered Beta ("not yet ready for production"). I > > see little chance in convincing managment to utilize > > something beta for something so important. :( > > Forgive me for being possibly naive but from what I understand 4.1.X moved > off of beta into Generally Available with a "This is the current generally > available (GA) release of the MySQL database server. It is recommended for > most users." [ http://dev.mysql.com/downloads/mysql/4.1.html ] Not > necessarily saying it's bomb proof but I don't know if they classify it > as beta anymore. > > As well if it means anything to you we would never have moved our > 'crticial' services to 4.1.X from 4.0.XX if we didn't believe it was > ready. Our wait time was seemingly forever but appears to have paid off > with the stability and strength of the system. > > My 2 cents. > > Rob. > > On Wed, 2 Feb 2005, Drumslayer wrote: > > > > > --- Technical Director wrote: > > > > > > > > Drumslayer, > > > > > > I am part of a team running MySQL 4.1.X on 5 > > > machines in a replication > > > setup. Our first way to help manage load is the use > > > of useful rules in > > > our connection classes to direct "W"rites to our big > > > server with fast I/O > > > and memory and directing "R"reads to our slower I/O > > > less RAM slaves only. > > > > > > I so far have only seen an alternative from a company > > called Emic. But it only runs any OS but freeBSD > > sadly. (it modifies the kernel so compat won't do it) > > > > Have you heard of any hardware solutions or FreeBSD > > friendly free or commercial products? I know basic > > clustering and such is supposed to be OK but > > everything that seems OS agnostic says it's Beta. > > > > We may wind up doing it this way but right now its a > > toss up of a Beta Solution or move to linux with Emic. > > Which I'm not fond of becouse its so convoluted and > > Well Not BSD :) > > > > Thanks > > > > M. > > > > > > > This one step in itself has done a LOT for keeping > > > uptimes high and > > > queries fast. > > > > > > A positive advantage is that the 5 machines allows > > > us the opportunity to > > > change the configuration if say one fails we can > > > promote another slave to > > > take that position or in the case of the "W"rite > > > server we can promote a > > > slave to a "W"rite server until the original "W"rite > > > server can be recovered. > > > > > > As well whether you use C/C++, Java, PHP or some > > > other scripting language > > > to access your database it shouldn't be too hard to > > > write some sort of > > > algorithm in your connection to spread the > > > connections across your host > > > base. > > > > > > When it comes to management I won't lie, 4.0.XX's > > > handling of Replication > > > was tough. Since though we've made the move to 4.1.X > > > our problems have > > > become less and less. > > > > > > A final advantage to having seperate machines in a > > > replication setup is > > > the ability to upgrade a segment or machine to a > > > newer MySQL version to > > > see how it will operate on your hardware/OS and with > > > your programs. We did > > > this with our move from 4.0.XX to 4.1.X by taking 2 > > > slaves out of the main > > > loop, promoting one to the new 4.1.X master and the > > > other slave to a new > > > 4.1.X slave. After testing in pre-production we > > > proceeded with the > > > deployment on our other 3 boxes. > > > > > > INFO: Our 5 machine replication setup consists of: > > > > > > 1) 1 - 4 x P4 Xeon Compaq Server ("W"rite DB Server) > > > 2) 4 - 1 x P3 Compaq Servers ("R"ead DB Server) > > > > > > NOTE: On a smaller scale on my home network I do the > > > same on three > > > machines all sub-server class. I still have great > > > reliability and "robust" > > > performance from such a simple design. > > > > > > I hope this information is helpful, I know it works > > > well for us. > > > > > > Rob. > > > > > > On Tue, 1 Feb 2005, Drumslayer wrote: > > > > > > > Hi > > > > I have been running a fairly heavy duty server > > > for > > > > MySQL on FreeBSD but its starting to peak. I would > > > > like to know what others have done as far as using > > > a > > > > load balancing solution for MySQL or their success > > > > with replication. > > > > Also has anyone done a 64 bit build of MySQL on > > > > FreeBSD successfully? > > > > > > > > Thanks! > > > > > > > > M. > > > > > > > > > > > > > > > > > > > > > > > > __________________________________ > > > > Do you Yahoo!? > > > > The all-new My Yahoo! - What will yours do? > > > > http://my.yahoo.com > > > > _______________________________________________ > > > > freebsd-questions@freebsd.org mailing list > > > > > > > > > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > > > > To unsubscribe, send any mail to > > > "freebsd-questions-unsubscribe@freebsd.org" > > > > > > > _______________________________________________ > > > freebsd-questions@freebsd.org mailing list > > > > > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > > > To unsubscribe, send any mail to > > > "freebsd-questions-unsubscribe@freebsd.org" > > > > > > > > > > > > > > > __________________________________ > > Do you Yahoo!? > > Yahoo! Mail - You care about security. So do we. > > http://promotions.yahoo.com/new_mail > > > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org" > From owner-freebsd-database@FreeBSD.ORG Wed Feb 2 20:58:48 2005 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 1307916A4CE for ; Wed, 2 Feb 2005 20:58:48 +0000 (GMT) Received: from web42101.mail.yahoo.com (web42101.mail.yahoo.com [66.218.93.194]) by mx1.FreeBSD.org (Postfix) with SMTP id 87C1E43D48 for ; Wed, 2 Feb 2005 20:58:47 +0000 (GMT) (envelope-from drumslayer2@yahoo.com) Received: (qmail 24974 invoked by uid 60001); 2 Feb 2005 20:58:46 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=0Tqte2rzJkNuryZeROOE1asRZ4dxU7tdV2RfiAjEkzzApjPhWTkqnQ0Ejz4R/+VyV+nxvz5+48NrLyzAk0S3SvpfRU5exDEuBw252HKPWv7W/ItJAumzqXxCW/5AeZX4UwIy4TLb8/2A0R5egRuoX//gKYufvgJ0k1XmvVd0FTs= ; Message-ID: <20050202205846.24972.qmail@web42101.mail.yahoo.com> Received: from [67.112.21.27] by web42101.mail.yahoo.com via HTTP; Wed, 02 Feb 2005 12:58:46 PST Date: Wed, 2 Feb 2005 12:58:46 -0800 (PST) From: Drumslayer To: Technical Director In-Reply-To: <20050202131948.C63837@server1.ultratrends.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii cc: FreeBSD Database cc: questions Subject: Re: MySql Load balancing Solutions? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 02 Feb 2005 20:58:48 -0000 --- Technical Director wrote: > > Drumslayer, > > > The only problem with this is that 4.1 is stil > > considered Beta ("not yet ready for production"). > I > > see little chance in convincing managment to > utilize > > something beta for something so important. :( > > Forgive me for being possibly naive but from what I > understand 4.1.X moved > off of beta into Generally Available with a "This is > the current generally > available (GA) release of the MySQL database server. > It is recommended for > most users." [ > http://dev.mysql.com/downloads/mysql/4.1.html ] Not > necessarily saying it's bomb proof but I don't know > if they classify it > as beta anymore. Sorry I am feeding some of this to our "Data Base Guy" and that is what he told me. I should have looked it up myself. > As well if it means anything to you we would never > have moved our > 'crticial' services to 4.1.X from 4.0.XX if we > didn't believe it was > ready. Our wait time was seemingly forever but > appears to have paid off > with the stability and strength of the system. That's so great to hear. The way things are setup I manage the Hardware and OS and he does the daily Database stuff so I tend to defer to him since that's all he does. But it seems he was in error or out of date. Makes me happy :) Thanks! M. > My 2 cents. > > Rob. > > On Wed, 2 Feb 2005, Drumslayer wrote: > > > > > --- Technical Director > wrote: > > > > > > > > Drumslayer, > > > > > > I am part of a team running MySQL 4.1.X on 5 > > > machines in a replication > > > setup. Our first way to help manage load is the > use > > > of useful rules in > > > our connection classes to direct "W"rites to our > big > > > server with fast I/O > > > and memory and directing "R"reads to our slower > I/O > > > less RAM slaves only. > > > > > > I so far have only seen an alternative from a > company > > called Emic. But it only runs any OS but freeBSD > > sadly. (it modifies the kernel so compat won't do > it) > > > > Have you heard of any hardware solutions or > FreeBSD > > friendly free or commercial products? I know basic > > clustering and such is supposed to be OK but > > everything that seems OS agnostic says it's Beta. > > > > We may wind up doing it this way but right now > its a > > toss up of a Beta Solution or move to linux with > Emic. > > Which I'm not fond of becouse its so convoluted > and > > Well Not BSD :) > > > > Thanks > > > > M. > > > > > > > This one step in itself has done a LOT for > keeping > > > uptimes high and > > > queries fast. > > > > > > A positive advantage is that the 5 machines > allows > > > us the opportunity to > > > change the configuration if say one fails we can > > > promote another slave to > > > take that position or in the case of the "W"rite > > > server we can promote a > > > slave to a "W"rite server until the original > "W"rite > > > server can be recovered. > > > > > > As well whether you use C/C++, Java, PHP or some > > > other scripting language > > > to access your database it shouldn't be too hard > to > > > write some sort of > > > algorithm in your connection to spread the > > > connections across your host > > > base. > > > > > > When it comes to management I won't lie, > 4.0.XX's > > > handling of Replication > > > was tough. Since though we've made the move to > 4.1.X > > > our problems have > > > become less and less. > > > > > > A final advantage to having seperate machines in > a > > > replication setup is > > > the ability to upgrade a segment or machine to a > > > newer MySQL version to > > > see how it will operate on your hardware/OS and > with > > > your programs. We did > > > this with our move from 4.0.XX to 4.1.X by > taking 2 > > > slaves out of the main > > > loop, promoting one to the new 4.1.X master and > the > > > other slave to a new > > > 4.1.X slave. After testing in pre-production we > > > proceeded with the > > > deployment on our other 3 boxes. > > > > > > INFO: Our 5 machine replication setup consists > of: > > > > > > 1) 1 - 4 x P4 Xeon Compaq Server ("W"rite DB > Server) > > > 2) 4 - 1 x P3 Compaq Servers ("R"ead DB Server) > > > > > > NOTE: On a smaller scale on my home network I do > the > > > same on three > > > machines all sub-server class. I still have > great > > > reliability and "robust" > > > performance from such a simple design. > > > > > > I hope this information is helpful, I know it > works > > > well for us. > > > > > > Rob. > > > > > > On Tue, 1 Feb 2005, Drumslayer wrote: > > > > > > > Hi > > > > I have been running a fairly heavy duty > server > > > for > > > > MySQL on FreeBSD but its starting to peak. I > would > > > > like to know what others have done as far as > using > > > a > > > > load balancing solution for MySQL or their > success > > > > with replication. > > > > Also has anyone done a 64 bit build of MySQL > on > > > > FreeBSD successfully? > > > > > > > > Thanks! > > > > > > > > M. > > > > > > > > > > > > > > > > > > > > > > > > __________________________________ > > > > Do you Yahoo!? > > > > The all-new My Yahoo! - What will yours do? > > > > http://my.yahoo.com > > > > > _______________________________________________ > > > > freebsd-questions@freebsd.org mailing list > > > > > > > > > > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > > > > To unsubscribe, send any mail to > > > "freebsd-questions-unsubscribe@freebsd.org" > > > > > > > _______________________________________________ > > > freebsd-questions@freebsd.org mailing list > > > > > > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > > > To unsubscribe, send any mail to > > > "freebsd-questions-unsubscribe@freebsd.org" > > > > === message truncated === __________________________________ Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! http://my.yahoo.com From owner-freebsd-database@FreeBSD.ORG Thu Feb 3 09:32:08 2005 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 0DCC216A4CE; Thu, 3 Feb 2005 09:32:08 +0000 (GMT) Received: from male.aldigital.co.uk (male.thebunker.net [213.129.64.13]) by mx1.FreeBSD.org (Postfix) with ESMTP id 541C243D1F; Thu, 3 Feb 2005 09:32:07 +0000 (GMT) (envelope-from matthew@thebunker.net) Received: from gravitas.thebunker.net (gateway.ash.thebunker.net [213.129.64.4]) (using TLSv1 with cipher EDH-RSA-DES-CBC3-SHA (168/168 bits)) (No client certificate requested) by male.aldigital.co.uk (Postfix) with ESMTP id 2E7BB97845; Thu, 3 Feb 2005 09:32:05 +0000 (GMT) Received: from gravitas.thebunker.net (localhost [127.0.0.1]) j139VwCT084285; Thu, 3 Feb 2005 09:31:58 GMT (envelope-from matthew@gravitas.thebunker.net) Received: (from matthew@localhost) by gravitas.thebunker.net (8.13.1/8.13.1/Submit) id j139Vrj4084071; Thu, 3 Feb 2005 09:31:53 GMT (envelope-from matthew) Date: Thu, 3 Feb 2005 09:31:53 +0000 From: Matthew Seaman To: Nick Pavlica Message-ID: <20050203093153.GA1210@gravitas.thebunker.net> Mail-Followup-To: Matthew Seaman , Nick Pavlica , Technical Director , FreeBSD Database , Drumslayer , questions References: <20050202200924.35488.qmail@web42103.mail.yahoo.com> <20050202131948.C63837@server1.ultratrends.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="OXfL5xGRrasGEqWY" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.6i cc: FreeBSD Database cc: Technical Director cc: questions Subject: Re: MySql Load balancing Solutions? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 03 Feb 2005 09:32:08 -0000 --OXfL5xGRrasGEqWY Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Feb 02, 2005 at 01:46:22PM -0700, Nick Pavlica wrote: > MySql 4.1 has been the production release since 4.1.7 and are > currently at the 4.1.9 release. You could look into the seperate > MySql Cluster product, but it is around $5k per cpu last time I > checked. Uh --- MySQL Cluster is a standard part of 4.1.9. You just have to install the mysql41-server port WITH_NDB=3Dyes, which gets you a bunch of extra executables, mostly in /usr/local/libexec, including ndb_mgmd and ndbd. See: http://dev.mysql.com/doc/mysql/en/ndbcluster.html I set up a system using these just yesterday, and it's working like a charm (so far...) Cheers, Matthew --=20 Dr Matthew J Seaman MA, D.Phil. 8 Dane Court Manor School Rd PGP: http://www.infracaninophile.co.uk/pgpkey Tilmanstone Tel: +44 1304 617253 Kent, CT14 0JL UK --OXfL5xGRrasGEqWY Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (FreeBSD) iQCVAwUBQgHviZr7OpndfbmCAQIJLAQAtyqt3HZOMn1OasFagV0c+A3Gi6kOPUEB fnG4f2n3XMqSS+2BH1hjQ1AHNwiub1rmuQHX0BlaK9rHR4XqkxUN6a1hWI4YtObc ixTs2I923/WGEKMXSgoWLiFpgp3C9igtudP1tI1qA9JSOV4ood57RC43hywE8Jx7 cpx+SoDArNU= =LGpY -----END PGP SIGNATURE----- --OXfL5xGRrasGEqWY-- From owner-freebsd-database@FreeBSD.ORG Thu Feb 3 21:02:41 2005 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 9565716A4CE for ; Thu, 3 Feb 2005 21:02:41 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.193]) by mx1.FreeBSD.org (Postfix) with ESMTP id 7F83543D41 for ; Thu, 3 Feb 2005 21:02:37 +0000 (GMT) (envelope-from linicks@gmail.com) Received: by rproxy.gmail.com with SMTP id 40so248262rnz for ; Thu, 03 Feb 2005 13:02:33 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=ol8MmePBYUA/1JK9OcLUCxpyDUjlYfEafvt82w6b5cl8toISPWvk/mS9gJAToVOaAnynHGN+QGaWSNOeOfFE1dTZnkYJiwkPaZbGO6X4Gut3fWDEqMNDxv2UEPCnFYHwdJ7vygIeTmcaIvaOk0+SMzieAZlyCCCPKhWwGziMWDA= Received: by 10.38.19.34 with SMTP id 34mr23646rns; Thu, 03 Feb 2005 13:02:33 -0800 (PST) Received: by 10.38.8.20 with HTTP; Thu, 3 Feb 2005 13:02:33 -0800 (PST) Message-ID: Date: Thu, 3 Feb 2005 14:02:33 -0700 From: Nick Pavlica To: Matthew Seaman , Nick Pavlica , Technical Director , FreeBSD Database , Drumslayer , questions In-Reply-To: <20050203093153.GA1210@gravitas.thebunker.net> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <20050202200924.35488.qmail@web42103.mail.yahoo.com> <20050202131948.C63837@server1.ultratrends.com> <20050203093153.GA1210@gravitas.thebunker.net> Subject: Re: MySql Load balancing Solutions? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: Nick Pavlica List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 03 Feb 2005 21:02:41 -0000 > Uh --- MySQL Cluster is a standard part of 4.1.9. You just have to > install the mysql41-server port WITH_NDB=yes, which gets you a bunch > of extra executables, mostly in /usr/local/libexec, including ndb_mgmd > and ndbd. See: http://dev.mysql.com/doc/mysql/en/ndbcluster.html Yes it's part of 4.19, but if your software is not licenced under the GPL you must buy a licence for the MySql servers ($595/server), and another licence for MySql Cluster($5,000/CPU). So if you you have three servers with dual cpus you would owe MySql $31,785. The licencing applies to any situation where you are running the database on more that one server, even if it is a web application. I spent quite a bit of time working with a MySql representative trying to clear this out a while back, and called them back to confirm today. Here is the name of the Mysql rep. that I spoke to: Rena Dosono Inside Sales Executive MySQL, Inc. www.mysql.com Tel: 206-824-4356 Email: rena@mysql.com I'm sure all your code is GPL and is available in source for download :) --Nick On Thu, 3 Feb 2005 09:31:53 +0000, Matthew Seaman wrote: > On Wed, Feb 02, 2005 at 01:46:22PM -0700, Nick Pavlica wrote: > > > MySql 4.1 has been the production release since 4.1.7 and are > > currently at the 4.1.9 release. You could look into the seperate > > MySql Cluster product, but it is around $5k per cpu last time I > > checked. > > Uh --- MySQL Cluster is a standard part of 4.1.9. You just have to > install the mysql41-server port WITH_NDB=yes, which gets you a bunch > of extra executables, mostly in /usr/local/libexec, including ndb_mgmd > and ndbd. See: http://dev.mysql.com/doc/mysql/en/ndbcluster.html > > I set up a system using these just yesterday, and it's working like a > charm (so far...) > > Cheers, > > Matthew > > -- > Dr Matthew J Seaman MA, D.Phil. 8 Dane Court Manor > School Rd > PGP: http://www.infracaninophile.co.uk/pgpkey Tilmanstone > Tel: +44 1304 617253 Kent, CT14 0JL UK > > > From owner-freebsd-database@FreeBSD.ORG Fri Feb 4 12:05:00 2005 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 5047716A4CE for ; Fri, 4 Feb 2005 12:05:00 +0000 (GMT) Received: from lurza.secnetix.de (lurza.secnetix.de [83.120.8.8]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5BE2543D5A for ; Fri, 4 Feb 2005 12:04:59 +0000 (GMT) (envelope-from olli@lurza.secnetix.de) Received: from lurza.secnetix.de (nwluzy@localhost [127.0.0.1]) by lurza.secnetix.de (8.13.1/8.13.1) with ESMTP id j14C4v3e083456; Fri, 4 Feb 2005 13:04:57 +0100 (CET) (envelope-from oliver.fromme@secnetix.de) Received: (from olli@localhost) by lurza.secnetix.de (8.13.1/8.13.1/Submit) id j14C4vCe083455; Fri, 4 Feb 2005 13:04:57 +0100 (CET) (envelope-from olli) Date: Fri, 4 Feb 2005 13:04:57 +0100 (CET) Message-Id: <200502041204.j14C4vCe083455@lurza.secnetix.de> From: Oliver Fromme To: freebsd-database@FreeBSD.ORG, Nick Pavlica In-Reply-To: X-Newsgroups: list.freebsd-database User-Agent: tin/1.5.4-20000523 ("1959") (UNIX) (FreeBSD/4.11-RELEASE (i386)) MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Subject: Re: MySql Load balancing Solutions? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: freebsd-database@FreeBSD.ORG, Nick Pavlica List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 04 Feb 2005 12:05:00 -0000 Nick Pavlica wrote: > [...] > > Uh --- MySQL Cluster is a standard part of 4.1.9. You just have to > > install the mysql41-server port WITH_NDB=yes, which gets you a bunch > > of extra executables, mostly in /usr/local/libexec, including ndb_mgmd > > and ndbd. See: http://dev.mysql.com/doc/mysql/en/ndbcluster.html > > Yes it's part of 4.19, but if your software is not licenced under the > GPL you must buy a licence for the MySql servers ($595/server), and > another licence for MySql Cluster($5,000/CPU). That only applies if you are redistributing mysql. If you are only _using_ it, then it doesn't matter at all, and your other software doesn't have to be GPL. Specifically, www.mysql.com says [1]: "Free use for those who never copy, modify or distribute. As long as you never distribute the MySQL Software in any way, you are free to use it for powering your application, irrespective of whether your application is under GPL license or not." That's as clear as it can get. :-) Best regards Oliver [1]: http://www.mysql.com/company/legal/licensing/opensource-license.html -- Oliver Fromme, secnetix GmbH & Co KG, Oettingenstr. 2, 80538 München Any opinions expressed in this message may be personal to the author and may not necessarily reflect the opinions of secnetix in any way. "It combines all the worst aspects of C and Lisp: a billion different sublanguages in one monolithic executable. It combines the power of C with the readability of PostScript." -- Jamie Zawinski, when asked: "What's wrong with perl?" From owner-freebsd-database@FreeBSD.ORG Fri Feb 4 20:53:34 2005 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 0492716A4CE for ; Fri, 4 Feb 2005 20:53:34 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.201]) by mx1.FreeBSD.org (Postfix) with ESMTP id 9549F43D2D for ; Fri, 4 Feb 2005 20:53:29 +0000 (GMT) (envelope-from linicks@gmail.com) Received: by rproxy.gmail.com with SMTP id 40so331298rnz for ; Fri, 04 Feb 2005 12:53:29 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=auRIhH8+BVb0aYP1UUtuiOS17BON+8gjPDyYWrT6UP1R3mfAjnpF6VkFUkrEzWkp90O1oOBjm1mfYrUO/xIxUX5b2coJdjBApkhSPg1grXNl9cFjPbj2A2Y/38yKC5Smb8KDI+vQy2VWECv1yw8ksutmbTeYbCUchCpebVX6Jvw= Received: by 10.38.8.57 with SMTP id 57mr165278rnh; Fri, 04 Feb 2005 12:53:28 -0800 (PST) Received: by 10.38.8.20 with HTTP; Fri, 4 Feb 2005 12:53:28 -0800 (PST) Message-ID: Date: Fri, 4 Feb 2005 13:53:28 -0700 From: Nick Pavlica To: freebsd-database@freebsd.org, Nick Pavlica In-Reply-To: <200502041204.j14C4vCe083455@lurza.secnetix.de> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable References: <200502041204.j14C4vCe083455@lurza.secnetix.de> Subject: Re: MySql Load balancing Solutions? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: Nick Pavlica List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 04 Feb 2005 20:53:34 -0000 Oliver, Please contact MySql for verification/clarification like I did. The MySql Rep. explained to me that by installing the database on more that one computer, even if it is for you own use, it is considered a distributed piece of software and should be licenced. Obviously if you are replicating or clustering you are going to have more than one server running the database and should licence the software. If this truly isn't the case, I would like to have it cleared up with MySql.=20 The reps info is as follows: Rena Dosono Inside Sales Executive MySQL, Inc. www.mysql.com Tel: 206-824-4356 Email: rena@mysql.com You may want to talk to another Rep to get an additional take. --Nick On Fri, 4 Feb 2005 13:04:57 +0100 (CET), Oliver Fromme wrote: > Nick Pavlica wrote: > > [...] > > > Uh --- MySQL Cluster is a standard part of 4.1.9. You just have to > > > install the mysql41-server port WITH_NDB=3Dyes, which gets you a bun= ch > > > of extra executables, mostly in /usr/local/libexec, including ndb_mg= md > > > and ndbd. See: http://dev.mysql.com/doc/mysql/en/ndbcluster.html > > > > Yes it's part of 4.19, but if your software is not licenced under the > > GPL you must buy a licence for the MySql servers ($595/server), and > > another licence for MySql Cluster($5,000/CPU). >=20 > That only applies if you are redistributing mysql. If > you are only _using_ it, then it doesn't matter at all, > and your other software doesn't have to be GPL. >=20 > Specifically, www.mysql.com says [1]: >=20 > "Free use for those who never copy, modify or distribute. > As long as you never distribute the MySQL Software in any > way, you are free to use it for powering your application, > irrespective of whether your application is under GPL > license or not." >=20 > That's as clear as it can get. :-) >=20 > Best regards > Oliver >=20 > [1]: > http://www.mysql.com/company/legal/licensing/opensource-license.html >=20 > -- > Oliver Fromme, secnetix GmbH & Co KG, Oettingenstr. 2, 80538 M=FCnchen > Any opinions expressed in this message may be personal to the author > and may not necessarily reflect the opinions of secnetix in any way. >=20 > "It combines all the worst aspects of C and Lisp: a billion different > sublanguages in one monolithic executable. It combines the power of C > with the readability of PostScript." > -- Jamie Zawinski, when asked: "What's wrong with perl?" >