MySQL Newsletter August 2009

Articles in this newsletter:

Spotlight: MySQL on Microsoft Windows

Events

Live Webinar: Tuning and Optimizing MySQL for Maximum Performance (Thursday, September 03, 2009)
Live Webinar: Advanced Techniques for High Traffic Sites (Thursday, September 17, 2009)
Live Webinar: For ISVs - Architecting Embedded Databases for High Performance Applications (Wednesday, September 23, 2009)
Live Webinar: High Availability Architectures for Online Applications (Tuesday, September 29, 2009)

Training, Consulting, & Certification

Highlights

The MySQL Librarian is Here - Find and Add MySQL Content!

We're pleased to announce the MySQL Librarian, a collection of community-generated and cross referenced content related to MySQL. It's a place where the community collaboratively builds and maintains MySQL content. Everyone is encouraged to add articles, presentations, videos, and pictures to the librarian.

Visit the MySQL Librarian »

Read the Article "Introducing the MySQL Librarian" »

Read the Tutorial »

Twitter: Follow the MySQL Community on Twitter!

In addition to MySQL, the MySQL Community has a separate Twitter account, with more than 1,000 followers. This account listens to and interacts with the MySQL community, by answering requests, announcing community related information, and giving advice. Join this big family by following the MySQL Community Twitter account.

Follow MySQL Community on Twitter »

Meet MySQL Experts at OpenSQL Camp Europe (August 22-23, Germany)

The OpenSQL Camp Europe is being held in Sankt Augustin, Germany, in conjunction with FrOSCon on August 22 and 23. Many MySQL and open-source database talks will be presented, so if you are in Europe, it's definitely worth a visit. FrOSCon is one of the most charming and well organized open source events in Europe.

Learn More about OpenSQL Camp »

Learn More about FrOSCon »

Case Study: MySQL Helps Simply Accounting by Sage Increase Revenue, Market Share, and Customer Satisfaction

The Sage Group plc, is one of the world-wide market leaders in accounting and business management software and services for small and medium-sized businesses (SMBs), with over 5.8 million customers. In the Canadian market, Simply Accounting by Sage is the established market share leader in the small to mid-size business accounting software market with 54% of the Canadian retail market.

MySQL is now the new Sage database standard for Sage's small-to-medium targeted products. At present this includes Simply Accounting by Sage in Canada, Sage 50 HR in the UK and Sage's GS product line in Germany.

Read this Case Study » (http://www.mysql.com/why-mysql/case-studies/mysql_cs_sage.php)

Case Study: TweetMeme Manages Explosive Growth with MySQL Enterprise

Like many social network products, TweetMeme was initially developed in PHP using the MySQL open source database. With Twitter users growing at a month-over-month rate of approximately 82% for the first half of 2009, TweetMeme needed to manage incredible scalability demands being placed upon its database infrastructure. The nature of real-time search also meant that to stay competitive, TweetMeme needed to be highly available, offer lightning fast service delivery capability, while ensuring that management and administration costs didn't grow out of control.

Read this Case Study » (http://www.mysql.com/why-mysql/case-studies/mysql_cs_Tweetmeme.php)

Live Webinar: Introduction to MySQL Scale Out and Replication Services

Tuesday, August 18, 2009 - 10:00am PDT

Join us for the first in a series of 4 webinars that will explore 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 this first installment we look at the basics for deploying MySQL for a scalable online application. Whether you are already using MySQL for your online application or considering it for a new project, register today to learn how you can make best use of the world's most popular database for online applications.

Live Webinar: MySQL at Clickability - Growing Small and Mid-Sized Businesses Fast on MySQL

Thursday, August 27, 2009 - 10:00am PDT

MySQL is a proven business-critical database that provides incredible scale and performance at a significantly lower total cost of ownership. At the same time, MySQL is also easy to deploy, easy to use, and requires low administration which makes it ideal for small and mid-sized businesses.

In this informative webinar, Jeff Freund, CTO and Co-Founder at Clickability, will discuss how the company builds its core application on MySQL and grows from a small start-up to a global leader in on demand Web Content Management. You'll also learn from Alex Roedling, Sr. MySQL Product Marketing Manager at Sun Microsystems, regarding MySQL's benefits and how it can be leveraged to build a scalable, reliable and high performance platform in your fast-growing business.

New Product Releases

New Release of MySQL Server 5.0.84 (GA)

MySQL Community Server 5.0.84, 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.

View the complete list of changes »

Download Now »

New Release of MySQL Server 5.1.37 (GA)

MySQL Community Server 5.1.37, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.37 is recommended for use on production systems.

View the complete list of changes »

Download Now »

Read the Documentation »

New Release of MySQL Workbench 5.2.2 (Alpha)

The MySQL Workbench team announces the availability of version 5.2.2 - the 3rd alpha release - of our database development tool. Since the last alpha release, several bugs have been fixed and fixes from the 5.1 branch were also included.

View the complete list of changes »

Download Now »

New Release of MySQL Connector/Net 5.2.7 (GA)

MySQL Connector/Net 5.2.7, 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 many 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.

View the complete list of changes »

Download Now »

New Release of MySQL Connector/Net 6.1.0 (Alpha)

MySQL Connector/Net 6.1.0, a new version of the all-managed .NET driver for MySQL has been released. This is an alpha release and is intended to introduce you to the new features and enhancements we are planning. This release should not be used in a production environment. Additional functions include:

Support for native output parameters
Session State Provider
Website Configuration Dialog

View the complete list of changes »

Download Now »

New Release of MySQL Connector/J 5.1.8 (GA)

MySQL Connector/J 5.1.8, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL. Version 5.1.8 is suitable for use with any MySQL version, including version 4.1, 5.0, 5.1 and the 5.4 performance release.

View the complete list of changes »

Download Now »

Hints & Tips

White Paper: Open Databases White Paper - MySQL Provides Scalability, Reliability & Enterprise Support at a Lower Cost

Enterprises are looking for the best, most cost-effective way to manage the ever-increasing amount of data, an ever-growing pool of users, and unrelenting demands for high availability. As proprietary database systems have grown increasingly complex with features that many companies don't need, they have also become harder to manage and more expensive in terms of upgrades and staffing, training, and support. The Sun MySQL database delivers the scalability and features that companies need but with less complexity and lower costs than proprietary systems.

Read this White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_open_online_database.php)

White Paper: Guide to Using Open-source Software to Develop Web Applications

As enterprises struggle to develop and deliver new and more dynamic services to more people, they must do so with severe budget constraints. They need a Web infrastructure that can enable higher developer productivity at a lower cost. While many enterprises are looking to open-source software to meet these complex requirements, managing and supporting a range of disparate software solutions is a huge challenge for the IT staff.

Read this White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_open_web_platform.php)

White Paper: MySQL Enterprise for Small and Mid-sized Businesses

This paper explores the database, monitoring and support components of MySQL Enterprise and how Small and Mid-Sized businesses under pressure to "do more with less" can confidently deploy it as part of a cost-effective and low-maintenance platform, ideal for delivering Internet-based applications for fast-growing businesses.

Read this White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_Enterprise_SMB.php)

Article: MySQL - Five More Dials To Turn

Sean Hull

Last month we talked about some things to set and tune in a new MySQL database installation. We touched on connections, query cache, temp tables, session memory, and the slow query log. This second part in the series hits on some other very important things to tune in a new MySQL database.

Read this Article »

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 »

Submit Your Blog Feed »

PlanetMySQL Blog: OPTIMIZE TABLE on MySQL Cluster (revisited)

Johan Andersson

Before, OPTIMIZE TABLE hardly freed up any pages and to defragment you had to do a rolling restart of the data nodes. Now, there is only a 2% discrepancy between OPTIMIZE TABLE and doing a rolling restart. This is great stuff. This fix will make into MySQL Cluster 6.3.26 and 7.0.7.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Understanding Different MySQL Index Implementations

Ronald Bradford

It is important to know and understand that while indexing columns in MySQL will generally improve performance, using the appropriate type of index can make a greater impact on performance.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Setting up MySQL Asynchronous Replication for High Availability

Andrew Morgan

MySQL replication is often positioned as a solution to provide extra throughput for your database. What tends to be overlooked is how it can be used to provide high availability (HA) - no matter how much redundancy you have at a local level, your system remains at risk from a single catastrophic failure - loss of power, earthquake, terrorist attack etc.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Possible Improvements to MySQL Administration

Simon Mudd

One thing you learn when you start to manage several servers is that life is easier if things are done the same way. I manage a few MySQL database instances on a few different hosts and here are a list of some things which I think could do with improvement.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Disabling binary logging when restoring a MySQL dump

Geert JM Vanderkelen

There is a cool option for mysqlbinlog for disabling the binary log when doing recovery using binary logs, namely --disable-log-bin. How, one would think it is also available for something like mysqldump or even the mysql CLI?

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Auto-create relationships for MyISAM tables in MySQL Workbench

Alfredo Kojima

Over a chat on the #workbench IRC channel, Collin Cusce has written a handy little Lua script to automatically create relationships (through foreign keys) for his reverse engineered database.

Read the PlanetMySQL BlogPost »

Spotlight: MySQL on Microsoft Windows

White Paper: A Visual Guide to Installing MySQL on Windows

This guide is meant to make getting started with MySQL easily for Windows developers, system administrators and Microsoft SQL Server DBAs that are new to MySQL. This paper will guide you through the steps and tools needed to get up and running quickly with MySQL on Windows using familiar terms, comparisons, and language.

Read this White Paper » (http://www.mysql.com/why-mysql/white-papers/visual_guide_to_installing_mysql_windows.php)

White Paper: A Visual Guide to Microsoft SQL Server 2008 Reporting Services and MySQL

For many years, Microsoft Windows has been the most popular development platform and second most popular production platform for organizations developing MySQL applications. We also found that roughly one in three MySQL Enterprise shops also made use of Microsoft SQL Server. In this paper we will visually show you how to connect MySQL into some of the existing tools that the SQL Server DBA will already be familiar with.

Read this White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_MSReporting_Services.php)

White Paper: Guide to MySQL Embedded Server for Microsoft Windows

This Guide outlines the reasons why MySQL on Windows continues to be a popular choice for independent software vendors, original equipment manufacturers, and hosting providers. In addition, it provides tips and links to various resources on how to develop and optimize MySQL applications on Windows.

Read this White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_embedded_win_guide.php)

PlanetMySQL Blog: MySQL Windows Install Troubleshooting

Lee Stigile

If you're having trouble installing MySQL 5.1 on a Windows server, I'd recommend the following process. Don't skip the first steps that describe the uninstall and removal of the previous install as this seems to clear up most issues.

Read the PlanetMySQL BlogPost »

Live Webinar: For ISVs - What's New in MySQL Connector/NET 6.1?

Tuesday, September 15, 2009 - 10:00am PDT

MySQL Connector/Net 6.1.0 is the latest version of the all-managed .NET driver for MySQL. In this Web seminar, Reggie Burnett, the creator of MySQL Connector/NET 6.1, will introduce you to its new features and enhancements and explain how and when to use them for optimal results with your Windows applications.

Events

Live Webinar: Tuning and Optimizing MySQL for Maximum Performance

Thursday, September 03, 2009 - 10:00am PDT

Join us for the second of our 4 part webinar series exploring the different aspects of using MySQL as the backend database for online applications.

For our second installment we will look at performance tuning. You will get expert insight and learn best practices to help you identify those areas of database and application design that will give you the greatest benefits for performance.

Live Webinar: Advanced Techniques for High Traffic Sites

Thursday, September 17, 2009 - 10:00am PDT

Join us for the 3rd of our 4 part webinar series exploring the different aspects of using MySQL as the database for 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.

We will discuss guidelines, best practices and customer examples in the following areas: caching services such as memcache, session management, intelligent load balancing via MySQL Proxy, use of Cloud services for on demand scalability, and using MySQL Enterprise and the new MySQL Query Analyzer.

Live Webinar: For ISVs - Architecting Embedded Databases for High Performance Applications

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. They will also help you find the right answers to important architecture choices that can impact your application's performance.

Live Webinar: High Availability Architectures for Online Applications

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 use cases for implementing MySQL Replication, MySQL Cluster, Distributed Replicated Block Device (DRBD), and other high-availability technologies

Also covered will be the fundamentals of how these technologies work and how they can be combined to create a more scalable and highly available database infrastructure. Several case studies will be presented to show how these technologies have been implemented in the real world.

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 MySQL Webinars »

Training, Consulting, and Certification

Training: MySQL Performance Tuning (4 Days)

Paris, Nashville, Sao Paulo, Portland

The MySQL Performance Tuning course is designed for Database Administrators and others who wish to monitor and tune MySQL. This course will prepare you with the skills needed to utilize tools for monitoring, evaluating and tuning. You will evaluate the architecture, learn to use the tools, configure the database for performance, tune application and SQL code, tune the server, examine the storage engines, assess the application architecture, and learn general tuning concepts.

Consulting: MySQL Architecture and Design (2+ Days)

A dedicated MySQL certified consultant will work closely with you to review your database application plans and provide an analysis of how to architect them for current and future requirements. Sun's MySQL consultants can provide expertise in the following areas:

Web Applications
Online Transaction Processing (OLTP)
Data Warehousing
Online Analytical Processing (OLAP)
High Availability
Load Balancing
Embedded Systems
Search Applications

Learn More » (http://www.mysql.com/consulting/packaged/architecture.html)

Partners

Press Release: MySQL on the optimized Joyent Cloud is 3x faster than Amazon EC2!

Joyent, the industry leading Enterprise-Class Cloud Computing provider is excited to announce the launch of the Joyent Virtual Appliance for MySQL! The Joyent Virtual Appliance for MySQL is pre-configured to maximize the database's performance on Joyent's powerful, secure and stable virtualization technology. The most recent performance benchmarks have demonstrated that the Joyent Virtual Appliance for MySQL can deliver 3 times the number of Transactions per Second or more than comparable deployments of XEN based clouds, such as Amazon's EC2.

Read the Full Press Release » (http://www.mysql.com/news-and-events/generate-article.php?id=1625)

Learn More about MySQL Enterprise on the Joyent Cloud » (http://www.mysql.com/products/enterprise/joyent.html)

Live Webinar: Kimball Group Data Warehousing Educational Webinar Series - Part II: Dimensional Modeling 101

Wednesday, September 9, 2009 - 10:00am PDT

According to a recent Aberdeen Group report, top-performing companies deploy business intelligence (BI) at a rate of 2.5x more than their peers. The foundation for any successful BI deployment is the data warehouse (DW). Understanding how to properly design and deploy a DW is therefore key.

In this second webinar presented by Kickfire and Sun, Joy Mundy of The Kimball Group explains the fundamentals of dimensional modeling - the logical design technique for building data warehouses.