MySQL Newsletter May 2009

Articles in this newsletter:


New Product Releases

Hints & Tips

Spotlight: MySQL Community Server 5.4


Training, Consulting, & Certification



MySQL Conference & Expo 2009 Wrap-up - Presentation Files Now Available

The MySQL Conference and Expo 2009 was a huge success. MySQL engineers and experts from leading organizations like Google, craigslist, TicketMaster and the tech team from Barack Obama's Online Presidential Campaign shared their MySQL best practices, scalability & performance tuning tips and lessons learned with over 2000 attendees from all over the world.

View the Presentation Files »

Watch the Video Episode Archives including keynotes »

For ISVs: Take the MySQL OEM Life Cycle Survey and Win a $150 Gift Certificate!

Are you a Commercial Software Developer or Product Manager? Please help us understand how the MySQL team can provide best value to you by taking a 3 minute survey on your product's development cycle. And, you'll be entered to win a $150 gift certificate.

Take the Survey Now »

MySQL Query Analyzer Lunch-n-Learn - Reserve Your Spot!

The MySQL Query Analyzer Lunch-n-Learn Program is designed to be a fun and educational event for your technical team. The goal of this training is to help your team understand how they can leverage the new MySQL Query Analyzer to improve application performance. And the MySQL experts will bring lunch!

Learn More and Register Now » (

Case Study: MySQL Delivers 50% Lower Database Costs as NetHawk Develops Network Monitoring Solutions

With a mission to enhance the quality and user experience of converged communication networks, NetHawk provides state-of-the-art software-based network testing and monitoring tools and services for telecoms and VoIP equipment manufacturers and operators.

NetHawk evaluated proprietary database products, but found MySQL delivered higher levels of performance at 50% lower cost, while meeting stringent availability requirements.

Read the Case Study » (

Case Study: SonicWALL Achieves 100% ROI in Under Nine Months Using MySQL Embedded Server

SonicWALL started using MySQL 5.0 in July 2008 and within just six months of using MySQL, SonicWALL was able to: Lower their cost of goods sold (COGS); Shorten new product time-to-market through the efficiencies they gained in Development, Quality Assurance, Training, and Documentation; and, Reduce the number of trouble tickets they received by over 20%, in addition to other gains.

Read the Case Study »

Live Webinar: 6 Ways to Optimize Performance, Save Time and Lower Risk with a MySQL Enterprise Subscription

Thursday, May 28, 2009 - 10:00am PDT

The MySQL Enterprise subscription provides you with the highest level of technical support for your databases. But, did you know that MySQL Enterprise also includes the MySQL Enterprise Monitor and the MySQL Query Analyzer, which proactively monitors your systems and alerts you on performance issues, security holes, tuning opportunities and expensive code? And did you know that as a subscriber you can start using the Monitor and Query Analyzer now to optimize your application performance and lower your risk of downtime?

Register for this Webinar »

Upcoming MySQL University Sessions

MySQL University is a no cost online training program for Sun Engineers, MySQL Community Contributors and anyone who's interested in MySQL development and internals. Sessions are scheduled on Thursdays and usually last for an hour. Upcoming topics include:

  • May 28: MySQL Replication - Walk-through of the new 5.1 and 6.0 features (Lars Thalmann, head of MySQL Replication and Backup teams)
  • June 4: Boosting Performance With MySQL 5.1 Partitioning (Giuseppe Maxia, head of MySQL Community team)
  • June 11: Building MySQL Releases on Unix (Jörg Brühe, MySQL Build team)
  • June 18: Architecture of MySQL Backup (Lars Thalmann, head of MySQL Replication and Backup teams)

Learn More »

New Product Releases

New Release of MySQL Community Server 5.0.81 (GA)

MySQL Community Server 5.0.81, a new version of the popular Open Source Database Management System, has been released. This release of the MySQL Community Server is based on the MySQL Enterprise Server 5.0.80 code base. Future releases in the MySQL Community Server 5.0 release series will share version numbers with their corresponding MySQL Enterprise Server counterparts.

View the complete list of changes »

Download Now »

New Release of MySQL Connector/Net 5.2.6 (GA)

MySQL Connector/Net 5.2.6, a new version of the all-managed .NET driver for MySQL has been released. This release is of GA quality and is suitable for use in production environments. We have lots of fixes in this release so please review the changelog and see if your favorite bug has been fixed. This version officially supports all versions of MySQL from 4.1 and later.

View the complete list of changes »

Download Now »

New Release of MySQL Connector/Net 6.0.3 (GA)

MySQL Connector/Net 6.0.3, a new version of the all-managed .NET driver for MySQL has been released. This is the first GA release of the new 6.0 connector and introduces several new features and enhancements. This release is approved for use in all scenarios and officially supports MySQL servers 4.1 and higher. New features and improvements include:

  • Massive speedups: in many situations it now matches or exceeds the speed of the native C connector
  • SQL tokenizing has been improved dramatically
  • Implement initial Entity Framework support
  • Improved Visual Studio integration

Download Now »

Read the Documentation »

New Release of MySQL Workbench 5.1.12 (Beta)

We are proud to announce the release of the third official Beta of MySQL Workbench 5.1. This release is available for all major platforms: OS X, Linux and Windows.

We have fixed more bugs and stabilized the application further. Also the table-editor in Mac version is now included. The binary-packages are available for several different platforms as well as the zipped sources for building workbench yourself.

Learn More »

Download Now »

New Release of MySQL Workbench 5.2.0 (Alpha)

The MySQL Workbench team would like to announce the availability of the first Alpha release of MySQL Workbench 5.2.

The major new feature in MySQL Workbench 5.2 is the SQL IDE, which offers the ability to edit and execute queries on MySQL servers. The new SQL query editor, based on the Open Source Scintilla text editor component, offers full syntax highlighting and other advanced editing features.

Learn More »

Download Now »

Hints & Tips

Article: Why Move to MySQL from Microsoft SQL Server?

Robin Schumacher

Before we get started, let me say that I always liked being a SQL Server DBA. My database experience started with DB2, then Teradata, followed by Oracle, and then SQL Server (and then a little bit of Sybase after that, followed by MySQL).

Read this Article »

Tutorial: Developing MySQL Database Applications With PHP

Giri Mandalika

This series of tutorials shows the essential steps involved in installing PHP with MySQL extensions mysql, mysqli, and pdo_mysql, and with support for the MySQL native driver for PHP, mysqlnd. The tutorials also provide simple examples to connect, insert, and retrieve data from a MySQL database.

Read the Tutorial: Part 1 - Using the MySQL Improved Extension, mysqli »

Read the Tutorial: Part 2 - Using the MySQL Extension, mysql »

Read the Tutorial: Part 3 - Using the PDO Extension With MySQL Driver, pdo_mysql »

Read the Tutorial: Part 4 - Using the MySQL Native Driver for PHP, mysqlnd »

White Paper: Guide to Deploying Carrier Grade Services Using Open Source Technologies

Open source technologies and commodity, carrier-grade hardware can combine to create a highly available, scalable and responsive infrastructure to deploy next-generation communications services. This paper examines a solution stack based on integrating Sun GlassFish Communications Server, MySQL Cluster Carrier Grade Edition database, the OpenSolaris operating system, Sun Netra ATCA blades and Sun open storage products into a carrier-grade solution for converged services - without the traditionally high carrier-grade price.

Read this White Paper » (

Building an Open Source, Carrier Grade Platform for Data Management with MySQL Cluster 7

Whether Service Providers are looking to deploy new Web/Telco 2.0 applications to mobile internet users or consolidating subscriber data within the network to support greater service personalization and targeted advertising, the database plays a key enabling role. In this paper we explore how an open source carrier grade platform architecture is able to cost-effectively meet the communication industry's high availability, scalability and real-time performance requirements.

Read this White Paper » (

White Paper: Guide to Scaling OpenLDAP with MySQL Cluster Carrier Grade Edition

Using industry standard LDAP directories with MySQL Cluster serving as the directory data store, Communications Service Providers and Equipment Manufacturers can embark on initiatives that fully exploit user and network data currently distributed across legacy applications and the network. MySQL Cluster provides real-time performance and carrier-grade availability to a total solution that reduces cost, risk and complexity for large, transaction-intensive directory data sets.

Read the White Paper - "Guide to scaling OpenLDAP with MySQL Cluster Carrier Grade Edition" »

Read the White Paper - "Guide to deploying MySQL Cluster as a high availability data store for OpenLDAP" »

White Paper: MySQL Enterprise Technical and Consultative Support Services Mitigate Risk, Minimize Downtime, Meet SLAs

This paper explores how you can confidently deploy MySQL, the "M" in the open source LAMP stack, as part of an innovative and cost-effective platform ideal for delivering low cost, high-performing, always on, internet-based applications. It provides an overview of MySQL Enterprise, which is comprised of MySQL database and advanced monitoring software that ensures you are running the most up to date version of MySQL at the highest levels of security, performance, and availability. It also provides a deeper dive into the MySQL Enterprise Technical and Consultative support services that are designed to mitigate risk, minimize downtime, and ensure you meet revenue, customer, and end-user Service Level Agreements.

Read this White Paper »

White Paper: Virtualization for MySQL on VMware® - Best Practices and Performance Guide

In a nutshell, performance variance is minimal on a properly configured system, as shown in tests on a typical small to medium business level server with MySQL running in a VMware virtualized environment. This document explains how we reached this conclusion by describing the setup, configuration, and results from our testing.

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: Hibernate Wars - The Query Cache Strikes Back

Darren L. Oldag

Not so long ago, in a galaxy not very far away... a middle-aged programmer battled to free memory from the dark side of the hibernate query cache. He was successful, or so it seemed. For the query cache memory problems had risen from the ashes - stronger and more bloated than ever ...

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL Sandbox 3.0 Release Candidate

Giuseppe Maxia

MySQL Sandbox is now in Release Candidate status. If no bugs are reported on the latest version (2.0.99f), I will repackage it as 3.0. In addition to the list of features previously announced, I managed to implement another feature that has been in the wish list for a long time, i.e. creating a sandbox from existing binaries, such as the ones installed by a .rpm or .deb package.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Are Stored Procedures available with MySQL Cluster?

Andrew Morgan

The answer is yes - kind of.

Stored procedures are implemented in a MySQL Server and can be used regardless of the storage engine being used for a specific table. One inference from this is that they won't work when accessing the Cluster database directly through the NDB API.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: How do I use the MySQL Proxy Admin plugin?

Diego Medina

We have an Admin plugin for the MySQL Proxy, but people started asking how to use it. I only found one example, thanks to Giuseppe, but people wanted more.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL Community Awards 2009

Giuseppe Maxia

Attending the MySQL Users Conference in 2006, I had one of the best days of my career. At the morning keynote, my name was called, and I found myself on stage, together with Markus Popp, Roland Bouman, and Rasmus Lerdorf, being awarded a Community Member of the year crystal ball. That day is permanently in my mind as a very fond memory.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL Connector/Python - on launchpad!

Geert Vanderkelen

I'm happy to announce (bit unofficially) the first (alpha) source code release of MySQL Connector/Python. It's hosted on Launchpad and can be downloaded using the Bazaar client. It's more a preview as I'm still working on it during free time. Please post comments, bug reports, ideas, critics, etc...

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Online configuration update and a new script

Johan Andersson

If you are using the scripts from the Configurator (and yes, the broken link is now fixed so it is actually possible to get the config package...), and want to tweak your configuration on a started Cluster then you can do like written below.

Read the PlanetMySQL BlogPost »

Spotlight: MySQL Community Server 5.4

Article: A Quick Look at MySQL 5.4

Robin Schumacher

Although MySQL 5.1 was released in December of 2008, Sun Microsystems isn't wasting any time moving forward with a number of new and exciting enhancements for its next release, MySQL 5.4. The first item of note is that the MySQL Server will be returning to a release early/often paradigm. So, instead of waiting on a full set of previously agreed upon features to be ready, the goal will now be to adhere to time-controlled releases that include all features that are ready by an agreed-upon beta date, with any features not fully 'baked' simply rolling to the next release.

Read this Article »

Download MySQL 5.4 Now »

PlanetMySQL BlogPost: MySQL 5.4 Scaling to 16-way x86 and 64-way CMT Servers

Mikael Ronstrom

The release of the MySQL 5.4 contains patches which increases the scalability of the MySQL Server. I am planning to blog about those changes in some detail over the next few days. This blog will give an introduction and show what the overall results we have achieved are.

Read the PlanetMySLQ BlogPost »

PlanetMySQL BlogPost: MySQL Performance - MySQL 5.4 and other InnoDB engines @dbSTRESS Benchmark

Dimitri Kravtchuk

As you may already know, today Sun announces MySQL 5.4. It's a big step forward and I hope you'll have enough time today to follow all blog posts and other interesting related publications!

Read the PlanetMySQL BlogPost »

PlanetMySQL BlogPost: MySQL 5.4 performance with logging

Giuseppe Maxia

About a month ago, I published the results of MySQL 5.x performance with logging. The results covered several versions, from 5.0.45 to 5.1.33. Among the conclusions of the post was the consideration that MySQL 5.0.x is faster than MySQL 5.1 in read only operations. I hinted that better results may come for MySQL 5.1. When I wrote that post I had, in fact, an ace up my sleeve, because I had already benchmarked the performance of MySQL 5.4, using the same criteria shown in my previous post.

Read the PlanetMySQL BlogPost »

PlanetMySQL BlogPost: Looking at MySQL 5.4 - IO bound benchmarks

Vadim Tkachenko

With a lot of talks around 5.4 I decided to check how it works in our benchmarks. For first shoot I took tpcc-like IO-bound benchmark (100W, ~10GB of data, 3GB buffer_pool) and tested it on our Dell PowerEdge R900 box (16 cores, 32GB of RAM, RAID 10 on 8 SAS 2.5" 15K RPM disks). For comparison I took XtraDB-release5 and 5.0.77-highperf percona release.

Read the PlanetMySQL BlogPost »

Live Webinar: MySQL 5.4 Benchmarks In-Depth

Thursday, May 21, 2009 - 3:00pm PDT

Join us for this informative technical webinar presented by performance expert, Allan Packer, Principal Engineer at Sun Microsystems. In this webinar Allan will give an overview of the scalability and performance improvements of MySQL 5.4. This version can yield up to 90% faster response times, and scalability up to 16-way x86 servers and 64-way CMT servers. Allan will also explore in depth, several benchmarks concerning MySQL 5.4, including Sysbench results on CMT and Nehalem systems plus an OLTP workload derived from an industry-standard benchmark.

Register for this Webinar »


Live Webinar: MySQL Performance Tuning Step-by-step

Thursday, May 21, 2009 - 10:00am PDT

Learn the basic steps the MySQL Consulting pros follow to tune a MySQL database server. Each step will be covered at a high level with one or two of the most critical parameters covered in detail for each step.

Register for this Webinar »

Live Webinar: What's New in the Next Generation of MySQL Cluster? (EMEA)

Wednesday, May 27, 2009 - 10:00 CET / 11:00 EET

Whether you're racing to introduce a new service, or trying to manage an avalanche of data in real time, your database has to be scalable, fast and highly available to meet ever-changing market conditions and stringent SLAs.

By attending this webinar, you will learn more about the next generation of MySQL Cluster, and how it enables you to deliver 99.999% database availability, with real time performance and linear scalability, while slashing TCO.

Register for this Webinar »

Live Webinar: Cloud Computing For DBAs - Presented By MySQL and Zmanda

Tuesday, June 9, 2009 - 1:00pm PDT

Join us for this informative technical webinar with Jimmy Guerrero, Sr Product Manager - Sun Microsystems and Chander Kant, CEO - Zmanda to learn how to leverage compute and storage clouds for MySQL backed applications. In this presentation we will cover the fundamentals of cloud computing and some tips and tricks when deploying and managing MySQL on the cloud.

Register for this Webinar »

Live Webinar: Open Source Memcached Tools Overview by Gear6

Wednesday, June 10, 2009 - 10:00am PDT

Join us for this tools overview for memcached by Ryan Lucio and Rama Chitta, Software Engineers at Gear6, the leading provider of memcached solutions. In this webinar Ryan and Rama will provide an overview of several open source tools for memcached, including: Advanced Reporter, Statsproxy, Brutis, Cacti and Wireshark. In addition to providing an overview of each tool, Ryan and Rama will show how the tools are used and when to use them.

Register for this Webinar »

Live Webinar: For ISVs: Faster Data Reduction and Smoothing for Analysis & Archival in MySQL

Thursday, June 11, 2009 - 10:00am PDT

ScienceLogic embeds MySQL in its EM7 network management appliances. An installation of EM7 can perform over half a billion database queries daily, storing massive amounts of data for both real-time and trended performance reporting. The product's need for high-scale data handling and storage required solutions to increase efficiency and get to scale. One solution is to utilize data smoothing techniques in MySQL, using "group by".

Register for this Webinar »

Live Webinar: Developing and Deploying SaaS Applications with MySQL and LongJump

Thursday, June 11, 2009 - 1:00pm PDT

Join us for this informative webinar with Brian Gerhold, Director of Engineering at Simco Electronics and Pankj Malviya, Founder/CEO of LongJump. In this presentation we'll examine how Simco's development team built a next-generation SaaS application which automated data collection, reporting and compliance leveraging MySQL and the LongJump development platform. Brain will discuss how Simco approached common SaaS application development problems and the solutions that lead to their success.

Register for this Webinar »

Live Webinar: Improve Application Performance with the MySQL Enterprise Monitor and the MySQL Query Analyzer

Tuesday, June 30, 2009 - 10:00am PDT

Are you looking for performance tuning opportunities in MySQL?

In this technical webinar, Phil Hildebrand, Database Manager at thePlatform, will talk about how they used the MySQL Enterprise Monitor, the MySQL Enterprise Advisors and the MySQL Query Analyzer to deploy new applications and implement changes to production systems more efficiently. Phil will present these tools from a practical, user-oriented perspective, and also showcase how to achieve significant performance enhancements while reducing troubleshooting time of difficult SQL code issues.

Register for this Webinar »

On-demand Webinar: Mission Critical Coverage with MySQL Enterprise Technical Services

For business and mission critical deployments of MySQL, the MySQL Enterprise subscription offering provides the comprehensive production support, monitoring tools and database software necessary to provide optimal levels of performance, reliability, security, and uptime.

Join this webinar to learn about how the proactive and consultative tools and support included in a MySQL Enterprise subscription can help the most demanding Enterprises and Web properties mitigate risk, minimize downtime, and maintain SLAs.

Register for this Webinar »

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

Training, Consulting, and Certification

Training: MySQL for Developers (5 Days)

Tel Aviv, Shanghai, Bangkok, Paris

This instructor-led course is designed for students planning on developing applications that make use of MySQL 5.0 and 5.1. This course covers essential SQL statements for data design, querying, and programming. In addition, it will prepare you for the MySQL Developer certification.

Register Now for an Upcoming Date » (

Consulting: MySQL High Availability Service (20+ Days)

A dedicated Sun's MySQL consultant will use proven methodologies and expertise in database clustering, replication, fail-over, fault-tolerance and other HA techniques to guide and assist you. Sun's MySQL consultants can assist you who purchase this service with the process of designing, testing, deploying and operating a modern database infrastructure that will help them meet their objectives for performance and high-availability.

Learn More » (


Calling ISVs: Certify Your Application with MySQL Cluster Carrier Grade Edition Today

By certifying your application with MySQL Cluster Carrier Grade Edition, the industry's leading high availability database, you enjoy the following benefits:

  • Provide even higher levels of customer assurance that your application can meet the most stringent demands for high availability, performance and scalability
  • Increase awareness and visibility of your application among one of the world's largest and most influential software user communities
  • Differentiate your product from the competition by offering reduced complexity and integration costs along with faster time to market for your end customers

Learn More » (

White Paper: MySQL and Kickfire - Delivering the Best of all Worlds for Today's Analytics

With today's explosion of business data and the urgent need for analytics to tap trends and facilitate rapid decision making, this white paper provides guidance on how to evaluate the many analytic solutions that exist today - from traditional vendors to the very latest approaches.

Read this White Paper »

Live Webinar: High Performance, Low Cost - Scaling Reporting and Analytics for Large Data Volumes

Tuesday, May 26, 2009 - 1:00pm PDT

Infobright, integrated with MySQL, combines a column-oriented database with a unique Knowledge Grid architecture, which will be detailed in the webinar.

Also, hear how Mavenir, a provider of next generation Mobile core for Voice, Messaging and Rich Communication Suites (RCS), is using Infobright with MySQL to manage massive messaging traffic for its customers on a minimal hardware footprint and at less cost.

Register for this Webinar »

Live Webinar: SmartScaling MySQL in the Internet Data Center

Wednesday, May 27, 2009 - 10:00am PDT

Virident has pioneered SmartScaling, a new approach to datacenter management that simplifies scaling, decreases complexity, and conserves capital and power. Virident GreenCloud Servers for MySQL and Memcached represent a fundamentally better building block for building an infrastructure. Come learn how to take advantage of the breakthrough new approach to managing your data center.

Register for this Webinar »

Live Webinar: Faster and More Scalable MySQL Reporting and Analytics with Kickfire

Thursday, June 4, 2009 - 10:00am PDT

There is a growing number of MySQL users doing reporting and analytics. With larger data volumes and more users demanding faster query response times, organizations are looking for the best MySQL platform on which to scale their reporting and analytic applications. With a variety of options available, it can be hard to know how to choose. This webinar will give an overview of the choices available and present the benefits of the Kickfire approach.

Register for this Webinar »