MySQL Newsletter March 2011

Articles in this newsletter:


New Product Releases

Hints & Tips



Live Webinar: MySQL on Windows Online Forum

Wednesday, March 16, 2011 - 9:00AM PT

Would you like to reduce your database TCO on Microsoft Windows by up to 90% while increasing manageability and flexibility? Did you know that Windows is the #1 MySQL development platform? Join us for the "MySQL on Windows Online Forum" on March 16 and discover how you can win with MySQL on Windows!

Register Now »

Event: Collaborate 11 - Orlando, Florida

April 10-14, 2011

Collaborate 11 is a user-driven technology and applications forum for the Oracle community, presented by three leading users groups - IOUG, OAUG, and Quest. This year, in response to the great interest in MySQL among its members, the IOUG creates a special "conference within a conference" on MySQL and features over 50 sessions with topics from technical tips to best practices. You can also meet with the MySQL experts from Oracle at the demo grounds and get all your questions answered!

Learn More about the MySQL sessions at Collaborate 11 »

Register Now »

Event: MySQL Community Reception - Santa Clara, California

April 13, 2011 - 6:00PM PT

Join the MySQL Team on April 13, 2011, as we celebrate the health and growth of the MySQL community. Whether you are an attendee at O'Reilly MySQL Conference, a member of local MySQL user groups, a MySQL user in the Bay Area, or simply interested in the MySQL technology, you're all invited to Oracle's MySQL Community Reception. If you're at the MySQL Conference, don't miss Tomas Ulin's "State of the Dolphin" keynote, as he summarizes MySQL's first year under Oracle's stewardship, discusses the current and ongoing engagement with the MySQL user community, and offers insights into future roadmaps of the MySQL products.

RSVP for the MySQL Community Reception »

Learn More about the "State of the Dolphin" Keynote »

DevZone Interview: When the IOUG Meets the MySQL Community

In light with the formation of the MySQL Council under the IOUG (Independent Oracle User Group) and two upcoming conferences with a lot of MySQL content - Collaborate 11 and O'Reilly MySQL Conference, we talked to Andy Flower, President of IOUG, Sarah Novotny, recognized MySQL community member and the Council Chair, as well as Lenz Grimmer and Dave Stokes, MySQL community managers at Oracle, on their thoughts and takes of the IOUG and the MySQL community.

Read the Interview »

White Paper: MySQL Enterprise Backup - Fast, Consistent, Online Backups

MySQL Enterprise Backup provides a high-performance, online "hot" backup solution with data compression technology to ensure your data is protected in case of downtime or an outage.

This white paper explores numerous backup methods to help you formulate your backup strategy. We also compare the advantages and disadvantages of these backup methods including mysqldump, LVM snapshots and MySQL Enterprise Backup. Backup and restore performance benchmarks, as well as illustrated examples of how MySQL Enterprise Backup works are provided.

Read the White Paper »

Live Webinar: MySQL Cluster 7.1, Latest Updates and Enhancements

Thursday, March 24, 2011 - 9:00AM PT

MySQL Cluster is a leading real-time, write-scalable transactional database, combining high availability with the low TCO of open source. Join the live Webinar as we discuss the design concepts and most recent developments in MySQL Cluster.

Register for this Webinar »

Live Webinar: For MySQL ISVs/OEMs: Improve Product Performance, Lower Customer Support Costs

Tuesday, March 29, 2011 - 9:00AM PT

MySQL Enterprise Monitor with best practice Advisors and the MySQL Query Analyzer are now available to OEMs in MySQL Enterprise Edition. MySQL OEMs can use MySQL Enterprise Monitor to provide higher levels of support to their customers, reduce support costs, and gain additional revenue.

Register for this Webinar »

New Product Releases

New Release of MySQL Community Server 5.5.9 (GA)

MySQL 5.5.9 is a new release of the 5.5 production version of the world's most popular open source database. MySQL 5.5 includes several high-impact changes to address scalability and performance issues in MySQL Server. These changes exploit advances in hardware and CPU design and enable better utilization of existing hardware.

View the Complete List of Changes »

Download Now »

New Release of MySQL Community Server 5.1.56 (GA)

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

View the Complete List of Changes »

Download Now »

New Release of MySQL Cluster 7.1.10 (GA)

The latest binary of MySQL Cluster 7.1.10 has been released.

View the Complete List of Changes »

Download Now »

New Release of MySQL Workbench 5.2.32 (GA)

We're proud to announce the next release of MySQL Workbench, version 5.2.32. This is a maintenance release featuring a new and improved UI appearance and other enhancements.

View the Complete List of Changes »

Download Now »

New Release of MySQL Connector/J 5.1.15 (GA)

MySQL Connector/J 5.1.15, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL and version 5.1.15 is suitable for use with any MySQL version including MySQL 5.1 or MySQL 5.5.

View the Complete List of Changes »

Download Now »

New Release of MySQL Connector/ODBC 3.51.28 (GA)

MySQL Connector/ODBC 3.51.28, a new version of the ODBC driver for the MySQL database management system, has been released. This release is the latest release of the 3.51 series and is suitable for use with any MySQL version since 4.1.

View the Complete List of Changes »

Download Now »

Hints & Tips

White Paper: MySQL Cluster for Presence & Location-Based Services

This whitepaper explores the different types of services that can take advantage of location and presence awareness, and considers their unique requirements for data management. A solution is then presented, based on MySQL Cluster, that allows operators to fully leverage the market opportunity and differentiation presented by these new services.

Read this White Paper »

White Paper: MySQL Replication - Enhancing Scalability and Availability with MySQL 5.5

This white paper introduces the concepts behind replication and what can be achieved with MySQL Replication. It steps through setting up replication as well as handling failover. In addition, the changes introduced to replication in MySQL 5.5 are covered as well as the differences when replicating with MySQL Cluster.

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: Simple lessons in improving scalability

Ronald Bradford

It can be very easy to improve scalability with a MySQL server by a few simple rules. Here is one of them -- "the most efficient way to improve an SQL statement is to eliminate it".

Read the PlanetMySQL BlogPost - Part 1 »

Read the PlanetMySQL BlogPost - Part 2 »

PlanetMySQL Blog: Upgrading passwords from old_passwords to "new passwords"

Shlomi Noach

You have old_passwords=1 in your my.cnf. I'm guessing this is because you used one of the my-small.cnf, my-large.cnf etc. templates provided with your MySQL distribution.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Web and Telco mode Cluster Configuration

Johan Andersson

The Core Scripts (aka Configurator) for MySQL Cluster has now been updated with a new feature that allows you to tune cluster for a particular workload. Currently there are two types of workloads supported: Web and Telco/Realtime.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Checkpoint handling enhancements in Cluster 7.1 -or- *Ding Dong* GCP Stop is dead!

Matthew Montgomery

One of the tasks that a data node must perform reliably is the Global Check Point. That is, to flush the transaction redo log to disk. The GCP completion must be synchronized on all data nodes in order to maintain a consistent end point for recovery.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: OurSQL Episode 34: Collaborating

Sheeri Cabral and Sarah Novotny

In this episode, we talk about the Collaborate conference, including comparisons to the O'Reilly MySQL conference.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: PHP: Application calling plugin - on communication

Ulf Wendel

Imagine PECL/mysqlnd_ms could keep certain reads on certain slaves in a MySQL master-slave setup. You would have a good chance to profit from hot database caches. You would not only distribute read load, scale out horizontally by using MySQL replication, you would also optimize your reads for hot caches.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL Semi-Synchronous Replication. See the Magic. Try the Magic.

Ronen Baram

MySQL Replication is one of the most used and valued features of the MySQL Server. Unlike some other products on the market, it's out-of-the-box, easy to configure, non-paid and smart features. Most of our medium/large/super-large installation base are using replication to achieve "scale-out" scaling.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: PHP: want transparent master slave load balancing in mysqlnd?

Ulf Wendel

Are you interested in a master slave load balancing plugin for mysqlnd? It could have two operational modes. The automatic mode would operate transparent from an applications point of view. The manual mode would give you full control over all decisions. Automatic mode is for install and forget when you start with MySQL replication. Manual mode is for growing as your application evolves.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Video: MySQL 5.5 Overview by Bill Papp

Sheeri Cabral

At the February 2011 Boston MySQL User Group Meeting, Bill Papp of Oracle shared a presentation about what's new in MySQL 5.5. The video is already up on YouTube and is also embedded at the end of this post.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: VIEWS on INFORMATION_SCHEMA tables - Useful stuff

Anders Karlsson

Views in MySQL really has quite a bad reputation, for bad performance mainly, but also there were some stability issues at some point. Now they are pretty stable, but I don't see them used that much. One place where I like to use them myself is in combination with INFORMATION_SCHEMA tables. The I_S tables are really useful and contain a lot of information, and by using VIEWs we can massage the data a bit.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: How to detect if a MySQL server is an active replication slave

Giuseppe Maxia

Sometimes you know for sure. And sometimes you wonder: is this server part of a replication system? And, most specifically, is it an active slave? The completeness of the answer depends on how much visibility you have on the server.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Using SQL to create SQL (and other usefulness)

Sarah Novotny

Today, I had a task of modifying a slave to exclude (or if you want to say specifically include) tables. The situation is that this slave needs to only contain tables used for reporting. The added benefit is that with fewer tables to replicate, there will be less replication traffic, less disk I/O and less disk space used hence better performance for queries that digest statistical data.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL Enterprise Backup 3.5, the crash course

Ronen Baram

Everyone loves hands-on tutorials with code snippets and stuff to establish the knowledge that something can be done. So here is my first one: MySQL Enterprise Backup 3.5, the new and shiny backup solution for MySQL.

Read the PlanetMySQL BlogPost »


Live Webinar: MySQL Reference Architectures for Scalable Web Infrastructure - EMEA

In this webinar, we present a series of Reference Architectures for small, medium and large Web properties. You will learn about the components common to most web properties including Session Management, Authentication, eCommerce and Content Management.

Register for the Germany Webinar on March 15 at 10:00 CET »

Register for the Italian Webinar on March 16 at 15:00 CET »

Live Webinar: MySQL Enterprise Backup - Online "Hot" Backup for MySQL - Portuguese

Tuesday, March 22, 2011 - 16:00 Sao Paulo Time

In this webinar we will go into the advantages of Hot "Online" backups. We will show how MySQL Enterprise Backup supports full, incremental, partial, and compressed backups that allow you to perform consistent Point-in-Time Recovery, as well as saving both time and money.

Register for the Portuguese Webinar »

Live Webinar: MySQL 5.5 - What's New in Performance, Scalability and High Availability - Spanish

Wednesday, March 23, 2011 - 17:00 Mexico City Time

MySQL, the world's most popular open source database, presents its latest release, MySQL 5.5. Join the Webinar and learn the details about improvements in performance, scalability and high availability, as a result of Oracle's investment in MySQL's community, developers and customers.

Register for the Spanish Webinar »

On-Demand Webinar: MySQL Reference Architectures for Highly Scalable Web Infrastructure

In this webinar, we present a series of Reference Architectures for small, medium and large Web properties. You will learn about the components common to most web properties including Session Management, Authentication, eCommerce and Content Management.

Register for this On-Demand Webinar »

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?

Read Oracle's MySQL Blog »

Join MySQL on Facebook »

Follow MySQL on Twitter »