There’s nothing like hearing directly from the developers. As an Oracle employee, I’ve already learned a lot about MySQL 5.6 and other recent updates. Nevertheless, I was impressed with a few new updates mentioned during the keynote. Here’s a list of items that caught my attention (disclaimer: this is a partial list)
**Performance — with the group commit feature in 5.6 and other 5.6 performance improvements, the overhead of sync_binlog=1 is less than 10%. In fact, with binlog enabled, 5.6 is faster than 5.5 without binlog enabled.
**Audit Extension — Oracle offers a dynamic plugin for enabling auditing for Sarbanes Oxley, PCI Compliance… (note: this is a commercial feature which requires a subscription)
**Foreign Key support in MySQL Cluster — I find it ironic that at the same time NoSQL is becoming more popular; we’re also seeing very high demand for foreign key support in MySQL Cluster. Cluster 7.3 (not GA, new milestone release (beta-level) ) now supports foreign keys, even if you’re using our NoSQL api. Nice!
**Online ALTER TABLE (online DDL) for InnoDB — MySQL DBA’s are accustomed to all sorts of hurdles to change schema, including failing over to secondary servers during the change. No more! Add columns and indexes online.
Python connector GA– MySQL Workbench has been shipping with some very powerful python utilities. My favorite is a batch of utilities for managing 5.6 replication servers, including a utility to automate failover to a slave — safely. It uses the new 5.6 global transaction ID to ensure that the slave server is up-to-date. Oracle just announced a MySQL python connector, supported by Oracle — and more importantly, heavily used by the Oracle MySQL team.
I also impressed by Edward Screven’s comment that Oracle has more developers working on MySQL than ever before–great evidence of Oracle’s investment in MySQL