Oracle previews MySQL 5.6

"In regards to replication, MySQL introduces Global Transactions Identifiers (GTIDs), which assure the system can track data as it is replicated across different servers. GTIDs will ease the process of automatically switching to a duplicate server should the original fail. Third-party software now offers this capability, but this will be the first time MySQL itself can do the job.

"MySQL 5.6 offers a number of new features that should speed queries. It can now consolidate multiple queries or result sets into a single unit of work. It can assign the current date and time as the default for DATETIME columns, eliminating the need for the application to do that work itself. The software can also speed query time by determining the best order of execution for Filesort and ORDER BY queries.

"Another new benefit for developers: MySQL can also deliver query results in the popular JSON (JavaScript Object Notation) format, useful for integrating data to Web applications."

Complete Story

Related Stories:

• Virtual Hosting With PureFTPd And MySQL (Incl. Quota And Bandwidth Management) On CentOS 6.2(Mar 24, 2012)
• Facebook shares some secrets on making MySQL scale(Dec 08, 2011)
• Open core or dual licensing? The example of MySQL(Oct 31, 2011)
• Open Core MySQL(Sep 22, 2011)
• Monty's Problem with MySQL(Sep 21, 2011)
• Trouble on the high seas for MySQL?(Sep 20, 2011)