MySQL Newsletter September 2010

Articles in this newsletter:


New Product Releases

Hints & Tips



Event: MySQL Sunday at Oracle OpenWorld - Last Chance to Register! (September 19)

MySQL Sunday is a half-day conference with 4 highly technical tracks, covering the latest on MySQL High Availability, Scalability, MySQL Performance Tuning, and more. Don't miss this great opportunity to learn from the MySQL experts and hear the keynotes from Edward Screven, Oracle's Chief Corporate Architect, and Marten Mickos, CEO of Eucalyptus. MySQL Sunday is happening as part of Oracle OpenWorld in San Francisco, one of the largest IT events worldwide.

Learn More »

View the Sessions and Speakers »

Event: MySQL Sessions at DOAG Conference 2010 - Nuremberg, Germany (November 16-18)

The DOAG is the German association of users for Oracle products. In November 16-18, they will hold their annual Oracle Users Conference 2010, which will take place in Nuremberg, Germany. For the first time, this year's conference will also have a dedicated stream of sessions about MySQL.

View the full list of MySQL sessions »

Announcing the MySQL Japanese Newsletter

MySQL Newsletter is now available in Japanese, in addition to the English and German versions. You can subscribe to the Japanese Newsletter by editing newsletter subscriptions in your MySQL account profile.

Edit your MySQL Account (Log-in Required) »

日本語版 MySQL ニュースレターのご案内

毎月1回、日本語の MySQL ニュースレターを配信しています。この日本語版MySQLニュースレターの購読は、MySQLアカウントのプロファイル設定をご変更いただくことで可能になります。下記リンクより MySQL アカウントにログイン後、MySQL アカウントの編集ページ下部にある「サブスクリプション(Subscription)」 個所の 「ニュースレターや通知メールの言語 (Send me the newsletter and/or notifications in)」 項目で、"Japanese" をご指定ください。

MySQLアカウントを変更する »

Quickpoll: What concerns you most about your current MySQL backup solution?

A new quickpoll is posted on the MySQL Developer Zone about your MySQL backup solution.

Take the Quickpoll »

The MySQL Community Team is Hiring!

Our team at Oracle needs to grow in order to better serve the growing MySQL Community, and we are starting by filling the position for MySQL Community Manager in a place with a significantly large MySQL user base: North America.

Learn More »

White Paper: Session Management with MySQL

An inherent characteristic about the web and one of the most common technical issues when designing and maintaining the web infrastructure, is addressing the stateless interaction between the user's browser and the web server from which the pages are requested. In this paper we explore how MySQL and MySQL Cluster can be used as part of a cost-effective, high-performance, open-source solution for database-centric session management.

Read this White Paper »

White Paper: Guide to Optimizing Performance of the MySQL Cluster Database

This guide explores how to tune and optimize the MySQL Cluster database to handle diverse workload requirements. It discusses data access patterns and how to build distribution awareness into applications, exploring schema and query optimization, tuning of parameters and how to get the best out of the latest innovations in hardware design.

Read the English White Paper »

Read the French White Paper »

Case Study: boosts its performance with MySQL Enterprise and the Query Analyzer

Launched in 1998, Promovacances is a brand of the Karavel group, the leading provider of vacation packages online in France. gets about 40 million individual visitors per year and 250,000 per day during the high season.

The MySQL Enterprise Platinum subscription gives Karavel access to 24/7 technical support as well as to the MySQL Enterprise Monitor including the MySQL Query Analyzer.

Read this Case Study »

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.

MySQL Cluster was selected as it met all of the requirements of the service with one, integrated solution out of the box. MySQL Cluster is handling 1 million queries on average per day across both in-memory and disk-based tables, with the database growing at up to 2% daily.

Read this Case Study »

Live Webinar: Getting the Best MySQL Performance in Your Products: Part 2, Beyond the Basics

Wednesday, September 15, 2010 - 9:00am PT

In Part 2 of a three-part performance series, MySQL performance expert Brian Miezejewski will take you beyond the basics and show you the next set of steps to take when architecting your product's MySQL embedded or bundled database for higher performance and customer satisfaction.

In this session, Brian will build on the steps he covered in Part 1, the Fundamentals and will review more advanced topics, including monitoring, data and key caches, sessions, tuning, sorting and other server tuning tips.

Register for this Webinar »

Live Webinar: MySQL Essentials Part 4: How to Develop Simple .NET Applications for MySQL

Thursday, September 30, 2010 - 9:00am PT

In this webinar we will explore the use of MySQL as the underlying database for .NET applications. Using several example programs, we will dive into how to develop a few starter applications for MySQL in C# and ASP.Net using Visual Studio. We will also guide you through the process from installing MySQL Connector/NET, setting up Visual Studio, starting a project, designing, coding and running these simple .NET applications.

Register for this Webinar »

New Product Releases

New Release of MySQL Community Server 5.1.50 (GA)

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

View the complete list of changes »

Download now »

New Release of MySQL Connector/ODBC 5.1.7 (GA)

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

View the complete list of changes »

Download now »

New Release of MySQL Workbench 5.2.27 (GA)

We're proud to announce the next release of MySQL Workbench, version 5.2.27. This is the second maintenance release for 5.2 GA (Generally Available) and focuses on general product improvement and usability. We hope you will make MySQL Workbench your preferred tool for Design, Development, and Administration of your MySQL database applications.

View the complete list of changes »

Download now »

Hints & Tips

CEO Interview: AlSego develops financial applications with MySQL Enterprise

AlSego, based in Luxembourg, builds business intelligence reporting and integration solutions with MySQL Enterprise. Marc Van Oost, the CEO of AlSego, shares how MySQL addresses the flexibility, security and performance challenges of AlSego's financial applications.

Read the Interview »

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 Cluster on Windows

Anders Karlsson

So you thought that just because MySQL Cluster 7.1 is GA on Windows that NDB API was available and you could just download the MySQL Cluster 7.1 binary for Windows and start hacking the NDB API. Nope. But fear not, there is help!

Read the PlanetMySQL BlogPost - Part 1: NDB API »

Read the PlanetMySQL BlogPost - Part 2: Set up a dev environment »

Read the PlanetMySQL BlogPost - Part 3: The Code »

Read the PlanetMySQL BlogPost - Part 4: Finishing it up »

PlanetMySQL Blog: MySQL Master High Availability at Yahoo

Jay Janssen

I was asked to write a blog post about MySQL High Availability at Yahoo, particularly for writes. Our standard practice is not particularly high-tech, but we've been using it for over 4 years now and it has become a company-wide standard with a few exceptions.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Binary Log Group Commit - Recovery

Mats Kindahl

In the previous article, an approach was outlined to handle the binary log group commit. The basic idea is to use the binary log as a ticketing system by reserving space in it for the transactions that are going to be written. This will provide an order on the transactions as well as allowing writing the transactions in parallel to the binary log, thereby boosting performance.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: PHP @ FrOSCon: the power of mysqlnd plugins

Ulf Wendel

Slowly the power of mysqlnd plugins becomes visible. Mysqlnd plugins challenge MySQL Proxy and are often a noteworthy, if not superior, alternative to MySQL Proxy for PHP users.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Improving InnoDB Transaction Reporting

Mark Leith

Everybody knows that parsing the output of SHOW ENGINE INNODB STATUS is hard, especially when you want to track the information historically, or want to aggregate any of the more dynamic sections such as the TRANSACTIONS one.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: No, DRBD doesn't magically make your application crash safe

Florian Haas

It is a common misconception that DRBD (or any block-level data replication) solution can magically make an application crash-safe that intrinsically isn't.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Easy MySQL: how to backup databases to a remote machine

Matt Reid

Here's a simple answer to a simple question. "How do I run a backup of MySQL to another machine without writing to the local server's filesystem?" - this is especially useful if you are running out of space on the local server and cannot write a temporary file to the filesystem during backups.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL Workbench Plugin: Execute Query to Text Output

Alfredo Kojima

In MySQL Workbench 5.2.26 a new query execution command is available, where query output is sent as text to the text Output tab of the SQL Editor. Some MySQL Workbench users liked the "Results to Text" option available in Microsoft SQL Server Management Studio. Cool thing is with a few lines of Python we implemented this command using the SQL Editor scripting API.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Upcoming MySQL Conferences

Ronald Bradford

Unlike previous years when the number of conferences with MySQL content diminishes after the O'Reilly MySQL and OSCON conferences (Open SQL Camp excluded), this year has a lot to offer.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Managing load-balanced Connector/J deployments with MySQL Cluster

Todd Farmer

Connector/J has long provided an effective means to distribute read/write load across multiple MySQL server instances for Cluster or master-master replication deployments, but until version 5.1.13, managing such deployments frequently required a service outage to redeploy a new configuration.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Why GRANT ALL is bad

Ronald Bradford

A common observation for many LAMP stack products is the use of poor MySQL security practices. Even for more established products such as Wordpress don't always assume that the provided documentation does what is best for you.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Tips for taking MySQL backups using LVM

Shlomi Noach

LVM uses copy-on-write to implement snapshots. Whenever you're writing data to some page, LVM copies the original page to the snapshot volume. The snapshot volume must be large enough to accommodate all pages written to for the duration of the snapshot's lifetime. In other words, you must be able to copy the data somewhere outside in less time than it would take for the snapshot to fill up.

Read the PlanetMySQL BlogPost »


Live Webinar: MySQL Cluster: 5 Steps to Getting Started, then 5 More to Scale for the Web

Wednesday, September 8, 2010 - 9:00am PT

This session will demonstrate how to start an evaluation of the MySQL Cluster database in 5 easy steps, and then how to expand your deployment for web and telecoms-scale services.

Register for this Webinar »

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

Wednesday, September 8, 2010 - 15:00 CET

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. There are classes of web services, however, that are 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.

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

Register for this German Webinar »

Live Webinar: Scaling Web Services with MySQL Cluster - Italian

Thursday, September 9, 2010 - 10:00 CET

There are two common choices to power web applications. 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. The MEMORY storage engine has also been widely adopted by MySQL users to provide near-instant responsiveness with use cases such as caching and web session management.

The MySQL Cluster database, which itself can be implemented as a MySQL storage engine, is a viable alternative to address increased web service demands. This webinar will discuss the use-cases for all three approaches, and provide an insight into how MySQL Cluster is enabling users to scale their update-intensive web services.

Register for this Italian Webinar »

Live Webinar: Oracle Outlines Strategy for MySQL - Portuguese

Tuesday, September 14, 2010 - 9:30am Brazil Time

MySQL is the world's most popular open source database software, with over 100 million copies of its software downloaded or distributed throughout its history. Many of the world's largest and fastest-growing organizations use MySQL to save time and money powering their high-volume websites, critical business systems, and packaged software - including industry leaders such as Yahoo, Globo, TRF4, Google, Facebook, Paggo and Banco de Republica.

In this webinar you will learn more about the current and future state of MySQL, now part of the Oracle family of products. We will also cover Oracle's investment in MySQL technology and community, directed toward making MySQL an even better MySQL.

Register for this Portuguese Webinar »

Live Webinar: Getting Started with MySQL on Windows - Japanese

Thursday, September 30, 2010 - 14:00 JST

MySQL has been widely adopted and popular on Windows, with 45,000 downloads per day for Windows packages. Its ease of use allows you to download, configure and start using MySQL very quickly.

In this webinar, you will learn the basic "How-To's" for MySQL installation, security and configuration. We will also show you how to get started using MySQL tools on Windows.

Register for this Japanese 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?

Follow MySQL on Twitter »

Follow MySQL Community on Twitter »