December 2010
mysql-newsletter@sun.com
Articles in this newsletter:
Highlights
- Webcast: MySQL Technology Update - Announcing MySQL 5.5 GA
- Developer Zone Interview: MySQL 5.5 is GA - Interview with Tomas Ulin
- White Paper: What's New in MySQL 5.5
- White Paper: MySQL Enterprise Edition: Database. Management. Support.
- Oracle Magazine: Open for Business - MySQL Community Wins with Better Innovation, Support and Integration
- MySQL Selected as the Best Database by Linux Journal Reader's Choice Awards 2010
- Case Study: MySQL Powers the Market Leading Telecoms Network Management Framework
- Case Study: Central Banks Worldwide Rely on Bank of Finland's MySQL Based Simulator
- Live Webinar: What's New in Managing MySQL Cluster (January 12, 2011)
- Live Webinar: What's New: MySQL 5.5 and MySQL Enterprise Edition (January 18, 2011)
- Live Webinar: MySQL Enterprise Backup - Online "Hot" Backup for MySQL (January 20, 2011)
New Product Releases
- New Release of MySQL Community Server 5.5.8 (GA)
- New Release of MySQL Cluster 7.1.9 Binary (GA)
- New Release of MySQL Workbench 5.2.31 (GA)
- New Release of MySQL Connector/J 5.1.14 (GA)
- New Release of MySQL Connector/ODBC 5.1.8 (GA)
Hints & Tips
- Blog Series: MySQL 5.5
- White Paper: MySQL Reference Architectures for Massively Scalable Web Infrastructure
- White Paper: MySQL on Windows - Why, Where and How
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: MySQL At Scale - Zynga Games
- PlanetMySQL Blog: Testing MySQL 5.5 semi-synchronous replication
- PlanetMySQL Blog: MySQL Performance: 5.5 and InnoDB thread concurrency
- PlanetMySQL Blog: Working with MySQL on Windows
- PlanetMySQL Blog: MySQL Cluster Manager 1.1 available!
- PlanetMySQL Blog: Monitoring MySQL Cluster with MySQL Enterprise Monitor 2.3
- PlanetMySQL Blog: How To Build MySQL Releases
- PlanetMySQL Blog: How to setup MySQL on a DRBD volume
- PlanetMySQL Blog: Excluding databases from mysqldump
- PlanetMySQL Blog: A quick summary of patch contributions included in MySQL 5.5
- PlanetMySQL Blog: Does the insert buffer work?
- PlanetMySQL Blog: 8 substitution rules for running SQL in parallel
- PlanetMySQL Blog: Submitting MySQL talks to upcoming Oracle User Group Events in Europe
Spotlight: MySQL Workbench
- White Paper: MySQL Workbench: A Data Modeling Guide for Developers and DBAs
- Blog: MySQL Workbench Plugin: Auto-Create Foreign Keys
- Blog: MySQL Workbench: Introducing Utilities
- Blog: MySQL Workbench: Manage MySQL on Windows Servers the Windows Way
Events
- Live Webinar: MySQL Enterprise Backup - Italian (January 20, 2011)
- Live Webinar: What's New: MySQL 5.5 and MySQL Enterprise Edition - German (January 21, 2011)
-------------------------------------------------------------------
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:
http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-596.html
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:
http://dev.mysql.com/tech-resources/interviews/thomas-ulin-mysql-55.html
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://dev.mysql.com/why-mysql/white-papers/mysql-wp-whatsnew-mysql-55.php
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:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_enterprise_ready.php
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:
http://www.oracle.com/technetwork/issue-archive/2011/11-jan/o11mysql-194109.html
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:
http://www.linuxjournal.com/content/readers-choice-awards-2010
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:
http://dev.mysql.com/why-mysql/case-studies/mysql-cs-webnms.php
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:
http://dev.mysql.com/why-mysql/case-studies/mysql_cs_bankoffinland.php
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:
http://dev.mysql.com/news-and-events/web-seminars/display-599.html?p=newsletter
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:
http://dev.mysql.com/news-and-events/web-seminars/display-597.html?p=newsletter
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:
http://dev.mysql.com/news-and-events/web-seminars/display-598.html?p=newsletter
-------------------------------------------------------------------
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:
http://dev.mysql.com/doc/refman/5.5/en/news-5-5-8.html
Download Now:
http://dev.mysql.com/downloads/mysql/
Read the Documentation "What's New in MySQL 5.5":
http://dev.mysql.com/doc/refman/5.5/en/mysql-nutshell.html
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:
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-news-5-1-51-ndb-7-1-9.html
Download Now:
http://dev.mysql.com/downloads/cluster/
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:
http://dev.mysql.com/doc/workbench/en/wb-news-5-2-31.html
Download Now:
http://dev.mysql.com/downloads/workbench/
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:
http://dev.mysql.com/doc/refman/5.5/en/cj-news-5-1-14.html
Download Now:
http://dev.mysql.com/downloads/connector/j/5.1.html
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:
http://dev.mysql.com/doc/refman/5.5/en/connector-odbc-news-5-1-8.html
Download Now:
http://dev.mysql.com/downloads/connector/odbc/5.1.html
-------------------------------------------------------------------
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!":
http://blogs.oracle.com/mysql/2010/11/mysql_55_performance_and_scalability_unleashed.html
Read the Blog Post "MySQL 5.5 - What's New in Replication":
http://blogs.oracle.com/mysql/2010/11/mysql_55_whats_new_in_replication.html
Read the Blog Post "MySQL 5.5 - Improved manageability, efficiency for InnoDB":
http://blogs.oracle.com/mysql/2010/11/mysql_55_improved_manageability_efficiency_for_innodb.html
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:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_high-availability_webrefarchs.php
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:
http://dev.mysql.com/why-mysql/white-papers/mysql_on_windows_wwh.php
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: 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:
http://venublog.com/2010/12/02/mysql-at-scale-zynga-games/
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:
http://datacharmer.blogspot.com/2010/11/testing-mysql-55-semi-synchronous.html
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:
http://dimitrik.free.fr/blog/archives/11-01-2010_11-30-2010.html#116
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:
http://karlssonondatabases.blogspot.com/2010/12/working-with-mysql-on-windows-part-1.html
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:
http://www.clusterdb.com/mysql-cluster/mysql-cluster-manager-1-1-available/
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:
http://www.clusterdb.com/mysql-cluster/monitoring-mysql-cluster-with-mysql-enterprise-monitor/
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:
http://www.perkin.org.uk/blog/2010/11/how-to-build-mysql-releases/
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:
http://frederikkonietzny.de/wp/2010/12/08/howto-setup-mysql-on-a-drbd-volume/
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:
http://datacharmer.blogspot.com/2010/12/excluding-databases-from-mysqldump.html
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:
http://www.lenzg.net/archives/325-A-quick-summary-of-patch-contributions-included-in-MySQL-5.5.html
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:
http://www.facebook.com/note.php?note_id=460565850932
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:
http://swanhart.livejournal.com/134177.html
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:
http://www.lenzg.net/archives/322-Submitting-MySQL-talks-to-upcoming-Oracle-User-Group-Events-in-Europe.html
-------------------------------------------------------------------
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:
http://dev.mysql.com/why-mysql/white-papers/mysql-wp-workbench.php
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:
http://wb.mysql.com/?p=777
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:
http://wb.mysql.com/?p=873
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:
http://wb.mysql.com/?p=892
-------------------------------------------------------------------
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:
http://dev.mysql.com/news-and-events/web-seminars/display-595.html?p=newsletter
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:
http://dev.mysql.com/news-and-events/web-seminars/display-600.html?p=newsletter
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:
http://dev.mysql.com/news-and-events/web-seminars/index.html
-------------------------------------------------------------------
Want to receive the latest MySQL updates and interact with the MySQL Community?
Read Oracle's MySQL Blog:
http://blogs.oracle.com/mysql/
Join MySQL on Facebook:
http://www.facebook.com/mysql
Follow MySQL on Twitter:
http://twitter.com/mysql
Follow MySQL Community on Twitter:
http://twitter.com/mysql_community
-------------------------------------------------------------------
About the Newsletter
You can send us queries and give us feedback online.
http://dev.mysql.com/contact/
You can unsubscribe from this newsletter online:
http://dev.mysql.com/unsub?email=johandontmessup@gmail.com
Read more about the newsletter and view previous issues.
http://dev.mysql.com/news-and-events/newsletter/
Problems reading the newsletter in your email client? View the newsletter on the web.
http://dev.mysql.com/news-and-events/newsletter/2010/2010-12.html
--
Copyright (c) 2010, Oracle Corporation and/or its affiliates.
You are free to distribute this newsletter, as long as you don't make any changes.
IBM Rational DOORS Web Access and Rational Publishing Engine rebates
