Oracle announced availability of a new Development Milestone Release for MySQL 5.7, with enhancements in replication, security, and instrumentation that are aimed at boosting the performance, scalability, and manageability of the open source database. Oracle also announced additional MySQL product releases and early access features. According to Oracle, benchmark tests have shown that MySQL 5.7.4 DMR delivers 2x better QPS (queries per second) than MySQL 5.6, and 3x better than MySQL 5.5
In addition to MySQL 5.7.4 DMR, Oracle is also making available the Release Candidate of MySQL Fabric, providing high availability management and scale out through sharding. MySQL Fabric is included in the Release Candidate version of MySQL Utilities 1.4.2. MySQL Workbench 6.1 is also now generally available, delivering additional capabilities for performance assessment and query optimization. In addition, Oracle is providing early access to features under development including Geographic Information System (GIS) and multi-source improvements, and a preview of MySQL Cluster 7.4, for community testing.
In terms of performance and scalability, MySQL DMR 5.7.4 adds performance and throughput improvements for Solid State Disks (SSD), as well as improved InnoDB buffer pool and metadata locking, and semi-synchronous replication performance enhancements. Oracle said that benchmark tests using SysBench Read-only Point-Selects, at 1024 connections, resulted in MySQL 5.7 delivering 512,000 QPS, 2x better than MySQL 5.6, and 3x better than MySQL 5.5
To improve manageability, MySQL 5.7.4 DMR adds MyOptimizer enhancements to enable more accurate cost calculations; performance schema improvements, including added instrumentation; and security enhancements, including Advanced Encryption Standard (AES) 256-bit encryption and new options for password management.
Oracle continues to invest in MySQL innovation, said Tomas Ulin, vice president, MySQL Engineering, Oracle, in a statement released by the company. "By encouraging ongoing community participation and following the 'release early, release often' model, we help shorten the feedback-to-delivery cycle and allow users to get faster access to improved product capabilities and quality."