MySQL Newsletter August 2011

Articles in this newsletter:


New Product Releases

Hints & Tips



DevZone Article: MySQL 5.6 Early Access Features - InnoDB and Replication!

Rob Young

MySQL 5.5 has been widely acknowledged to be the best release in the history of MySQL. And, in April 2011, we raised the bar again with Development Milestone Release (DMR) and Early Access features of MySQL 5.6. At OSCON 2011, we are delivering more early access features for InnoDB and Replication. These features are focused on better scalability, performance and flexibility. We look forward to community testing and feedback.

Read this Article »

Event: Oracle Showcases MySQL at Innovation Nation & GOSCON 2011 - Washington, DC

Tuesday, August 23, 2011

GOSCON, the Government Open Source Conference, and Innovation Nation Forum are co-located this year and will provide a special one-day program featuring cloud, data center consolidation, cyber security, and open source. The MySQL team will showcase the latest product developments and demos running on a Sun Ray at the Exhibition Hall, and we look forward to meeting you there!

Learn More about GOSCON/Innovation Nation »

Learn More about Sun Ray »

Event: OTN Developer Day: MySQL - Washington, DC

Wednesday, August 24, 2011

The MySQL Developer Day is a one-stop shop for you to learn all the essential MySQL skills. In this free, one-day seminar, we will cover everything you need to know to successfully design, develop, and manage your MySQL databases. You'll also learn the guidelines and best practices in performance tuning and scalability. Space is limited so RSVP now!

Register Now »

Event: MySQL Community Reception at Oracle OpenWorld - San Francisco, CA

Tuesday, October 4, 2011

Come celebrate the growth of the MySQL community with Oracle's MySQL team! Whether you are attending the MySQL Track at Oracle OpenWorld, a member of local MySQL user groups, a MySQL user in the San Francisco Bay Area, or simply interested in MySQL technology, you're all invited to Oracle's MySQL Community Reception. Don't forget to register for Oracle OpenWorld and enjoy 40+ MySQL sessions!

RSVP Now for the MySQL Community Reception »

View the MySQL Sessions at Oracle OpenWorld via Content Catalog »

Register for Oracle OpenWorld »

Blog: MySQL 5.6 Feedback

Keith Larson

The MySQL Community Team would like your feedback about MySQL 5.6! What are you excited to see and test? What have you tested and benchmarked? Did you previously see the advantages of going to MySQL 5.5 and now eager to try 5.6?

Read this Blog Post »

Demo: MySQL Enterprise Edition

In only 3 minutes, this demo helps you understand how Oracle's MySQL Enterprise Edition reduces the risk, cost and time required in developing, deploying and managing business-critical MySQL applications.

Watch the Demo »

Live Webinar: What's New in MySQL 5.6 - Part 1: Overview

Thursday, August 18, 2011 - 9:00AM PT

MySQL 5.6 builds on Oracle's investment in MySQL by adding improvements to Performance, InnoDB, Replication, Instrumentation and flexibility with NoSQL (Not Only SQL) access. In the first session of this 5-part Webinar series, we'll cover the highlights of those enhancements to help you begin the development and testing efforts around the new features and improvements that are now available in the latest MySQL 5.6 Development Milestone Release and Early Access Features.

Register for this Webinar »

Live Webinar: MySQL Essentials for ISVs & OEMs, Part 1: Faster Development and Better Applications with MySQL Workbench

Tuesday, August 23, 2011 - 9:00AM PT

MySQL Workbench is a visual database modeling and design tool, a SQL editor, and an administrative tool. MySQL Workbench can help you create and validate your schema for your new MySQL databases, optimize existing physical MySQL databases with reverse/forward engineering and change management functions, resulting in faster development and time-to-market, better product quality and performance, and easier as-needed administration.

Register for this Webinar »

New Product Releases

New Release of MySQL Community Server 5.5.15 (GA)

MySQL 5.5.15 is a new version of the 5.5 production release of the world's most popular open source database. MySQL 5.5.15 is recommended for use on production systems.

MySQL 5.5 includes several high-impact enhancements to improve the performance and scalability of the MySQL Database, taking advantage of the latest multi-CPU and multi-core hardware and operating systems. In addition, with release 5.5, InnoDB is now the default storage engine for the MySQL Database, delivering ACID transactions, referential integrity and crash recovery by default.

View the Complete List of Changes »

Download Now »

New Release of MySQL Installer (GA)

MySQL Installer 5.5.15 GA has been released.

MySQL Installer is the all-in-one installation solution for all your MySQL software needs. It comes with the latest MySQL Server and related components (MySQL Workbench, Connectors, and documentation) and includes wizards to help with the installation and configuration.

Learn More »

Download Now »

Hints & Tips

Developer Interview: Globalizing MySQL - Interview with Alexander "Bar" Barkov

We interviewed Alexander "Bar" Barkov to discuss the recent improvements in MySQL globalization that enable MySQL users around the world to use the database system more easily and naturally.

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: InnoDB Full-Text Search Tutorial

John Russell

The InnoDB full-text search capability is an exciting feature. The full-text search itself is generally useful to have in an RDBMS. If an application is using all InnoDB tables except for one that is used for full-text searches, now that last table can be switched to InnoDB. If putting the full-text data in a MyISAM table led to scalability problems, duplication, or a less-than-ideal schema design, now those issues can be addressed.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Difference between InnoDB FTS and MyISAM FTS

Jimmy Yang

With the latest MySQL 5.6 feature preview, InnoDB now has its own Fulltext Search (FTS) support. People might wonder how different is this FTS comparing with that of MyISAM. From the usage standpoint, they seem very similar with no apparent difference. However, in the underlying FTS engine, the difference is huge, since two are built on different storage engines with totally different design.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Binlog Group Commit Experiments

Mats Kindahl

It was a while ago since I talked about binary log group commit. Since then, Kristian has released a version of binary log group commit that seems to work well. However, for a few reasons that will be outlined below, we decided to do experiments ourselves using the approach that I have described earlier.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: About InnoDB: Shortened warm-up times with a preloaded InnoDB buffer pool

Simon Mudd

This comment is in regard to this InnoDB blog post. The page talks about a new feature which allows you to save on shutdown an InnoDB buffer pool and to load this on startup, ensuring that once loaded the database will perform with this "hot" cache. That sounds interesting as I have seen on numerous occasions that if the buffer pool is not warm then the performance can be a magnitude worse.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL 5.6 Replication - New Early Access Features

Mat Keep

At OSCON 2011, Oracle delivered more early access features for MySQL 5.6 replication. These features are focused on better integration, performance and data integrity, built on the significant replication enhancements announced as part of the MySQL 5.6.2 Development Milestone Release back in April.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: How to Easily See Who's Connected to Your MySQL Server

Shlomo Priymak

If you have servers which have multiple application servers connected to them, you often need to see things like who's connected, how many connections they have, and which users.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Inserting Data into MySQL with Perl

Tony Darnell

In the two previous posts, we looked at simply connecting to a MySQL database via Python and Perl. In this post, we will use an insert statement to input data into a MySQL table via Perl, and use a select statement to view the same data to confirm our results.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Scaling Web Databases, Part 3: SQL & NoSQL Data Access

Mat Keep

Supporting successful services on the web means scaling your back-end databases across multiple dimensions. This blog focuses on scaling access methods to your data using SQL and/or NoSQL interfaces.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Improvements for PHP application portability in

Johannes Schlüter

I was writing about before, and many things have improved there meanwhile. Most notably we have a committed version number: the next PHP release will be called PHP 5.4. The topic I want to talk about today is "Improved application portability" which covers multiple small changes which aim at making it simpler for developers to write applications working on any PHP setup.

Read the PlanetMySQL BlogPost »


Seminar: Oracle Enterprise-Ready Open Source Software Seminar - Hong Kong & Beijing

Join us at this executive seminar where you will learn how Oracle can offer you a Complete Open Source Technology Stack. Oracle continues its long track record of contributions to the open source community and we are pleased to share its latest technology on Oracle Linux, MySQL, and Oracle VM.

Register for the Seminar in Hong Kong on August 18 »

Register for the Chinese Seminar in Beijing, China on August 30 »

Live Webinar: MySQL Cluster: Scaling Web Databases with Auto-Partitioning and SQL/NoSQL Access - APAC

Friday, August 26, 2011 - 13:00 Singapore Time

MySQL Cluster has been deployed to support some of the most demanding transactional services in the web and telecoms domains. This webinar will discuss best practices in scaling services on-demand for high volumes of reads and writes, and provide insight on the range of NoSQL and SQL access methods available to developers.

Register for this Webinar »

Live Webinar: Building High Performance and High Traffic PHP Applications with MySQL - The Fundamentals - French

Tuesday, August 30, 2011 - 10:00 CET

In this webinar we will walk through the fundamentals of creating dynamic web content using MySQL and PHP. We will also discuss many of the building blocks and key considerations when you architect your PHP applications, including the frameworks, APIs, security features, and asynchronous queries.

Register for this French Webinar »

Seminar: High Availability Solutions for MySQL - Paris, France

Wednesday, September 7, 2011

During this free French seminar, we will review various options and technologies at your disposal to implement highly available and highly scalable MySQL infrastructures, as well as best practices in terms of architectures.

Register for this French Seminar »

Live Webinar: MySQL Replication Essentials - German

Thursday, September 29, 2011 - 15:00 CET

In this webinar we'll share the technical and business reasons for deploying MySQL Replication and give an overview of how to deploy a master/slave configuration. You'll learn the fundamentals on how to install, configure, and manage a replicated environment.

Register for this German 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 »

Want to evaluate the advanced capabilities in the MySQL Enterprise Edition?

Try Now with MySQL Enterprise Edition Trial »