SOFTWARE DEVELOPER Oracle has released MySQL 5.6, citing improved performance and NoSQL access to InnoDB tables.
Oracle, which acquired MySQL when it bought Sun Microsystems, has been proclaiming its support to the free, open source database management system, promising it will continue to develop the immensely popular software product. Now the firm has released MySQL 5.6, saying it has up to 230 percent improvement in transactional performance and improved query optimisation tools.
Oracle's MySQL, which is facing growing competition from NoSQL databases such as MongoDB and CouchDB, now allows key value lookups with InnoDB tables and even took on one of NoSQL's big selling points by claiming it now supports self-healing replication clusters. The firm also touted improved replication performance, with multi-threaded replication slaves sporting up to five times higher performance.
Oracle said that along with improved NoSQL and replication features, MySQL developers will have access to better query optimisation tools that now optimise sub-queries before they are executed. The firm has also incorporated Index Condition Pushdown and Batch Key Access, which Oracle claims in the right conditions can provide a 280 times jump in query throughput.
While keen to talk up the new features in MySQL 5.6, Thomas Ulin, VP of MySQL engineering at Oracle was mindful of the community's worries about Oracle's continued support of the open source database and said that the firm had listened to the feedback it received on release candidates for MySQL 5.6.
He said, "The new features and enhancements that MySQL 5.6 delivers further demonstrate Oracle's investment in driving MySQL innovation, making MySQL a fantastic fit for today's most demanding web, cloud and embedded application requirements."
Ulin's comments come just days after popular Linux distributions Fedora and OpenSUSE announced that they will drop MySQL in favour of MariaDB. Despite this, Oracle's latest release shows that the firm is still bringing new features into the free Community Edition of the MySQL database server rather than limiting them to the Enterprise version, which should please a few of its customers that are considering jumping to alternatives including NoSQL. µ
Uses 20 percent less power than traditional systems
It's becoming more prevalent in car research and development
Sign up for INQbot – a weekly roundup of the best from the INQ