During the MySQL Connect conference at Oracle OpenWorld 2013, Oracle announced the second Development Milestone Release (DMR) for MySQL 5.7 database.

The new release provides faster connectivity, higher transactional throughput, increased replication rate, improvements in instrumentation of memory and other features, providing enhanced performance and manageability.

This year Openworld theme is based on Open Source and Oracle aims to build a large pool of developers and database administrator to build web, cloud based, and embedded applications capable of processing ever increasing volumes of data.

MySQL 5.7.2 DMR delivers a performance record of 500,000 queries per second for Sysbench InfoDB read only point select. It supports linear scaling up to 64 CPU threads and uses new multi-threaded inter-transactional replication event handling on slaves threading. The database provides support for renaming indexes and enlarging varchar datatypes, supports tracking memory allocations and usage throughout mysqld and monitoring with usage metrics for sizing, operation counts, and moving minimum/maximum windows from the Performance Schema.

In terms of Manageability, MySQL supports real-time execution analysis, improved dynamic control for triggers, and improved JSON Explain Data. The independent transactions are processed in parallel on different Workers, even if they run on the same database. The possibility of an AlterTable also conducts online so as to simplify the management of databases. Using performance scheme, it is also possible to continue to monitor memory allocations. MySQL 5.7.2 DMR also features a lossless, semi-synchronous replication: Transactions are only confirmed when it has received a slave server.

Oracle MySQL is ready for further experimental innovations, including Mysqlfabric. Thus, MySQL databases can scale better by sharding, a tool written in Python, and can handle the entire administration. However, Mysqlfabric only works with special drivers that are currently available only for Python and Java.

MySQL 5.7.2 DMR also delivers lossless semi-synchronous replication, enabling transactions to only be committed to the storage engine and externalized on the master after the slave has acknowledged receipt.

The company said Oracle continues to work closely with the MySQL user community and encourages feedback and input to help rapidly improve product capabilities and quality. With the latest MySQL 5.7 development milestone release, Oracle continues to drive MySQL innovation with predictable and consistent releases to closely address user requirements for their modern web, cloud and embedded applications.

The open source database recently got a blow when the search engine giant Google has decided to switch from MySQL DBMS database management to its derivative MariaDB, a fork of MySQL from a project by Michael “Monty” Widenius and supported by a foundation for this purpose.

The latest Development Milestone Release (DMR) for MySQL 5.7 is available for download.