Wednesday, August 4, 2010

MySQL Newsletter: August 2010

MySQL Newsletter
August 2010
mysql-newsletter@sun.com

Articles in this newsletter:

Highlights

- 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 Product Releases

- 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)

Hints & Tips

- 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?

Events

- Live Webinar: Freedom Fighter - The New Dolphin - Chinese (Wednesday, August 11)
- Live Webinar: Deployment Best Practices: The MySQL Cluster Database (Wednesday, August 25)

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

Highlights

Event: MySQL Sunday at Oracle OpenWorld - Save the Date! (September 19, San Francisco)

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!

Learn More about the Sessions and Speakers:
http://blogs.sun.com/MySQL/entry/mysql_sunday_tracks_at_oracle


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.

Read the White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql-wp_cluster-7.0_Cluster_MEMORY.php


Article: Introducing the MySQL Librarian

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.

Read this Article:
http://dev.mysql.com/tech-resources/articles/introducing-librarian.html


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://dev.mysql.com/why-mysql/case-studies/mysql_cs_plusnet.php


Live Webinar: Boosting Your Products' Performance and Scalability with InnoDB Upgrade for MySQL 5.1
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.

Register for this Webinar:
http://dev.mysql.com/news-and-events/web-seminars/display-557.html?p=newsletter


Live Webinar: MySQL Essentials Series - Part 3: Designing MySQL Databases
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.

Register for this Webinar:
http://dev.mysql.com/news-and-events/web-seminars/display-558.html?p=newsletter

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

New Product Releases

New Release of MySQL Community Server 5.5.5-m3 (Beta)

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.

View the complete list of changes:
http://dev.mysql.com/doc/refman/5.5/en/news-5-5-5.html

Download now:
http://dev.mysql.com/downloads/mysql/5.5.html#downloads


New Release of MySQL Community Server 5.1.49 (GA)

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.

View the complete list of changes:
http://dev.mysql.com/doc/refman/5.1/en/news-5-1-49.html

Download now:
http://dev.mysql.com/downloads/mysql/5.1.html#downloads


New Release of MySQL Connector/Net 6.3.3 (Beta)

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.

View the complete list of changes:
http://dev.mysql.com/doc/refman/5.1/en/connector-net-news-6-3-3.html

Download now:
http://dev.mysql.com/downloads/connector/net/6.3.html

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

Hints & Tips

White Paper: Boosting Performance and Scalability with the InnoDB Upgrade for MySQL 5.1

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://dev.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://dev.mysql.com/why-mysql/case-studies/mysql_cs_netlog.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: MySQL 5.5.4-m3 in Production
Jeremy Zawodny

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.

Read the PlanetMySQL BlogPost:
http://blog.zawodny.com/2010/07/14/mysql-5-5-4-m3-in-production/


PlanetMySQL Blog: MySQL versions at Wikipedia
Domas Mituzas

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.

Read the PlanetMySQL BlogPost:
http://mituzas.lt/2010/07/25/mysql-versions-at-wikipedia/


PlanetMySQL Blog: Using MySQL Partitioning Instead of MERGE Tables
Sheeri Cabral

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.

Read the PlanetMySQL BlogPost:
http://www.pythian.com/news/14971/using-mysql-partitioning-instead-of-merge-tables/


PlanetMySQL Blog: Link MySQL to Microsoft SQL Server 2008
Anirudh Tamsekar

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.

Read the PlanetMySQL BlogPost:
http://dbperf.wordpress.com/2010/07/22/link-mysql-to-ms-sql-server2008/


PlanetMySQL Blog: Install, configure and run MySQL Cluster - demo video
Andrew Morgan

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.

Read the PlanetMySQL BlogPost:
http://www.clusterdb.com/mysql-cluster/install-configure-and-run-mysql-cluster-demo-video/


PlanetMySQL Blog: How can a database be in-memory and durable at the same time?
Andrew Morgan

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.

Read the PlanetMySQL BlogPost:
http://www.clusterdb.com/mysql-cluster/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
Matthew Montgomery

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.

Read the PlanetMySQL BlogPost:
http://todointx.blogspot.com/2010/07/mysql-cluster-rpms-what-packages-to.html


PlanetMySQL Blog: Optimizing MySQL Cluster for the latest generation of x86 processors
Andrew Hutchings

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.

Read the PlanetMySQL BlogPost:
http://blogs.sun.com/LinuxJedi/entry/mysql_cluster_and_numa


PlanetMySQL Blog: Installing MySQL on Oracle Enterprise Linux
Ronald Bradford

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.

Read the PlanetMySQL BlogPost:
http://ronaldbradford.com/blog/installing-mysql-on-oracle-enterprise-linux-2010-07-11/


PlanetMySQL Blog: Using EXPLAIN EXTENDED / SHOW WARNINGS to Help Troubleshoot Inefficient Queries in MySQL
Chris Calender

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.

Read the PlanetMySQL BlogPost:
http://www.chriscalender.com/?p=118


PlanetMySQL Blog: Implicit casting you don't want to see around
Shlomi Noach

In "Beware of implicit casting", I have outlined the dangers of implicit casting. Here's a few more real-world examples I have tackled.

Read the PlanetMySQL BlogPost:
http://code.openark.org/blog/mysql/implicit-casting-you-dont-want-to-see-around


PlanetMySQL Blog: Do you really want autoReconnect to silently reconnect?
Todd Farmer

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?

Read the PlanetMySQL BlogPost:
http://mysqlblog.fivefarmers.com/2010/07/05/do-you-really-want-autoreconnect-to-silently-reconnect/

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

Events

Live Webinar: Freedom Fighter - The New Dolphin - Chinese
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.

Register for this Webinar:
http://dev.mysql.com/news-and-events/web-seminars/display-561.html?p=newsletter


Live Webinar: Deployment Best Practices: The MySQL Cluster Database
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.

Register for this Webinar:
http://dev.mysql.com/news-and-events/web-seminars/display-559.html?p=newsletter


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?

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

Follow MySQL Community on Twitter:
http://twitter.com/mysql_community

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

About the Newsletter

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

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/2010/2010-08.html

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

No comments:

Post a Comment