MySql Load balancing Solutions?

[Nick Pavlica]

> 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 at 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
<m.seaman at infracaninophile.co.uk> 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
> 
> 
>