MySQL Newsletter: August 2009

(0 votes, average: 0 out of 5)

Articles in this newsletter:

Highlights

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

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

Hints & Tips

- 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

Spotlight: MySQL on Microsoft Windows

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

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

- Training: MySQL Performance Tuning (4 Days)
- Consulting: MySQL Architecture and Design (2+ Days)

Partners

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

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

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:
http://dev.mysql.com/librarian/

Read the Article "Introducing the MySQL Librarian":
http://dev.mysql.com/tech-resources/articles/introducing-librarian.html

Read the Tutorial:

http://datacharmer.blogspot.com/2009/07/automating-mysql-librarian-tasks.htm
l

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:
http://twitter.com/mysql_community

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:
http://opensqlcamp.org

Learn More about FrOSCon:
http://froscon.org

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:
http://dev.mysql.com/doc/refman/5.0/en/news-5-0-84.html

Download Now:
http://dev.mysql.com/downloads/mysql/5.0.html

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:
http://dev.mysql.com/doc/refman/5.1/en/news-5-1-37.html

Download Now:
http://dev.mysql.com/downloads/mysql/5.1.html

Read the Documentation:
http://dev.mysql.com/doc/refman/5.1/en/index.html

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:
http://dev.mysql.com/workbench/?page_id=49

Download Now:
http://dev.mysql.com/downloads/workbench/5.2.html

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:
http://dev.mysql.com/doc/refman/5.1/en/connector-net-news-5-2-7.html

Download Now:
http://dev.mysql.com/downloads/connector/net/5.2.html

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:
http://dev.mysql.com/doc/refman/5.1/en/connector-net-news-6-1-0.html

Download Now:
http://dev.mysql.com/downloads/connector/net/6.1.html

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:
http://dev.mysql.com/doc/refman/5.1/en/cj-news-5-1-8.html

Download Now:
http://dev.mysql.com/downloads/connector/j/5.1.html

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

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.ph
p

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:

http://www.databasejournal.com/features/mysql/article.php/3828566/article.ht
m

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

http://johanandersson.blogspot.com/2009/08/optimize-table-on-cluster-revisit
ed.html

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:

http://ronaldbradford.com/blog/understanding-different-mysql-index-implement
ations-2009-07-22/

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:

http://www.clusterdb.com/mysql-cluster/setting-up-mysql-asynchronous-replica
tion-for-high-availability/

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:
http://blog.wl0.org/2009/07/possible-improvements-to-mysql-administration/

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:

http://blog.some-abstract-type.com/2009/07/disabling-binary-logging-when-res
toring.html

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:
http://dev.mysql.com/workbench/?p=271

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

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.ph
p

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:

http://lstigile.wordpress.com/2009/06/15/mysql-windows-install-troubleshooti
ng/

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:
http://www.mysql.com/news-and-events/web-seminars/index.html

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

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.

Magento Developers	Ecommerce Website Developers	Cakephp Services	SEO Services	Opensource Developers	VirtueMart Developers
Joomla Developers	Social Network Developer	Android Developer	Shoppingcart Programmer	Best Website Development	Codeigniter Services
Drupal Developers	Zend Framework Services	Web Testing	Symphony Services	Wordpress Customization	Manual Tester
Website Development	Web Design & Development	Website Designing	Joomla Extensions	Joomla Components	WorkFlow experts