MySQL Newsletter December 2010
Articles in this newsletter:
- 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 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)
- 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
- 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
- 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)
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.
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 »
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/)
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).
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.
Voted by more than 12,000 readers, MySQL remains the "Best Database" selected by Linux Journal Reader's Choice Awards three years running.
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.
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.
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.
Tuesday, January 18, 2011 - 9:00am PTMySQL, 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.
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.
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.
The binary version for MySQL Cluster 7.1.9 has been released.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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!
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.
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.
This document describes how to setup a failover system with MySQL and DRBD (Distributed Replicated Block Device).
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."
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!
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.
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.
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?
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.
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.
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.
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.
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.
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.
More free MySQL webinars are scheduled and added between each Newsletter edition, so visit our website frequently for the most updated information.