MySQL Newsletter August 2009
Articles in this newsletter:
- The MySQL Librarian is Here - Find and Add MySQL Content!
- Twitter: Follow the MySQL Community on Twitter!
- Meet MySQL Experts at OpenSQL Camp Europe (August 22-23, Germany)
- Case Study: MySQL Helps Simply Accounting by Sage Increase Revenue, Market Share, and Customer Satisfaction
- Case Study: TweetMeme Manages Explosive Growth with MySQL Enterprise
- Live Webinar: Introduction to MySQL Scale Out and Replication Services (Tuesday, August 18, 2009)
- Live Webinar: MySQL at Clickability - Growing Small and Mid-Sized Businesses Fast on MySQL (Thursday, August 27, 2009)
- New Release of MySQL Server 5.0.84 (GA)
- New Release of MySQL Server 5.1.37 (GA)
- New Release of MySQL Workbench 5.2.2 (Alpha)
- New Release of MySQL Connector/Net 5.2.7 (GA)
- New Release of MySQL Connector/Net 6.1.0 (Alpha)
- New Release of MySQL Connector/J 5.1.8 (GA)
- White Paper: Open Databases White Paper - MySQL Provides Scalability, Reliability & Enterprise Support at a Lower Cost
- White Paper: Guide to Using Open-source Software to Develop Web Applications
- White Paper: MySQL Enterprise for Small and Mid-sized Businesses
- Article: MySQL - Five More Dials To Turn
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: OPTIMIZE TABLE on MySQL Cluster (revisited)
- PlanetMySQL Blog: Understanding Different MySQL Index Implementations
- PlanetMySQL Blog: Setting up MySQL Asynchronous Replication for High Availability
- PlanetMySQL Blog: Possible Improvements to MySQL Administration
- PlanetMySQL Blog: Disabling binary logging when restoring a MySQL dump
- PlanetMySQL Blog: Auto-create relationships for MyISAM tables in MySQL Workbench
- White Paper: A Visual Guide to Installing MySQL on Windows
- White Paper: A Visual Guide to Microsoft SQL Server 2008 Reporting Services and MySQL
- White Paper: Guide to MySQL Embedded Server for Microsoft Windows
- PlanetMySQL Blog: MySQL Windows Install Troubleshooting
- Live Webinar: For ISVs - What's New in MySQL Connector/NET 6.1? (Tuesday, September 15, 2009)
- 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)
- Press Release: MySQL on the optimized Joyent Cloud is 3x faster than Amazon EC2!
- Live Webinar: Kimball Group Data Warehousing Educational Webinar Series - Part II: Dimensional Modeling 101 (Wednesday, September 9, 2009)
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.
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.
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.
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/sage-increase-revenue-market-share-mysql/)
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/tweetmeme-manages-explosive-growth-with-mysql-enterprise/)
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.
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.
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.
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.
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.
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.
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
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.
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)
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)
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)
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.
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.
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.
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.
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.
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.
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?
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.
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/a-visual-guide-to-installing-mysql-on-windows/)
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/guide-to-microsoft-sql-server-2008-reporting-services-mysql/)
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/guide-to-mysql-embedded-server-for-microsoft-windows/)
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.
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.
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.
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.
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.
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.
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.
Register Now for an Upcoming Date » (http://www.mysql.com/training/courses/performance_tuning.html)
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)
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.