MySQL Newsletter April 2011
Articles in this newsletter:
- Event: OTN Developer Day: MySQL - Santa Clara, CA (May 3)
- Blog Post: Thank You from The MySQL Team at Oracle!
- DevZone Article: What's New in MySQL 5.6
- DevZone Article: MySQL Cluster 7.2 Labs & Development Milestone Release - NoSQL with Memcached and 20x Higher JOIN Performance
- DevZone Article: NoSQL to MySQL with Memcached
- DevZone Article: Introducing the MySQL Installer for Windows
- Live Webinar: MySQL Enterprise Hot Backup for Your Products (April 28)
- New Release of MySQL Community Server 5.6.2 (Development Milestone)
- New Release of MySQL Cluster 7.2.0 (Development Milestone)
- New Release of MySQL Community Server 5.5.11 (GA)
- New Release of MySQL Workbench 5.2.33 (GA)
- OTN Article: Scaling a PHP MySQL Web Application
- White Paper: MySQL Enterprise Monitor for ISVs and OEMs
- White Paper: Scaling Web Services with MySQL Cluster: An Alternative to the MySQL Memory Storage Engine
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: Top Features in MySQL 5.6.2 Development Milestone Release
- PlanetMySQL Blog: A Big Bag of Epic Awesomeness
- PlanetMySQL Blog: Monitoring Table and Index IO with PERFORMANCE_SCHEMA
- PlanetMySQL Blog: More Stable Query Execution Times by Improving InnoDB Statistics
- PlanetMySQL Blog: Replication Event Checksum
- PlanetMySQL Blog: MySQL 5.6: Index Condition Pushdown
- PlanetMySQL Blog: Information Schema for InnoDB System Tables
- PlanetMySQL Blog: MySQL 5.6: InnoDB scalability fix - Kernel mutex removed
- PlanetMySQL Blog: Sharing user credentials between MySQL Servers with Cluster
- PlanetMySQL Blog: Scalable, persistent, HA NoSQL Memcache storage using MySQL Cluster
- PlanetMySQL Blog: Dramatically Increased MySQL Cluster JOIN performance with Adaptive Query Localization
- PlanetMySQL Blog: MySQL Workbench Utilities
- PlanetMySQL Blog: Get started with InnoDB Memcached Daemon plugin
- PlanetMySQL Blog: MySQL 5.6: Multi threaded purge
- PlanetMySQL Blog: Some Transactional Debugging Enhancements in MySQL Connector/J 5.1.15 You Should Know About
- PlanetMySQL Blog: As restoring a dump table into the MySQL master - you better get some sleep
- Live Webinar: MySQL Reference Architectures for Scalable Web Infrastructure - French (April 28)
- Live Webinar: NEW for ISVs and OEMs: MySQL Enterprise Edition - Adding Value to Your Products - Italian (May 13)
- On-Demand Webinar: MySQL Cluster 7.1, Latest Updates and Enhancements
Tuesday, May 3, 2011
The OTN Developer Day MySQL is a one-stop shop for you to learn all the essential skills about MySQL. 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.
The MySQL team at Oracle would like to thank everyone who joined us at the MySQL Community Reception on April 13 at the Santa Clara Tech Mart. We couldn't have hoped for better participation - the room was packed; in fact people were overflowing into the outside patio!
With MySQL 5.5 generally available and being deployed all over the planet, the architects and strategists can start looking ahead to the exciting new thing with "SQL" in its name: MySQL 5.6.
DevZone Article: MySQL Cluster 7.2 Labs & Development Milestone Release - NoSQL with Memcached and 20x Higher JOIN Performance
The announcement on April 11 marks an exciting milestone in the development of the MySQL Cluster database.
The MySQL Cluster 7.2 Development Milestone Release and latest labs.mysql.com builds deliver enhancements based on input from the community and customers, including support for the memcached NoSQL API, faster JOIN performance and simplified administration.
The ever increasing performance demands of web-based services has generated significant interest in providing NoSQL access methods to MySQL - enabling users to maintain all of the advantages of their existing relational database infrastructure, while providing blazing fast performance for simple queries, using an API to complement regular SQL access to their data.
The MySQL Installer for Windows radically simplifies the installation process for all MySQL users on the Windows platform. It only takes minutes from downloading the MySQL Installer to having a ready to use MySQL system on your machine.
Thursday, April 28, 2011 - 9:00am PT
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.
MySQL Server 5.6.2 is a new Development Milestone Release of the world's most popular open source database. The new features in this release are in development (pre-Production).
MySQL Cluster NDB 7.2.0 is a new development preview release of MySQL Cluster, incorporating several new features in the NDBCLUSTER storage engine for testing and user feedback.
MySQL 5.5.11 is a new version of the 5.5 production release of the world's most popular open source database. MySQL 5.5.11 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.
The MySQL developer tools team announces the next release of its flagship product, MySQL Workbench - version 5.2.33. This is a maintenance release and corrects some problems we didn't cover in the last release.
Creating a Web application - actually writing the core code - is often the initial focus of a project. It's fun, it's exciting, and it's what you are driven to do at that time. Hopefully however, there always comes a time when your application starts to take higher traffic than originally expected. This is the point where people often start thinking about how to scale their Website.
Over 2000 ISVs and OEMs such as Adobe, CA, F5, Sage, and Symantec rely on MySQL as their product's database for its performance, quality, ease of use, and low-cost. Using MySQL Enterprise Monitor, you can further improve on those four qualities, even as you add more sophisticated capabilities to your application and your customers' data volumes increase. MySQL Enterprise Monitor is now available to ISVs and OEMs to help ensure that MySQL is optimized for your particular product requirements, and in your customers' specific environments.
Read this White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql-enterprise-monitor-for-isvs-and-oems/)
White Paper: Scaling Web Services with MySQL Cluster: An Alternative to the MySQL Memory Storage Engine
MEMORY is a basic MySQL storage engine designed for in-memory operations. MySQL Cluster, which itself can be implemented as a MySQL storage engine, can perform all the same in-memory operations, and is faster, more reliable and uses less RAM for data, even on a single node.
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.
Great news was announced at the Collaborate 11 conference; the first development milestone release of MySQL 5.6.2 is now available to the MySQL Community! This is significant because 5.6.2 builds on the momentum generated by the performance, scalability, InnoDB and Replication improvements that rolled out in version 5.5 just last December.
I tried to come up with a number of topics for this post, but none seemed to really convey what I really feel. And really this blog is about all of them: a look at PERFORMANCE_SCHEMA.STAGES and PERFORMANCE_SCHEMA.STATEMENTS, graphing MySQL Statement Execution, a MySQL visual EXPLAIN plan with PERFORMANCE_SCHEMA, and tracing Sessions with PERFORMANCE_SCHEMA.
Another new feature of performance_schema within 5.6 is the ability to monitor both table and index IO - this was added in two parts: WL#4895 - PERFORMANCE SCHEMA TABLE IO, and WL#5379 - PERFORMANCE SCHEMA TABLE / INDEX IO SUMMARY.
As part of ensuring that changes to the MySQL Optimizer does not introduce performance regressions, we have started a project to create a new performance regression test suite. One component in this test suite will be the DBT-3 test suite. However, we observed that the execution times for DBT-3 varied so much that, in its present form, it was not usable for detecting performance regressions.
MySQL replication is fast, easy to use, and reliable, but once it breaks, it can be very hard to figure out what the problem is. One of the concerns often raised is that events are corrupted, either through failing hardware, network failure, or software bugs.
Index Condition Pushdown (ICP) is one of the new optimizer features in the MySQL 5.6.2 milestone release. The goal with Index Condition Pushdown is to move as much as possible of the processing of conditions (mainly WHERE clauses) from the server to the storage engine.
One of the most important things a database user or DBA wants to know is what columns, indexes etc. a table has. There are a few ways to find these things out, such as show tables. However, to really reveal all of the detailed metadata information in an InnoDB database, many have tried the "innodb_table_monitor" to peek into internal data dictionary.
For those interested in InnoDB internals, this post tries to explain why the global kernel mutex was required and the new mutexes and rw-locks that now replace it, along with the long-term benefits from this change.
The Development Release for MySQL Cluster 7.2 includes a new feature that allows the system data required for checking user access to be shared amongst all of your MySQL Servers. By default all of the tables holding these credentials are stored in MyISAM and so are local to that MySQL Server.
There are a number of attributes of MySQL Cluster that make it ideal for lots of applications that are considering NoSQL data stores. Scaling out capacity and performance on commodity hardware, in-memory real-time performance (especially for simple access patterns), flexible schemas ... sound familiar? In addition, MySQL Cluster adds transactional consistency and durability. In case that's not enough, you can also simultaneously combine various NoSQL APIs with full-featured SQL - all working on the same data set.
PlanetMySQL Blog: Dramatically Increased MySQL Cluster JOIN performance with Adaptive Query Localization
Regular readers of this Blog or attendees at the 2010 O'Reilly MySQL Conference may recall a feature that the MySQL Cluster team was working on to speed up JOINs. The good news is that work has continued since then and it is now part of the new MySQL Cluster 7.2 Milestone Development Release. This post will step through where to get hold of the binaries and see the benefits for yourself.
One of the many new things that are being introduced this week are some great new external tools for managing MySQL servers. These are available in MySQL Workbench under the name MySQL Workbench Utilities. It is a package of easy-to-use utilities for maintenance and administration of MySQL servers. These utilities encapsulate a set of primitive commands bundling them so that you can perform macro operations with a single command.
As Calvin mentioned in "NoSQL to InnoDB with Memcached", we just released a "technology preview" of the feature that makes memcached a MySQL Daemon Plugin. And this "technology preview" release demonstrates how user can go around SQL Optimizer and Query Processing and directly interact with InnoDB Storage Engine through InnoDB APIs. Here, we would like to walk with you step by step to see how to get the memcached Daemon Plugin set up and get it running.
What does purge exactly do and why is it needed? If you have ever wondered then read on. It is really a type of garbage collector.
PlanetMySQL Blog: Some Transactional Debugging Enhancements in MySQL Connector/J 5.1.15 You Should Know About
If you're using Innodb and transactions with JDBC and your MySQL application, you should know about a couple of debugging features that made their way into MySQL Connector/J 5.1.15.
Restoring a dump table into the MySQL master server can lead to serious replication delay. The massive inserts commands cause the Master and slaves to use most of their resources for replication. As a result, replication lag may increase dramatically (linear to the table size). To overcome the replication delay caused by restoring the dump table on the master, there is a need to widespread the massive inserts.
Thursday, April 28, 2011 - 10:00 CET
In this webinar, we present a series of Reference Architectures for small, medium and large Web properties. You will learn about the components common to most web properties including Session Management, Authentication, eCommerce and Content Management. We will also discuss the unique requirements for Large Social Networking applications.
Live Webinar: NEW for ISVs and OEMs: MySQL Enterprise Edition - Adding Value to Your Products - Italian
Friday, May 13, 2011 - 10:00 CET
With the release of MySQL 5.5, all of the advanced capabilities of MySQL Enterprise Edition are now available to OEMs to be distributed with their commercial products. In this technical webinar, MySQL Sales Consultant Luca Olivari will review new options for OEMs, which are new or improved in the recently released MySQL version 5.5.
MySQL Cluster is proven as a write-scalable, real-time transactional database, combining high availability with the low TCO of open source. With a distributed, multi-master architecture and no single point of failure, MySQL Cluster is able to scale horizontally on commodity hardware to serve read and write intensive workloads, accessed via SQL and NoSQL interfaces.
Listen to this webinar to learn more about the design concepts and most recent developments in MySQL Cluster!
More free MySQL webinars are scheduled and added between each Newsletter edition, so visit our website frequently for the most updated information.