MySQL Newsletter December 2009

Articles in this newsletter:


New Product Releases

Hints & Tips


Training, Consulting, & Certification



Case Study: Symantec Benefits from MySQL Embedded Server's Rock-Solid Quality and Low Administrative Costs For Over Six Years

Symantec is one of the largest software companies in the world and a global leader in providing security, storage, and systems management solutions. Symantec chose to use MySQL Embedded Server in its Brightmail product-line because, after looking at the leading commercial and open source databases, they found that MySQL Embedded Server provided both the best functionality and price point.

Read the Case Study » (

Case Study: Telenor Powers its Next Generation Mobile Broadband Services with MySQL Cluster

Telenor is an international provider of high quality mobile communications services to customers in twelve markets across Asia and Europe. Telenor is also a leading provider of fixed-line and media services to the Scandinavian countries. Telenor's Nexus platform provides IP management and authentication for user access and MySQL Cluster is used to store all IP leases, subscriber service configurations, entitlements and provisioning.

Read the Case Study » (

Press Release: MySQL Saves Cashpoint an Estimated Half-Million Euros per Year

Sun Microsystems today announced Cashpoint, the Austrian betting and gaming company, has selected Sun's MySQL™ database to manage its customer, Web, and results data. In order to protect its systems' high-availability, Cashpoint uses both a MySQL Enterprise™ Unlimited subscription and the MySQL Cluster database product. Employing an enterprise-wide MySQL Enterprise subscription along with MySQL Cluster contributes to considerable cost savings for the company.

Read the Press Release » (

White Paper: Guide to Optimizing Performance of the MySQL Cluster Database

This guide explores how to tune and optimize the MySQL Cluster database to handle diverse workload requirements. It discusses data access patterns and how to build distribution awareness into applications, before exploring schema and query optimization, tuning of parameters and how to get the best out of the latest innovations in hardware design.

Read the White Paper » (

Live Webinar: Windows Server Failover Clustering with MySQL

Thursday, December 17, 2009 10:00 PST

In this presentation we will explore the benefits of leveraging Microsoft Windows 2008 Server Failover Clustering with MySQL. We will also cover step by step, how to get started installing and configuring Failover Clustering. Finally, we will look at best practices concerning MySQL storage engine selection and behaviors with Failover Clustering.

Register Now »

Java & MySQL Webinar Series

Java is the number one most popular language for developing MySQL applications according to our most recent Annual MySQL Survey. The Java & MySQL Webinar Series features Java and MySQL sharing their best practices around developing, scaling and tuning MySQL applications.

Upcoming Java and MySQL Webinars »

On Demand Java and MySQL Webinars »

Other Java and MySQL Resources »

Upcoming MySQL University Sessions

MySQL University is a free educational online program for engineers and developers who are interested in MySQL development and internals. MySQL University sessions are open to anyone, not limited to Sun employees. Sessions are recorded with slides and audio, so if you can't attend the live session you can review the recording anytime after the session.

Learn More and View Upcoming Sessions »

To attend a MySQL University session »

Take the MySQL Cluster Community Survey

If you use MySQL Cluster then now's your chance to influence the product roadmap. All information you provide will be kept confidential and will only be reported on in aggregate form.

Take the Survey »

New Product Releases

New Release of MySQL Cluster 7.0.9 (GA)

MySQL Cluster 7.0.9 GA binaries have been released. MySQL Cluster is a real-time open source transactional database designed for fast, always-on access to data under high throughput conditions.

View the complete list of changes »

Download Now »

MySQL Cluster 7.0 Evaluation Guide » (

New Release of MySQL Community Server 5.0.88 (GA)

MySQL Community Server 5.0.88, 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 Connector/NET 6.1.3 (GA)

MySQL Connector/Net 6.1.3, a new version of the all-managed .NET driver for MySQL has been released. This is our latest GA release and is suitable for use in all scenarios against servers ranging from version 4.1 to 5.4!

View the complete list of changes »

Download Now »

New Release of MySQL Connector/MXJ 5.0.11 (GA)

MySQL Connector/MXJ 5.0.11 is a Java utility package for deploying and managing a MySQL RDBMS. The 5.0.11 version includes MySQL 5.1.40 server community binaries and related resources for the following platforms:

  • Linux x86, x86_64
  • Mac OS X ppc, x86, x86_64
  • Windows XP/2K/NT/Vista/2008/7 x86, x86_64
  • SunOS sparc, x86, x86_64

Platforms can easily be added or removed from: mysql-connector-mxj-gpl-5-0-11-db-files.jar

View the complete list of changes »

Download Now »

Hints & Tips

Article: Using MySQL Cluster in Sun's Virtual Desktop Infrastructure

Sun Virtual Desktop Infrastructure (VDI3) is a desktop virtualization technology that provides virtual desktop access, brokering, and hosting, enabling Windows, OpenSolaris, or Linux virtual desktops. These desktops can be accessed by using existing PCs, Macs or thin clients such as Sun Ray.

Read the Article »

White Paper: MySQL Cluster for Presence & Location-Based Services

This whitepaper explores the different types of services that can take advantage of location and presence awareness, and considers their unique requirements for data management. A solution is then presented, based on MySQL Cluster, that allows operators to fully leverage the market opportunity and differentiation presented by these new services.

Read the White Paper » (

White Paper: Virtualization for MySQL on the VMware® Platform: Using VMotion, DRS, HA, and FT

In this paper, we explore using MySQL with advanced VMware features that support live migration, high availability, recovery, and load balancing. Specifically, we discuss how we set up and performed a live migration of a MySQL 5.1 Enterprise Server environment under sustained Sysbench load using VMware VMotionTM. Also included is an example that demonstrates dynamic load balancing for a MySQL server using VMware DRS, again while under sustained Sysbench load.

Read this white paper » (

Case Study: MySQL Enterprise Powers Educational Software in 70% of Belgium's Dutch-Speaking Schools

Smartschool is an on-line educational platform used by school administrators, teachers and students in 750 schools in Belgium - more than 70% of all Dutch- speaking secondary schools. In order to support and monitor the system, Smartbit purchased a MySQL Enterprise Unlimited subscription from Sun Microsystems to help ensure the Smartschool platform would scale to handle the growing number of users from all over Belgium.

Read this Case Study » (

Case Study: MySQL Cluster Powers Leading Mobile Media Publishing Platform go2 Media

go2 Media ( publishes the largest entertainment guide on the mobile web, growing at 300% every 6 months. Updated daily, the guide covers everything from movies, concerts, sports events, and a restaurant guide combined with tools like directions, weather and contact details. Social networking features are also included, enabling users to share their plans with friends and colleagues via their preferred platform, i.e. Twitter, Facebook, SMS or Send to Friend.

Read the Case Study » (

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: Fixing Poor MySQL Default Configuration Values

Jeremy Zawodny

I've recently been accumulating some MySQL configuration variables that have defaults which have proven to be problematic in a high-volume production environment. The thing they all have in common is a network blip or two can trigger some very undesirable behavior.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: MySQL Schema Maintenance

Giuseppe Maxia

At CodeBits I had my first session about MySQL schema maintenance. I covered the basic command line possibilities before coming to the recommended tool, MySQL Workbench.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: Poor man's Schema Comparison

Giuseppe Maxia

Comparing database schemas is one of those DBA tasks that occur all the time. If you can afford the luxury of having a GUI, then MySQL Workbench is the tool for you. It will help you compare structures and eventually synchronizing the differences.

If the only thing at your disposal is a command line interface, without the possibility of installing anything (a common occurrence when you are consulting), then this Poor man's schema comparison tool may come handy.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: Things you manage to miss - ALTER TABLE .. ORDER BY

Lachlan Mulcahy

It's funny how you can use a product heavily for so many years and still be completely unaware of some features.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: About CSV Tables

Gerardo Narvaja

As most of MySQL users, I have often ignored what I'd like to call the minor storage engines. MYISAM, InnoDB and NDB (aka MySQL Cluster) are well covered in several articles; but what about engines like CSV or ARCHIVE? As part of some internal projects, we have been playing around with these 2 with some interesting results. On this article I'll concentrate on CSV.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: Launch MySQL from the Command Line

Lee Stigle

In my last blog entry, I discussed a "silent" install method for deploying MySQL on Windows. However, the best way to distribute MySQL may be to not install it. Instead, design the application to launch mysql from the command line. With this method, you can deploy with two files, avoid registry entries, and hide database files from end-users and their IT staff.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: Software preview MySQL Scriptable Replication

Andrew Morgan

A MySQL Software preview is available which allows you to write Lua scripts to control replication on a statement-by-statement basis. Note that this is prototype functionality and is not supported but feedback on its usefulness would be gratefully received. The final version would allow much greater functionality but this preview allows you to implement filters on either the master or slave to examine the statements being replicated and decide whether to continue processing each one or not.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: MySQL University: Speakers for 2010 wanted!

Stefan Hinz

We'll soon have our last MySQL University session for this year, followed by a winter break until the end of January 2010. So far there's only one session scheduled next year, but we'd like to have one session per week, so we need lots more speakers!

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: Ext4 with MySQL binary logs oddity

Harrison Fisk

I was working with a customer recently that kept seeing 10-12 second hangs in MySQL. Everything would be working well and suddenly all data changing statements would stop working.

Once the 10-12 seconds passed, the system would recover and everything would be fine for a while. This would repeat every 30-45 minutes normally, and would occur more frequently when the system was doing some heavy ETL type activity (data loads, big updates, etc...), with the ETL ones being longer and worse generally.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: On restoring a single table from mysqldump

Shlomi Noach

Following Restore one table from an ALL database dump and Restore a Single Table From mysqldump, I would like to add my own thoughts and comments on the subject. I also wish to note performance issues with the two suggested solutions, and offer improvements.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: MySQL Cluster Restarts Get Faster

MySQL Cluster 6.3.28b and 7.0.9b contain optmizations which can greatly reduce the time taken for data nodes to restart - this includes restarting a single node, performing a rolling restart or a full system restart.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: Node Failure Handling - Take 2

Johan Andersson

Jonas improved the node failure handling in MySQL Cluster 7.0.9 (and 6.3.29) so here comes a re-run of the a previous blog post. And the node failure handling time has improved a lot - see below.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: Scaling - going from 2 to X data nodes

When moving from two data nodes to a bigger Cluster it is not necessarily true that you will have better performance. In fact you can get worse. Here are some things to think about.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: MySQL Cluster fault tolerance - impact of deployment decisions

MySQL Cluster is designed to be a High Availability, Fault Tolerant database where no single failure results in any loss of service.

This is however dependent on how the user chooses to architect the configuration - in terms of which nodes are placed on which physical hosts, and which physical resources each physical host is dependent on.

Read the PlanetMySQL Blogpost »


Live Webinar: Why LiveTime Software Provides SQL Server to MySQL Migration for its Customers

Tuesday, December 15, 2009 - 10:00 am PST

LiveTime has been providing ITIL Service Management and Help Desk products to global 2000 companies for more than 8 years and has recently witnessed significant interest from customers in migrating from SQL Server to MySQL. In this webinar you will learn why LiveTime decided to offer a free migration service for its customers as well as optimizations and performance characteristics. You will also learn specifically about:

  • Toolsets used to perform migration
  • Tuning parameters
  • Scalability
  • Compiling on Solaris
  • Cost of ownership
  • Database connections
  • Character sets

Register for this Webinar »

Live Webinar: Windows and MySQL - Part 7: MySQL Cluster on Windows

Thursday, January 7, 2010 - 10:00am PST

In this presentation we will explore the benefits of leveraging MySQL Cluster on Windows. We will also cover step by step, how to get started with installing, configuring, and running MySQL Cluster on Windows. Finally, a review of MySQL Cluster's architecture and future roadmap for Windows support will be covered. If you are interested in learning how to leverage MySQL Cluster on Windows, this webinar is for you.

Register for this Webinar »

Live Webinar: How to grow your user base 275% with High Availability

Wednesday, January 13, 2010 - 10:00am CET (EMEA)

University of Turku in Finland is at the forefront of research in areas such as bioscience, interaction of culture and society, mathematical research, research of learning and education, astronomy and space research. Their organization is expanding from 22,000 users to 60,000 users with the combination of Turku School of Economics and University of Turku as one unified organization as of January 1st 2010. With MySQL Enterprise the universities have created a solution that enables them to expand and scale. "With our double set of databases, we can ensure high availability of the identity and access management of all students". Listen to Miika Kauppi, Project Manager at University of Turku, present how he designed the solution, purchased it and now is taking it into production.

Register for this Webinar »

Live Webinar: Scaling to 20k Transactions per Second with Open Source - MySQL, Java, curl, PHP

Thursday, January 19, 2010 - 10:00am PST

It IS possible to build an ad-engine that can serve up more ads than Twitter to an audience larger than Twitter's (19.2m unique US visitors in Oct 2009), using fewer than 10 MySQL servers producing more then 20K Transactions per Second across a Multi-Terabyte store with all open source software. Dathan Pattishall, Chief DataLayer architect at RockYou and former database architect at Friendster and Flickr, will tell you how to do this giving real-world examples.

Register for this Webinar »

Live Webinar: Developing Windows Applications with MySQL

Thursday, January 21, 2010 - 10:00am PST

In this presentation we will explore the benefits of developing Windows applications with MySQL. We will also cover development best practices with Visual Studio and how to get the most from the latest version MySQL Connector/Net. Finally, we will offer a review of the future roadmap of the MySQL Connectors applicable for Windows environments. If you are interested in learning how to leverage MySQL Cluster on Windows, this webinar is for you.

Register for this Webinar »

Training, Consulting, and Certification

Consulting: MySQL Time Hire (4+ Days)

  • Would you like the flexibility of adding one or more of Sun's MySQL consultants to your team, on an as needed basis?
  • Do you need Sun's MySQL consultants on a project basis?
  • Do you need DBA experts to cover for staff absences or increased work load?

Sun's MySQL consultants have proven expertise in designing, developing, deploying, upgrading and managing database applications. By using Sun's MySQL consultants to supplement their teams, customers can reduce the time, effort and costs associated with building and running MySQL-based applications. Sun's MySQL consultants will work closely with customers who purchase this service to:

  • Act as a temporary member of the customer's MySQL database team working on those areas that they prioritize
  • Provide advice on architecture and design
  • Implement the database schema
  • Assist with loading or migrating data from existing system
  • Make recommendations on best practice for development, deployment and operations
  • Assist in performance measurement, tuning and optimization
  • Achieve improved scalability, availability and reliability

Learn More » (

MySQL Consulting Testimonials » (

Training: MySQL High for DBAs (5 Days)

Phoenix, Dublin, Montreal, London, Paris, Boston

An Authorized MySQL instructor will teach you how to properly install MySQL, create and execute Backup Strategies, create secure Stored Procedures to update and access data and more!

This instructor led, hands-on class will teach you how to secure users privileges, set resource limitations, and access controls. In addition, you will learn multiple new features such as creating and using Stored Procedures, Triggers and Views.

Register Now for an Upcoming Date » (

Java and Solaris Training for Startups

Need to boost your knowledge of Java and Solaris? The Sun Startup Essentials program offers over 120 web-based Java Technology and Solaris training programs covering Web development with Servlet and JSP Technologies, Java Application Security, Solaris System Administration, Virtualization Management and much more. Check if you qualify for the program and learn how you can save 90% off list price for a typical 10-person startup!

Java Technology Course Package »

Solaris Course Package »

Learn More about the Sun Startup Essentials Training Packages »


Calpont: A Technical Overview of the InfiniDB Analytic Database

If you're struggling to develop cost effective data warehouses, data marts, reporting databases, or BI/analytic applications, but aren't getting the performance you want, maybe you need a new approach. Learn how Calpont's InfiniDB handles all query and read-intensive application needs by supplying an architecture that both scales up and out using massive parallel processing, but with the ease-of-use of MySQL.

Read the White Paper » (

Want to receive the latest MySQL updates and interact with the MySQL community?

Follow MySQL on Twitter »

Follow MySQL Community on Twitter »