MySQL Newsletter December 2010

Articles in this newsletter:

Highlights

New Product Releases

Hints & Tips

Spotlight: MySQL Workbench

Events

Highlights

Webcast: MySQL Technology Update - Announcing MySQL 5.5 GA

In this webcast, Tomas Ulin, Vice President of MySQL development, and Rob Young, Senior MySQL Product Manager, announced the availability of MySQL 5.5 GA release and provided updates on the latest developments with MySQL.

Watch the Webcast »

Developer Zone Interview: MySQL 5.5 is GA - Interview with Tomas Ulin

Oracle Magazine features editor Rich Schwerin interviews Tomas Ulin, Vice President, MySQL Engineering, who answers questions about the GA release of MySQL 5.5.

Read the Interview »

White Paper: What's New in MySQL 5.5

This white paper provides a look at what's new in MySQL 5.5, including greatly improved performance, scalability, and usability specifically on today's modern, multi-processing hardware, software, and middleware architectures. Sysbench benchmarks demonstrate performance improvements of up to 370% and 540% faster performance on Linux and Windows respectively. Also, new Semi-synchronous Replications and MySQL Performance Schema provide developers and DBAs with improved tools for building high performance, scalable applications.

Read this White Paper » (http://www.mysql.com/why-mysql/white-papers/whats-new-in-mysql-5-5/)

White Paper: MySQL Enterprise Edition: Database. Management. Support.

MySQL Enterprise Edition combines the MySQL database, online backup, monitoring, management, visual database design and SQL developments tools. The MySQL Enterprise Edition is backed by Oracle Premier Support, 24x7 global enterprise-class support services, specifically designed to mitigate risk and ensure you meet customer and end-user Service Level Agreements (SLAs).

Read this White Paper »

Oracle Magazine: Open for Business - MySQL Community Wins with Better Innovation, Support and Integration

David A. Kelly

Sometimes, relatively small things can make a big impact. Take the case of the MySQL database. First released in 1995 and purchased by Sun in 2008, MySQL has quickly graduated from the realm of hobbyists to the world of business, becoming the leading open source database for many Web applications and an integral part of the LAMP (Linux, Apache, MySQL, PHP) Web application stack. Almost a year after Oracle's acquisition of Sun, MySQL plays an even bigger role in enterprises of all sizes worldwide.

Read this Article »

MySQL Selected as the Best Database by Linux Journal Reader's Choice Awards 2010

Voted by more than 12,000 readers, MySQL remains the "Best Database" selected by Linux Journal Reader's Choice Awards three years running.

Learn More »

Case Study: MySQL Powers the Market Leading Telecoms Network Management Framework

WebNMS, the leading network and element management solution, has been embedding MySQL as the default database for over ten years. To accommodate ever more stringent demands for availability and performance, WebNMS and MySQL can write up to 10 million rows daily and support 2,000 transactions per second across a replicated architecture and are positioned to address the explosive growth driven by Long Term Evolution (LTE) and mobile broadband in next generation telecom networks.

Read this Case Study »

Case Study: Central Banks Worldwide Rely on Bank of Finland's MySQL Based Simulator

The Bank of Finland acts as Finland's central bank, national monetary authority, and member of the European System of Central Banks and the Eurosystem.

The BoF developed a MySQL based versatile Payment and Settlement System Simulator for making payments and settlement system simulations. Running on Windows, the application has been widely adopted by Central Bank Economists Worldwide.

Read this Case Study »

Live Webinar: What's New in Managing MySQL Cluster

Wednesday, January 12, 2011 - 9:00am PT

By their very nature, clustered environments involve more effort and resource to administer than standalone systems, and the same is true of MySQL Cluster, the database designed for web-scale throughput with carrier-grade availability.

In this webinar, we will present an overview of the three latest enhancements to provisioning, monitoring and managing MySQL Cluster - collectively serving to lower costs, enhance agility and reduce the risk of downtime caused by manual configuration errors.

Register for this Webinar »

Live Webinar: What's New: MySQL 5.5 and MySQL Enterprise Edition

Tuesday, January 18, 2011 - 9:00am PT

MySQL, the world's most popular open source database, powers today's most demanding web sites and applications. With the acquisition of Sun, Oracle continued to invest and improve MySQL - to make MySQL a better MySQL. Come join us to see what we have accomplished - from the MySQL database itself and across the MySQL product suite of development, management, and monitoring tools. You'll also hear about new innovative professional support services offerings aimed at quickly improving the performance of your business-critical MySQL databases and applications.

Register for this Webinar »

Live Webinar: MySQL Enterprise Backup - Online "Hot" Backup for MySQL

Thursday, January 20, 2011 - 9:00am PT

Online backup has been one of the most requested features for MySQL. With MySQL Enterprise Backup, developers and DBAs have the tools they need to safely and rapidly backup and restore their databases. In this webinar we will go into the advantages of Hot "Online" backups. We will show how MySQL Enterprise Backup supports full, incremental, partial, and compressed backups that allow you to perform consistent Point-in-Time Recovery, as well as saving both time and money.

Register for this Webinar »

New Product Releases

New Release of MySQL Community Server 5.5.8 (GA)

We are proud to present the MySQL Server 5.5.8 GA release, the first 5.5 production version of the world's most popular open source database. MySQL 5.5.8 is recommended for use on production systems.

MySQL 5.5 includes several high-impact changes to address scalability and performance issues in MySQL Server. These changes exploit advances in hardware and CPU design and enable better utilization of existing hardware. MySQL 5.5 also provides a number of other new enhancements, including InnoDB I/O subsystem changes, enhanced Solaris Support as well as diagnostic and monitoring capabilities.

View the Complete List of Changes »

Download Now »

Read the Documentation "What's New in MySQL 5.5" »

New Release of MySQL Cluster 7.1.9 Binary (GA)

The binary version for MySQL Cluster 7.1.9 has been released.

View the Complete List of Changes »

Download Now »

New Release of MySQL Workbench 5.2.31 (GA)

We're proud to announce the next release of MySQL Workbench, version 5.2.31. This is a maintenance release focusing on general product improvement and usability.

View the Complete List of Changes »

Download Now »

New Release of MySQL Connector/J 5.1.14 (GA)

MySQL Connector/J 5.1.14, 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.14 is suitable for use with any MySQL version including MySQL-5.0, MySQL-5.1 or MySQL-5.5.

View the Complete List of Changes »

Download Now »

New Release of MySQL Connector/ODBC 5.1.8 (GA)

MySQL Connector/ODBC 5.1.8, a new version of the ODBC driver for the MySQL database management system, has been released. This release is the latest release of the 5.1 series and is suitable for use with any MySQL version since 4.1.

View the Complete List of Changes »

Download Now »

Hints & Tips

Blog Series: MySQL 5.5

Rob Young

MySQL 5.5 is GA now so I thought I would create a series of blogs that highlight the key new features. I will start with a rundown of where we have made improvements and then expand into details as things progress.

Read the Blog Post "MySQL 5.5 - Performance and Scalability Unleashed!" »

Read the Blog Post "MySQL 5.5 - What's New in Replication" »

Read the Blog Post "MySQL 5.5 - Improved manageability, efficiency for InnoDB" »

White Paper: MySQL Reference Architectures for Massively Scalable Web Infrastructure

This whitepaper presents a series of Reference Architectures for small, medium and large Web properties. You will learn about the components common to most web properties including Session Management, Authentication, eCommerce and Content Management. Optimum deployment architectures and topologies are defined based on sizing and availability requirements for each environment. The paper also discusses the unique requirements for Large Social Networking applications.

Read this White Paper »

White Paper: MySQL on Windows - Why, Where and How

Why is the world's most popular open source database so popular on Windows? What are the applications for which one should consider MySQL on Microsoft's platform? How should Windows shops relying on Microsoft databases get going with MySQL? Those are the questions we aim to answer in this guide.

Read this White Paper »

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: MySQL At Scale - Zynga Games

Venu Anuganti

Recently I am part of Zynga's database team as I was pretty much impressed with the company's database usage. Everyone knows how popular Zynga games like Farmville, Cafe World, Mafia Wars, Poker, FrontierVille, FishVille, PetVille and Treasure Island etc are.

As a matter of fact, Zynga may be the second largest MySQL user after Facebook. All games at Zynga are currently powered by MySQL as the backend storage along with memcache as the middle caching layer.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Testing MySQL 5.5 semi-synchronous replication

Giuseppe Maxia

A few days ago I saw an article about Semi-Synchronous Replication in MySQL 5.5. It asks questions, and doesn't give answers beyond gut feeling. So I thought that I would do some practical testing of this new feature.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL Performance: 5.5 and InnoDB thread concurrency

Dimitri Kravtchuk

Until now, when you observed a performance degradation with a growing number of concurrent user sessions in InnoDB, the most simple way to avoid such a degradation was to set innodb_thread_concurrency to something different from zero - and since 5.5.4 the most optimal value was around of 32 ... But all the latest performance improvements in 5.5 are so good that it become less and less true now.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Working with MySQL on Windows

Anders Karlsson

This is the first post in an attempt to write about how to get along with MySQL on Windows. Before I start, I want to stress that the focus here is seasoned Windows users getting started with MySQL.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL Cluster Manager 1.1 available!

Andrew Morgan

As the title of this post suggests, MySQL Cluster Manager 1.1 is now available - but this actually has a double meaning: 1. MySQL Cluster Manager 1.1 is GA, and 2. Everyone is now able to download and try it!

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Monitoring MySQL Cluster with MySQL Enterprise Monitor 2.3

Andrew Morgan

A few months ago, I posted a walkthrough of how to extend MySQL Enterprise Monitor in order to monitor MySQL Cluster. The great news is that as of MySQL Enterprise Monitor 2.3 this functionality is included in the core product and so there is no need to add the extra features in manually.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: How To Build MySQL Releases

Jonathan Perkin

One of the major benefits from the CMake work available in MySQL 5.5 is that in the MySQL Release Engineering team we have been able to make it easy for users and developers to build MySQL exactly as we do for the official releases.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: How to setup MySQL on a DRBD volume

Frederik Konietzny

This document describes how to setup a failover system with MySQL and DRBD (Distributed Replicated Block Device).

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Excluding databases from mysqldump

Giuseppe Maxia

A question that came up during the MySQL track at the UKOUG conference in Birmingham was "Can I exclude only a few databases from mysqldump? Let's say that I have 50 databases, and I want to dump all of them, except a few."

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: A quick summary of patch contributions included in MySQL 5.5

Lenz Grimmer

I've been going through our bugs database to compile a list of some noteworthy patch contributions that have been included in the MySQL 5.5 release. Of course any contribution is appreciated, no matter how small!

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Does the insert buffer work?

Mark Callaghan

The insert buffer in InnoDB buffers pending inserts for secondary index pages to avoid blocking on disk reads for those pages during secondary index maintenance. This feature has been renamed the change buffer for InnoDB in MySQL 5.5 as it has been enhanced to support more than inserts.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: 8 substitution rules for running SQL in parallel

Justin Swanhart

A lot of the work that I do on my personal projects such as Flexviews and Shard-Query involves taking a query and manipulating it in such a way as to obtain the same result, but in a different manner. Flexviews amortizes aggregation over time, making it possible to maintain summary tables incrementally. Shard-Query spreads queries over multiple Gearman workers, allowing it to run queries on one or more MySQL servers in parallel.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Submitting MySQL talks to upcoming Oracle User Group Events in Europe

Lenz Grimmer

I've been informed about two upcoming events/conferences that are organized by the independent Oracle user groups of the respective countries. If you're nearby, how about submitting a talk about a MySQL-related topic?

Read the PlanetMySQL BlogPost »

Spotlight: MySQL Workbench

White Paper: MySQL Workbench: A Data Modeling Guide for Developers and DBAs

This paper looks at the various types of data that modern businesses need to manage, examines the reasons why a model-driven approach to data management is necessary, and outlines the benefits such an approach provides. It also highlights how the MySQL Workbench product from MySQL can be an indispensable aid in the hands of experienced data modelers, developers, and DBAs who are tasked with managing the complex data management infrastructure of a dynamic and growing business.

Read this White Paper »

Blog: MySQL Workbench Plugin: Auto-Create Foreign Keys

Alfredo Kojima

To automatically create Foreign Key relationships is a typical use case for developers working with the MyISAM storage engine. This has been a popular topic on the Blog and forums so we're revisiting it here - with a new and improved plugin written in Python.

Read this BlogPost »

Blog: MySQL Workbench: Introducing Utilities

Mats Kindahl

To make it easier to work with the server, the latest release of the MySQL Workbench - version 5.2.31 - contains a set of Python scripts intended to make the life easier for DBAs by providing easy-to-use utilities for common tasks, which were introduced in the blog MySQL Workbench: Utilities.

Read this BlogPost »

Blog: MySQL Workbench: Manage MySQL on Windows Servers the Windows Way

Mike Lischke

The MySQL team has been continuously improving its products on the Windows platform. Along this line, we've responded to a request from our users of Workbench on Windows - to provide remote access to Windows Servers using Windows management methods - as an alternative to SSH.

Read this BlogPost »

Events

Live Webinar: MySQL Enterprise Backup - Italian

Thursday, January 20, 2011 - 10:00 CET

In this webinar we will go into the advantages of Hot "Online" backups. We will show how MySQL Enterprise Backup supports full, incremental, partial, and compressed backups that allow you to perform consistent Point-in-Time Recovery, as well as saving both time and money.

Register for this Italian Webinar »

Live Webinar: What's New: MySQL 5.5 and MySQL Enterprise Edition - German

Friday, January 21, 2011 - 11:00 CET

MySQL, the world's most popular open source database, powers today's most demanding web sites and applications. With the acquisition of Sun, Oracle continued to invest and improve MySQL - to make MySQL a better MySQL. Come join us to see what we have accomplished - from the MySQL database itself and across the MySQL product suite of development, management, and monitoring tools. You'll also hear about new innovative professional support services offerings aimed at quickly improving the performance of your business-critical MySQL databases and applications.

Register for this Webinar »

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

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

Read Oracle's MySQL Blog »

Join MySQL on Facebook »

Follow MySQL on Twitter »

Follow MySQL Community on Twitter »