MySQL Newsletter March 2009

Articles in this newsletter:


New Product Releases

Hints & Tips

Spotlight: Database Migration to MySQL


Training, Consulting, & Certification



MySQL Conference & Expo 2009, April 20-23 - Register Now before Tutorials Sell Out

The 5th annual MySQL Conference & Expo will be held in Santa Clara, CA in April 20-23, 2009. This gathering of over 2,000 MySQL developers, users and DBAs is only a month away, so reserve your spot today! Here are 5 great reasons why you should attend:

  1. Get In-Depth Knowledge from 15 Half Day Tutorials
  2. Learn New Skills in 120+ Technical Sessions, including the new ISV/OEM track specifically designed for ISVs
  3. Stay Current with the Latest MySQL Best Practices
  4. Get Up-close and Personal with MySQL Experts
  5. Get MySQL Certified at the Conference

View the Tutorials »

View the sessions in the new ISV/OEM track »

Register Now »

Find MySQL Case Studies, Presentations, Articles and Blogs All in One Place

Interested in learning how modern enterprises are running MySQL for mission-critical applications? Curious about which company in your country or in your business vertical is using MySQL to deliver industry-leading products? With the recent re-design of the MySQL customer page, it's easier than ever to browse through MySQL customers, locate the ones you're interested in, and read all the related information about MySQL.

View the new MySQL customer web page » (

MySQL Enterprise Monitor Test Drive - now with the MySQL Query Analyzer!

Test Drive the new MySQL Query Analyzer - included in MySQL Enterprise Monitor - for 48 hours with no download or installation required! MySQL will provide you access to demo servers to test MySQL Enterprise Monitor and the new MySQL Query Analyzer for 48 hours. After you Test Drive on our system, you can try MySQL Enterprise Monitor and the new MySQL Query Analyzer on your system for 30 days by signing-up for the MySQL Enterprise Trial.

Register for the Test Drive Now » (

Register for the MySQL Enterprise 30-day Trial » (

White Paper: CIO Guide - The Strategic Value of MySQL

This white paper examines a model whereby CIOs can reduce their database costs significantly by adopting a heterogeneous database architecture and implement MySQL for a large part of their business critical and operational applications.

Read the White Paper » (

View More Resources for CIOs » (

Case Study: UTStarcom Delivers Complete IPTV Solution with MySQL Cluster

UTStarcom is a global leader in the manufacture, integration and support of IP-based, end-to-end networking and telecommunications solutions. A Fortune 500 company, UTStarcom is headquartered in the United States and its customers include the largest service providers in both emerging and established telecommunications markets worldwide.

Read the Case Study »

Case Study: SPEECH DESIGN Delivers Next Generation Call Completion Services with MySQL Cluster

SPEECH DESIGN is a leading European provider of messaging and mobility solutions for the corporate and carrier markets. More than 130,000 companies and millions of individual users benefit daily from SPEECH DESIGN's added-value communications solutions. Following extensive evaluations of database products, SPEECH DESIGN selected MySQL Cluster Carrier Grade Edition over existing proprietary databases to power their new call completion & next generation messaging services.

Read the Case Study » (

Live Webinar: FOR ISVs and OEMs - How to Develop MySQL-Backed Java Applications with Netbeans, JRuby-on-Rails & Glassfish and Lower Your COGS

Thursday, March 26, 2009 - 10:00am PDT

Join us for this informative technical webinar presented by Arun Gupta, "Glassfish Guy" at Sun Microsystems, where he will demonstrate how to leverage the latest version of the Netbeans IDE to quickly and easily develop and deploy MySQL and Glassfish backed applications using the JRuby-on-Rails framework. Combining JRuby-on-Rails with the MySQL database and Glassfish application server allows developers to deliver highly scalable and robust applications for the Web in a complete and integrated stack in less time, reducing development cycles and lowering your COGS.

Register for this Webinar »

Live Webinar: Simulating Workload with the MySQL Proxy

Thursday, April 02, 2009 - 10:00am PDT

MySQL Proxy is a program that sits between your client and MySQL server(s) that can monitor, analyze or transform their communication. Besides gaining a basic understanding of how MySQL Proxy works, you'll also get an overview of the new enhancements in the latest release and the planned features for the next few months. We will also discuss how to get involved with the MySQL Proxy community and explore how to create your own MySQL Proxy-based projects.

Register for this Webinar »

New Product Releases

New Release of MySQL Community Server 5.0.77 (GA)

MySQL Community Server 5.0.77, a new version of the popular Open Source Database Management System, has been released. This is a bugfix release for the current production release family. It replaces MySQL 5.0.67 (binary) and 5.0.75 (source-only). Changes include:

  • Security Enhancement: To enable stricter control over the location from which user-defined functions can be loaded, the plugin_dir system variable has been backported from MySQL 5.1. (Bug #37428)
  • A new status variable, Queries, indicates the number of statements executed by the server. (Bug #41131)
  • Important Change: Security Fix: Additional corrections were made for the symlink-related privilege problem originally addressed in MySQL 5.0.60. (Bug #32167, Bug #39277)

View the complete list of changes »

Download Now »

New Release of MySQL Community Server 5.1.32 (GA)

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

View the complete list of changes »

Read the Documentation for "What's New in MySQL 5.1" »

Download Now »

New Release of MySQL Workbench OSS/SE 5.0.30 (GA)

MySQL Workbench is a next-generation visual database design application that can be used to efficiently design, manage and document database schemata.

We're back with releasing a bugfix release of our current GA version of MySQL Workbench 5.0. We managed to close 27 bugs for this release. As a minor addition, we added the possibility to navigate through the wizards in Workbench using shortcut keys.

View the complete list of changes »

Download Now »

New Release of MySQL GUI Tools for 5.0 Release 17 (Windows)

We are pleased to announce a new maintenance release of the GUI Tools Bundle. This is a Windows-only release and contains a number of bug fixes. MySQL GUI Tools for 5.0 is a bundled package including MySQL GUI tools for the MySQL 4.1/5.0/5.1 server. It consists of the following products:

  • MySQL Administrator 1.2.17 GA
  • MySQL Query Browser 1.2.17 GA
  • MySQL Migration Toolkit 1.1.17 GA

and offers a complete set of graphical tools to configure, manage and work with the MySQL Server.

Read the Documentation »

Download Now »

New Release of MySQL Connector/Net 6.0 (Alpha)

MySQL Connector/Net 6.0.0, a new version of the all-managed .NET driver for MySQL has been released. This is an alpha release and is intended to introduce you to the new features and enhancements we are planning. This release should not be used in a production environment. We had three major goals with this release. Speed, Entity Framework support, and a better Visual Studio experience. I'm happy to report that we have met all three.

Download Now »

New Release of MySQL Connector/C++ 1.0.3 (Alpha)

A new version of MySQL Connector/C++ has been made available: MySQL Connector/C++ 1.0.3alpha. The MySQL Connector/C++ provides a C++ API for connecting client applications to the MySQL Server. The 1.0.3alpha is a bug fix release. Please see the documentation and the CHANGES file in the source distribution for a detailed description of bugs that have been fixed.

View the complete list of changes »

Read the Documentation »

Download Now »

Hints & Tips

Article: How FriendFeed uses MySQL to store schema-less data

Bret Taylor

We use MySQL for storing all of the data in FriendFeed. Our database has grown a lot as our user base has grown. We now store over 250 million entries and a bunch of other data, from comments and "likes" to friend lists.

Read this Article »

Article: Exception Error Handling Implementation in MySQL/VB.NET Windows Database Applications

Ernest Bonat, Ph.D

Error handling implementation in Windows database applications is a must for any Application Developer today. The main idea of error handling is to avoid application crashes by finding out the occurred errors and fixing them. Different programming languages have different ways of implementing error handling. Microsoft Visual Basic .NET (VB.NET) is the most common programming language for developing windows database applications today.

Read this Article »

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: Reflections on MySQL Enterprise Monitor

Simon Mudd

Merlin is MySQL's Enterprise Monitor, a system designed to monitor a number of MySQL database servers and provide useful feedback to the DBAs as to how they are running and what things may require attention.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Database Sharding at Netlog, with MySQL and PHP

Jurriaan Persyn

This article accompanies the slides from a presentation on database sharding. Sharding is a technique used for horizontal scaling of databases we are using at Netlog. If you're interested in high performance, scalability, MySQL, php, caching, partitioning, Sphinx, federation or Netlog, read on ...

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL Magazine - Winter 2009 Released

Keith Murphy

This is one of the largest issues so far. In addition, it has some of the best content we have ever had. The articles are all in-depth with some exciting new information.

Read the PlanetMySQL BlogPost »

Read the MySQL Magazine Winter 2009 Issue »

PlanetMySQL Blog: MySQL University Needs You!

Martin 'MC' Brown

MySQL University keeps rolling along. We've had some fantastic sessions just recently (not including my own, of course!), such as Lenz's presentation of backing up MySQL with filesystem snapshots, Allan Packer's presentation on the optimization of MySQL and, going back a little further, David Van Couvering and Petr Pisl's talk on using PHP and MySQL within Netbeans.

We've got some good topics coming up, but we need more!!

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: How to Move Your Web Server With No Downtime

Jonathan Levin

How do you move your web servers to another location with no downtime? The answer: the magic of MySQL Master-Master Replication.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: How To Set Up MySQL Database Replication On Fedora 10

Falko Timme

This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: My Favorite New Feature of MySQL 5.1: Less InnoDB Locking

Harrison Fisk

MySQL 5.1 has a lot of nice new features, partitioning, event scheduler, dynamic logging, etc... Most of these require changing some application code or design logic to make use of them. However, there is a few new features that almost every user of InnoDB can take advantage of right away and that is the ability to set MySQL so that less locking is required for many statements in InnoDB. There are a few changes which make this possible.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Bencher - a benchmarking utility for MySQL Cluster

Johan Andersson

Bencher is a test program that allows you to benchmark requests on MySQL Cluster. I have used this utility for a lot of customers, because it lets me specify a simple query that I want to benchmark on the command line, implement more complex use cases, implement NDBAPI requests, and I don't have to reinvent the wheel every time.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Date handling in MySQL

Henrik Ingo

With dates, just as in many other cases, MySQL is very flexible in how you can input data. But one thing is that, between the multitudes of formats that are allowed, MySQL does not by default allow you to enter a non-existant date, e.g. "31st of February 2009". I know some other DB products allow that - they then store it as a correct date automatically (3rd of March 2009). This is mentioned at the end of the above manual page. It can be enabled with an SQL_MODE setting and I have attached a lengthy example about that separately below.

Read the PlanetMySQL BlogPost »

Spotlight: Database Migration to MySQL

Article: Migrating from Microsoft SQL Server or Access to MySQL

Mike Hillyer

One of the more common themes present on the various MySQL forums and mailing lists is that of data migration. Typically requests are made by users of Microsoft Access and Microsoft SQL Server who are looking to migrate their data (and client applications) to a MySQL database. Developers often ask for tools that can be used to convert an Access database to MySQL (or convert an Microsoft SQL database to MySQL), without realizing that there is more to migrating an application to MySQL than simply converting data.

Read the Article »

White Paper: A Practical Guide to Migrate from Oracle to MySQL

This paper provides insight into what is needed for considering a move from Oracle to MySQL, and presents a number of options that help make the transition easy. Both the business and technical sides of migrating to MySQL will be dealt with, so whether you are a manager or a seasoned DBA, you will find the needed answers to questions that revolve around migrating to the world's most popular open source database - MySQL.

Read the White Paper »

Presentation: Migrating from PostgreSQL to MySQL at Cocolog, Japan's Largest Blog Community

Naoto Yokoyama, Kenji Hirohama, Lisa Phillips, Garth Webb

In MySQL Conference & Expo 2008, NIFTY Corporation discussed their experiences with MySQL and how they changed the configuration in TypePad to meet the Japanese market's requirement, such as more availability, more cell phone support, and so on.

Migration from PostgreSQL to MySQL, administration, optimization, and maintenance are also covered. Through this session, the audience will recognize how to deal with scenarios when the number of servers grows quickly from six to three hundred, and also learn about real-life security and administration best practices.

View the Presentation »

PlanetMySQL Blog: Moving data from Microsoft SQL server to MySQL

Haidong Ji

To move data from SQL Server to MySQL, it is certainly possible to use tools that can make connections to both data stores and manipulate data that way, such as Access, Excel, or SSIS. Here I will introduce a process that does not need any special tools or data drivers. Instead, we can use the utilities and methods that come with a standard SQL Server and MySQL install to accomplish that task.

Read the PlanetMySQL BlogPost »

Share Your Migration Story and Shine

Have you migrated from other databases to MySQL and find the results rewarding? Do you want other people to hear your story and follow your path? Now it's the opportunity for you to share and shine.

Send a paragraph of your successful database migration story to, and you and your company could be the next one to be featured on and in the MySQL Monthly Newsletter.

Live Webinar: Migrating to MySQL - Is it Right for You?

Thursday, March 19, 2009 - 10:00am PDT

In these tough economic times, are you faced with the pressure of high proprietary database costs? If so, then migrating to MySQL may be something for you to consider.

Join this webinar to learn the benefits of migrating to MySQL, from both a technical and business point of view. We will also provide general guidelines on evaluating whether your application is a good candidate for migration, and address the migration strategies, toolkits, and 5-step migration plan that you can follow and use.

Register for this Webinar »

Live Webinar: Migrating to MySQL - Is it Right for You? (European Hours)

Friday, March 27, 2009 - 13:00 GMT/14:00 CET/09:00 EDT

Join this webinar to learn the benefits of migrating to MySQL, from both a technical and business point of view. We will also provide general guidelines on evaluating whether your application is a good candidate for migration, and address the migration strategies, toolkits, and 5-step migration plan that you can follow and use.

Register for this Webinar »


Live Webinar: Scaling MySQL Leveraging Sun Systems - Turkish presentation

Thursday, March 19, 2009 - 14:00 CET

Scalability is a top priority for MySQL DBAs and developers. However, there are different scalability options to choose from, with different benefits.

Sun Systems for MySQL are enterprise-ready solutions combining servers, storage and software that can give you up to three times greater performance and help you cut costs by 50%. Join this webinar to discover how!

This webinar will be delivered in Turkish.

Register for this Webinar »

Live Webinar: Developing MySQL-Backed Applications with Netbeans and Java RESTful Web Services

Tuesday, March 24, 2009 - 10:00am PDT

Join us for this informative technical webinar presented by Carol McDonald, Java Architect at Sun Microsystems, where she will demonstrate how to leverage the latest version of the Netbeans IDE to develop RESTful Web Services and clients deployed on Glassfish with MySQL. This talk will provide an overview of the design process for a sample RESTful Pet Catalog service using JAX-RS. It will then show how to build 2 sample clients for the Pet Catalog service one using the Dojo AJAX framework and one using JavaFX.

Register for this Webinar »

Live Webinar: For ISVs and OEMs: How to Develop Commercial Applications Using Deeply Embedded MySQL (libmysqld)

Wednesday, April 01, 2009 - 10:00am PDT

Join us for this informative technical webinar presented by Anders Karlsson, Sun Engineer and MySQL expert. The libmysqld embedded server library makes it possible to run a full-featured MySQL server inside (or "deeply embedded") in an application. The main benefits are: increased performance because there is no network I/O; zero database administration because it runs within the application, invisible to the end-user; and a very small footprint. Anders will describe in some detail how libmysqld works and how developing applications with it differs from "normal" MySQL Client / Server development.

Register for this Webinar »

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

View the full list of webinars »

Training, Consulting, and Certification

Training: MySQL for Beginners (4 Days)

Ottawa, Monterrey, London, Sao Paulo

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 » (

Consulting: MySQL Performance Tuning & Optimization (3+ Days)

A dedicated MySQL certified consultant will work closely with your team to explain and implement architecture and performance tuning optimization. Sun's MySQL consultants can provide expertise in the following areas:

  • MySQL Internals
  • Query Optimization
  • Index Tuning
  • Caching and Buffer Tuning
  • Hot Spot and Bottleneck identification
  • Storage Engine selection

Learn More » (


White Paper: Leveraging Identity with Sun GlassFish and MySQL

Identity Management is an often overlooked cost in managing an enterprise's data. This paper describes what identity management is, how to install and configure Sun Identity Manager using GlassFish and MySQL, and compares the TCO for this solution to other vendors' offerings.

Read this White Paper »

Live Webinar: Powerful, Low Cost Data Warehousing in a Challenging Economy

Tuesday, April 07, 2009 - 09:00 EDT/14:00 BST/15:00 CET

Find out how Royal Bank of Canada, ZipRealty, the Belgian Government and other organizations improved their ability to integrate and analyze data, monitor operational business health and make faster and better decisions using integrated solutions from MySQL and Pentaho. This webcast will focus on data integration challenges and solutions, using real-world examples as well as a product demonstration to show you how these organizations achieved success with Pentaho Data Integration and MySQL.

Register for this Webinar »

Beta Release of IBM DB2 (IBMDB2I) Storage Engine for MySQL

A new pluggable storage engine has been developed specific to MySQL running in IBM i, V5R4 and V6R1 and is now available as a beta. This storage engine is The DB2 for i (IBMDB2I) Storage Engine for MySQL on IBM i. The IBMDB2I engine works with MySQL version 5.1.

Download the storage engine »

Read the FAQ » (