Hi John,
But MYSQL 5.1 is not yet in Production rite?
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
