MySQL Newsletter April 2009

Articles in this newsletter:


New Product Releases

Hints & Tips

Spotlight: MySQL Embedded Server for ISVs & OEMs


Training, Consulting, & Certification



Sun Microsystems Announces MySQL 5.4

Sun Microsystems announced MySQL 5.4, a new version of the world's most popular open source database, designed to deliver significant performance and scalability improvements to MySQL applications. A preview version of MySQL 5.4 is available for download now.

Download MySQL 5.4 Now » (

Read the Documentation: MySQL 5.4 Feature Summary »

Read the Article "A Quick Look at MySQL 5.4" »

Sun Microsystems Announces MySQL Cluster 7.0

Sun Microsystems announced MySQL Cluster 7.0, a major new release of its high-availability open source database software for real-time, mission-critical applications. New features include significantly enhanced performance and scalability; support for popular LDAP directories; and simplified cluster back-up and maintenance.

Download MySQL Cluster 7.0 Now »

Read the White Paper "MySQL Cluster 7.0: Architecture and New Features" » (

Attend the Live Webinar "What's New in MySQL Cluster 7.0?" (April 30, 2009) »

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

In a keynote presentation at the MySQL Conference & Expo, Sun executives Karen Padir and Kaj Arnö announced the winners of the 2009 MySQL Community-Member-of-the-Year, 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: Oracle to Buy Sun

Sun Microsystems and Oracle Corporation announced on today they have entered into a definitive agreement under which Oracle will acquire Sun common stock for $9.50 per share in cash. The transaction is valued at approximately $7.4 billion, or $5.6 billion net of Sun's cash and debt.

Read the Press Release »

MySQL European Customer Conference 2009 - Save the Dates!

MySQL Conference is coming to the Europe again in 2009. We had a great success in 2008, and we invite all alumni as well as new faces to join us this year. Save the dates and we'll have more information for you soon!

  • Köln Germany, October 20th, 2009
  • London, October 22nd, 2009
  • Paris, November 18th, 2009

View the agenda and presentation slides in MySQL European Customer Conference 2008 » (

Renew and Get the Most Out Of Your MySQL Enterprise Subscription

Your MySQL Enterprise subscription provides access to the software and services that keep your systems high performing, secure and reliable. Do you have a subscription that's about to expire? Learn why you should renew now:

  1. Get a 200% Return on Your Investment in MySQL Enterprise
  2. Don't risk your business with downtime that will result in lost revenue and profits
  3. Improve MySQL Performance by up to 300% with the MySQL Query Analyzer
  4. Maintain your High Availability with the MySQL Enterprise Monitor
  5. Be the first to receive new releases and save time and effort writing, testing, versioning, and deploying custom scripts with the MySQL Advisors, Rules and Alerts
  6. Receive Design and Tuning Advice from MySQL Support Engineers

Renew Your Subscription Now » (

Learn More » (

Case Study: Virgin Mobile France Chooses MySQL Enterprise Unlimited to Drive Growth

Virgin Mobile France, launched in April 2006, has become the fourth mobile operator in the country with over 1 million customers. Launched by Sir Richard Branson, Virgin Mobile is now the world's leading mobile virtual network operator (MVNO) with over 11 million customers in 7 countries (UK, Australia, USA, Canada, South Africa, India and France).

Read the Case Study »

Case Study: Netlog ensures fast response times as traffic increases 300% with MySQL Enterprise Unlimited

Netlog is one of the fastest-growing social networks in Europe. The target group is young people, 14-24 years of age, and Netlog is primarily used for communication, entertainment and sharing music and photos. Access to MySQL Enterprise's monitoring and support services helps Netlog deliver excellent performance, security and response times on its 300 database servers.

Read the Case Study » (

Live Webinar: Using MySQL Query Analyzer to Remove Performance Bottlenecks (EMEA)

Tuesday, April 28, 2009 - 15:00 CET

Join this webinar to learn how the MySQL Query Analyzer, a new feature in the MySQL Enterprise subscription, can help DBAs and Developers like you improve application performance by monitoring query performance to accurately pinpoint SQL code that is causing a slow down.

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:

  • Testing Multiple Servers With MySQL Sandbox (April 30)
  • MySQL Replication: Walk-through of the new 5.1 and 6.0 features (May 7)
  • Boosting Performance With MySQL 5.1 Partitioning (June 4)

Learn More »

New Product Releases

New Release of MySQL Community Server 5.1.34 (GA)

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

View the complete list of changes »

Download Now »

New Release of MySQL Enterprise Monitor 2.0.5 (GA)

MySQL Enterprise Monitor has been released. This is a maintenance release of the Enterprise Monitor that fixes a number of bugs. Fixes include:

  • Calling the Agent with the option --agent-run-os-tests resulted in a crash. This happened on Linux x86-64 systems. (Bug #43381)
  • Following a change in the replication configuration, MySQL Enterprise Monitor did not display the new topology correctly. (Bug #43240)
  • MySQL Enterprise Monitor did not add a log entry each time data was purged. The log entry should have noted how many rows of each type of data were purged. (Bug #43159)

View the complete list of changes »

Download Now (Login Required) »

Sign-up for MySQL Enterprise 30-day Trial » (

New Release of MySQL Connector/C++ 1.0.5 (GA)

The first GA (general availability) version of MySQL Connector/C++ has been made available: MySQL Connector/C++ 1.0.5 GA. The MySQL Connector/C++ provides a C++ API for connecting client applications to the MySQL Server 5.1 or newer. We have improved the driver and added a couple of new features since the last beta release. Please see the documentation and the CHANGES file in the source distribution for a detailed description of bugs that have been fixed.

Download Now »

Read the Documentation »

New Release of MySQL Connector/C 6.0.1 (GA)

MySQL Connector/C 6.0.1, a new version of the C API for accessing MySQL database servers, is now available. This is the first generally available (production) release of the new packaging for this standalone distribution of code that used to only be distributed along with the server.

Download Now »

Read the Documentation »

New Release of MySQL Connector/Net 6.0.2 (Beta)

MySQL Connector/Net 6.0.2, a new version of the all-managed .NET driver for MySQL has been released. This is a beta release and is intended to introduce you to the new features and enhancements we are planning. This release was quickly pushed out due to a problem that caused 6.0.1 to not register with Visual Studio correctly.

Download Now »

Read the Documentation »

New Release of MySQL Workbench 5.1.10 - Linux/OS X/Windows (Beta)

We are proud to announce the release of the second official Beta of MySQL Workbench 5.1, the next highly anticipated version of our database GUI tool - MySQL Workbench. This release is available for all major platforms: Mac OS X, Linux and Windows.

Download Now »

Learn More »

New Release of MySQL Connector/ 1.0.2 (Alpha)

A new version the MySQL Connector/ has been made available: MySQL Connector/ 1.0.2 alpha (Alpha 2). The driver can be used to connect from 3.1 to MySQL 5.1 or newer. The MySQL Connector/ is implemented as an easy to install extension.

Learn More »

Hints & Tips

Article: Getting Started with DTracing MySQL

Amit Saha

DTrace is a dynamic tracing facility built into the Solaris and Open Solaris operating systems and can be used by system administrators and developers alike to observe the runtime behavior of user level programs and of the operating system itself. On one hand, DTrace can be used to identify potential bottlenecks in the running processes on a production system, and on the other, DTrace can help you understand the runtime behavior of an external program such as MySQL better.

Read this Article »

Article: Five Query Optimizations in MySQL

Sean Hull

Query optimization is the often overlooked part of applications. Development schedules being what they are, getting the right results and getting the application working are the main priorities. So thoroughly testing, and benchmarking queries is often left as an afterthought.

Read this Article »

Tutorial: Using the MySQL Connector/J JDBC Driver With the Java SE Platform

Giri Mandalika

This tutorial will show you the essential steps to install and configure the Connector/J JDBC driver, with simple examples to connect to a MySQL database. Because the focus is on the database driver and the database connectivity from the Java programming language, this document assumes that some kind of MySQL database is already up and accessible from the client machine.

Read the Tutorial »

White Paper: Improving MySQL Database Scalability

Benoit Chaffanjon and Nick Kloski

In the past, databases ran entire workloads on a single server. Everything that needed to get done could be accomplished on one system. Times changed, and the need for scalability drove software development toward multi-server scaling. Now, being open to change can have a dramatic impact on the datacenter.

Read this White Paper »

White Paper: High Availability MySQL Database Replication with Solaris Zone Cluster

Pedro Lay

This paper describes the benefit of deploying the master and slave database of MySQL Replication using Zone Clusters. In addition, it provides details on how to deploy the master and slave databases in two different Zone Clusters, using non-global zones from two different machines as the virtual cluster nodes.

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: MySQL 5.4 Scalability on 64-way CMT Servers

Allan Packer

Today Sun Microsystems announced MySQL 5.4, a release that focuses on performance and scalability. For a long time it's been possible to escape the confines of a single system with MySQL, thanks to scale-out technologies like replication and sharding. But it ought to be possible to scale-up efficiently as well - to fully utilize the CPU resource on a server with a single instance.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL 5.4 Scaling on Nehalem with Sysbench

Allan Packer

As a final followup to my MySQL 5.4 Scalability on 64-way CMT Servers blog, I'm posting MySQL 5.4 Sysbench results on a Sun Fire X4270 platform using the Intel x86 Nehalem chip (2 sockets/8 cores/16 threads).

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL & Google Summer of Code 2009 - time to get going!

Kaj Arnö

As Colin revealed last week, Google has accepted MySQL for the Google Summer of Code 2009. We've already participated in GSoC 2007 and 2008, so this is our third year running. We know more than before about what's waiting for us, and so does our mentors and perhaps even some of our students.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: LDAP and MySQL Cluster

Johan Andersson

There are two LDAP Directory Servers available that supports MySQL Cluster - OpenLDAP (supported and maintained by Symas Corp.) and OpenDS (Sun Microsystems). Both of them have implemented a back-end called back-ndb that talks direclty to the data nodes. This means that they use the NDBAPI directly to access data in the cluster, thus bypassing the MySQL Server.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: How MySQL Sandbox Solves All My Problems

Gregory Haase

I just can't help thinking about how amazing and useful MySQL Sandbox is. There are so many things that it can do, and so many problems that it solves for Database Developers. When it comes down to it, I really think that every project that uses MySQL can benefit in some way or another just by using MySQL Sandbox.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: What's the Performance impact of the Double Write Buffer?

Matt Yonkovit

I have been benchmarking Waffle Grid using the new InnoDB Plugin 1.03 in the past couple of days. Let me say the plugin is fast. Which got me thinking, generally when you fix a bottleneck another area becomes a bottleneck ... it's a vicious cycle really. I figured why not benchmarks several different settings just to see what sort of improvement or detriment we get in InnoDB.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Multi-source replication with MySQL Cluster

Johan Andersson

With MySQL Cluster it is possible to aggregate data from many MySQL Servers using Replication. Here is how. E.g, you might have a sensor network, where each sensor writes data into a mysql server. The problem is that you have a quite few of these sensors, and you want to aggregate this data, e.g. in order to do data mining on the combined data set.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL DBA 5.1 Exam Contents

Dave Stokes

The MySQL DBA 5.1 Certification Exam is a big change from previous exams. 1. No multiple choice, true/false questions. 2. Must be able to use MySQL. 3. You are given the answers (in most cases) and must change the database to meet expectations. 4. No study guide.

Read the PlanetMySQL BlogPost(Part 1 of 3) »

Read the PlanetMySQL BlogPost(Part 2 of 3) »

Read the PlanetMySQL BlogPost(Part 3 of 3) »

Spotlight: MySQL Embedded Server for ISVs & OEMs

Event: The MySQL "Lower-Your-COGS Workshop for ISVs and OEMs" is coming to New York City (May 7, 2009)

Today's economic pressures are causing growing interest in MySQL from ISV and OEM Product Teams as they look to lower their cost of goods sold (COGS) and confront the now common question of: "How can we provide feature-rich solutions at a lower cost and increase our margins?" (or, "How can we do more with less?")

The MySQL Embedded Server provides answers to this question by "Eliminating the Database Tax", which is the theme of our two-part, half-day workshop. Register soon to reserve you space!

Register Now » (

View the Location and Session Details » (

Article: Developing Database Applications Using MySQL Connector/C++

Giri Mandalika

This tutorial will show you the essential steps to build and install MySQL Connector/C++ driver, with simple examples to connect, insert, and retrieve data from a MySQL database.

Read the Article »

Article: Installing MySQL Connector/C++ from Source

Giri Mandalika

Before you proceed with the installation from source, check the Connector/C++ downloads page to see whether the driver is available in binary form for your build platform, and whether it works for you. In general, all the pre-compiled binaries are built with the best possible options for all the supported platforms.

Read the Article »

PlanetMySQL Blog: Libmysqld performance. And a Webinar. And a talk at the UC!

Anders Karlsson

As you might know by now, libmysqld, the deeply embedded version of MySQL, has reappeared in MySQL 5.1, having been gone in version 5.0. If you are curious about libmysqld in general, then feel free to pop by this free live webinar, hosted by no one else but yours truly.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL Connector/C++: how to build a client on Linux using NetBeans 6.5

Ulf Wendel

A few days ago, I have published a tutorial on building a Connector/C++ client application on Windows using Visual Studio. Its time for a Linux How-To.

Read the PlanetMySQL BlogPost »

White Paper: Reducing ISV Risk Using MySQL

In this white paper, we explore the challenges and risks faced by technology providers (including Independent System Vendors (ISV), Original Equipment Manufacturers (OEM), and Value-Added Resellers (VAR)) when bringing a new product to market. Embedding a proven, market-leading database such as MySQL can go a long way toward building a solid technology foundation while concurrently helping to mitigate risk.

Read the White Paper » (

White Paper: MySQL Embedded Server 5.1 for Commercial ISVs/OEMs

The MySQL 5.1 server continues to move MySQL and Sun ahead in its mission to make sophisticated database management available and affordable to all. MySQL 5.1 is particularly appealing to ISV (Independent Software Vendors) and OEM (Original Equipment Manufacturers) solution providers who need to embed a database within the application that they either sell in traditional manner or use in a software-as-a-service fashion.

Read the White Paper » (

Case Study: Adobe Relies on MySQL to Make Creative Professionals More Productive

Adobe Systems is one of the largest software companies and is the leading provider of creative tools for print, web, interactive, mobile, video, and film. Adobe embeds MySQL into several Adobe Creative Suite 3 components including Adobe Acrobat CS3, Adobe Bridge CS3, and Adobe Version CueR CS3 so that workgroups can work more efficiently on complex projects.

Read the Case Study » (

Case Study: Tema Networks Selects MySQL Embedded Server to Power its Real Time Mobile Billing Solution

Tema Networks develops billing and Value Added Services (VAS) solutions for mobile network operators around the world. Based in Finland, Tema Network's management team are seasoned professionals with a combined experience of over 40 years, holding senior level positions within leading suppliers to the Communications industry.

Read the Case Study » (

Live Webinar: For Commercial ISVs and OEMs: Securely and Seamlessly Deploy MySQL with Your Application

Tuesday, May 12, 2009 - 10:00am PDT

MySQL security best practices often assume restricted access to the physical server and restrictive file system privileges. However, OEM's and ISV's who bundle and distribute MySQL with their applications have no control over where the application is installed. In fact, the application is often deployed on workstations with unrestricted access to the underlying data files.

Register for this Webinar »

Live Webinar: For Commercial ISVs: The New MySQL Connector/C++

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

MySQL Connector/C++ is the latest Connector for MySQL. It takes different approach compared to existing C++ drivers by following the JDBC specification in a way that makes sense in C++ world. In this webinar you'll learn the reasoning behind Connector/C++'s development, what's included in Connector/C++, what's planned for Connector/C++ and how you can use it to ease your C++ development.

Register for this Webinar »


Live Webinar: Mission Critical Coverage with MySQL Enterprise Technical Services

Tuesday, April 28, 2009 - 10:00am PDT / 17:00 UTC

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

Register for this Webinar »

Live Webinar: What's New in Memcached 1.3

Wednesday, April 29, 2009 - 4:00pm PDT

Join us for this informative technical webinar presented by Toru Maesaka, Software Engineer at, the most popular social networking site in Japan. In this webinar Toru will explain the basic concepts of how memcached works, how it can be leveraged to increase the scalability of online applications, plus what's new in the 1.3 release.

Register for this Webinar »

Live Webinar: Scaling MySQL Leveraging Sun Systems (Australia/New Zealand)

Thursday, April 30, 2009 - 11:00 Australia EST / 13:00 NZST

Virtualizing and scaling MySQL can provide substantial benefits when properly implemented. This session covers:

  • MySQL Virtualization Options, Considerations, Recommendations
  • Considerations for Scaling MySQL
  • Test Results, Financial and Eco Impact

Join this web seminar to learn more about these features and how you can put them to use.

Register for this Webinar »

Live Webinar: What's New in MySQL Cluster 7.0?

Thursday, April 30, 2009 - 10:00am PDT / 17:00 UTC

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: Memcached Technical Deep Dive

Tuesday, May 05, 2009 - 10:00am PDT / 17:00 UTC

Join us for this informative technical webinar presented by Trond Norbye, Sr. Software Engineer at Sun Microsystems. In this webinar Trond will explain the basic concepts of how memcached works and how it can be leveraged to increase the scalability of online applications.

Register for this Webinar »

Live Webinar: MySQL and Search at Craigslist

Thursday, May 07, 2009 - 10:00am PDT / 17:00 UTC

Join us for this informative technical webinar presented by Jeremy Zawodny of In this webinar Jeremy will look at the recent evolution of database and search architecture at Craigslist, including performance, caching, partitioning, and other tweaks.

Register for this Webinar »

Live Webinar: Running MySQL Web Services on Sun systems with Intel Xeon 5500 processors

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

Speed up application performance, simplify your datacenter and see cost and energy savings with Sun's Open Network System for MySQL - integrating and optimizing compute technologies and featuring the Intel Xeon processor 5500 series with new flash-ready options.

Register for this Webinar »

Live Webinar: Guide to Open Source Data Warehousing for Communications Service Providers

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

The biggest asset Communications Service Providers (CSPs) have to compete and grow in the market is their data - specifically customer data. This data is much more than just traditional customer billing details. Tune into this live webinar from Infobright and MySQL to learn how open source data warehousing enables Communications Service Providers to gain greater subscriber insight, with lower cost and risk than ever before.

Register for this Webinar »

Live Webinar: Database Sharding at Netlog with MySQL and PHP (EMEA)

Wednesday, May 13, 2009 - 15:00 CET / 16:00 EET

Netlog, one of the fastest-growing Web communities in Europe, need to ensure its database infrastructure will scale to handle its traffic increase of 300% last year. The company has 40 million registered members generating more than 6 billion page views every month. If you're interested in high performance, scalability, MySQL, php, caching, partitioning, Sphinx, federation or Netlog - join this webinar!

Register for this Webinar »

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

View the full list of webinars »

Training, Consulting, and Certification

Training: MySQL for DBAs (5 Days)

Orlando, Paris, Bangalore, Mexico City

An Authorized MySQL instructor will teach you how to properly install MySQL, create and execute Backup Strategies, create secure Stored Procedures to update and access data and more!

This instructor led, hands-on class will teach you how to secure users privileges, set resource limitations, and access controls. In addition, you will learn multiple new features such as creating and using Stored Procedures, Triggers and Views.

Register Now for an Upcoming Date » (

Certification: NEW! Performance-Based Testing for MySQL 5.1 Certification

MySQL now offers performance-based testing for real-world skills. The new performance-based certification exam is currently offered in the MySQL DBA training class at no additional charge. Experts rate lab-based exams as highly relevant because these exams allow candidates to test their IT skills in a live environment. Separate yourself from others in this economy by getting MySQL Certified.

Learn More » (

Consulting: MySQL Data Warehouse Jumpstart (8+ Days)

Sun's MySQL consultants have the experience and knowledge to help accelerate your Data Warehouse project and guide you through the crucial startup phase of creating a Data Warehouse. Getting the initial phase of a Data Warehouse project right helps to reduce the risk of schedule overruns.

Learn More » (


MySQL Enterprise Certification for Technology Providers

Certifying your technology to work with MySQL Enterprise has benefits to both your company and your customers. Certification enables you to provide your customers with the confidence that they are deploying a production-ready, enterprise-grade solution.

Learn More » (