MySQL Newsletter June 2010

Articles in this newsletter:


New Product Releases

Hints & Tips

Spotlight: Running MySQL Embedded Server on Windows



Developer Interview: What's New in the MySQL Enterprise Spring 2010 Release?

In this interview, Mark Matthews and Andy Bang, two core developers in the MySQL Enterprise Monitor team, give us some insight into the new features in the latest MySQL Enterprise Release.

Read this Developer Interview »

White Paper: MySQL Query Analyzer Overview

This paper explores common use cases and challenges faced by MySQL developers and DBAs in tuning SQL code. It also introduces the MySQL Query Analyzer and explains how it can be used to optimize queries during development and then to monitor applications in production environments.

Read the English White Paper » (

Read the German White Paper » (

Read the French White Paper » (

Read the Italian White Paper » (

Read the Japanese White Paper »

White Paper: Scaling Web Services with MySQL Cluster: An Alternative Approach to MySQL & memcached

MySQL and memcached has become, and will remain, the foundation for many dynamic web services with proven deployments in some of the largest and most prolific names on the web.

On the other hand, there are classes of web services that are highly transactional and update-intensive, demanding real-time responsiveness and continuous availability. In these cases, MySQL Cluster provides the familiarity and ease-of-use of the regular MySQL Server, while delivering significantly higher levels of write performance with less complexity, lower latency and 99.999% availability.

Read this White Paper »

Case Study: MySQL Cluster Powers Leading Document Management Web Service

The DocQ web service eliminates the limitations of sharing physical documents by offering a complete paperless business solution; providing a single place where customers can manage, archive, and send their important documents. DocQ supports secure business transactions and the services to store, edit, collaborate, and publish business documents with MySQL Cluster.

Read this Case Study »

Case Study: Cashpoint Saves Half a Million Euros per Year as it Bets on MySQL

Cashpoint is a betting and gaming enterprise founded in 1996 in Austria and is the market leader in several EU countries. Cashpoint has an extensive network of betting offices, more than 3,000 betting terminals, and an online betting platform.

The Sybase database that was originally deployed at Cashpoint no longer met their ever-increasing data management requirements. The stability, reliability, and performance did not allow Cashpoint to achieve the required level of service availability. Therefore Cashpoint searched for a stable and low administration database environment to optimize their performance levels, maintenance times, and availability demands.

Read this Case Study »

TechCast Live: Jono Bacon and Luke Kowalski from Oracle on MySQL Community

Tuesday, June 8, 2010 - 10:00am PT

What makes a productive, thriving community? Look no further than the MySQL example. Bring your questions; we'll answer them in this live, interactive Webcast on June 8, 2010 at 10am PDT.

Join the Webcast »

Live Webinar: What's New in the MySQL Enterprise Spring 2010 Release

Tuesday, June 15, 2010 - 8:00am PT

The MySQL Enterprise Spring 2010 Release includes key improvements designed to help you proactively optimize MySQL performance and identify potential issues before they can become costly outages or slowdowns. In this webinar, we will explore the new features of the MySQL Enterprise Monitor 2.2 that are designed to save DBAs and Developer time and effort in keeping MySQL systems running at the highest levels of security, performance and availability.

Register for the English Webinar (June 15) »

Register for the German Webinar (June 17) »

Register for the Italian Webinar (June 24) »

Register for the French Webinar (June 29) »

New Product Releases

New Release of MySQL Community Server 5.1.47 (GA)

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

View the complete list of changes »

Download now »

New Release of MySQL Enterprise Monitor 2.2 (GA)

We are excited to announce that MySQL Enterprise Monitor 2.2 is now available on the Enterprise web site as our latest GA release.

The flagship features of this release include:

  • Plugins for MySQL Connectors now feed Query Analyzer data directly to the Dashboard
  • Support for LDAP authentication
  • Easy upload of MySQL diagnostic info to Support

Read the Documentation »

View the complete list of changes »

New Release of MySQL Workbench 5.2.22 (RC)

We're announcing the second Release Candidate of MySQL Workbench. MySQL Workbench 5.2 RC provides:

  1. Data Modeling
  2. Query (upgrade from MySQL Query Browser)
  3. Admin (upgrade from MySQL Administrator)

If you are a current user of MySQL Query Browser or MySQL Administrator, we look forward to your feedback on all the new capabilities we are delivering in a single unified MySQL Workbench.

View the complete list of changes »

Download now »

Hints & Tips

White Paper: What's New in MySQL Enterprise Spring 2010 Release

MySQL is proud to announce the Spring 2010 Release of the MySQL Enterprise Monitor. This release improves the flexibility, usability and scalability of the MySQL Enterprise Monitor to alleviate common pain points for DBAs and developers, so that you can deploy advanced MySQL features more efficiently to build, maintain and scale your on-line applications.

Read the English Paper » (

Read the German Paper » (

Read the French Paper » (

Read the Italian Paper » (

Read the Japanese 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: InnoDB recovery gets even faster in Plugin 1.1, thanks to native AIO

Michael Izioumtchenko

InnoDB Plugin 1.1 doesn't add any recovery specific improvements on top of what we already have in Plugin 1.0.7. The details on the latter are available in this blog. Yet, when I tried to recover another big recovery dataset I created, I got the following results for total recovery time: Plugin 1.1 recovery is 1.5 times faster.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL Sandbox meets plugins

Giuseppe Maxia

In the past year I have been working more and more with plugins. The InnoDB plugins, the semi-synchronous replication plugins, the Gearman UDFs, the Spider plugins, and every time I found myself doing a long installation process, with inevitable mistakes.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL Performance: Using Performance Schema

Dimitri Kravtchuk

Two weeks ago I was very lucky to meet in Paris Marc Allf (one of developers of MySQL Performance Schema) and get all details about Performance Schema directly from the source.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: How To Set Up WebDAV With MySQL Authentication On Apache2 (Ubuntu 9.10)

Falko Timme

This guide explains how to set up WebDAV with MySQL authentication (using mod_auth_mysql) on Apache2 on an Ubuntu 9.10 server. WebDAV stands for Web-based Distributed Authoring and Versioning and is a set of extensions to the HTTP protocol that allow users to directly edit files on the Apache server so that they do not need to be downloaded/uploaded via FTP.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: A Useful Tool to Centrally Manage Many MySQL Instances

Sheeri Cabral

I have been talking with a group of folks who have been making a product that has lots of free functionality, including the ability to centrally manage many MySQL instances. The administration functions include starting and stopping MySQL, seeing status and system variables, seeing and managing the MySQL config file (/etc/my.cnf), seeing and managing accounts, a small dashboard of overall health graphs, and more.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Replication configuration checklist

Shlomi Noach

This post lists the essential and optional settings for a replication environment.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: The MySQL Track at Kaleidoscope is set!

Sheeri Cabral

The MySQL track at Kaleidoscope in Washington, DC during June 28 - July 1st is set! Here is the schedule, and Lincoln VI is the MySQL track room.

Read the PlanetMySQL BlogPost »

Spotlight: Running MySQL Embedded Server on Windows

White Paper: A Guide to 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, including understanding the MySQL security model, user account, password management, and more.

Read this White Paper »

White Paper: A Visual Guide to Installing MySQL Embedded Server on Windows

The goal of this guide is to make getting started with MySQL Embedded Server on the Windows platform easy for commercial application developers who are new to MySQL and/or are used to using SQL Server. This paper will guide you through the steps and tools needed to get up and running quickly with MySQL Embedded Server on Windows using familiar terms, comparisons, and language.

Read this White Paper » (

White Paper: A Guide to Migrating from Microsoft SQL Server to MySQL Embedded Server

This paper provides insight into what is needed when considering a move from SQL Server to MySQL Embedded Server and presents a number of options that help make the transition easy.

Read this White Paper » (

Live Webinar: Running MySQL Embedded Server Securely on Windows

Thursday, June 10, 2010 - 9:00am PT

In this technical webinar, Jimmy Guerrero and Mike Frank, MySQL Senior Product Managers and Windows experts, will show you how to install and configure MySQL Embedded Server to run securely on Windows.

Register for this Webinar »

On-Demand Webinar: Getting Started Using MySQL Embedded Server with Windows Applications

In this presentation Mike Frank, Sr Product Manager at Oracle, covers the benefits of deploying MySQL Embedded Server with your Windows applications. You will learn the basic "How-Tos" of installation, security and configuration. You'll also learn how to use MySQL Connector/NET and Connector/ODBC, and how to ensure high availability and fault tolerance for MySQL on Windows.

Register for this Webinar »

On-Demand Webinar: Why and How LiveTime Software Provides Microsoft SQL Server to MySQL Migration for its Customers

LiveTime has been providing ITIL Service Management and Help Desk products to global 2000 companies for more than 8 years and has recently witnessed significant interest from customers in migrating from SQL Server to MySQL. In this webinar you will learn why LiveTime decided to offer a free migration service for its customers as well as optimizations and performance characteristics.

Register for this Webinar »


Live Webinar: Scaling Web Services with MySQL Cluster, Part 1: An Alternative to MySQL Server & memcached

Wednesday, June 9, 2010 - 9:00am PT

This webinar will discuss the use cases for MySQL with memcached and for MySQL Cluster, and provide an insight into how MySQL Cluster is enabling users to scale their update-intensive web services.

Register for this Webinar »

MySQL track at Kaleidoscope 2010 (June 27 - July 1, Washington DC)

The Oracle Development Tools Users Group (ODTUG) is holding its annual conference, Kaleidoscope 2010, in Washington, DC, from June 27th to July 1st. By popular demand, there will be a MySQL track organized by the MySQL community filled with technical content. Join us and meet with the MySQL experts!

Learn more »

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 »