Re: Cluster performance in web environment

[Jon Stephens]

MuraliPD@GMail wrote:
> Hi John,
> 
> But MYSQL 5.1 is not yet in Production rite?

You're heaps better off looking at the current known issues in 5.1 in 
relation to your actual requirements and basing your decision on that 
than you are with trying to use labels.

Here's some places to find relevant information:

Open Issues In MySQL 5.1 -

http://dev.mysql.com/doc/refman/5.1/en/open-bugs.html

Previous MySQL Cluster Issues Resolved in MySQL 5.1 -

http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-limitations-resolved.html

MySQL Cluster Changes in MySQL 5.1 -

http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-5-1-changes.html

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

NDB does not support FULLTEXT indexes, if that's what you're asking 
about. MyISAM is the only storage engine that has those.

cheers

jon.

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


-- 

Jon Stephens - jon@stripped
Technical Writer - MySQL Documentation Team
Stockholm, Sweden
Mobile: [phone] (GMT +01.00)
MySQL AB: www.mysql.com