From owner-freebsd-questions@FreeBSD.ORG Thu Feb 3 21:02:40 2005 Return-Path: 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 D7D0616A4CE for ; Thu, 3 Feb 2005 21:02:40 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.194]) by mx1.FreeBSD.org (Postfix) with ESMTP id 7F6C043D3F for ; Thu, 3 Feb 2005 21:02:37 +0000 (GMT) (envelope-from linicks@gmail.com) Received: by rproxy.gmail.com with SMTP id 40so248263rnz 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-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: Nick Pavlica List-Id: User questions 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 > > >