Database News: MySQL Newsletter: May 2011

MySQL Newsletter
May 2011

Articles in this newsletter:

Highlights

- DevZone Article: MySQL 5.5: Pluggable Authentication API: Interview with Georgi "Joro" Kodinov
- Seminar: Scalability and High Availability with MySQL - EMEA
- Live Webinar: MySQL Essentials Part 9: Essentials to Securing MySQL (May 25)
- Live Webinar: MySQL Cluster: Scaling Web Databases with Auto-Partitioning and SQL/NoSQL (May 26)

New Product Releases

- New Release of MySQL Community Server 5.5.12 (GA)
- New Release of MySQL Community Server 5.1.57 (GA)
- New Release of MySQL Connector/Net 6.4.0 (Alpha)

Hints & Tips

- White Paper: What's New in MySQL 5.5
- White Paper: MySQL Replication - Enhancing Scalability and Availability with MySQL 5.5
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: Partitioning the WordPress Comments Table
- PlanetMySQL Blog: Benchmark MySQL 5.5.9 on Oracle Sun X7140 M2
- PlanetMySQL Blog: MySQL Development Milestone 5.6.2: Taking MySQL Replication to the Next Level
- PlanetMySQL Blog: Using MySQL 5.6 to find queries creating disk temporary tables
- PlanetMySQL Blog: InnoDB Persistent Statistics Save the Day
- PlanetMySQL Blog: Feature Preview: The Multi-Threaded Slave
- PlanetMySQL Blog: Crash-Safe Slaves
- PlanetMySQL Blog: Memcached Server for MySQL Cluster ... When to Cache
- PlanetMySQL Blog: MySQL Cluster Benchmark
- PlanetMySQL Blog: MySQL Performance: 5.6.2 and Performance Schema
- PlanetMySQL Blog: EVENTs - The hidden MySQL 5.1+ feature
- PlanetMySQL Blog: Replication and load balancing mysqlnd plugin for all PHP MySQL extensions released

Events

- Live Webinar: Delivering Scalable and Highly Available Session Management with MySQL Cluster (May 31)
- On-Demand Webinar: MySQL Essentials Part 8: MySQL Server and SQL Performance Tuning
- On-Demand Webinar: MySQL Enterprise Hot Backup for Your Products

-------------------------------------------------------------------

Highlights

Developer Interview: MySQL 5.5: Pluggable Authentication API: Interview with Georgi "Joro" Kodinov
Alex Roedling

In this interview, Georgi "Joro" Kodinov shared the latest enhancements around the Pluggable Authentication API and its benefits.

Read the Interview:
http://dev.mysql.com/tech-resources/interviews/georgi-kodinov.html

Seminar: Scalability and High Availability with MySQL - EMEA

In this seminar we will explain enhanced features and performance improvements introduced in MySQL 5.5 with benchmark data. We will also cover the new features you can expect in the upcoming MySQL 5.6 release.

Register for the German Seminar in Zürich, Switzerland on May 25:
http://www.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=132772&src=7011252&src=7011252&Act=210

Register for the English Seminar in Cambridge, UK on June 10:
http://www.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=134211&src=7314534&src=7314534&Act=4

Live Webinar: MySQL Essentials Part 9: Essentials to Securing MySQL
Wednesday, May 25, 2011 - 9:00am PT

In Part 9 of the MySQL Essentials webinar series, you'll learn how to secure your MySQL deployments. Craig Sylvester, Principal Systems Consultant for MySQL, will explore general security issues and present common practices to help you make your MySQL installation more secure against attacks or misuse. Join us for this technical webinar to learn the configurations, setup and tools recommended by the MySQL expert to better secure your MySQL databases!

Live Webinar: MySQL Cluster: Scaling Web Databases with Auto-Partitioning and SQL/NoSQL
Thursday, May 26, 2011 - 9:00am PT

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, specifically covering automatic partitioning (sharding) for high scalability, on-line scaling of the cluster across commodity hardware, as well as SQL and NoSQL interfaces.

-------------------------------------------------------------------

New Product Releases

New Release of MySQL Community Server 5.5.12 (GA)

MySQL 5.5.12 is a new version of the 5.5 production release of the world's most popular open source database. MySQL 5.5.12 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 MySQL 5.5, InnoDB is now the default storage engine, delivering ACID transactions, referential integrity and crash recovery by default.

View the Complete List of Changes:
http://dev.mysql.com/doc/refman/5.5/en/news-5-5-12.html

Download Now:
http://dev.mysql.com/downloads/mysql/

New Release of MySQL Community Server 5.1.57 (GA)

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

View the Complete List of Changes:
http://dev.mysql.com/doc/refman/5.1/en/news-5-1-57.html

Download Now:
http://dev.mysql.com/downloads/mysql/5.1.html

New Release of MySQL Connector/Net 6.4.0 (Alpha)

MySQL Connector/Net 6.4.0, a new version of the all-managed .NET driver for MySQL has been released. This release is of Alpha quality and is intended for testing and exposure to new features. Version 6.4.0 is intended for use with MySQL versions from 5.0 to 5.5.

Read the Documentation:
http://dev.mysql.com/doc/refman/5.5/en/connector-net.html

Download Now:
http://dev.mysql.com/downloads/connector/net/6.4.html

-------------------------------------------------------------------

Hints & Tips

White Paper: What's New in MySQL 5.5

This white paper provides a look at what's new in MySQL 5.5, including greatly improved performance, scalability, and usability specifically on today's modern, multi-processing hardware, software, and middleware architectures. Sysbench benchmarks demonstrate performance improvements of up to 370% and 540% faster performance on Linux and Windows respectively. Also, new Semi-synchronous Replications and MySQL Performance Schema provide developers and DBAs with improved tools for building high performance, scalable applications.

Read this White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql-wp-whatsnew-mysql-55.php

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

MySQL Replication has been widely deployed by some of the leading properties on the web and in the enterprise to deliver extreme levels of database scalability. It provides a simple mechanism for users to rapidly create multiple replicas of their database to elastically scale-out beyond the capacity constraints of a single instance, enabling them to serve rapidly growing database workloads.

Read this White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql-wp-replication.php

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:
http://planet.mysql.com/

Submit Your Blog Feed:
http://planet.mysql.com/new

PlanetMySQL Blog: Partitioning the WordPress Comments Table
Gary Pendergast

WordPress sites can get big. Really big. When you're looking at a site of Cheezburger, Engadget or Techcrunch properties, you get hundreds of comments per post, on dozens of posts per day, which adds up to millions of comments per year.

Read the PlanetMySQL BlogPost:
http://pento.net/2011/04/28/partitioning-the-wordpress-comments-table/

PlanetMySQL Blog: Benchmark MySQL 5.5.9 on Oracle Sun X7140 M2
Ivan Tu

My colleagues from the Oracle System Practice are very interested in MySQL performance on Oracle Sun x86 servers, so with the help from our VAD partner, we got a Sun X7140 M2 installed in our data center. Thanks for the endeavor form my colleague Cano Lai, the server was setup and ready for testing very soon.

Read the PlanetMySQL BlogPost:
http://voicefromoldsoul.blogspot.com/2011/05/benchmark-mysql-559-on-oracle-sun-x7140.html

PlanetMySQL Blog: MySQL Development Milestone 5.6.2: Taking MySQL Replication to the Next Level
Mat Keep

A number of significant replication enhancements were released as part of the MySQL 5.5 GA just a few months ago. We are always listening to our customers and the community. And, based on their input, the MySQL engineering team has continued to rapidly evolve replication functionality - enabling new classes of applications to rely on MySQL for their fastest growing and most dynamic web services.

Read the PlanetMySQL BlogPost:
http://blogs.oracle.com/mysql/2011/04/mysql_development_milestone_562_taking_mysql_replication_to_the_next_level.html

PlanetMySQL Blog: Using MySQL 5.6 to find queries creating disk temporary tables
Alexander Rubin

In MySQL 5.6, we can use new performance_schema table events_statements_history or events_statements_history_long to find all performance metrics for all queries including created disk/memory tables, use of index, etc. WOW! This is what I have been waiting for a long time!

Read the PlanetMySQL BlogPost:
http://www.arubin.org/blog/2011/05/01/using-mysql-5-6-to-find-queries-creating-disk-temporary-tables/

PlanetMySQL Blog: InnoDB Persistent Statistics Save the Day
Øystein Grøvlen

In my previous blog posting, I explained how I was able to get more stable query execution times by increasing the amount of sampling used to by InnoDB to calculate statistics. However, for my example query, Query 8 of the DBT-3 benchmark, the MySQL Optimizer still toggled between three different indexes to use when accessing one of the 8 tables.

Read the PlanetMySQL BlogPost:
http://oysteing.blogspot.com/2011/05/innodb-persistent-statistics-save-day.html

PlanetMySQL Blog: Feature Preview: The Multi-Threaded Slave
Luis Soares

The MySQL replication team has come up with a feature that looks very promising for improving slave scalability.

Read the PlanetMySQL BlogPost:
http://d2-systems.blogspot.com/2011/04/mysql-56x-feature-preview-multi.html

PlanetMySQL Blog: Crash-Safe Slaves
Mats Kindahl

A common request is to have replication crash-safe in the sense that the replication progress information always is in sync with what has actually been applied to the database, even in the event of a crash. Although transactions are not lost if the server crashes, it could require some tweaking to bring the slaves up again.

Read the PlanetMySQL BlogPost:
http://mysqlmusings.blogspot.com/2011/04/crash-safe-replication.html

PlanetMySQL Blog: Memcached Server for MySQL Cluster ... When to Cache
John David Duncan

I had a great time introducing the new memcached API for MySQL Cluster in April. There is an interesting question about how you might use the new API: should you turn the cache off, so that the memcached server is just an easy-to-use, high performance NoSQL gateway to the data stored in the cluster? Or should you enable caching in memcached? The memcached server - actually the NDB engine plugin in the server - allows either. In fact you can tune this on the basis of a key prefix, so that some keys are cached and others are not. But how would you make the choice?

Read the PlanetMySQL BlogPost:
http://mysqlblog.lenoxway.net/index.php/archives/15-NDB-Memcache-when-to-cache.html

PlanetMySQL Blog: MySQL Cluster Benchmark
Mikael Ronstrom

We had the opportunity to use a fair amount of machines to run a benchmark to see what throughput MySQL Cluster can achieve on a bit bigger clusters. The benchmark we use is a benchmark we developed for internal testing many years ago and shows very well the performance aspects of MySQL Cluster.

Read the PlanetMySQL BlogPost:
http://mikaelronstrom.blogspot.com/2011/04/mysql-cluster-benchmark.html

Read the Result - MySQL Cluster doing 6.82M reads per second:
http://mikaelronstrom.blogspot.com/2011/04/mysql-cluster-doing-682m-reads-per.html

Read the Result - MySQL Cluster running 2.46M updates per second:
http://mikaelronstrom.blogspot.com/2011/04/mysql-cluster-running-246m-updates-per.html

PlanetMySQL Blog: MySQL Performance: 5.6.2 and Performance Schema
Dimitri Kravtchuk

Last year I've published a post about Performance Schema overhead which involved many e-mail discussions and finally resulted in a massive code improvements in MySQL Performance Schema (P_S) released by Marc Alff. Marc made an enormous work to redesign P_S code and made P_S overhead "manageable" by user.

Read the PlanetMySQL BlogPost:
http://dimitrik.free.fr/blog/archives/04-01-2011_04-30-2011.html#130

PlanetMySQL Blog: EVENTs - The hidden MySQL 5.1+ feature
Anders Karlsson

MySQL 5.1 and up has EVENTs, but this features seems to be little used. I started using them some time ago, and once I was using them, I found them more and more useful.

Read the PlanetMySQL BlogPost:
http://karlssonondatabases.blogspot.com/2011/04/events-hidden-mysql-51-features.html

PlanetMySQL Blog: Replication and load balancing mysqlnd plugin for all PHP MySQL extensions released
Ulf Wendel

Replication is as old as life on earth. No life without replication. MySQL replication is as old as MySQL, almost. No MySQL without replication. The PECL/mysqlnd_ms 1.0.0 alpha release is brand new. My dream: no PHP without the mysqlnd library replication and load balancing plugin, which works with all the PHP MySQL extensions (mysql, mysqli, PDO_MySQL)!

Read the PlanetMySQL BlogPost:
http://blog.ulf-wendel.de/?p=307

-------------------------------------------------------------------

Events

Live Webinar: Delivering Scalable and Highly Available Session Management with MySQL Cluster
Tuesday, May 31, 2011 - 9:00am PT

As organizations seek to enhance their users' web experience through personalization based on historic browsing and buying behaviors, session data is becoming more critical. Larger volumes of session data need to be managed and persisted in real-time, and so session management has become increasingly performance-intensive, while also demanding very high levels of availability to ensure a seamless customer experience. In these scenarios, it makes sense to evaluate the MySQL Cluster database. This is a practical session and we will demonstrate how to manage PHP session data with MySQL Cluster.

On-Demand Webinar: MySQL Essentials Part 8: MySQL Server and SQL Performance Tuning

In this webinar, you'll gain tips and tricks to optimally architect your database for highest performance. You'll learn from the MySQL performance pros what they do, step by step, to design and optimize a database server for maximal performance and scalability. We will discuss the main performance optimization possibilities and practices, including index selection and tuning, SQL code techniques, schema optimization, and more.

On-Demand Webinar: MySQL Enterprise Hot Backup for Your Products

Online backup has consistently been one of the most requested features for MySQL by ISVs and OEMs. With MySQL Enterprise Backup, your developers and customers now have tools to safely and rapidly backup and restore MySQL Embedded database without interrupting your application. In this technical webinar we will review and compare MySQL Enterprise Backup's full, incremental, partial, and compressed backups that allow you to perform consistent Point-in-Time Recovery.

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:
http://dev.mysql.com/news-and-events/web-seminars/index.html

-------------------------------------------------------------------

Want to receive the latest MySQL updates and interact with the MySQL Community?

Read Oracle's MySQL Blog:
http://blogs.oracle.com/mysql/

Join MySQL on Facebook:
http://www.facebook.com/mysql

Follow MySQL on Twitter:
http://twitter.com/mysql

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

Try Now with MySQL Enterprise Edition Trial:
http://www.mysql.com/trials/

-------------------------------------------------------------------

About the Newsletter

You can send us queries and give us feedback online.
http://dev.mysql.com/contact/?topic=newsletter

You can unsubscribe from this newsletter online:
http://dev.mysql.com/unsub?email=johandontmessup@gmail.com

Read more about the newsletter and view previous issues.
http://dev.mysql.com/news-and-events/newsletter/

Problems reading the newsletter in your email client? View the newsletter on the web.
http://dev.mysql.com/news-and-events/newsletter/2011/2011-05.html

--
Copyright (c) 2011, Oracle Corporation and/or its affiliates.
You are free to distribute this newsletter, as long as you don't make any changes.

Database News

Wednesday, May 18, 2011

MySQL Newsletter: May 2011

No comments:

Post a Comment

Followers

Blog Archive

About Me