Home » Computer & Software » Internet » Latest MySQL 5.7 Development Milestone Release Enhances Database Performance and Manageability
Ihren XING-Kontakten zeigen

Latest MySQL 5.7 Development Milestone Release Enhances Database Performance and Manageability

REDWOOD SHORES, CA — (Marketwired) — 09/25/14 — Oracle (NYSE: ORCL)

Oracle announced today a new development milestone release for MySQL 5.7. Continuing to meet the demands of today–s web, cloud, and embedded applications, the new release further extends the performance, scalability, and reliability of MySQL, the world–s most popular open source database, while enhancing management capabilities. Oracle also announced several additional MySQL product releases and early access features as well as the availability of MySQL source code on GitHub.com.

Oracle announced a new development milestone release (DMR) for 5.7.

Available for download in the , on Monday, September 29, this MySQL 5.7.5 DMR includes many performance and scalability features, including a new optimizer dynamic cost model, improved InnoDB performance, and replication performance improvements, as well as several manageability enhancements.

Also available on Monday, September 29 are:

1.5, which includes the ability to provision servers through OpenStack

6.2, which features new performance and migration capabilities

The first 7.4 DMR, which delivers active-active replication as well as performance and operational enhancements

In addition, Oracle is providing early access to features under development, including MySQL Group Replication and multisource replication, for community testing and feedback through .

To better serve the MySQL community, Oracle is making the MySQL source code publicly available on GitHub.com (), allowing users to download it from their preferred code host and collaboration platform.

Oracle will host from Sunday, September 28 through Thursday, October 2 at Oracle OpenWorld in San Francisco. To learn more about the new MySQL capabilities and best practices for developing next-generation applications with MySQL, join us at the conference. Additional information on MySQL Central and be found . Save $200 off the onsite registration by .

Performance and scalability:

A new MySQL optimizer dynamic cost model has been introduced to provide greater user control and better query performance.

Improved InnoDB performance provides faster online and bulk load operations.

Performance schema improvements include user and status variable instrumentation as well as replication information and progress instrumentation.

Replication performance improvements, including intraschema multithread slave, allow many transactions to be applied in parallel while maintaining full consistency and supporting transaction retries.

In benchmark tests using SysBench Read-only Point-Selects, at 1,024 connections, MySQL 5.7 delivered 645,000 queries per second (QPS), 2x better than MySQL 5.6. More than 1 million NoSQL QPS to InnoDB via Memcached were achieved with MySQL 5.7, which is 6x more than with MySQL 5.6.

Manageability:

A new global data dictionary improves manageability and query performance.

Improved partitioning simplifies database administration by quickly and easily moving database partitions.

GIS improvements provide more robust spatial data support including GeoHash and GeoJSON.

Replication GTID improvements remove the requirement to run binary logs on the slaves.

This latest DMR also features support for , including native DTrace support, and Red Hat Enterprise Linux 7.

MySQL Fabric 1.5 provisions servers using OpenStack and also supports additional types of sharding keys.

MySQL Workbench 6.2 delivers the following new capabilities:

Database migrations from Microsoft Access, allowing users to easily migrate Microsoft Access data to MySQL

Visual explain enhancements, improving and simplifying SQL statement performance tuning

GIS data viewer, allowing users to view MySQL spatial data from a more powerful and reliable geometric engine

The first MySQL Cluster 7.4 DMR features the following enhancements to increase scalability, uptime, and agility:

Active-active replication, allowing replication between clusters in different locations with automated conflict detection and resolution

Performance enhancements, exploiting more cores within each node to massively scale out throughput

Operational improvements such as improved reporting and faster maintenance activities

Key features are also available through for early testing and feedback from the MySQL community, including:

Multi-source Replication, which consolidates data from multiple masters to one or more slaves

MySQL Group Replication, which simplifies high availability by allowing any server to accept writes and enhances application transparency by removing the need for the application and servers to coordinate where transactions should be routed

“Oracle is focused on enhancing MySQL to provide the community and customers with the best capabilities for building and delivering their web, cloud, and embedded applications,” said Tomas Ulin, vice president, MySQL Engineering, Oracle. “The latest MySQL 5.7 development milestone release delivers on our promise of release early, release often, and the enhanced performance and management features are the result of our collaboration with users. Additionally, by making the MySQL source code available on GitHub.com we are allowing users to get access to the latest MySQL innovations from one of the world–s largest code host and collaboration platforms.”

Download the MySQL 5.7 development milestone release . Terms, conditions, and restrictions apply.

Webcast: , October 15, 2014 at 9:00 AM PT

. Save $200 off the onsite registration by .

for Oracle OpenWorld 2014 San Francisco

Follow Oracle OpenWorld on , , and

Oracle OpenWorld San Francisco is the most important business and technology conference of the year for Oracle customers, prospective customers, and partners. This educational conference is dedicated to helping businesses optimize existing systems and understand upcoming industry trends and breakthroughs driven by technology. Oracle OpenWorld offers more than 2,700 educational sessions, hundreds of demos and hands-on labs, and exhibitions from more than 400 partners and customers from around the world showcasing applications, middleware, database, server and storage systems, industries, management, cloud, and infrastructure solutions — all engineered for innovation. Oracle OpenWorld 2014 is being held September 28 through October 2 at the Moscone Center in San Francisco. For more information; to register; or to watch Oracle OpenWorld keynotes, sessions, and more, visit . Join the Oracle OpenWorld discussion on , , and the .

Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE: ORCL), visit .

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

THIS DOCUMENT IS FOR INFORMATIONAL PURPOSES ONLY AND MAY NOT BE INCORPORATED INTO A CONTRACT OR AGREEMENT.

Teri Whitaker
Oracle
+1.650.506.9914

Danielle Tarp
Blanc & Otus for Oracle
+ 1.415.856.5182

You must be logged in to post a comment Login


Blogverzeichnis - Blog Verzeichnis bloggerei.de Blog Top Liste - by TopBlogs.de Bloggeramt.de blogoscoop