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
[...] MySQLConnect — Auditing, Online DDL, FK in Cluster and More – Lee Stigile [...]
Pingback by MySQL 5.6 new features: the user’s perspective | code.openark.org — October 5, 2012 @ 7:20 am |
Whilst altering your every day life style and undesirable habits for the better,
you can find anti-snoring mouth guards, chin straps, nasal sprays, herbal
pills, adhesive nasal strips, nose clips, certain sleeping positions and even specific types of anti-snoring pillows that can correctly
maintain your neck and head aligned throughout
the night. For those that have a tendency to snore on account of the
mouth often popping open even though sleeping, the anti-snoring chin straps
will work wonders, and so do the herbal anti-snoring throat sprays vesting boost this type of snoring
difficulty.
Comment by buy snore guards — March 4, 2013 @ 3:41 pm |