MySQL clustering and licensing

--=-i4iJO3H/tf1UAPJwkXT7
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit

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


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?

2. Is there further licensing implications?

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.


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.

Regards
Machiel




--=-i4iJO3H/tf1UAPJwkXT7--

Re: MySQL clustering and licensing

Hi!


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


HTH,
Joerg

--
Joerg Bruehe, MySQL Build Team, joerg.bruehe@oracle.com
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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: MySQL clustering and licensing

--=-5vrc45lKvBBtwgmaSh1R
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit

Good day

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
response times.


Any ideas on this will help us out in making the final
decisions.

Ps.... there are only 2 machine available for the databases.

Regards



-----Original Message-----
From: Joerg Bruehe
To: Machiel Richards
Cc: mysql mailing list
Subject: Re: MySQL clustering and licensing
Date: Wed, 10 Nov 2010 00:09:16 +0100


Hi!


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


HTH,
Joerg




--=-5vrc45lKvBBtwgmaSh1R--

Re: MySQL clustering and licensing

Hi!


Machiel Richards wrote:
> Good day
>
> 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
> response times.
>
>
> Any ideas on this will help us out in making the final
> decisions.
>
> Ps.... there are only 2 machine available for the databases.

With those specifications, I am quite certain:
Check out the replication feature to achieve failover, this should be a
standard setup.

For fast response times, you will need good design and (maybe) the
tuning techniques which are discussed here so often.

Advanced strategies for performance increase might include using the
MySQL Proxy and going for a read/write splitting between the replicated
machines, but I'm not sure whether a 2-machine setup will gain much.


HTH,
Joerg

--
Joerg Bruehe, MySQL Build Team, joerg.bruehe@oracle.com
(+49 30) 417 01 487
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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org