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--