MySQL Newsletter October 2008

Articles in this newsletter:


New Product Releases

Hints & Tips


Training, Consulting & Certification



MySQL Customer Conference 2008

Paris, November 19

A day packed with technical sessions, customer experiences and all round MySQL goodness! You will be able to learn, improve your skills and network with other MySQL users.

Whatever your experience with MySQL, the MySQL conference will help you can get the most out of MySQL technology, and from the company now behind it, Sun Microsystems.

Don't miss this once a year opportunity!

Register Now » (

MySQL Conference & Expo 2009 - Last Chance to Submit a Proposal

The MySQL Conference & Expo 2009, April 20-23, 2009 in Santa Clara, CA, brings over 2,000 open source and database enthusiasts together to harness the power of MySQL and celebrate the huge MySQL ecosystem. Take an active role in shaping the future of MySQL and related open source technologies by leading sessions and tutorials at the next MySQL Conference & Expo.

Submit a Proposal (Deadline Oct 22, 2008) »

MySQL University - Training on MySQL Development & Internals

MySQL University is a no cost training program for Sun Database Group Engineers, MySQL Community Contributors and anyone who's interested in MySQL development and internals. Sessions are run via voice stream and IRC feedback channel and usually last for one hour. Topics include MySQL Optimizer, Using Memcached with MySQL, Low-level locking in mysqld and InnoDB and much more.

For more information, visit »

White Paper: Web 2.0 Lessons for Communications Service Providers

In this two part whitepaper we compare the approaches and attitudes of the Web 2.0 industry and the Communications industry, as well as outline the changes that the Communications Service Providers and Telecom Equipment Manufacturers must embrace if they want to stay competitive and relevant in the new converged marketplace.

Read the White Paper » (

Live Webinar: Using Microsoft ADO.NET Entity Framework with MySQL

Tuesday, November 4, 2008 - 10:00am PST

In this new web seminar you'll learn about the new Entity Framework and how you can access these and other benefits with MySQL:

  • Develop your application against SQL Server and then switch it to MySQL with zero code changes
  • Optimize your database schema without requiring any code changes in your application
  • Use LinQ syntax for type safety in your applications

Register for this Webinar »

Case Study: KACE Deliver Mission-Critical Systems Management Solution

KACE is the leading systems management appliance company whose award-winning KBOX family of appliances provide PC and Server Lifecycle Management for mid-sized organizations. KACE uses MySQL in all of its appliances to provide the same ease-of-use, comprehensive capabilities, and low cost that its customers rely on their KBOX products to deliver.

Read the Case Study » (

Sun Startup Essentials - Get Your Startup off the Ground Fast

Sun Startup Essentials is an exclusive program designed to help startups get their business off the ground. If your company has been in business less than 6 years and has fewer than 150 employees, we can offer you the following benefits:

  • VC Connect, which gives you the opportunity to connect with interested investors
  • Deeply discounted servers certified for Linux, Windows, and Solaris OS
  • No cost technical advice on hardware and OS from Sun engineers
  • No cost web-based training on Solaris OS and GlassFish application server
  • Special pricing on MySQL Enterprise Gold and MySQL Enterprise Unlimited

Learn more »

New Product Releases

New Release of MySQL Workbench OSS 5.1.3 for Linux (Alpha)

Thanks again for the input and contributions we received since the last alpha build. We have incorporated fixes for building on other distros, cleaned up the source code and prepared a Ubuntu-repository for easy installing via apt package management. Note that we currently only offer i386 binary packages, if you need a package for some other architecture, please build it from sources.

Learn more »

Hints & Tips

Documentation: Browsing the MySQL Documentation by Topic

On the MySQL documentation team, we've been discussing how to split it into easier to digest portions. But a real split doesn't seem the best thing to do, so we've decided to make use of our Arbitrary Docs System that allows to create arbitrarily compiled documents from the MySQL Manual. That system, called Arby for short, was written by MC Brown, and creates "dynamic" excerpts from our documentation sources, rather than static copies, thus those excerpts are always as up to date as the complete Manual.

On the MySQL Documentation Library page we've added a table with documents that serve the information needs of specific target groups, such as database administrators or developers.

Learn More »

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 MySQL, including technical tips and best practices.

Visit PlanetMySQL »

Submit Your Blog Feed »

PlanetMySQL Blog: Online Backup - Encryption

Peter Gulutzan

A new addition inside the new "MySQL Online Backup" feature is encryption. Australian Senior Software Engineer Stewart Smith has already mentioned it a few months ago in his blog. There's a preview that you can download on the online backup pages. Probably it will be part of MySQL-6.0 source downloads soon. I've extract some paragraphs from what I wrote in a non-public worklog task, WL#4271.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: A Bunch of Great Strategies for Using Memcached and MySQL Better Together

Todd Hoff

MySQL hosted two excellent webinars (referenced below) on the subject of how to deploy and use memcached. The star of the show, other than MySQL of course, is Farhan Mashraqi of Fotolog.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: MySQL Multi-Master - Single-Slave - Replication

Oli Sennhauser

One of the features that make MySQL so great is its easy replication set-up. If you are experienced and know-how to do it, it takes you about 15 minutes to set-up a slave. From time to time some customers are asking for the other way: Many masters replicating to one slave (which is also called multi-source replication).

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: Success with OpenSolaris + ZFS + MySQL in production!

Don MacAskill

There's remarkably little information online about using MySQL on ZFS, successfully or not, so I did what any enterprising geek would do: Built a box, threw some data on it, and tossed it into production to see if it would sink or swim.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: Been too long in coming, more MySQL SSD benchmarks!

Matt Yonkovit

I presented these at an internal MySQL professional services meeting about a month ago - its mostly a hodge podge of various benchmarks - but enjoy! The big difference in these benchmarks vs the other benchmarks is I am testing on the memoright GT drive, which is supposed to be one of the fastest SLC drives out their currently. Lets get right too it.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: Test application for MySQL High Availability (HA) Set-up

Oli Sennhauser

When I set-up a MySQL HA environment for customers I usually do some final fail over tests after configuring the whole beast. To check if the application behaves like expected I always run my little test application ( from the server(s) where the customers application runs. It displays "graphically" how the application behaves and you can show to the customer immediately what is going on...

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: Upgrade from MySQL Cluster 6.2 to 6.3

Johan Andersson

Is it possible to upgrade from MySQL Cluster 6.2 to MySQL Cluster 6.3? Of course! Can it be done online? Sure! Here is how!

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: Preparing for Open SQL Camp

Giuseppe Maxia

The Open SQL Camp will take place in Charlottesville, VA, USA, on November 14, 15, and 16. Attendees are requested to register in the event's Wiki, and if you are interested in presenting something, there is a mailing list to discuss your intended topics.

Read the PlanetMySQL Blogpost »


Live Webinar: Better Performance, Development, and Installation with MySQL Embedded Server

Tuesday, October 21, 2008 - 10:00am PST

In this technical webinar you will learn how to shorten your commercial application's development time, improve its performance, and eliminate the need for any customer database installations with MySQL Embedded Server.

We will cover the following topics:

  • Cross-platform development for Windows, Linux, Solaris, and Mac
  • Integration with Java, .Net, and other languages
  • Choosing a MySQL storage engine
  • Silently installing the MySQL server and clients with your application
  • Designing and modeling a database using MySQL Workbench

Register for this Webinar »

Live Webinar: Troubleshooting Performance Issues and Managing Backup/Recovery with MySQL Enterprise and Zmanda Recovery Manager

Wednesday, November 19, 2008 - 10:00 am PST

Are you experiencing pain points around diagnosing and fixing performance problems related to poorly performing SQL code? Do you have a data backup and recovery plan that ensures data availability and integrity in case of accidental data loss or destruction?

Join Rob Young, Senior MySQL Enterprise Product Manager and TK Krishnamurthy, Vice President, Services, Support and Operations from Zmanda as they discuss the benefits of using MySQL Enterprise - including the new Query Analyzer - and backup/recovery with Zmanda Recovery Manager for MySQL to keep your MySQL systems high performing and safeguarded.

Register for this Webinar »

Training, Consulting, and Certification

Consulting: MySQL Developer (4+ Days)

A dedicated MySQL certified consultant will work closely with your team to:

  • Analyze your current database application
  • Analyze your database requirements
  • Identify potential issues and limitations
  • Benchmark, load test, and optimize critical SQL queries
  • Help them implement best practices and recommend tools for developing your database infrastructure

Learn More » (

Training: MySQL High Availability (3 Days)

Paris, Cupertino, London, Singapore

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 » (


IBM: Live Webinar, The Power of Open Development Tools and Applications

Tuesday, October 28, 2008 - 11:00am PST

This webinar session is designed to help IBM i application developers learn:

  • How the DB2R Storage Engine for MySQL opens data to RPG and DB2 Web Query.
  • How to bring information from your IBM i applications to the web with PHP.
  • To deploy open source applications on i with PHP and MySQL.
  • To leverage open source applications while simplifying data management.

To Register, click on the "Enroll Now" for "IBM Power of i Webcast Series". Select the second series called "The Power of Open Development Tools and Applications" »