It’s OracleWorld 2010 time but that’s not slowing Oracle’s worldly developments like their continued innovations to MySQL. As part of their recent announcement, Oracle has a lot to say about the developments of this highly favored open source database server software,

We continue to invest in MySQL technology and support the thriving MySQL user community,” said Edward Screven, Oracle’s Chief Corporate Architect. “The availability of MySQL 5.5 release candidate is a testament to Oracle’s focus on helping not only LAMP users, but also Windows users maximize the performance and reliability of critical application environments while reducing cost. Oracle now has two superior database alternatives to SQLServer, both delivering better value and broader platform support to end users and ISVs.

The new release demonstrates a huge increase in performance with a bunch of adjustments that enhance enterprise scalability and other factors. On Windows: up to 1,500 percent performance gains for Read/Write operations, and up to 500 percent gain for Read Only(1). On Linux: up to 360 percent performance gain in Read/Write operations and up to 200 percent improvement in Read Only(2).

Already some corporate users have been quoted as discovering the new benefits greatly advantageous. “I’m really blown away by MySQL 5.5’s improvements,” said Don MacAskill, CEO, SmugMug. “You can now have a whopping 128K transactions in flight. Best of all, it’s far more performant than it used to be. Thank you Oracle!”

As for the technical side of the innovations, here’s the short list:

• Improved performance and scalability:
  • MySQL Server and InnoDB have been enhanced to provide optimum performance and scalability when running on the latest multi-CPU and multi-core hardware and operating systems.
  • InnoDB is now the default storage engine for MySQL Server, delivering ACID transactions, referential integrity, and crash recovery.
• Higher availability:
  • New semi-synchronous replication improves failover reliability by allowing the master to proceed without waiting for all the slaves to acknowledge. Once one slave acknowledges, the transaction can be committed. This also helps improve data integrity.
  • Replication Heart Beat enables faster detection, diagnosis and correction of master/slave synchronization issues, helping improve the reliability and availability of data by reducing the risk and impact of master/slave synchronization issues.
• Improved usability:
  • Improved index and table partitioning enables RANGE and LIST partitions to be defined on date, datetime, varchar, and char columns, simplifying and extending MySQL and adding flexibility to indexing and query tuning.
  • DBAs and developers can save time using the ANSI/ISO standard SIGNAL/RESIGNAL syntax inside stored routines, including triggers, to raise an error condition invoking specific error handling within their applications.
  • Enhanced diagnostics, including a new PERFORMANCE_SCHEMA, provide low-level diagnostics on MySQL server performance statistics, allowing DBAs to pinpoint resource-intensive processes and events, streamlining efforts and helping to enhance their productivity.

You can read more about the announcement at Oracle’s MySQL blog and download the release candidate.  Also, be sure to check our continuous Oracle Open World coverage at SiliconANGLE.tv.