Preview of MySQL 5.6.5
Preview of MySQL 5.6.5
Written by Kay Ewbank   
Tuesday, 17 April 2012

Oracle has released a preview version of MySQL to coincide with this year’s MySQL Conference and Expo.

The Development Milestone Release (DMR) is of MySQL 5.6.5, and according to a blog post from Rob Young, Product Manager for MySQL, the highlights of the new release are self-healing replication clusters and better query optimization and throughput.

Young says that the new version adds global transaction Ids and automated utilities for self-healing replication clusters, admitting that until now, setting up self-healing replication clusters has been

somewhat of a pain point for MySQL users with most developing custom solutions or looking to costly, complex third-party solutions for these capabilities.”

The global transaction ids are supported by a set of utilities that make use of them to provide manual or automatic failover to the most up to date slave replica in the event of a master failure.

The new version also promises improvements to complex query optimization and throughput. This has been achieved by a number of changes, starting with the inclusion of subqueries in the optimizer path. Application developers can also consolidate multiple queries and result sets into a single unit of work. Range based queries can be optimized, and you can also include queries using Order By clauses in the optimizer.

To download the MySQL 5.6.5 DMR go to the download site and click the Development Releases tab

Alongside the development release, MySQL is showing off some "Early Access" development features via the MySQL Labs.  These are things that may or may not make it into future releases, and the current crop includes InnoDB online operations for adding indexes and renaming columns; and direct access to data in InnoDB without the need to use SQL. This has been added using the memcache API, and gives developers the means to have both fast, simple key/value access and complex query support in their applications.

These improvements can be tried out in the download called "mysql-5.6-labs-april-2012" from  MySQL Labs. See the InnoDB blog for details.

More Information

New Replication, Optimizer and High Availability features in MySQL 5.6.5!

InnoDB 2012 Spring Labs Release

Related Articles

MySQL 5.5 Now Available

MySQL 5.6 - more speed and scalability

 

 
 

 

blog comments powered by Disqus

 

To be informed about new articles on I Programmer, subscribe to the RSS feed, follow us on Google+, Twitter, Linkedin or Facebook or sign up for our weekly newsletter.

 

Banner


Three New Experiments for Firefox Test Pilot
03/08/2017

Firefox Test Pilot is an opt-in program where you can have early access to features designed to be Firefox add-ins and extensions while they are in the early stages of development. This week three new [ ... ]



Can You Craft A HTML5 Game In 13Kb?
13/08/2017

The 2017 edition of a long running contest kicks off today. The challenge is to write a HTML5 game in JavaScript whose code and assets can be zipped into a package with a 13Kb limit.


More News

Last Updated ( Tuesday, 17 April 2012 )
 
 

   
RSS feed of news items only
I Programmer News
Copyright © 2017 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.