MySQL Newsletter April 2008

Articles in this newsletter:


New Product Releases

Hints & Tips


Training, Consulting & Certification



Sun Microsystems Announces MySQL 5.1

Sun Microsystems announced the pending general availability of MySQL 5.1, a new version of the world's most popular open source database, designed to improve performance and simplify management of large database applications. A near-final release candidate of the GPL software is available for download.

Download the White Paper - Inside MySQL 5.1 » (

Download MySQL 5.1 »

Sun Introduces MySQL Workbench

Sun Microsystems announced the availability of MySQL Workbench, a new visual database design tool that integrates data modeling, physical database design, database creation, change management and documentation capabilities into a single, seamless environment for MySQL developers and DBAs. MySQL Workbench is available for download in two versions: an open source Community Edition and a (US) $99 commercial Standard Edition.

Learn More » (

Download MySQL Workbench (Community Edition) »

Purchase MySQL Workbench (Standard Edition) »

Sun Announces MySQL Community, Partner & Application of the Year Awards

In a keynote presentation this morning at the MySQL Conference & Expo, Sun executives Rich Green and Mårten Mickos announced the winners of the 2008 MySQL Community, Partner-of-the-Year and Application-of-the-Year Awards.

Community Member of the Year Awards » (

Partner of the Year Awards » (

Application of the Year Awards » (

Press Release: Sun Celebrates Third-Party MySQL Storage Engines

Sun Microsystems, Inc. today announced new and enhanced third-party support for the MySQL™ database's unique pluggable storage engine architecture. The MySQL Certified Storage Engine Program ( enables commercial and community database engine developers to certify that their software has been tested and is compatible with Sun's MySQL Database Server - helping to assure MySQL users that these certified engines have reached high-level standards of usability, performance and integration.

Read the Press Release » (

MySQL Conference & Expo Highlights

Thank you to the 2000+ attendees, speakers, partners and staff that made the 2008 MySQL Conference and Expo the largest and most successful Conference ever. Follow the links below to view the speaker presentation files, photos, news and media coverage.

Speaker Presentation Files »

Photos »

News & Coverage »

MySQL Jobs

MySQL is the world's most popular open source database software. As part of Sun Microsystems' software group, MySQL is a global organization with over 400 workers in 25 countries. We are looking for talented professionals in engineering, sales, marketing, professional services, and support that will contribute to our products' strong momentum and share in our success! We have openings for the following positions:

  • Technical Writer
  • Support Engineers
  • Senior Software Engineer, Online Backup
  • QA Engineers
  • Senior Instructors (Ireland)
  • Senior Consultants (USA, EMEA)
  • Sales Representatives
  • And Many More ...

Apply Now » (

New Product Releases

New Release of MySQL 5.1.24 (Release Candidate)

We are proud to present to you the MySQL Server 5.1.24-rc release, a new "release candidate" version of the popular open source database. Changes include:

  • Please note that the Federated engine is not built into the MySQL 5.1.24 RC release binaries, but is scheduled to return in the next release, which will be MySQL 5.1.25. The reasons for Federated's omission in 5.1.24 RC includes various quality and timing issues that unfortunately could not be avoided, and we apologize for any inconvenience this has caused.
  • Windows Installer: Important Change: The data directory now defaults to the Windows Common App Data Folder (on Windows XP, this is ...\All Users\Application Data; on Vista, it is ProgramData). (Bug#34593)
  • Replication: Introduced the slave_exec_mode system variable to control whether idempotent or strict mode is used for replication conflict resolution. Idempotent mode suppresses duplicate-key, no-key-found, and some other errors, and is needed for circular replication, multi-master replication, and some other complex replication setups when using MySQL Cluster. Strict mode is the default. (Bug#31609)

View the complete list of changes »

Download Now »

New Release of MySQL Enterprise Monitor (Spring 2008 Release)

MySQL is proud to announce the Spring 2008 Release of the MySQL Enterprise Monitor. A new Upgrade Advisor identifies the most up to date, secure and reliable version of MySQL that you should be running. Plus, the MySQL Enterprise Monitor is also available in Japanese. The new feature set includes:

  • New Upgrade Advisor (Available to Silver levels and up). The Upgrade Advisor provides automated rules that monitor and advise you on specific bugs that can potentially impact versions of the MySQL Enterprise Server deployed within your environment.
  • MySQL Enterprise Monitor is now available in Japanese. You can switch the context of the Monitor user interface to Japanese using Settings tab, User preferences link and setting the locale to Japanese.

Learn more » (

Download Now (Login Required) »

New Release of MySQL Workbench 5.0.19 (GA)

The MySQL Developer Tools team is proud to announce that the result of our recent project, MySQL Workbench, has reached GA status. MySQL Workbench is a next-generation visual database design application that can be used to efficiently design, manage and document database schemata. MySQL Workbench is available for download in two versions: an open source Community Edition and a (US) $99 commercial Standard Edition. Fixes includes:

  • MySQL Workbench - Foreign Key Label Issues (Bug #30902)
  • Cancelling the file open dialogue window crashes the application Bug (#32453)
  • autoplace needs to resize diagram to fit large models (Bug #32888)

View the complete list of changes »

Download Now »

New Release of MySQL Connector/ODBC 5.1.4 (GA)

MySQL Connector/ODBC 5.1.4, a new version of the ODBC driver for the MySQL database management system, has been released. This release is the first generally available (production) release of the 5.1 series and is suitable for use with any MySQL server version since MySQL 4.1, including MySQL 5.0, 5.1, and 6.0. (It will not work with 4.0 or earlier releases.) Fixes include:

  • SQLGetDiagRec() sometimes returned SQL_SUCCESS but no error message. (Bug #33910)
  • Driver installer (myodbc-installer.exe) fails to create a new DSN (Bug #35776)
  • Get wrong result with decimal(8,2) field type (Bug #35920)

View the complete list of changes »

Download Now »

New Release of MySQL Connector/.NET 5.0.9 (GA)

MySQL Connector/Net 5.0.9, a new version of the all-managed .NET driver for MySQL has been released. This release is an update to the existing production-quality 5.0 series. We plan for this to be the last release in the 5.0 series. We will only be updating the 5.0 product in the event a "data-loss" type bug is discovered. We encourage all new products to use the new 5.1 product. Changes include:

  • added implementation of MySqlCommandBuilder methods QuoteIdentifier and UnquoteIdentifier (Bug #35492)
  • Fixed problem where fields that were blobs but did not include the BLOB flag were treated as binary when they should have been treated as text. (Bug #30233)
  • Changed from using Array.Copy to Buffer.BlockCopy in MySqlDataReader.GetBytes. This helps with memory usage as we expect the source and destination arrays to not be overlapping. (Bug #31090)

View the complete list of changes »

Download Now »

Hints & Tips

Article: How the MySQL Enterprise Upgrade Advisor Helps DBAs Avoid Being Bitten by Known Bugs

Rob Young

In an effort to provide DBAs with a belt-and-suspenders support and alert system and to further help take the guesswork out of deciding which version of the MySQL server they should be running, MySQL Enterprise now provides the new Upgrade Advisor. The premise is simple; the Upgrade Advisor provides monitoring for specific security and crash inducing bugs that affect current versions of the MySQL Community or Enterprise Server running in an Enterprise Monitor protected environment.

Read the Article »

Article: A Look at Falcon Diagnostic Tables

Robin Schumacher

The Falcon team has designed a set of new Information Schema tables to help you understand how well Falcon is performing and where issues may be developing. Let's take a quick look at some of these new tables and see how you can make use of them when you're working with Falcon.

Read the Article »

White Paper: A Data Modeling Guide for Developers and DBAs

This paper looks at the various types of data that modern businesses need to manage, examines the reasons why a model-driven approach to data management is necessary, and outlines the benefits such an approach provides. It also highlights how the MySQL Workbench product from MySQL can be an indispensable aid in the hands of experienced data modelers, developers, and DBAs who are tasked with managing the complex data management infrastructure of a dynamic and growing business.

Download the White Paper - A Data Modeling Guide for Developers and DBAs » (

White Paper: ZRM - Guide to MySQL Backup & Recovery

Database backup and recovery are a primary responsibility of every enterprise DBA. This white paper is a guide to the requirements, challenges, and solutions available to the MySQL DBA. You will learn about Logical/Raw backups, Hot/Warm backups, Full/Incremental backups, Snapshots, Point-in-Time Recovery, Retention Policies, Compliance, Access Control, Scheduling, Monitoring and Administration.

Download the White Paper » (

Download a 30 Day Trial Version » (

White Paper: Jasper for MySQL - OEM Edition

Jasper for MySQL: OEM Edition 2.0 builds on earlier releases to provide significant enhancements to this high-performance interactive report server optimized for MySQL users. This white paper includes details on many of these enhancements to better assist you in understanding what 2.0 provides.

Download the White Paper » (

Download a 30 Day Trial Version » (

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 MySQL, including technical tips and best practices.

Visit PlanetMySQL »

Submit Your Blog Feed »

PlanetMySQL Blog: MySQL Proxy: Rollbacked Transactions

Jan Kneschke

If you use a transactional storage engine in MySQL like InnoDB some of your transaction may be terminated by the storage engine because of deadlocks. Sadly it is a bit tricky to see what has led to the deadlock. SHOW ENGINE INNODB STATUS gives only a very minimal look into the state when it happened.

With the proxy and a little script we can track what happened in all open transactions before the deadlock happened. A classic example is the cross-over deadlock:

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: MySQL Proxy: COMMIT obfuscator

Jan Kneschke

This is an idea I came across at the MySQL UC last week: How many applications handle failing COMMITs correctly? And how can we test it?

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: Fourteen Summer of Code projects accepted 2008

Kaj Arnö

This year, we got fourteen Google Summer of Code projects accepted. Colin Charles has informed the students, and things can now get started!

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: How to estimate query completion time in MySQL

MySQL Performance Blog

Have you ever run a query in MySQL and wondered how long it'll take to complete? Many people have had this experience. It's not a big deal until the query has been running for an hour. Or a day and a half. Just when IS that query going to finish, anyway?

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: EXPLAIN Cheatsheet

Sheeri K. Cabral

At the 2008 MySQL Conference and Expo, The Pythian Group gave away EXPLAIN cheatsheets. They were very nice, printed in full color and laminated to ensure you can spill your coffee* on it and it will survive. For those not at the conference, or those that want to make more, the file is downloadable as a 136Kb PDF

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: MySQL Replication Series (tip #1): what should be replicated and what should not be replicated?

Sunny Walia

Welcome to Tip #1 in MySQL Replication Series. In this tip we will go over what to do when you only want to replicate certain data to slave(s). Most general way to tell what is replicated to which slave is to include following configuration directive in my.cnf file depending on your environment and your goals.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: Common Steps to Scale Linearly

Dathan Pattishall

Whenever I work at a place I do the following. Get a rundown of what the application is, what its demands are, what does the company expect the application to be a year from now - like how many users are going to use the application. 10 million, 20 million, 100 million?

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: OpenLDAP, MySQL Cluster, World of Awesome

A group of us gathered around to hear about some work that had been done in getting a MySQL Cluster backend for OpenLDAP.

I'd heard a bit of rumors about this previously, but last night was the first time I a) saw it working and b) saw performance numbers.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: MySQL Magazine - Spring 2008 Available for Download

A few minutes ago I uploaded the new issue of the MySQL Magazine. I am very excited about this issue as the quality continues to increase!

Read the PlanetMySQL Blogpost »


Live Webinar: Enabling Enterprise 2.0 with MySQL

Thursday, May 08, 2008

Join us for this informative webinar where we will explore how open source Web 2.0 technologies, applications and architectures leveraging MySQL Enterprise can help enable information access across an enterprise's entire technology spectrum, through a network of tightly and loosely integrated applications, services and devices. We will also explore various use cases for the enterprise, including technology overviews of MySQL Replication, MySQL Load Balancer, DRBD and Memcached for MySQL.

Register for this Webinar »

Live Webinar: Multi-Tenant Architectures with MySQL Enterprise for SaaS Providers

Thursday, May 15, 2008

Join us for an informative webinar where we will explore how Software as a Service providers are leveraging MySQL Enterprise to build scalable, high performance web applications based on multi-tenant architectures. We will review the benefits a MySQL Enterprise subscription can bring to an organization along with an overview of available add-ons like DRBD, MySQL Load Balancer and Memcached, for delivering highly available and scalable SaaS applications in a multi-tenant environment.

Register for this Webinar »

Live Webinar: Designing a Highly Scalable MySQL Architecture for Write-intensive Applications

Tuesday, May 20, 2008

In this Webinar you will learn from ScienceLogic about how they are using MySQL to perform hundreds of millions of database writes daily and continue to scale and perform extremely well.

Register for this Webinar »


May 4-5, 2008, San Francisco

Its not easy to start your own business. There are countless decisions to make from how you differentiate your product to how you support your customers and provide timely service. Startup Camp is an unconference-style event that's dedicated to bringing together the various members of the startup community for a face-to-face collaborative meetup where its the attendees that drive the agenda.

Learn More »

Training, Consulting, and Certification

Consulting: MySQL Health Check (2+ Days)

In this engagement, a dedicated MySQL certified consultant will work closely with your team to deliver the following benefits:

  • Analyze your database requirements and your current MySQL database infrastructure
  • Review database monitoring, security, backup & recovery, replication usage, and fault-tolerance architecture
  • Identify potential issues and limitations
  • Review best practices and recommend tools for managing your database infrastructure
  • Make recommendations on best practices for development, deployment, and operations

Learn More » (

Training: MySQL for Beginners (4 Days)

Washington D.C., Toronto, Mexico City, Berlin, Warsaw

Want to join the wonderful world of MySQL? Here's your chance to learn how this powerful relational database management system can make your life easier and more fun! This class covers all the basics and will get you on your way, with a solid foundation. This instructor led, hands-on class covers the fundamentals of SQL and relational databases, using MySQL as a teaching tool.

Register Now for an Upcoming Date » (


Qualiteam Software - Shopping Cart Hosting Solution

Qualiteam Software, a MySQL OEM customer and MECA partner, is an IT company specializing in ebusiness-focused technology solutions, including shopping cart software development, system integration/migration, IT consulting, software outsourcing and e-commerce web site design. Qualiteam Software chose the MySQL database for its e-commerce applications due to its high performance, economy resource usage, flexibility and wide availability on most hosting platforms. Recently, Qualiteam Software introduced a new shopping cart hosting service, X-Cart hosting, equipped with the outstanding set of unique e-commerce hosting features.

Learn More »