MySQL Newsletter October 2011

Articles in this newsletter:


New Product Releases

Hints & Tips



Oracle OpenWorld: MySQL Presentations Now Available!

It was a busy week for the MySQL community and the MySQL team at Oracle! In the MySQL Track at Oracle OpenWorld last week, a total of 47 technical sessions were delivered, and many of the presentations are now posted. Select "MySQL Track" under "Database" in the drop down menu in the Content Catalog and hit "Search", and you should see the pdf icons.

View the Oracle OpenWorld Content Catalog »

Event: OTN Developer Day: MySQL - Minneapolis, MN

Thursday, November 17, 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.

Register for the OTN Developer Day: MySQL in Minneapolis »

DevZone Article: MySQL Cluster 7.2 (DMR2): NoSQL, Key/Value, Memcached

Mat Keep

MySQL Cluster is one of the fastest growing technologies available from MySQL today. To build on this momentum, we announced the second Development Milestone Release (DMR) at Oracle OpenWorld 2011. As with all MySQL community releases, the DMR is available under the GPL and can be downloaded from the MySQL Developer Zone website.

Read the Article »

Blog: More Early Access Features in the MySQL 5.6.3 Development Milestone!

Rob Young

Demonstrating how Oracle drives MySQL innovation, Tomas Ulin's "State of the Dolphin" keynote at Oracle OpenWorld last week gave a great overview of the new MySQL products that have recently been delivered. Of these announcements I am most excited about the new early access features ready for community evaluation in the MySQL 5.6.3 DMR.

Read this Blog Post »

Blog: New Commercial Extensions for MySQL Enterprise Edition

Rob Young

MySQL 5.5 GA and MySQL 5.6 Development Milestone Releases have delivered many new compelling features to the MySQL users and community for testing, feedback and use.

In addition, commercial customers have access to a number of commercial extensions already included in MySQL Enterprise Edition: MySQL Enterprise Monitor and MySQL Enterprise Backup. Continuing the business model of MySQL, we are adding three new commercial extensions to MySQL Enterprise Edition: MySQL Enterprise Scalability, MySQL Enterprise High Availability and MySQL Enterprise Security.

Read this Blog Post »

Podcast: Meet the MySQL Experts - MySQL on Windows

In September, MySQL Product Manager Alex Roedling interviews Software Development Manager Reggie Burnett about MySQL on Windows. Reggie covers Connector/NET, integration with Visual Studio, MySQL Workbench, the new MySQL installer for Windows, the new external authentication module for Windows, and more...

Listen to the Podcast »

White Paper: MySQL Guide to High Availability Solutions

Databases are the center of today's web and enterprise applications, storing and protecting an organization's most valuable assets and supporting business-critical applications. Just minutes of downtime can result in significant lost revenue and dissatisfied customers. Ensuring database highly availability is therefore a top priority for any organization.

Read this White Paper »

Live Webinar: What's New in MySQL Cluster 7.2.1 Development Milestone Release

Wednesday, October 19, 2011 - 9:00am PT

Join this session to learn about the latest enhancements to the MySQL Cluster database, enabling even more of the latest generation of web, telecoms and embedded applications to take advantage of high write scalability, SQL and NoSQL interfaces and 99.999% availability.

Register for this Webinar »

Live Webinar: MySQL Enterprise Edition: Thread Pool

Thursday, October 20, 2011 - 9:00am PT

MySQL Thread Pool is one of the latest features released in MySQL Enterprise Edition, aiming at providing even better scalability for MySQL applications. Join Mikael Ronstršm, Senior MySQL Architect, and Rob Young, Senior MySQL Product Manager, to learn how MySQL Thread Pool can help you meet the sustained performance and scalability of ever increasing user, query and data loads.

Register for this Webinar »

Live Webinar: MySQL Essentials for ISVs & OEMs: Part III, MySQL Enterprise Monitor for Higher Performance & Lower Costs

Tuesday, October 25, 2011 - 9:00am PT

In Part III of our Essentials series we'll show how you and your customers can monitor, optimize, and troubleshoot your product's MySQL database. MySQL Enterprise Monitor provides a single, consolidated view into the health, security, performance and availability of your products' MySQL database, either remotely or on-site.

Register for this Webinar »

Live Webinar: Building High Performance and High Traffic PHP Applications with MySQL - Part 3: Succeed with Plugins

Wednesday, October 26, 2011 - 9:00am PT

Your PHP application is running nicely using MySQL. But suddenly it becomes more popular than you expected, and you have to find a quick solution to handle the surge of traffic. In the final session of this 3-part Webinar series, we will explain how you can use mysqlnd plugins for PHP to improve your application performance without changing the application code. We will cover an overview of the plugin architecture and introduce a number of useful plugins.

Register for this Webinar »

New Product Releases

New Release of MySQL Community Server 5.6.3 (DMR)

MySQL Server 5.6.3 (Development Milestone Release) is a new version of the world's most popular open source database. MySQL 5.6 builds on MySQL 5.5 and delivers higher performance and scalability by improving Optimizer, InnoDB, Replication and more.

View the Complete List of Changes »

Download Now »

New Release of MySQL Installer 5.5.16 (GA)

MySQL Installer GA has been released. This package includes our first "Generally Available" MySQL Installer. MySQL Installer is the all-in-one installation solution for all your MySQL software needs and 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 »

New Release of MySQL Connector/Net 6.4.4 (GA)

MySQL Connector/Net 6.4.4, a new version of the all-managed .NET driver for MySQL has been released. This is an update to our latest GA release and is intended for full production deployment. Version 6.4.4 is intended for use with MySQL versions from 5.0 to 5.5.

View the Complete List of Changes »

Download Now »

New Release of MySQL Connector/J 5.1.18 (GA)

MySQL Connector/J 5.1.18, 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.18 is suitable for use with any MySQL version including MySQL 5.1 and MySQL 5.5.

View the Complete List of Changes »

Download Now »

New Release of MySQL Workbench 5.2.35 (GA)

The MySQL Developer Tools team is proud to announce the next release of its flagship product, MySQL Workbench, version 5.2.35. MySQL Workbench 5.2.35 now supports the Native Windows Authentication Method - available in the commercial MySQL server product - and the creation of user accounts utilizing this new authentication method. For the PHP developers, Workbench now also comes with a new set of plugins to turn SQL Queries into PHP code to be put right into your scripts.

View the Complete List of Changes »

Download Now »

New Release of MySQL Enterprise Monitor 2.3.7

We are pleased to announce that MySQL Enterprise Monitor 2.3.7 is now available for download on the My Oracle Support (MOS) web site as our latest GA release. This is a maintenance release that fixes a number of bugs and includes the following new features:

  • MySQL Enterprise Monitor Plugins for PHP
  • Support for PAM authentication in MySQL Server 5.5.16
  • New graphs and rules for the Thread Pool plugin

View the Complete List of Changes »

Learn More »

New Release of MySQL Enterprise Backup 3.6.1 (GA)

This maintenance release allows MySQL Enterprise Backup to leverage the new authentication feature of the commercial MySQL 5.5.16 server release. MySQL Enterprise Backup 3.6.1 allows the backup user to be authenticated by an external authentication method supported by the MySQL Server.

View the Complete List of Changes »

Learn More »

Hints & Tips

Blog: New MySQL Enterprise Oracle Certifications and Integration

Bertrand Matthelié

At Oracle OpenWorld, we announced new MySQL Enterprise Certifications and Integration with Oracle Secure Backup and with a number of offerings within the Oracle Fusion Middleware product family. Many Oracle customers use MySQL for their web-based, departmental and embedded applications. The MySQL Enterprise Oracle certifications and integration make it faster and easier for them to deploy and manage MySQL within their existing environment.

Read this Blog Post »

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: Testing MySQL 5.6.3 network performance improvements

Yoshinori Matsunobu

I'm excited to see the new features in MySQL 5.6.3. Replication enhancements such as parallel SQL threads, crash safe slave and binlog checksum have been desired for years. I really appreciate that MySQL development team has released 5.6.3 in a timely manner.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Multi-threaded slave: it's in!

Luis Soares

I am very happy to share with you all that the much awaited feature request - multi-threaded slave (MTS) - has made it to the development tree targeting 5.6 release and is part of this latest 5.6 DMR release (5.6 DMR2).

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: How to implement MySQL Sharding

Liran Zelkha

Database Sharding has proven itself a very successful strategy for scaling relational databases. Almost every large web-site/SaaS solution uses sharding when writing to its relational database.

Read the PlanetMySQL BlogPost - Part 1 »

Read the PlanetMySQL BlogPost - Part 2 »

Read the PlanetMySQL BlogPost - Part 3 »

PlanetMySQL Blog: Change Views DEFINER without ALTER VIEW: how to fix thousands of views!

Rene Cannao

Recently I faced an interesting challenge: modify over 26k views on a single mysqld instance. Altering the view one by one was far from an easy task, so I had to look for an efficient way to do it.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Global Transaction Identifiers Feature Preview

Luis Soares

"Global Transaction Identifiers" is a feature that has been requested every now and then. We have put out there an early access release (based on 5.6 codebase) of our ongoing effort to implement the global transaction identifiers and we would like some early feedback.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Optimizer tracing: Query Execution Plan descriptions beyond EXPLAIN

Jørgen Løland

Understanding why MySQL chooses a particular join order or why table scan is chosen instead of range scan is often very hard even for experienced MySQL users. That's why we're introducing a great new feature in 5.6: Optimizer Tracing. The target users of this feature are developers and MySQL users experienced enough to understand the ins and outs of EXPLAIN.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: InnoDB Memcached with Binlog Capability

Jimmy Yang

In our earlier Labs release, we presented a MySQL NoSQL solution through InnoDB Memcached Daemon Plugin. However, there is one major functionality we did not implement in the first release: the replication (binlog) capability. And this important feature is being done in the latest labs release (mysql-5.6.4-labs-innodb-memcached), in which all memcached commands are now supported for binlogging.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Windows Native Authentication for MySQL

Rafal Somla

Starting with MySQL 5.5.16 it is possible to setup password-less connections from clients into the MySQL server using the Windows SSPI authentication framework.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: The mysqlnd replication plugin 1.1.0 release

Ulf Wendel

PECL/mysqlnd_ms 1.1.0 has been released! It is a drop-in solution to add MySQL replication support to any PHP 5.3+ application using any of the PHP MySQL APIs (mysql, mysqli, PDO_MySQL) when compiled to use the mysqlnd library.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL Query Analyzer and PHP

Johannes Schlüter

In the past two weeks we've released a few things for PHP and MySQL users: One is the first beta of the mysqlnd_ms plugin for MySQL Replication and Load Balancing support, and the first GA version of a PHP plugin for the Query Analyzer of the MySQL Enterprise Monitor.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL Workbench: PHP development helper plugins

Alfredo Kojima

In the new MySQL Workbench 5.2.35, a plugin that will be of interest to PHP developers has been added. The plugin contains a couple of functions that allows you to create PHP code straight out of your current work in the Workbench SQL Editor, ready to be pasted to your PHP program.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: 5 Steps to an Enterprise Backup

Lynn Ferrante

I'd like to focus this blog on using MySQL in the Enterprise and kickoff with a series of posts on "Enterprise Backup" building on the new features in both MySQL Enterprise Backup (MEB) and MySQL Enterprise Monitor (MEM).

Read the PlanetMySQL BlogPost - Part 1: 5 Steps to an Enterprise Backup »

Read the PlanetMySQL BlogPost - Part 2: Monitoring Your MySQL Backup »

PlanetMySQL Blog: Centralized Login Management Comes to MySQL: Introducing PAM and Windows Authentication Support

Georgi Kodinov

You probably remember the world of new possibilities introduced by MySQL 5.5. If you do, you probably would agree that no API is useful by itself. This is why you need authentication plugins that fit the largest possible number of authentication setups.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL Cluster Manager 1.1.2 - creating a Cluster is now trivial

Andrew Morgan

MySQL Cluster Manager 1.1.2 is now available to download and try from Oracle E-Delivery. Something that's new and really cool in the new version is that you can download a version of MCM that actually includes the MySQL Cluster software itself and then you can have MCM automatically define, create and start a single-host cluster deployment for you with just the command "mcmd -bootstrap".

Read the PlanetMySQL BlogPost »


Live Webinar: MySQL Technical Update: New Security, Scalability and High Availability features in MySQL Enterprise Edition - JAPAC

Wednesday, October 19, 2011 - 17:00 Singapore Time

Do you have questions about how to integrate MySQL into your existing security infrastructure? Or how to scale and sustain performance as your user and data loads continue to grow? Or how to ensure your systems are always up, ready to service customers? If you also use Oracle Database, do you wonder what options you have to manage your MySQL databases using existing tools? If you answered yes to any of these questions, this webinar is for you!

Register for this Webinar »

Live Webinar: Unboxing MySQL: First Steps after the Download

Thursday, October 27, 2011 - 9:00am PT

You've downloaded the latest version of MySQL, the world's most popular open-source database. Now what? Join us for this free, one-hour webinar, which guides you through the architecture of MySQL and covers the features, benefits, advantages, and consequences of available options.

Register for this Webinar »

Live Webinar: MySQL Enterprise Edition - External Authentication and Thread Pool - EMEA

October 27 & November 3, 2011

In this webinar we will share how you can deploy MySQL External Authentication, included in MySQL Enterprise Edition, to reduce complexity and improve security. In addition, you will also learn how MySQL Thread Pool can help you meet the sustained performance and scalability of ever increasing user, query and data loads.

Register for the Italian Webinar on October 27 at 10:00 CET »

Register for the German Webinar on November 3 at 15:00 CET »

JAPAC Seminar: High Availability Solutions with Oracle MySQL in the Communications Industry - India

Tuesday, October 18, 2011

Join us for our Latest Product Updates and High Availability Solutions with MySQL to better understand how to achieve highly mission critical clustered deployments providing online scalability, automatic data partitioning and real time performance.

Register for this Seminar »

JAPAC Event: Oracle MySQL Developer Day - Japan

October 26 & 28, 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.

Register for the Oracle MySQL Developer Day in Osaka, Japan on October 26 »

Register for the Oracle MySQL Developer Day in Tokyo, Japan on October 28 »

JAPAC Roadshow: MySQL Solutions Seminars - Australia

Melbourne, Canberra, Sydney, Brisbane

We invite you to join us at two information packed seminars exploring how MySQL solutions can help you to economically scale-out highly available web applications.

  • Seminar #1: MySQL Cluster - Architecting for Real-Time Performance and 99.999% Availability
  • Seminar #2: MySQL Best Practices for Innovating on the Web

Learn More and Register »

EMEA Roadshow: News and Innovations at MySQL - Germany

Düsseldorf, Berlin, Dreieich, München

In this German seminar we'll introduce the new features in the MySQL 5.5 GA release as well as in the upcoming 5.6 release. Also you will get an overview about integration of MySQL into the Oracle environment, including the new Oracle VM Template for MySQL Enterprise Edition.

Learn More and Register »

EMEA Seminar: MySQL - News from Oracle OpenWorld and Beyond - UK

Monday, November 14, 2011

Join us on Monday November 14th in London to learn more about the exciting news we recently shared at Oracle OpenWorld in San Francisco!

Register for this Seminar »

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 »