MySQL Newsletter April 2010

Articles in this newsletter:

Highlights

New Product Releases

Hints & Tips

Events

Highlights

Article: Introduction to MySQL 5.5 (Performance and Scalability Improvements)

It's been a busy year for MySQL. Perhaps you've heard. Here are some recent improvements to the speed, scalability, and user-friendliness of the MySQL database and the InnoDB storage engine that we think deserve their own headlines. Now is a great time to beta test the 5.5 release and give feedback to the MySQL engineering team.

Read the Article »

White Paper: MySQL Cluster Connector for Java

As part of the MySQL Cluster 7.1 release, the MySQL Cluster Connector for Java implements a high performance and easy-to-use native Java interface and OpenJPA plug-in that directly maps Java objects to relational tables stored in the MySQL Cluster database.

By eliminating data transformations into SQL, users get lower data access latency and higher throughput. As a result, the development of Java applications is simplified with faster development cycles resulting in accelerated time to market for new services.

Read the White Paper »

White Paper: MySQL Cluster Manager

MySQL Cluster Manager simplifies the creation and management of MySQL Cluster Carrier Grade Edition by automating common management tasks. As a result, Database Administrators (DBAs) and Systems Administrator are more productive, enabling them to focus on strategic IT initiatives that support the business and respond more quickly to changing user requirements.

Read the White Paper »

MySQL ISV/OEM Customer Survey: Tell Us What You Want!

MySQL is committed to meeting the needs of our ISV/OEM customers - so please let us know what those are and help shape future product direction by participating in the MySQL ISV/OEM customer survey. The 2010 survey is more OEM-specific and significantly shorter, and it only takes about 5 minutes to complete. Thank you for your participation in making MySQL a better product!

Take the MySQL ISV/OEM Customer Survey »

Case Study: MySQL Enterprise powers SaaS ERP for Italian local and central authorities

PA Digitale helps the Italian government authorities achieve the objectives established by the Italian e-government plan for Public Digital Administration. Based on its ease of use and reliability, PA Digitale selected the MySQL database as the engine in the core of its technology infrastructure. By administering databases activities with the MySQL Enterprise Monitor and the Query Analyzer, PA Digitale can meet the database requirements with extremely intelligent and easy-to-use tools.

Read the Case Study »

Live Webinar: MySQL Performance Tuning Best Practices

Thursday, April 22, 2010 - 9:00am PDT

  • Do your applications slow down during busy times?
  • Will finding and fixing those performance issues take weeks of time that you just don't have?
  • Designing a new application and contemplating the best way to structure your schema and index strategy for optimal performance?

Then this free web presentation is for you! You will get expert insight and learn best practices from the experts at MySQL to help you improve performance!

Register for this Webinar »

Live Webinar: Introducing MySQL Cluster 7.1

Thursday, April 29, 2010 - 9:00am PDT

In blazing speed we will cover the most important features of MySQL Cluster 7.1: NDB$INFO, MySQL Cluster Connector/Java and other features that push the limits of MySQL Cluster into new workloads and communities.

Register for this Webinar »

New Product Releases

New Release of MySQL Server 5.5.3-m3 (Beta)

MySQL Server 5.5.3-m3, a new version of the popular Open Source Database Management System, has been released. MySQL 5.5 includes several high-impact changes to address scalability and performance issues in MySQL Server. These changes exploit advances in hardware and CPU design and enable better utilization of existing hardware.

View the complete list of changes »

Download Now »

New Release of MySQL Server 5.5.4-m3 (Beta)

We've released MySQL Server 5.5.4-m3, for Linux on x86_64 only at this time. It contains a new version of InnoDB including several performance enhancements in comparison to MySQL Server 5.5.3-m3. The "-m3" suffix tells these releases belong to the third milestone according to our "milestone" release model, also called "Celosia".

View the complete list of changes »

Download Now »

New Release of MySQL Server 5.1.45 (GA)

MySQL Community Server 5.1.45, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.45 is recommended for use on production systems.

View the complete list of changes »

Download Now »

New Release of MySQL Cluster 7.1 (GA)

MySQL Cluster 7.1 represents the latest release of the leading open source, high availability database, offering a range of new features designed to reduce operational costs and improve accessibility.

Download Now »

Read the Documentation »

New Release of MySQL Workbench 5.2.18 (Beta)

We are proud to announce MySQL Workbench Beta 8 (5.2.18). Since beta 7 we have fixed additional bugs as well as put in some improvements requested by the community, including fixes for 35 bugs, new HUD-style (FADE IN) UI elements, and Connection Sorting.

Download Now »

Read the Tutorial »

Hints & Tips

Documentation: InnoDB 1.1 for MySQL 5.5 User's Guide

Beginning with MySQL version 5.1, it is possible to swap out one version of the InnoDB storage engine and use another (the "plugin"). This manual documents the latest InnoDB plugin, version 1.1, which works with MySQL 5.5 and features cutting-edge improvements in performance and scalability.

Read the Documentation »

White Paper: Securing MySQL Embedded Server on Windows

Windows is the most popular platform for MySQL's ISV and OEM customers. This white paper provides the best practices to secure a Windows-based installation of MySQL Embedded Server 5.1. The paper covers the following MySQL security-related topics, including understanding the MySQL security model, post-installation tasks, user accounts, password management, encryption, and more.

Read this White Paper »

PlanetMySQL Blog Posts

The following blog posts are from PlanetMySQL. PlanetMySQL is an aggregation of blogs and news from MySQL developers, users and employees. It is an excellent source of all things about MySQL, including technical tips and best practices.

Visit PlanetMySQL »

Submit Your Blog Feed »

PlanetMySQL Blog: Replication Features in MySQL 5.5.3

Lars Thalmann

We are happy to announce the new and exciting replication features in the MySQL 5.5.3 development release.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: InnoDB recovery is now faster... much faster!

Inaam Rana

One of the well known and much written complaint regarding InnoDB recovery is that it does not scale well on high-end systems. Well, not any more. In InnoDB plugin 1.0.7 (which is GA) and plugin 1.1 (which is part of MySQL 5.5.4) this issue has been addressed. Two major improvements, apart from some other minor tweaks, have been made to the recovery code. In this post I'll explain these issues and our solution for these.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Scalability enhancements of MySQL 5.5.4-m3

Mikael Ronstrom

The MySQL 5.5.4-m3 beta version contains a number of interesting new scalability features.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL 5.5.4-m3 scales to 32 cores

Mikael Ronstrom

The newly released MySQL 5.5 beta version MySQL 5.5.4-m3 has a large number of significant performance improvements. These improvements make it possible for MySQL to scale well even on 32-core servers. The graph below shows how MySQL 5.5.4-m3 scales from 12 cores to 32 cores using a single thread per core.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL Performance: 5.5.4 @dbSTRESS

Dimitri Kravtchuk

Today we have something to celebrate - the MySQL 5.5.4 was announced! And a huge number of performance improvement made in this version make me very happy :-))

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: InnoDB Performance Schema

Jimmy Yang

With the plugin 1.1 release, InnoDB will have full support of Performance Schema, a new feature of MySQL 5.5 release. This allows a user to peak into some critical server synchronization events and obtain their usage statistics. On the other hand, in order to make a lot of sense of the instrumented result, you might need some understanding of InnoDB internals, especially in the area of synchronization with mutexes and rwlocks.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Better Scalability with Multiple Rollback Segments

Sunny Bains

The original motivation behind this patch was the infamous Bug#26590 - MySQL does not allow more than 1023 open transactions. Actually the 1024 limit has to do with the number of concurrent update transactions that can run within InnoDB. Where does this magic number come from?

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL: Partition-wise backups with mysqldump

Roland Bouman

To whom it may concern, in response to a query from André Simões, I slapped together a MySQL script that outputs mysqldump commands for backing up individual partitions of the tables in the current schema. The script is maintained as a snippet at MySQL Forge.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Hyper Threading Performance

Venu Anuganti

It's been a while anyone talked about Intel's Hyper-Threading performance when it comes to databases. There were enough posts about disabling Hyper-Threading completely when it comes to MySQL/InnoDB workloads way back when we had enough issues with scalability of InnoDB on multi-core systems. But things have changed quite a bit in the past year or two in terms of multi-core support.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Index only

Mark Callaghan

A problem with SQL is SQL. It is easy to write queries that require random IO in the worst case. It is usually easy to find queries that do too much random IO on a NoSQL system as you must code the extra data fetches manually.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Using ClusterJ (part of MySQL Cluster Connector for Java) - a tutorial

Andrew Morgan

ClusterJ is part of the MySQL Cluster Connector for Java which is currently in beta as part of MySQL Cluster 7.1. It is designed to provide a high performance method for Java applications to store and access data in a MySQL Cluster database. It is also designed to be easy for Java developers to use and is "in the style of" Hibernate/Java Data Objects (JDO) and JPA.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Using ClusterJPA (part of MySQL Cluster Connector for Java) - a tutorial

Andrew Morgan

This is a follow up to the earlier post Using ClusterJ (part of MySQL Cluster Connector for Java) - a tutorial but covers the ClusterJPA interface rather than ClusterJ.

Read the PlanetMySQL BlogPost »

Events

Live Webinar: Introducing MySQL Cluster 7.1 - EMEA

Tuesday, April 20, 2010 - 10:00 CET/8:00 UTC

In blazing speed we will cover the most important features of MySQL Cluster 7.1: NDB$INFO, MySQL Cluster Connector/Java and other features that push the limits of MySQL Cluster into new workloads and communities.

Register for this Webinar »

Live Webinar: Migrating from Microsoft Access to MySQL Embedded Server

Wednesday, April 28, 2010 - 10:00am PDT

Join Jimmy Guerrero and Mike Frank, MySQL product managers and Windows experts, for this technical presentation. Jimmy and Mike will explore the technical and business benefits of migrating your product's data from Microsoft Access to MySQL Embedded Server. They will also cover migration best practices, and provide an overview of migration tools, scripts and datatype mapping. Finally, they will demonstrate how to leverage Access front-ends with a MySQL Embedded Server back-end.

Register for this Webinar »

Live Webinar: Introducing MySQL Cluster 7.1 - German

Wednesday, April 28, 2010 - 15:00 CET/13:00 UTC

In blazing speed we will cover the most important features of MySQL Cluster 7.1: NDB$INFO, MySQL Cluster Connector/Java and other features that push the limits of MySQL Cluster into new workloads and communities.

Register for this Webinar »

Live Webinar: Introducing MySQL Cluster 7.1 - Italian

Thursday, April 29, 2010 - 10:00 CET/8:00 UTC

In blazing speed we will cover the most important features of MySQL Cluster 7.1: NDB$INFO, MySQL Cluster Connector/Java and other features that push the limits of MySQL Cluster into new workloads and communities.

Register for this Webinar »

More free MySQL webinars are scheduled and added between each Newsletter edition, so visit our website frequently for the most updated information.

View the full list of webinars »

Want to receive the latest MySQL updates and interact with the MySQL community?

Follow MySQL on Twitter »

Follow MySQL Community on Twitter »