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.
Joerg Bruehe, MySQL Build Team, joerg.bruehe@stripped
ORACLE Deutschland B.V. & Co. KG, Komturstrasse 18a, D-12099 Berlin
Geschaeftsfuehrer: Juergen Kunz, Marcel v.d. Molen, Alexander v.d. Ven
Amtsgericht Muenchen: HRA 95603