MySQL Newsletter August 2010
Articles in this newsletter:
- Event: MySQL Sunday at Oracle OpenWorld - Save the Date! (September 19, San Francisco)
- White Paper: Scaling Web Services with MySQL Cluster: An Alternative to the MySQL Memory Storage Engine
- Article: Introducing the MySQL Librarian
- Case Study: Plusnet Achieves Continuous Availability of AAA Services with MySQL Cluster and FreeRADIUS
- Live Webinar: Boosting Your Products' Performance and Scalability with InnoDB Upgrade for MySQL 5.1 (Tuesday, August 10)
- Live Webinar: MySQL Essentials Series - Part 3: Designing MySQL Databases (Thursday, August 19)
- New Release of MySQL Community Server 5.5.5-m3 (Beta)
- New Release of MySQL Community Server 5.1.49 (GA)
- New Release of MySQL Connector/Net 6.3.3 (Beta)
- White Paper: Boosting Performance and Scalability with the InnoDB Upgrade for MySQL 5.1
- Case Study: Netlog ensures fast response times as traffic increases 300% with MySQL Enterprise Unlimited
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: MySQL 5.5.4-m3 in Production
- PlanetMySQL Blog: MySQL versions at Wikipedia
- PlanetMySQL Blog: Using MySQL Partitioning Instead of MERGE Tables
- PlanetMySQL Blog: Link MySQL to Microsoft SQL Server 2008
- PlanetMySQL Blog: Install, configure and run MySQL Cluster - demo video
- PlanetMySQL Blog: How can a database be in-memory and durable at the same time?
- PlanetMySQL Blog: MySQL Cluster RPMs: What packages to install on which system
- PlanetMySQL Blog: Optimizing MySQL Cluster for the latest generation of x86 processors
- PlanetMySQL Blog: Installing MySQL on Oracle Enterprise Linux
- PlanetMySQL Blog: Using EXPLAIN EXTENDED / SHOW WARNINGS to Help Troubleshoot Inefficient Queries in MySQL
- PlanetMySQL Blog: Implicit casting you don't want to see around
- PlanetMySQL Blog: Do you really want autoReconnect to silently reconnect?
- Live Webinar: Freedom Fighter - The New Dolphin - Chinese (Wednesday, August 11)
- Live Webinar: Deployment Best Practices: The MySQL Cluster Database (Wednesday, August 25)
Join us for MySQL Sunday, a half-day technical conference packed with the latest on MySQL, where you can choose sessions covering MySQL performance tuning, InnoDB, MySQL Cluster, MySQL Enterprise Monitor, and more. You'll also hear what's new and what's next directly from Edward Screven, Oracle Chief Corporate Architect, and learn from other MySQL users. Save the date and join us!
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.
In the performance testing, MySQL Cluster was able to deliver 30x higher throughput with 1/3 the latency of the Memory storage engine on just a single node.
The MySQL Librarian is a collection of community-generated and cross-referenced content related to MySQL. It's a place where the community collaboratively builds and maintains the MySQL content.
Case Study: Plusnet Achieves Continuous Availability of AAA Services with MySQL Cluster and FreeRADIUS
Plusnet upgraded their AAA (Authentication, Authorization, Accounting) platform to the FreeRADIUS server and MySQL Cluster database in order to address increased demands. Since deployment, the new MySQL Cluster and FreeRADIUS AAA platform has provided many benefits, including accurate billing and revenue assurance, accelerated time to market of new services with less cost and complexity, and new levels of flexibility to scale RADIUS servers independently of their database.
Read this Case Study » (http://www.mysql.com/why-mysql/case-studies/mysql_cs_plusnet.php)
Tuesday, August 10, 2010 - 9:00am PT
Join us for the first of a two-part webinar series in which we will discuss how you can achieve immediate performance and scalability gains by enabling the free and easy InnoDB Upgrade for MySQL 5.1.
In this webinar you'll learn about new features and benefits available only in the InnoDB upgrade, performance/scalability of the InnoDB Upgrade vs. MySQL 5.1's Built-in InnoDB, and how to easily enable the InnoDB Upgrade in MySQL 5.1 for immediate use.
Thursday, August 19, 2010 - 9:00am PT
Join us for Part 3 of the MySQL Essentials series to learn the design dos and don'ts for MySQL. MySQL Product Manager and MySQL Workbench expert, Mike Frank will show you how to design, forward and reverse engineer databases including discussions on datatypes, indexes, and foreign keys for various application scenarios.
MySQL Server 5.5.5-m3, a new version of the popular Open Source Database Management System, has been released. The "-m3" suffix indicates that these releases belong to the third milestone. MySQL 5.5 includes several high-impact changes to address scalability and performance issues in MySQL Server. These changes exploit advances in hardware and CPU design and enable better utilization of existing hardware.
MySQL Community Server 5.1.49, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.49 is recommended for use on production systems.
MySQL Connector/Net 6.3.3, a new version of the all-managed .NET driver for MySQL has been released. This is a beta release and is intended to introduce you to the new features and enhancements we are planning. The new features in this release include Visual Studio 2010 RTM support and a new SQL editor.
MySQL versions 5.1.38 and above now ship with the InnoDB Upgrade for 5.1, which provides users with immediate access to performance and scalability gains while sustaining the current production-ready and stable feature set of the MySQL 5.1 server.
In this paper, we provide a technical overview of the MySQL storage engine architecture used by the InnoDB Upgrade, a review of the features, and performance and scalability gains users can expect to see when enabling the InnoDB Upgrade in MySQL 5.1.38 or later.
Read this White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_51_InnoDBUpgrade.php)
Case Study: Netlog ensures fast response times as traffic increases 300% with MySQL Enterprise Unlimited
Netlog is one of the fastest-growing social networks in Europe. The target group is young people, 14-24 years of age, and Netlog is primarily used for communication, entertainment and sharing music and photos.
Access to MySQL Enterprise's monitoring and support services helps Netlog deliver excellent performance, security and response times on its 300 database servers. The company has 40 million registered members generating more than 6 billion page views every month.
Read this Case Study » (http://www.mysql.com/why-mysql/case-studies/mysql_cs_netlog.php)
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.
Back in April I wrote that MySQL 5.5.4 is very exciting and couldn't wait to start running it in production. Now here we are several months later and are using 5.5.4-m3 on all the slaves in what is arguably our most visible (and one of the busiest) user-facing cluster.
Lately I hear people questioning database software choices we made at Wikipedia, and I'd like to point out that Wikipedia database infrastructure needs are remarkably boring.
One common question I get is how to use partitioning instead of MERGE tables. The process I use involves using stored procedures to create and drop partitions. This article will go over the stored procedures I use; special thanks to Roland Bouman for taking a look and giving great feedback to optimize this process.
I came up with the idea of this article when I tried to create replication setup between MS SQL 2008 and MySQL. I was unable to do it since MS SQL provides only two non SQL Subscriptions/Publishers options. However I created the linked server through which I can access and query the MySQL databases and tables.
There is a new video available: Demonstration of installing, configuring and running MySQL Cluster (Linux) to accompany the MySQL Cluster Quick Start guides. The Flash video lasts for about 7 minutes.
There is often confusion as to how it can be claimed that MySQL Cluster delivers in-memory performance while also providing durability (the "D" in ACID). This post explains how that can be achieved as well as how to mix and match scalability, High Availability and Durability.
Oracle distributes a series of 12 RPM packages that make up the MySQL Cluster product. Lately I've been getting a lot of questions asking which of these dozen RPM packages should be installed onto which nodes.
One problem with MySQL Cluster we are starting to see quite often is to do with the current generation of Xeon processors. This post outlines the problem and how to avoid it.
One of the significant benefits of MySQL is its ease of use. Generally already installed on most Linux systems, MySQL can be installed by a single command if not yet present. On Oracle Enterprise Linux 5.4 you can use the following commands to check for MySQL, configure your yum repository and install MySQL.
PlanetMySQL Blog: Using EXPLAIN EXTENDED / SHOW WARNINGS to Help Troubleshoot Inefficient Queries in MySQL
When examining the execution plan of troublesome queries in MySQL, most users are aware of using EXPLAIN. However, an often overlooked, yet very helpful extension of EXPLAIN, is EXPLAIN EXTENDED coupled with the SHOW WARNINGS command.
In "Beware of implicit casting", I have outlined the dangers of implicit casting. Here's a few more real-world examples I have tackled.
Chances are, if you write Java applications using MySQL's Connector/J driver, you've run across the autoReconnect property. I remember that when I first found it, it seemed I had found the grail itself. "No more nasty connection closed error messages," I thought. Except ... it doesn't really work that way, does it?
Wednesday, August 11, 2010 - 10:00am China Time
As a result of the acquisition of Sun and Oracle, MySQL is now among Oracle's product portfolio. Oracle invests in MySQL, the world's most popular open source database, and drives its innovation further. In this webcast, we will share with you the latest updates from MySQL, including Oracle's strategy for MySQL, MySQL 5.5 beta preview, MySQL Cluster 7.1 introduction, and MySQL channel plan in Greater China Region.
Wednesday, August 25, 2010 - 9:00am PT
Delivered by the lead MySQL Cluster professional services consultant at Oracle, this session will present best practices on deploying MySQL Cluster in order to accelerate time to service with the highest levels of availability and performance to support your most critical web and telecoms applications.
More free MySQL webinars are scheduled and added between each Newsletter edition, so visit our website frequently for the most updated information.