MySQL cluster 7.2 is not yet GA and so e wouldn't recommend using it in a production
environment. Customers have tried it out but not gone live with it
On 22 Sep 2011, at 14:04, umapathi b <umapathi.b@stripped> wrote:
> Hi All,
> Is there anybody using cluster 7.2 version in production ?
> Can we use it on production ?
> - Umapathi.
> ---------- Forwarded message ----------
> From: Mat Keep <mat.keep@stripped>
> Date: Thu, Sep 22, 2011 at 6:24 AM
> Subject: Re: join queries
> To: umapathi b <umapathi.b@stripped>
> Cc: cluster@stripped
> Hi Umapathi
> The MySQL Cluster 7.2 Development Release would be the best place to start
> as this includes the Index Statistics function which works with the SQL
> optimizer to create execution plans that push JOIN operations down to the
> cluster data nodes, rather than being resolved in the server - this giving
> much lower latency
> This new capability is called Adaptive Query Localization (AQL), and you can
> learn more about it here:
> We do also have a performance optimization guide which provides best
> practices on query optimization (note, it does not yet reflect AQL), and
> this can be downloaded from here (registration required):
> Would be very interested in hearing your results
> On 22/09/2011 11:00, umapathi b wrote:
>> Hi All,
>> Can anybody share any resources/links which will be useful to optimize
>> environment ..especially the queries with joins ..
>> I am trying to migrate my existing environment(MYISAM) with the same
>> queries and tables to mysql cluster.
>> But a straight forward query which runs in MYISAM within 0.1 seconds takes
>> around 30 seconds in Cluster.
>> Help is highly appreciated/needed.
>> 80191 33653
> Mat Keep
> MySQL Cluster& HA Programs
> Oracle Corp.
> +44 (0)7765 898-605