Hi,
Then What about MYSQL 5.0?
At present we are using MYSQL 5.0 in our production Environment.
This is a huge project we wish to go with and there can be more billions of
information will be stored in database and has to be searched and retrieved
quickly.
My Server Administration team suggests us to go with a Cluster Configuration
with MYSQL 5.0 and here I want to know about its setup [Including the
Hardware and Software details for configuring it in LINUX] advantages and
disadvantages.
Thanks,
V.Murali
Keep in Touch
.
-----Original Message-----
From: Mikael Ronström [mailto:mikael@stripped]
Sent: Friday, November 16, 2007 1:43 PM
To: MuraliPD@GMail
Cc: 'John David Duncan'; 'Jonathan Haddad'; cluster@stripped
Subject: Re: Cluster performance in web environment
Hi,
16 nov 2007 kl. 08.13 skrev MuraliPD@GMail:
> Hi John,
>
> But MYSQL 5.1 is not yet in Production rite?
>
It's not a GA version yet, currently an RC. However it's been in long
use in production at various customers.
Rgrds Mikael
> As performance vise, Tables with NDB storage Engine will give us
> better
> performance in Searching Text and Retrieving Large Data like XML
> from the DB
> [As similar to MYISAM].
>
>
> Thanks,
> V.Murali
> Keep in Touch...
>
>
> -----Original Message-----
> From: John David Duncan [mailto:jdd@stripped]
> Sent: Friday, November 16, 2007 12:32 PM
> To: MuraliPD@GMail
> Cc: 'Jonathan Haddad'; cluster@stripped
> Subject: Re: Cluster performance in web environment
>
>>> My own advice is like this: First, use 5.1. There's not really much
>>> reason to use 5.0 Cluster anymore. Second, Dolphin SCI cards
>>> cost as
>>> little as $1500 per box and can be well worth it.
>>
>> What this really means Cluster 5.0 and Cluster 5.1... As similar to
>> MYSQL
>> Version 5.0 and 5.1 .... Is that different versions available in the
>> MYSQL
>> CLUSTER 5.0 and 5.1?
>
> I mean MySQL 5.1.
>
> MySQL 5.1 is not yet generally available for production use. However,
> MySQL Cluster in MySQL 5.1 is generally better than 5.0
>
>> Don't really get this point..
>> Only tables with ndbcluster storage engine will be reflected to the
>> other
>> nodes then how can we maintain tables with InnoDB/MYISAM storage
>> engines in
>> the different nodes.
>
> InnoDB & MyISAM tables will be local to the MySQL server where they
> are resident. Only NDB (cluster) tables will be visible from multiple
> MySQL servers.
>
> JD
>
>
> --
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe: http://lists.mysql.com/cluster?
> unsub=mikael@stripped
>
