thank you all for the responses thus far.
Just to add onto the requirements.
The client's business is based around a website that does all
business related tasks and are exremely utilized.
The idea is to provide failover as well as the best possible
Any ideas on this will help us out in making the final
Ps.... there are only 2 machine available for the databases.
From: Joerg Bruehe <joerg.bruehe@stripped>
To: Machiel Richards <machielr@stripped>
Cc: mysql mailing list <mysql@stripped>
Subject: Re: MySQL clustering and licensing
Date: Wed, 10 Nov 2010 00:09:16 +0100
Machiel Richards wrote:
> Good day all
> Maybe someone can assist me here as I am not sure where to get this
> information from and I need this for a proposed environment for a
> 1. The client will have 2 new machines, had a look at the specs and
> it is fairly good considering it will be dedicated to MySQL. The
> question is, is the solution able to use 2 nodes without shared storage
> and be clustered?
If by "clustered" you mean what most products call "cluster", you cannot
apply that concept to MySQL:
The MySQL Cluster product is an in-memory database keeping the data
mirrored in the RAM (!) of (at least) two machines.
It is especially designed for extremely fast response times, typical
customers include some telecommunication providers.
Even though AFAIK you can run MySQL Cluster on just two nodes, I think
it would be a very untypical setup, and very likely your client's
application is not what MySQL Cluster was designed for.
> 2. Is there further licensing implications?
MySQL Cluster is available with either GPL or a commercial license.
> 3. Is this part of the Enterprize edition license ? Currently there
> is a Mysql enterprize Gold support contract in place, however not sure
> it requires aditional licences for clustering or not.
MySQL Cluster is a separate product, AFAIK it is not covered by any
support contract for the general server but needs one of its own.
> I would really appreciate any suggestions here, I am busy trying to
> get the info from the net as well but I am pressured for responses.
If your client runs a typical database application, I suspect the
replication feature is much more appropriate for them.