MySQL Newsletter September 2009
Articles in this newsletter:
- Developer Interview: What's New in the MySQL Enterprise Fall 2009 Release? - Interview with Mark Matthews and Andy Bang
- Press Release: New Version of MySQL Enterprise Allows DBAs to Graphically Drill-Down into Database Bottlenecks to Improve Application Performance
- Case Study: Ticketmaster.com Migrated from Microsoft SQL Server to MySQL and Improved Scalability by 400%
- White Paper: MySQL Enterprise Monitor - What's New, Fall 2009 Release
- White Paper: MySQL Query Analyzer Overview
- Live Webinar: What's New in MySQL Enterprise Fall 2009 Release (Tuesday, September 22, 2009)
- Live Webinar: For ISVs - Architecting Embedded Databases for High Performance Applications (Wednesday, September 23, 2009)
- Upcoming MySQL University Sessions
- New Release of MySQL Enterprise Monitor 2.1 (GA)
- New Release of MySQL Server 5.1.38 (GA)
- New Release of MySQL Server 5.0.85 (GA)
- New Release of MySQL Workbench 5.1.18 (GA)
- New Release of MySQL Connector/Net 6.1.2 (GA)
- New Release of MySQL Connector/C 6.0.2 (GA)
- Article: Quick and Dirty MySQL Performance Troubleshooting
- Article: Using MySQL to generate daily sales reports with filled gaps
- White Paper: A Guide to MySQL for Microsoft Windows Server 2008 Failover Clustering
- White Paper: An SMB Guide to Developing an Open Source Strategy
- Case Study: School of Everything's Powerful Web Infrastructure Relies on MySQL Deployed using Amazon EC2
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: MySQL/Open Source Event Calendar
- PlanetMySQL Blog: FrOSCon/OpenSQL Camp summary
- PlanetMySQL Blog: Examples of bad queries
- PlanetMySQL Blog: MySQL Labs - server snapshots available for download
- PlanetMySQL Blog: When does InnoDB do disk IO?
- PlanetMySQL Blog: Will your production MySQL server survive a restart?
- PlanetMySQL Blog: Watch out for hostname changes when using replication!
- White Paper: Using MySQL Cluster for Web & eCommerce Applications
- White Paper: IDC Analysis of Open Source Adoption in Telecom Service Delivery Infrastructure
- Case Study: Shopatron Grows eCommerce Services with MySQL Cluster
- Case Study: MySQL Cluster Helps Mapion to Improve its On-Line Mapping Application
- PlanetMySQL Blog: Using NDB API Events to mask/hide column data when replicating
- PlanetMySQL Blog: MySQL Cluster + Dolphin DX = Sweet!
- PlanetMySQL Blog: Updating the MySQL Cluster DBA Exam
- Live Webinar: FreeRADIUS & MySQL Cluster - Scalable and Highly Available AAA Services (Wednesday, September 30, 2009)
- Live Webinar: Best Practices Webinar - Shopatron's eCommerce Services Powered by MySQL Cluster (Thursday, October 22, 2009)
- Live Webinar: Top MySQL Enterprise Subscription Tips and Tricks (Monday, September 21, 2009)
- Live Webinar: Advanced Techniques for High Traffic Sites - EMEA (Wednesday, September 23, 2009)
- Live Webinar: Open-Source for High Performance Web Applications (Thursday, September 24, 2009)
- Live Webinar: High Availability Architectures for Online Applications (Tuesday, September 29, 2009)
- Live Webinar: Getting Started with MySQL on Windows (Thursday, October 01, 2009)
- Live Webinar: For ISVs and OEMs - Automatic MySQL multi-platform deployment with your Java Application Using MySQL Connector/MXJ (Wednesday, October 07, 2009)
- Live Webinar: How to grow your user base 275% with High Availability - EMEA (Wednesday, October 07, 2009)
- Live Webinar: Inserts at Drive Speed - Designing a Custom Storage Engine (Tuesday, October 13, 2009)
- Training: MySQL High Availability (3 Days)
- Training: Enroll a Training Course by September 30 to Receive a 10% Discount and a Sony PSP
- Consulting: MySQL DBA (4+ Days)
- Live Webinar: Kimball Group Data Warehousing Educational Webinar Series Part III - Kimball Data Warehouse Lifecycle (Tuesday, October 06, 2009)
- Live Webinar: Alfresco - Web Based Collaborative Content Management (Thursday, October 15, 2009)
Developer Interview: What's New in the MySQL Enterprise Fall 2009 Release? - Interview with Mark Matthews and Andy Bang
We talked to Mark Matthews and Andy Bang, two core developers in the MySQL Enterprise Monitor team, to give us some insight into the new features in the latest MySQL Enterprise Release. You can find more about the MySQL Query Analyzer in our previous interview with Mark.
Read the Interview »
Press Release: New Version of MySQL Enterprise Allows DBAs to Graphically Drill-Down into Database Bottlenecks to Improve Application Performance
Sun Microsystems, Inc. today announced an update to its MySQL Enterprise subscription, designed to assist corporate users improve the speed and uptime of their MySQL database applications. Graphical enhancements to the MySQL Enterprise Monitor's Query Analyzer help DBAs and developers to better pinpoint database queries to avoid performance problems. With new visual correlation graphs, problem queries can now be filtered and analyzed by highlighting specific time-periods of interest with a few mouse-clicks - making it easier to quickly find spikes in key system resources, and fix problems rooted in inefficient SQL code.
Learn More » (http://www.mysql.com/news-and-events/generate-article.php?id=2009_14)
Try the MySQL Enterprise Fall 2009 Release 30 days for free » (http://www.mysql.com/trials)
Watch the Demos » (http://www.mysql.com/products/enterprise/demo.html)
Read the English White Papers » (http://www.mysql.com/products/enterprise/whitepapers.html)
Read the French White Papers » (http://www.mysql.fr/products/enterprise/whitepapers.html)
Read the Italian White Papers » (http://www.mysql.it/products/enterprise/whitepapers.html)
Read the German White Papers » (http://www.mysql.de/products/enterprise/whitepapers.html)
Case Study: Ticketmaster.com Migrated from Microsoft SQL Server to MySQL and Improved Scalability by 400%
Ticketmaster Entertainment, Inc. is the world leading event ticketing company. In 2001, due to the growing popularity of online sales of show and sports tickets, the demand for Ticketmaster.com began to exceed its capacity and caused stability issues. To solve the problem, Ticketmaster.com decided to move the Event database from Microsoft SQL Server to MySQL. MySQL enables Ticketmaster.com to achieve the 4x scalability, while consistently maintaining the average replication time of less than one second.
Read this Case Study » (http://www.mysql.com/why-mysql/case-studies/ticketmaster-com-migrated-from-microsoft-sql-server-to-mysql/)
MySQL is proud to announce the Fall 2009 Release of the MySQL Enterprise Monitor. The MySQL Enterprise Monitor now allows you to visually correlate MySQL and OS graph and query activity so you can easily find your most expensive queries and analyze execution patterns and trends that may be causing spikes in key system resources. Plus, new Advisor Rules and Graphs enable DBAs to implement more MySQL best practices relating to administration, upgrade, schema, and performance.
Read the English White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_enterprise_fallrel_whatsnew.php)
Read the French White Paper » (http://www.mysql.fr/why-mysql/white-papers/mysql_wp_enterprise_fallrel_whatsnew.php)
Read the German White Paper » (http://www.mysql.de/why-mysql/white-papers/mysql_wp_enterprise_fallrel_whatsnew.php)
Read the Italian White Paper » (http://www.mysql.it/why-mysql/white-papers/mysql_wp_enterprise_fallrel_whatsnew.php)
The MySQL Query Analyzer helps developers and DBAs improve application performance by monitoring query performance and accurately pinpointing SQL code that is causing a slow down. With the new clickable correlation graphs, problem queries can be filtered and analyzed by highlighting the timeframe of interest, which makes it even faster to identify SQL bottlenecks.
This paper explores common use cases and challenges faced by MySQL developers and DBAs in tuning SQL code. It also introduces the MySQL Query Analyzer and explains how it can be used to optimize queries during development and then to monitor applications in production environments.
Read the English White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql-query-analyzer-overview/)
Read the French White Paper » (http://www.mysql.fr/why-mysql/white-papers/mysql-query-analyzer-overview/)
Read the German White Paper » (http://www.mysql.de/why-mysql/white-papers/mysql-query-analyzer-overview/)
Read the Italian White Paper » (http://www.mysql.it/why-mysql/white-papers/mysql-query-analyzer-overview/)
Tuesday, September 22, 2009 - 10:00am PDT
Join this webinar and see a live demonstration of the new MySQL Enterprise Monitor and the improved Query Analyzer, hear about the new Advisor rules and support services and get live answers to your questions from our MySQL experts.
Wednesday, September 23, 2009 - 10:00am PDT
In this Web seminar you'll learn the tips and tricks for architecting your application's embedded or bundled database for higher performance and customer satisfaction. Using MySQL Embedded Server as our example, the MySQL Consulting pros will take you through the steps they use to optimize MySQL Embedded Server to achieve highest database and application performance.
MySQL University is a free educational online program for engineers and developers who are interested in MySQL development and internals. MySQL University sessions are open to anyone, not limited to Sun employees. Sessions are recorded with slides and audio, so if you can't attend the live session you can review the recording anytime after the session.
Upcoming sessions include:
- September 24: Concurrency Control - How It Really Works (Heikki Tuuri)
- October 1: InnoDB Internals - InnoDB File Formats and Source Code Structure (Calvin Sun)
- October 8: Building MySQL Releases on Unix (Jörg Brühe)
- October 15: The Spider Storage Engine (Giuseppe Maxia)
We are pleased and excited to announce that MySQL Enterprise Monitor 2.1 is now posted on the Enterprise web site as our latest GA release.
The flagship features of this release include:
- Visual correlation of any graph activity with queries in the Query Analyzer
- Query History Graphs (in the query pop-ups)
- Query Error and Warning tracking
- Important product-related announcements on the What's New? page
- New rules and graphs
Not a customer yet? Try the MySQL Enterprise for 30 Days for Free » (http://www.mysql.com/trials)
MySQL Community Server 5.1.38, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.38 is recommended for use on production systems.
MySQL Community Server 5.0.85, a new version of the popular Open Source Database Management System, has been released. This and future releases in the MySQL Community Server 5.0 series share version numbers with their MySQL Enterprise Server counterparts.
We are proud to announce the next service release of MySQL Workbench 5.1.18. We have fixed another set of bugs and made some improvements people have been asking for. We have optimized the layout of the Columns-section in our table-editor. Now it provides a smoother and more comfortable workflow.
MySQL Connector/Net 6.1.2, a new version of the all-managed .NET driver for MySQL has been released. This is our latest GA release and is suitable for use in all scenarios against servers ranging from version 4.1 to 5.4. This release also includes a slew of bug fixes made to the 5.2 and 6.0 trees. Please check the release notes and change log for a complete list of those changes.
MySQL Connector/C 6.0.2, a new version of the C API for accessing MySQL database servers has been released. This release is of GA quality and is suitable for use in production environments.
Sooner or later, you're going to get that phone call (or email, SMS, instant message, tweet, or whatever): The database is slow! Fix ASAP! And you'll be expected to very quickly figure out what's slowing things down - often wither very little context, background, or sense of what may have changed recently at the application layer.
This is a classic problem but I was surprised to see that there's not a great deal of info on the web on how to do a proper daily report - one that doesn't have any gaps when data is missing. In this post I'll guide you through building such a report using MySQL and PHP for presentation.
In this paper we present a guide for setting up a development environment in order to leverage MySQL with Microsoft's Windows Server 2008 Failover Clustering feature. Although, not intended to be a guide for production deployments, it should give Windows developers, DBAs and system administrators a fundamental understanding of how to configure MySQL to use this feature.
Read this White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql-wp-windows-cluster.php)
Not only is open source ready for the world's largest enterprises, it's ideal for small- and medium-sized businesses (SMB's) as well. Many SMB's are realizing significant cost savings by using open source products to power web sites, business-critical enterprise applications and packaged software. This paper is your guide to developing an open source strategy.
Read the English White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_smb_lamp.php)
Read the German White Paper "Leitfaden zur Entwicklung einer Open-Source-Strategie für KMU" » (http://www.mysql.de/why-mysql/white-papers/mysql_wp_SMB.php.de)
Read the Italian White Paper "Guida allo sviluppo di una strategia open source per le PMI" » (http://www.mysql.it/why-mysql/white-papers/mysql_wp_smb_lamp.php.it)
Case Study: School of Everything's Powerful Web Infrastructure Relies on MySQL Deployed using Amazon EC2
The School of Everything is a website that helps people who want to learn meet up with people who want teach. School of Everything chose to deploy MySQL and Drupal on Amazon's Elastic Compute Cloud (EC2) services as this offered them the greatest flexibility.
Read this Case Study » (http://www.mysql.com/why-mysql/case-studies/school-of-everythings-mysql-amazon-ec2/)
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.
The MySQL Community Team maintains a calendar to keep track of Open Source events and conferences that might be relevant from a MySQL point of view. This calendar is now public - you can either look at the HTML version on the MySQL Forge or subscribe to the iCal feed.
It's almost two weeks now since FrOSCon and the OpenSQL Camp subconference have taken place in Sankt Augustin, Germany - about time for a summary and update from my side!
In my years of teaching MySQL topics, I've noticed that many people write bad queries. It's not necessarily their fault. It could be that they don't understand some aspect of SQL, or that they solved the problem with the first technique that came to mind, or that their query is fine except that MySQL optimizes it poorly. I'll give a few examples.
Users familiar with the MySQL development process will remember that our developers use a tool called pushbuild, which builds the server code with the latest changes, using several operating systems, and runs the test suite.
This is a list of most of the sources of disk IO in InnoDB. Most of the statements below are true for official MySQL 5.0 and the InnoDB plugin prior to 1.0.4.
Do you know if your production MySQL servers will come back up when restarted? A recent support episode illustrates a number of best practices. The task looked trivial: Update a production MySQL server with a configuration tuned and tested on a development server. Clean shutdown, change configuration, restart.
For one reason or another, many times we find ourselves changing the hostname of a machine. It's been repurposed or moved - or perhaps the original installer didn't know what name it should have. To achieve this on most modern Linux distributions there are 2 key files you need to update.
MySQL Cluster is a proven key component of web infrastructure that can help you cost-effectively deploy online applications to generate new revenue streams and build vibrant user communities. Read the white paper to learn how deploying MySQL Cluster with your web and eCommerce services enables you to grow revenue and enhance customer loyalty.
Read this White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_Cluster_For_OnlineApps.php)
Reducing cost, accelerating time to market and enhancing subscriber experience are key drivers for investment by Communications Service Providers (CSPs) today, and open source technologies are playing a transformational role in enabling CSPs to meet these strategic goals. Get the latest research from IDC and MySQL and learn where and why CSPs and technology providers are adopting open source technologies to power the next generation of network service infrastructure.
Read this White Paper » (http://www.mysql.com/why-mysql/white-papers/idc-analysis-of-open-source-adoption-in-telecommunications/)
In 2006, Shopatron began investigating clustered database solutions that would provide the performance, scale and availability demanded by their growing eCommerce business. Having used the MySQL Server for several internal projects, they were aware of the performance and reliability offered by MySQL technologies. They were also aware that MySQL offered a real-time, high availability implementation of the database called MySQL Cluster.
Read this Case Study » (http://www.mysql.com/why-mysql/case-studies/mysql-cluster-powers-rapidlygrowing-ecommerce-service/)
Mapion Co., Ltd, is Japan's leading provider of online map services. The company offers the Mapion online map; navigation tools and directions delivered to users' mobile phones with Mapion Mobile; and provides its Mapion BB service for broadband users.
If you have asynchronous replication where the slave database is using MySQL Cluster then you can use the NDB API events functionality to mask/overwrite data. You might do this for example if the replica is to be used for generating reports where some of the data is sensitive and not relevant to those reports.
At a customer I have had the opportunity to work with some really state of the art equipment. The customer is in the online gaming industry and we are building a platform based on MySQL Cluster where we are consolidating a number of applications.
It is time to update the MySQL Cluster exam. The current exam was written when the Cluster software was at version 5.1 and 7.0.5 is available for download. Reviewing the old exam questions shows some of them are badly dated.
Wednesday, September 30, 2009 - 9:30am PDT
Tune into this webinar where you can hear from Alan Dekok, one of the founders of the FreeRADIUS project and CEO of Network RADIUS, discussing the concepts and implementation of RADIUS services using the FreeRADIUS server and the MySQL Cluster database to deliver highly available and scalable AAA services.
Thursday, October 22, 2009 - 10:00am PDT
Tune into this webinar where Shopatron's CIO/COO and VP of Engineering will both share their experiences and best practices of implementing the MySQL Cluster database for eCommerce applications.
Monday, September 21, 2009 - 10:00am PDT
Join us in this webinar to hear from a MySQL customer, Phil Hildebrand, Operations Manager for databases and deployments, thePlatform, his top MySQL Enterprise tips and tricks to help you improve performance, productivity and stay ahead of your competition!
Wednesday, September 23, 2009 - 10:00 CET
Join us for the 3rd of our 4 part webinar series exploring the different aspects of using MySQL as the database for online applications. With real life experience gained working with MySQL Customers such as Facebook, Alcatel Lucent and Google, this webinar series will give you the information you need to run scalable, highly available online applications.
In the 3rd part of this webinar series we examine some of the advanced techniques available to service complex, high traffic, online applications.
Thursday, September 24, 2009 - 10:00am PDT
Many enterprises are looking to open-source software to significantly cut IT costs while increasing agility to respond to changing market conditions. In this web seminar, you will get tips and tricks from the MySQL and GlassFish experts for building a highly performant, agile open-source platform structure in your enterprise.
Tuesday, September 29, 2009 - 10:00am PDT
Join us for the last of our 4 part webinar series exploring the different aspects of using MySQL as the backend database for online applications. In this last installment we look at MySQL high availability technologies and architectures. We will explore the uses cases for implementing MySQL Replication, MySQL Cluster, Distributed Replicated Block Device (DRBD), and other high-availability technologies.
Thursday, October 01, 2009 - 10:00am PDT
Join us for this informative technical webinar with Mike Frank, Sr Product Manager at Sun Microsystems. In this presentation we'll cover the benefits of deploying MySQL on Windows. You will learn the basic "How-To's" of installation, security and configuration. We will show you how to start using MySQL tools on Windows, such as MySQL Workbench and MySQL Enterprise Monitor with the new MySQL Query Analyzer.
Live Webinar: For ISVs and OEMs - Automatic MySQL multi-platform deployment with your Java Application Using MySQL Connector/MXJ
Wednesday, October 07, 2009 - 10:00am PDT
Connector/MXJ is a Java utility package that makes the MySQL database appear to be a Java-based component. The connector automatically determines which platform the system is running on, selects the appropriate binary, and launches the executable. With MySQL Connector/MXJ, you can reduce installation barriers for your end user customers by simply adding an additional parameter to the JDBC connection url which will cause the database to start when the first connection is made.
Wednesday, October 07, 2009 - 9:00 CET
University of Turku in Finland is at the forefront of research in areas such as bioscience, interaction of culture and society, mathematical research, research of learning and education, astronomy and space research. With MySQL Enterprise the universities have created a solution that enables them to expand and scale. Listen to Miika Kauppi, Project Manager at University of Turku, present how he designed the solution, purchased it and now is taking it into production.
Tuesday, October 13, 2009 - 10:00am PDT
MySQL offers a variety of storage engines that can be matched to application requirements. When none of the existing engines look like a perfect match to your requirements, you can add your own. Building a customer storage engine is easier than you'd think and there can be some substantial benefits. We will talk about lessons learned implementing the storage engine to improve flexibility and performance.
More free MySQL webinars are scheduled and added between each Newsletter edition, so visit our website frequently for the most updated information.
Washington DC, Sao Paulo, Santa Clara, Paris
This course is designed for experienced database administrators and system architects that want to analyze and form a basis of understanding different high availability options, including clustering and replication solutions within MySQL. This course will provide the tools required to make the decision of what high availability solution is appropriate and how to implement a system with the correct design.
Register Now for an Upcoming Date » (http://www.mysql.com/training/courses/mysql_5_ha.html)
Don't miss out on this great opportunity to get a free Sony Playstation Portable with any MySQL Classroom Training Class. Enroll in any one of the qualifying courses by September 30, 2009 and attend by November 30, 2009 and you will receive a 10% discount and a Sony PSP Gift.
Find out the Qualifying Courses and More Details » (http://www.mysql.com/training/psp_promo.html)
A dedicated MySQL certified consultant use proven methodologies and expertise in database administration, security, performance tuning, replication, backup, and fault-tolerance to provide this service. Sun's MySQL consultants will work closely with your team to:
- Analyze your current database infrastructure and database requirements
- Identify potential issues and limitations
- Install, configure and administer MySQL
- Set-up and manage replication
- Benchmark, load test, and optimize critical SQL queries
- Implement best practices and recommend tools for managing your database infrastructure.
Learn More » (http://www.mysql.com/consulting/packaged/dba.html)
Live Webinar: Kimball Group Data Warehousing Educational Webinar Series Part III - Kimball Data Warehouse Lifecycle
Tuesday, October 06, 2009 - 10:00am PDT
In this third webinar presented by Kickfire and Sun, Joy Mundy of The Kimball Group overviews all the steps to build, deploy and maintain a data warehouse.
Thursday, October 15, 2009 - 11:00 CET
Join us for this informative technical webinar with Jeff Nott and Will Abson at Alfresco Software, which will explore the benefits of an open source Collaborative Content Management stack based on Alfresco and MySQL.