MySQL Newsletter May 2009
Articles in this newsletter:
- MySQL Conference & Expo 2009 Wrap-Up - Presentation Files Now Available
- For ISVs: Take the MySQL OEM Life Cycle Survey and Win a $150 Amazon.com Gift Certificate!
- MySQL Query Analyzer Lunch-n-Learn
- Case Study: MySQL Delivers 50% Lower Database Costs as NetHawk Develops Network Monitoring Solutions
- Case Study: SonicWALL Achieves 100% ROI in Under Nine Months Using MySQL Embedded Server
- Live Webinar: 6 Ways to Optimize Performance, Save Time and Lower Risk with a MySQL Enterprise Subscription (May 28, 2009)
- Upcoming MySQL University Sessions
- New Release of MySQL Community Server 5.0.81 (GA)
- New Release of MySQL Connector/Net 5.2.6 (GA)
- New Release of MySQL Connector/Net 6.0.3 (GA)
- New Release of MySQL Workbench 5.1.12 (Beta)
- New Release of MySQL Workbench 5.2.0 (Alpha)
- Article: Why Move to MySQL from Microsoft SQL Server
- Tutorial: Developing MySQL Database Applications With PHP
- White Paper: Guide to Deploying Carrier Grade Services Using Open Source Technologies
- White Paper: Building an Open Source, Carrier Grade Platform for Data Management with MySQL Cluster 7
- White Paper: Guide to Scaling OpenLDAP with MySQL Cluster Carrier Grade Edition
- White Paper: MySQL Enterprise Technical and Consultative Support Services Mitigate Risk, Minimize Downtime, Meet SLAs
- White Paper: Virtualization for MySQL on VMware® - Best Practices and Performance Guide
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: Hibernate Wars - The Query Cache Strikes Back
- PlanetMySQL Blog: MySQL Sandbox 3.0 Release Candidate
- PlanetMySQL Blog: Are Stored Procedures available with MySQL Cluster?
- PlanetMySQL Blog: How do I use the MySQL Proxy Admin plugin?
- PlanetMySQL Blog: MySQL Community Awards 2009
- PlanetMySQL Blog: MySQL Connector/Python - on launchpad!
- PlanetMySQL Blog: Online configuration update and a new script
- Article: A Quick Look at MySQL 5.4
- PlanetMySQL BlogPost: MySQL 5.4 Scaling to 16-way x86 and 64-way CMT Servers
- PlanetMySQL BlogPost: MySQL Performance - MySQL 5.4 and other InnoDB engines @dbSTRESS Benchmark
- PlanetMySQL BlogPost: MySQL 5.4 performance with logging
- PlanetMySQL BlogPost: Looking at MySQL 5.4 - IO bound benchmarks
- Live Webinar: MySQL 5.4 Benchmarks In-Depth (May 21, 2009)
- Live Webinar: MySQL Performance Tuning Step-by-step (May 21, 2009)
- Live Webinar: What's New in the Next Generation of MySQL Cluster? (EMEA) (May 27, 2009)
- Live Webinar: Cloud Computing For DBAs - Presented By MySQL and Zmanda (June 9, 2009)
- Live Webinar: Open Source Memcached Tools Overview by Gear6 (June 10, 2009)
- Live Webinar: For ISVs: Faster Data Reduction and Smoothing for Analysis & Archival in MySQL (June 11, 2009)
- Live Webinar: Developing and Deploying SaaS Applications with MySQL and LongJump (June 11, 2009)
- Live Webinar: Improve Application Performance with the MySQL Enterprise Monitor and the MySQL Query Analyzer (June 30, 2009)
- On-demand Webinar: Mission Critical Coverage with MySQL Enterprise Technical Services
- Calling ISVs: Certify Your Application with MySQL Cluster Carrier Grade Edition Today
- White Paper: MySQL and Kickfire - Delivering the Best of all Worlds for Today's Analytics
- Live Webinar: High Performance, Low Cost - Scaling Reporting and Analytics for Large Data Volumes (May 26, 2009)
- Live Webinar: SmartScaling MySQL in the Internet Data Center (May 27, 2009)
- Live Webinar: Faster and More Scalable MySQL Reporting and Analytics with Kickfire (June 4, 2009)
The MySQL Conference and Expo 2009 was a huge success. MySQL engineers and experts from leading organizations like Google, craigslist, TicketMaster and the tech team from Barack Obama's Online Presidential Campaign shared their MySQL best practices, scalability & performance tuning tips and lessons learned with over 2000 attendees from all over the world.
Are you a Commercial Software Developer or Product Manager? Please help us understand how the MySQL team can provide best value to you by taking a 3 minute survey on your product's development cycle. And, you'll be entered to win a $150 Amazon.com gift certificate.
The MySQL Query Analyzer Lunch-n-Learn Program is designed to be a fun and educational event for your technical team. The goal of this training is to help your team understand how they can leverage the new MySQL Query Analyzer to improve application performance. And the MySQL experts will bring lunch!
Learn More and Register Now » (http://www.mysql.com/news-and-events/lunch-n-learn/quan.html)
Case Study: MySQL Delivers 50% Lower Database Costs as NetHawk Develops Network Monitoring Solutions
With a mission to enhance the quality and user experience of converged communication networks, NetHawk provides state-of-the-art software-based network testing and monitoring tools and services for telecoms and VoIP equipment manufacturers and operators.
NetHawk evaluated proprietary database products, but found MySQL delivered higher levels of performance at 50% lower cost, while meeting stringent availability requirements.
Read the Case Study » (http://www.mysql.com/why-mysql/case-studies/nethawk-develops-network-monitoring-solutions-mysql/)
SonicWALL started using MySQL 5.0 in July 2008 and within just six months of using MySQL, SonicWALL was able to: Lower their cost of goods sold (COGS); Shorten new product time-to-market through the efficiencies they gained in Development, Quality Assurance, Training, and Documentation; and, Reduce the number of trouble tickets they received by over 20%, in addition to other gains.
Live Webinar: 6 Ways to Optimize Performance, Save Time and Lower Risk with a MySQL Enterprise Subscription
Thursday, May 28, 2009 - 10:00am PDT
The MySQL Enterprise subscription provides you with the highest level of technical support for your databases. But, did you know that MySQL Enterprise also includes the MySQL Enterprise Monitor and the MySQL Query Analyzer, which proactively monitors your systems and alerts you on performance issues, security holes, tuning opportunities and expensive code? And did you know that as a subscriber you can start using the Monitor and Query Analyzer now to optimize your application performance and lower your risk of downtime?
MySQL University is a no cost online training program for Sun Engineers, MySQL Community Contributors and anyone who's interested in MySQL development and internals. Sessions are scheduled on Thursdays and usually last for an hour. Upcoming topics include:
- May 28: MySQL Replication - Walk-through of the new 5.1 and 6.0 features (Lars Thalmann, head of MySQL Replication and Backup teams)
- June 4: Boosting Performance With MySQL 5.1 Partitioning (Giuseppe Maxia, head of MySQL Community team)
- June 11: Building MySQL Releases on Unix (Jörg Brühe, MySQL Build team)
- June 18: Architecture of MySQL Backup (Lars Thalmann, head of MySQL Replication and Backup teams)
MySQL Community Server 5.0.81, a new version of the popular Open Source Database Management System, has been released. This release of the MySQL Community Server is based on the MySQL Enterprise Server 5.0.80 code base. Future releases in the MySQL Community Server 5.0 release series will share version numbers with their corresponding MySQL Enterprise Server counterparts.
MySQL Connector/Net 5.2.6, a new version of the all-managed .NET driver for MySQL has been released. This release is of GA quality and is suitable for use in production environments. We have lots of fixes in this release so please review the changelog and see if your favorite bug has been fixed. This version officially supports all versions of MySQL from 4.1 and later.
MySQL Connector/Net 6.0.3, a new version of the all-managed .NET driver for MySQL has been released. This is the first GA release of the new 6.0 connector and introduces several new features and enhancements. This release is approved for use in all scenarios and officially supports MySQL servers 4.1 and higher. New features and improvements include:
- Massive speedups: in many situations it now matches or exceeds the speed of the native C connector
- SQL tokenizing has been improved dramatically
- Implement initial Entity Framework support
- Improved Visual Studio integration
We are proud to announce the release of the third official Beta of MySQL Workbench 5.1. This release is available for all major platforms: OS X, Linux and Windows.
We have fixed more bugs and stabilized the application further. Also the table-editor in Mac version is now included. The binary-packages are available for several different platforms as well as the zipped sources for building workbench yourself.
The MySQL Workbench team would like to announce the availability of the first Alpha release of MySQL Workbench 5.2.
The major new feature in MySQL Workbench 5.2 is the SQL IDE, which offers the ability to edit and execute queries on MySQL servers. The new SQL query editor, based on the Open Source Scintilla text editor component, offers full syntax highlighting and other advanced editing features.
Before we get started, let me say that I always liked being a SQL Server DBA. My database experience started with DB2, then Teradata, followed by Oracle, and then SQL Server (and then a little bit of Sybase after that, followed by MySQL).
This series of tutorials shows the essential steps involved in installing PHP with MySQL extensions mysql, mysqli, and pdo_mysql, and with support for the MySQL native driver for PHP, mysqlnd. The tutorials also provide simple examples to connect, insert, and retrieve data from a MySQL database.
Open source technologies and commodity, carrier-grade hardware can combine to create a highly available, scalable and responsive infrastructure to deploy next-generation communications services. This paper examines a solution stack based on integrating Sun GlassFish Communications Server, MySQL Cluster Carrier Grade Edition database, the OpenSolaris operating system, Sun Netra ATCA blades and Sun open storage products into a carrier-grade solution for converged services - without the traditionally high carrier-grade price.
Read this White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_cluster_deploy_opencge.php)
Whether Service Providers are looking to deploy new Web/Telco 2.0 applications to mobile internet users or consolidating subscriber data within the network to support greater service personalization and targeted advertising, the database plays a key enabling role. In this paper we explore how an open source carrier grade platform architecture is able to cost-effectively meet the communication industry's high availability, scalability and real-time performance requirements.
Read this White Paper » (http://www.mysql.com/why-mysql/white-papers/open-source-carrier-grade-platform-with-mysql-cluster/)
Using industry standard LDAP directories with MySQL Cluster serving as the directory data store, Communications Service Providers and Equipment Manufacturers can embark on initiatives that fully exploit user and network data currently distributed across legacy applications and the network. MySQL Cluster provides real-time performance and carrier-grade availability to a total solution that reduces cost, risk and complexity for large, transaction-intensive directory data sets.
White Paper: MySQL Enterprise Technical and Consultative Support Services Mitigate Risk, Minimize Downtime, Meet SLAs
This paper explores how you can confidently deploy MySQL, the "M" in the open source LAMP stack, as part of an innovative and cost-effective platform ideal for delivering low cost, high-performing, always on, internet-based applications. It provides an overview of MySQL Enterprise, which is comprised of MySQL database and advanced monitoring software that ensures you are running the most up to date version of MySQL at the highest levels of security, performance, and availability. It also provides a deeper dive into the MySQL Enterprise Technical and Consultative support services that are designed to mitigate risk, minimize downtime, and ensure you meet revenue, customer, and end-user Service Level Agreements.
In a nutshell, performance variance is minimal on a properly configured system, as shown in tests on a typical small to medium business level server with MySQL running in a VMware virtualized environment. This document explains how we reached this conclusion by describing the setup, configuration, and results from our testing.
Read this White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_VMware_BestPraticesandPerfGuidev7.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.
Darren L. Oldag
Not so long ago, in a galaxy not very far away... a middle-aged programmer battled to free memory from the dark side of the hibernate query cache. He was successful, or so it seemed. For the query cache memory problems had risen from the ashes - stronger and more bloated than ever ...
MySQL Sandbox is now in Release Candidate status. If no bugs are reported on the latest version (2.0.99f), I will repackage it as 3.0. In addition to the list of features previously announced, I managed to implement another feature that has been in the wish list for a long time, i.e. creating a sandbox from existing binaries, such as the ones installed by a .rpm or .deb package.
The answer is yes - kind of.
Stored procedures are implemented in a MySQL Server and can be used regardless of the storage engine being used for a specific table. One inference from this is that they won't work when accessing the Cluster database directly through the NDB API.
We have an Admin plugin for the MySQL Proxy, but people started asking how to use it. I only found one example, thanks to Giuseppe, but people wanted more.
Attending the MySQL Users Conference in 2006, I had one of the best days of my career. At the morning keynote, my name was called, and I found myself on stage, together with Markus Popp, Roland Bouman, and Rasmus Lerdorf, being awarded a Community Member of the year crystal ball. That day is permanently in my mind as a very fond memory.
I'm happy to announce (bit unofficially) the first (alpha) source code release of MySQL Connector/Python. It's hosted on Launchpad and can be downloaded using the Bazaar client. It's more a preview as I'm still working on it during free time. Please post comments, bug reports, ideas, critics, etc...
If you are using the scripts from the Configurator (and yes, the broken link is now fixed so it is actually possible to get the config package...), and want to tweak your configuration on a started Cluster then you can do like written below.
Although MySQL 5.1 was released in December of 2008, Sun Microsystems isn't wasting any time moving forward with a number of new and exciting enhancements for its next release, MySQL 5.4. The first item of note is that the MySQL Server will be returning to a release early/often paradigm. So, instead of waiting on a full set of previously agreed upon features to be ready, the goal will now be to adhere to time-controlled releases that include all features that are ready by an agreed-upon beta date, with any features not fully 'baked' simply rolling to the next release.
The release of the MySQL 5.4 contains patches which increases the scalability of the MySQL Server. I am planning to blog about those changes in some detail over the next few days. This blog will give an introduction and show what the overall results we have achieved are.
As you may already know, today Sun announces MySQL 5.4. It's a big step forward and I hope you'll have enough time today to follow all blog posts and other interesting related publications!
About a month ago, I published the results of MySQL 5.x performance with logging. The results covered several versions, from 5.0.45 to 5.1.33. Among the conclusions of the post was the consideration that MySQL 5.0.x is faster than MySQL 5.1 in read only operations. I hinted that better results may come for MySQL 5.1. When I wrote that post I had, in fact, an ace up my sleeve, because I had already benchmarked the performance of MySQL 5.4, using the same criteria shown in my previous post.
With a lot of talks around 5.4 I decided to check how it works in our benchmarks. For first shoot I took tpcc-like IO-bound benchmark (100W, ~10GB of data, 3GB buffer_pool) and tested it on our Dell PowerEdge R900 box (16 cores, 32GB of RAM, RAID 10 on 8 SAS 2.5" 15K RPM disks). For comparison I took XtraDB-release5 and 5.0.77-highperf percona release.
Thursday, May 21, 2009 - 3:00pm PDT
Join us for this informative technical webinar presented by performance expert, Allan Packer, Principal Engineer at Sun Microsystems. In this webinar Allan will give an overview of the scalability and performance improvements of MySQL 5.4. This version can yield up to 90% faster response times, and scalability up to 16-way x86 servers and 64-way CMT servers. Allan will also explore in depth, several benchmarks concerning MySQL 5.4, including Sysbench results on CMT and Nehalem systems plus an OLTP workload derived from an industry-standard benchmark.
Thursday, May 21, 2009 - 10:00am PDT
Learn the basic steps the MySQL Consulting pros follow to tune a MySQL database server. Each step will be covered at a high level with one or two of the most critical parameters covered in detail for each step.
Wednesday, May 27, 2009 - 10:00 CET / 11:00 EET
Whether you're racing to introduce a new service, or trying to manage an avalanche of data in real time, your database has to be scalable, fast and highly available to meet ever-changing market conditions and stringent SLAs.
By attending this webinar, you will learn more about the next generation of MySQL Cluster, and how it enables you to deliver 99.999% database availability, with real time performance and linear scalability, while slashing TCO.
Tuesday, June 9, 2009 - 1:00pm PDT
Join us for this informative technical webinar with Jimmy Guerrero, Sr Product Manager - Sun Microsystems and Chander Kant, CEO - Zmanda to learn how to leverage compute and storage clouds for MySQL backed applications. In this presentation we will cover the fundamentals of cloud computing and some tips and tricks when deploying and managing MySQL on the cloud.
Wednesday, June 10, 2009 - 10:00am PDT
Join us for this tools overview for memcached by Ryan Lucio and Rama Chitta, Software Engineers at Gear6, the leading provider of memcached solutions. In this webinar Ryan and Rama will provide an overview of several open source tools for memcached, including: Advanced Reporter, Statsproxy, Brutis, Cacti and Wireshark. In addition to providing an overview of each tool, Ryan and Rama will show how the tools are used and when to use them.
Thursday, June 11, 2009 - 10:00am PDT
ScienceLogic embeds MySQL in its EM7 network management appliances. An installation of EM7 can perform over half a billion database queries daily, storing massive amounts of data for both real-time and trended performance reporting. The product's need for high-scale data handling and storage required solutions to increase efficiency and get to scale. One solution is to utilize data smoothing techniques in MySQL, using "group by".
Thursday, June 11, 2009 - 1:00pm PDT
Join us for this informative webinar with Brian Gerhold, Director of Engineering at Simco Electronics and Pankj Malviya, Founder/CEO of LongJump. In this presentation we'll examine how Simco's development team built a next-generation SaaS application which automated data collection, reporting and compliance leveraging MySQL and the LongJump development platform. Brain will discuss how Simco approached common SaaS application development problems and the solutions that lead to their success.
Live Webinar: Improve Application Performance with the MySQL Enterprise Monitor and the MySQL Query Analyzer
Tuesday, June 30, 2009 - 10:00am PDT
Are you looking for performance tuning opportunities in MySQL?
In this technical webinar, Phil Hildebrand, Database Manager at thePlatform, will talk about how they used the MySQL Enterprise Monitor, the MySQL Enterprise Advisors and the MySQL Query Analyzer to deploy new applications and implement changes to production systems more efficiently. Phil will present these tools from a practical, user-oriented perspective, and also showcase how to achieve significant performance enhancements while reducing troubleshooting time of difficult SQL code issues.
For business and mission critical deployments of MySQL, the MySQL Enterprise subscription offering provides the comprehensive production support, monitoring tools and database software necessary to provide optimal levels of performance, reliability, security, and uptime.
Join this webinar to learn about how the proactive and consultative tools and support included in a MySQL Enterprise subscription can help the most demanding Enterprises and Web properties mitigate risk, minimize downtime, and maintain SLAs.
More MySQL webinars are scheduled and added between each Newsletter edition, so visit our website frequently for the most updated information.
Tel Aviv, Shanghai, Bangkok, Paris
This instructor-led course is designed for students planning on developing applications that make use of MySQL 5.0 and 5.1. This course covers essential SQL statements for data design, querying, and programming. In addition, it will prepare you for the MySQL Developer certification.
Register Now for an Upcoming Date » (http://www.mysql.com/training/workshops/mysql_dev.html)
A dedicated Sun's MySQL consultant will use proven methodologies and expertise in database clustering, replication, fail-over, fault-tolerance and other HA techniques to guide and assist you. Sun's MySQL consultants can assist you who purchase this service with the process of designing, testing, deploying and operating a modern database infrastructure that will help them meet their objectives for performance and high-availability.
Learn More » (http://www.mysql.com/consulting/packaged/high-availability.html)
By certifying your application with MySQL Cluster Carrier Grade Edition, the industry's leading high availability database, you enjoy the following benefits:
- Provide even higher levels of customer assurance that your application can meet the most stringent demands for high availability, performance and scalability
- Increase awareness and visibility of your application among one of the world's largest and most influential software user communities
- Differentiate your product from the competition by offering reduced complexity and integration costs along with faster time to market for your end customers
Learn More » (https://partner-portal.mysql.com/guide/cge_certification.html)
With today's explosion of business data and the urgent need for analytics to tap trends and facilitate rapid decision making, this white paper provides guidance on how to evaluate the many analytic solutions that exist today - from traditional vendors to the very latest approaches.
Tuesday, May 26, 2009 - 1:00pm PDT
Infobright, integrated with MySQL, combines a column-oriented database with a unique Knowledge Grid architecture, which will be detailed in the webinar.
Also, hear how Mavenir, a provider of next generation Mobile core for Voice, Messaging and Rich Communication Suites (RCS), is using Infobright with MySQL to manage massive messaging traffic for its customers on a minimal hardware footprint and at less cost.
Wednesday, May 27, 2009 - 10:00am PDT
Virident has pioneered SmartScaling, a new approach to datacenter management that simplifies scaling, decreases complexity, and conserves capital and power. Virident GreenCloud Servers for MySQL and Memcached represent a fundamentally better building block for building an infrastructure. Come learn how to take advantage of the breakthrough new approach to managing your data center.
Thursday, June 4, 2009 - 10:00am PDT
There is a growing number of MySQL users doing reporting and analytics. With larger data volumes and more users demanding faster query response times, organizations are looking for the best MySQL platform on which to scale their reporting and analytic applications. With a variety of options available, it can be hard to know how to choose. This webinar will give an overview of the choices available and present the benefits of the Kickfire approach.