Ahead of Oracle's OpenWorld conference in 2013, the company first began to talk about a major new release of its open-source MySQL database. Now two years later, development on MySQL 5.7 is compete and general availability is set for October 26.
Tomas Ulin, vice president, MySQL Engineering at Oracle told DatabaseJournal that Oracle has been able to add a tremendous amount of major new features to MySQL in the last two years.
"MySQL 5.7 represents a major milestone in the history of MySQL and it offers very compelling new features, along with improved performance and stability--it's something that every MySQL user should examine," Ulin said.
Among the new features and enhancements that have been added to MySQL 5.7 since MySQL 5.6 are:
• Performance: 3x faster with read-only performance of 1.6 million queries/second on Linux
• JSON Support using a native binary format for efficient processing & storage
• Multi-Source Replication, enabling a replication slave to receive transactions from multiple sources simultaneously
• Optimizer Cost Model, resulting in better query performance
• Query Rewrite Plugin to specify how certain queries that arrive at the server should be rewritten
• Sys Schema providing easy to understand views with insights into MySQL health and performance
• GIS Spatial Extensions for mobile applications and location based services
• InnoDB Transparent Page Level Compression with support for Zlib and LZ4
• InnoDB Native Partitioning reducing memory requirements by up to 90%
• InnoDB Native Full Text Search with better performance and support for Chinese, Japanese, and Korean
• Performance Schema with additional instrumentation and lower overhead
• Security through safer initialization, enhanced data encryption, better password handling and more
• Replication enhancements including GTIDs, semi-synchronous replication, new performance schema tables, and dynamic replication filters
As to why it has taken two years for MySQL 5.7 to reach general availability, Ulin noted that simply put, there are a lot of new features and improvements with enhancements made in virtually all areas across the product.
One area that is particularly interesting is the improvement to Global Transaction Identifiers. Ulin explained that Global Transaction Identifiers are used to uniquely identify each replication event, which greatly simplifies the job of developers and DBAs who manage MySQL replication.
"It can eliminate many potential legacy problems when managing binary log file names and positions across large replication groups, and it allows MySQL nodes to easily track what's been executed where, allowing them to intelligently manage their individual and group state without manual intervention," Ulin explained. "In MySQL 5.7 you can now enable GTIDs as an on-line operation, thus removing what has been an adoption obstacle for users."
In addition to MySQL 5.7, Oracle is also releasing the new MySQL Router technology. Ulin noted that MySQL Router is open source and licensed under the GPL.
"The Router would typically be part of the application stack," Ulin explained. "So for example, your applications can connect to port 3306 on localhost, and then the Router would transparently route the application connections within your MySQL farm."
Looking forward, the plan is to continue to improve the performance and scalability of MySQL.
"Making MySQL an even more natural choice in modern cloud-based deployments is also important," Ulin said. " We plan to focus on making MySQL increasingly adaptive, available, and resilient so it just works, without manual intervention from administrators, regardless of the failures and changes that can happen within cloud environments."
Sean Michael Kerner is a senior editor at Database Journal and InternetNews.com. Follow him on Twitter @TechJournalist