Hi,
16 nov 2007 kl. 09.51 skrev MuraliPD@GMail:
> 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.
>
You can obviously use 5.0 as well, but given that you're requirements
are on the
high side I would recommend 5.1 and possibly even being in contact
with MySQL
to know more about the Cluster Carrier Grade Editions.
5.1 has ontop of the disk data possibility for non-indexed data also
more efficient
storage of VARCHAR fields.
Rgrds Mikael
>
>
>
> 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
>>
>
