The second day of Percona Live 2016 is wrapping up, but I still wanted to get to one last lecture. Fortunately, there was a great one available: What’s New in MySQL with Geir Høydalsvik, Senior Software Development Director at Oracle, and Simon Mudd, DBA at booking.com.
MySQL 5.7 is an extremely exciting new version of the world’s most popular open source database that is 2x faster than MySQL 5.6, while also improving usability, manageability, and security. MySQL 5.7, now in GA, is the result of almost three years of development and brings improvements to all areas of the product. Some key enhancements include:
- MySQL improved InnoDB scalability and temporary table performance, enabling faster online and bulk load operations, and more.
- They’ve added native JSON support.
- For increased availability and performance, they’ve included multi-source replication, multi-threaded slave enhancements, online GTIDs, and enhanced semi-sync replication.
- They’ve added numerous new monitoring capabilities so the Performance Schema for better insights, reduced the footprint and overhead, and significantly improved ease of use with the new SYS Schema.
- They are fulfilling “secure by default” requirements, and many new MySQL 5.7 features will help users keep their database secure.
- They have rewritten large parts of the parser, optimizer, and cost model. This has improved maintainability, extendability, and performance.
- GIS is completely new in MySQL 5.7, as is InnoDB spatial indexes, the use of Boost.Geometry, and increased completeness and standard compliance.
I had a chance to talk with Geir and Simon after their lecture: