Oracle Announces General Availability of MySQL 5.7

New version of the world's most popular open source database is up to 3x faster than MySQL 5.6 in benchmark tests

REDWOOD SHORES, California, Oct. 19, 2015 /PRNewswire/ -- Oracle today announced the general availability of MySQL 5.7, the latest version of the world's most popular open source database. The new version delivers greater performance, scalability and manageability, plus enhanced NoSQL capabilities with JSON support and MySQL Router, which makes it easy to connect applications to multiple MySQL databases.

Photo - http://photos.prnewswire.com/prnh/20151019/278048

"MySQL 5.7 delivers a wide range of innovations allowing developers, database administrators and DevOps teams to build and manage next-generation Web and cloud-based applications capable of processing ever increasing volumes of data," said Tomas Ulin, vice president, MySQL Engineering, Oracle. "MySQL 5.7 builds upon Development Milestone Releases that have enabled users to preview, test and provide feedback during the development process – and as a result, this release has been a collaborative process involving many members of the MySQL community."

Ulin will provide an overview of what's new in MySQL 5.7 during the upcoming MySQL Central @ OpenWorld "State of the Dolphin" address in San Francisco on Monday, October 26 at 4.00 pm. Additionally, a webcast will be held on November 11, 2015, at 9.00 a.m. US Pacific Time.

"Booking.com's initial testing of the Development Milestone Releases has shown promising improvements that will enable us to perform online configuration and schema changes with less downtime," said Nicolai Plum, senior systems architect, Booking.com. "The multi-source and parallel replication improvements in MySQL 5.7 GA will help us to continue scaling our global e-commerce business with ease and we look forward to deploying it soon."

Key enhancements in MySQL 5.7, which deliver greater performance and scalability, include:

• Enhanced Speed: In benchmark tests using SysBench Read-only Point-Selects, at 1,024 connections, MySQL 5.7 delivered 1,600,000 queries per second (QPS) --  3x faster than MySQL 5.6.
• Optimized InnoDB: New capabilities include increased performance and concurrency, enhanced on-line operations, spatial indexes, native partitioning and more.
• More Robust Replication: Enhancements to MySQL's replication features include multi-source replication, enhanced Global Transaction Identifiers (GTIDs), and improved multi-threaded slaves for better scalability and availability.
• Enhanced Optimizer: A new MySQL optimizer dynamic cost model provides better query performance and greater user control.

Primary manageability enhancements within MySQL 5.7 include: