MySQL Newsletter May 2011
Articles in this newsletter:
- 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 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)
- 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
- 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
In this interview, Georgi "Joro" Kodinov shared the latest enhancements around the Pluggable Authentication API and its benefits.
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.
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!
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.
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.
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.
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.
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://www.mysql.com/why-mysql/white-papers/whats-new-in-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://www.mysql.com/why-mysql/white-papers/mysql-replication-scalability-and-availability-with-mysql-5-5/)
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.
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.
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.
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.
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!
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.
The MySQL replication team has come up with a feature that looks very promising for improving slave scalability.
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.
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?
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.
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.
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.
PlanetMySQL Blog: Replication and load balancing mysqlnd plugin for all PHP MySQL extensions released
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)!
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.
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.
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.
Want to receive the latest MySQL updates and interact with the MySQL community?
Want to evaluate the advanced capabilities in the MySQL Enterprise Edition?