April 2010
mysql-newsletter@sun.com
Articles in this newsletter:
Highlights
- Article: Introduction to MySQL 5.5 (Performance and Scalability Improvements)
- White Paper: MySQL Connector for Java
- White Paper: MySQL Cluster Manager
- MySQL ISV/OEM Customer Survey: Tell Us What You Want!
- Case Study: MySQL Enterprise powers SaaS ERP for Italian local and central authorities
- Live Webinar: MySQL Performance Tuning Best Practices (Thursday, April 22)
- Live Webinar: Introducing MySQL Cluster 7.1 (Thursday, April 29)
New Product Releases
- New Release of MySQL Server 5.5.3-m3 (Beta)
- New Release of MySQL Server 5.5.4-m3 (Beta)
- New Release of MySQL Server 5.1.45 (GA)
- New Release of MySQL Cluster 7.1 (GA)
- New Release of MySQL Workbench 5.2.18 (Beta)
Hints & Tips
- Documentation: InnoDB 1.1 for MySQL 5.5 User's Guide
- White Paper: Securing MySQL Embedded Server on Windows
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: Replication Features in MySQL 5.5.3
- PlanetMySQL Blog: InnoDB recovery is now faster... much faster!
- PlanetMySQL Blog: Scalability enhancements of MySQL 5.5.4-m3
- PlanetMySQL Blog: MySQL 5.5.4-m3 scales to 32 cores
- PlanetMySQL Blog: MySQL Performance: 5.5.4 @dbSTRESS
- PlanetMySQL Blog: InnoDB Performance Schema
- PlanetMySQL Blog: Better Scalability with Multiple Rollback Segments
- PlanetMySQL Blog: MySQL: Partition-wise backups with mysqldump
- PlanetMySQL Blog: Hyper Threading Performance
- PlanetMySQL Blog: Index only
- PlanetMySQL Blog: Using ClusterJ (part of MySQL Cluster Connector for Java) - a tutorial
- PlanetMySQL Blog: Using ClusterJPA (part of MySQL Cluster Connector for Java) - a tutorial
Events
- Live Webinar: Introducing MySQL Cluster 7.1 - EMEA (Tuesday, April 20)
- Live Webinar: Migrating from Microsoft Access to MySQL Embedded Server (Wednesday, April 28)
- Live Webinar: Introducing MySQL Cluster 7.1 - German (Wednesday, April 28)
- Live Webinar: Introducing MySQL Cluster 7.1 - Italian (Thursday, April 29)
-------------------------------------------------------------------
Highlights
Article: Introduction to MySQL 5.5 (Performance and Scalability Improvements)
It's been a busy year for MySQL. Perhaps you've heard. Here are some recent improvements to the speed, scalability, and user-friendliness of the MySQL database and the InnoDB storage engine that we think deserve their own headlines. Now is a great time to beta test the 5.5 release and give feedback to the MySQL engineering team.
Read the Article:
http://dev.mysql.com/tech-resources/articles/introduction-to-mysql-55.html
White Paper: MySQL Cluster Connector for Java
As part of the MySQL Cluster 7.1 release, the MySQL Cluster Connector for Java implements a high performance and easy-to-use native Java interface and OpenJPA plug-in that directly maps Java objects to relational tables stored in the MySQL Cluster database.
By eliminating data transformations into SQL, users get lower data access latency and higher throughput. As a result, the development of Java applications is simplified with faster development cycles resulting in accelerated time to market for new services.
Read the White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_cluster_connector_for_java.php
White Paper: MySQL Cluster Manager
MySQL Cluster Manager simplifies the creation and management of MySQL Cluster Carrier Grade Edition by automating common management tasks. As a result, Database Administrators (DBAs) and Systems Administrator are more productive, enabling them to focus on strategic IT initiatives that support the business and respond more quickly to changing user requirements.
Read the White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_cluster_manager.php
MySQL ISV/OEM Customer Survey: Tell Us What You Want!
MySQL is committed to meeting the needs of our ISV/OEM customers - so please let us know what those are and help shape future product direction by participating in the MySQL ISV/OEM customer survey. The 2010 survey is more OEM-specific and significantly shorter, and it only takes about 5 minutes to complete. Thank you for your participation in making MySQL a better product!
Take the MySQL ISV/OEM Customer Survey:
http://www.zoomerang.com/Survey/WEB22AE76QG7WA
Case Study: MySQL Enterprise powers SaaS ERP for Italian local and central authorities
PA Digitale helps the Italian government authorities achieve the objectives established by the Italian e-government plan for Public Digital Administration. Based on its ease of use and reliability, PA Digitale selected the MySQL database as the engine in the core of its technology infrastructure. By administering databases activities with the MySQL Enterprise Monitor and the Query Analyzer, PA Digitale can meet the database requirements with extremely intelligent and easy-to-use tools.
Read the Case Study:
http://dev.mysql.com/why-mysql/case-studies/mysql_cs_padigitale.php
Live Webinar: MySQL Performance Tuning Best Practices
Thursday, April 22, 2010 - 9:00am PDT
* Do your applications slow down during busy times?
* Will finding and fixing those performance issues take weeks of time that you just don't have?
* Designing a new application and contemplating the best way to structure your schema and index strategy for optimal performance?
Then this free web presentation is for you! You will get expert insight and learn best practices from the experts at MySQL to help you improve performance!
Register for this Webinar
http://www.mysql.com/news-and-events/web-seminars/display-532.html
Live Webinar: Introducing MySQL Cluster 7.1
Thursday, April 29, 2010 - 9:00am PDT
In blazing speed we will cover the most important features of MySQL Cluster 7.1: NDB$INFO, MySQL Cluster Connector/Java and other features that push the limits of MySQL Cluster into new workloads and communities.
Register for this Webinar:
http://dev.mysql.com/news-and-events/web-seminars/display-529.html
-------------------------------------------------------------------
New Product Releases
New Release of MySQL Server 5.5.3-m3 (Beta)
MySQL Server 5.5.3-m3, a new version of the popular Open Source Database Management System, has been released. 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.
View the complete list of changes:
http://dev.mysql.com/doc/refman/5.5/en/news-5-5-3.html
Download Now:
http://dev.mysql.com/downloads/mysql/5.5.html#downloads
New Release of MySQL Server 5.5.4-m3 (Beta)
We've released MySQL Server 5.5.4-m3, for Linux on x86_64 only at this time. It contains a new version of InnoDB including several performance enhancements in comparison to MySQL Server 5.5.3-m3. The "-m3" suffix tells these releases belong to the third milestone according to our "milestone" release model, also called "Celosia".
View the complete list of changes:
http://dev.mysql.com/doc/refman/5.5/en/news-5-5-4.html
Download Now:
http://dev.mysql.com/downloads/mysql/5.5.html#downloads
New Release of MySQL Server 5.1.45 (GA)
MySQL Community Server 5.1.45, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.45 is recommended for use on production systems.
View the complete list of changes:
http://dev.mysql.com/doc/refman/5.1/en/news-5-1-45.html
Download Now:
http://dev.mysql.com/downloads/mysql/5.1.html#downloads
New Release of MySQL Cluster 7.1 (GA)
MySQL Cluster 7.1 represents the latest release of the leading open source, high availability database, offering a range of new features designed to reduce operational costs and improve accessibility.
Download Now:
http://dev.mysql.com/downloads/cluster/7.1.html#downloads
Read the Documentation:
http://dev.mysql.com/doc/mysql-cluster-excerpt/5.1/en/index.html
New Release of MySQL Workbench 5.2.18 (Beta)
We are proud to announce MySQL Workbench Beta 8 (5.2.18). Since beta 7 we have fixed additional bugs as well as put in some improvements requested by the community, including fixes for 35 bugs, new HUD-style (FADE IN) UI elements, and Connection Sorting.
Download Now:
http://dev.mysql.com/downloads/workbench/
Read the Tutorial:
http://wb.mysql.com/?p=406
-------------------------------------------------------------------
Hints & Tips
Documentation: InnoDB 1.1 for MySQL 5.5 User's Guide
Beginning with MySQL version 5.1, it is possible to swap out one version of the InnoDB storage engine and use another (the "plugin"). This manual documents the latest InnoDB plugin, version 1.1, which works with MySQL 5.5 and features cutting-edge improvements in performance and scalability.
Read the Documentation:
http://dev.mysql.com/doc/innodb-plugin/1.1/en/index.html
White Paper: Securing MySQL Embedded Server on Windows
Windows is the most popular platform for MySQL's ISV and OEM customers. This white paper provides the best practices to secure a Windows-based installation of MySQL Embedded Server 5.1. The paper covers the following MySQL security-related topics, including understanding the MySQL security model, post-installation tasks, user accounts, password management, encryption, and more.
Read this White Paper:
http://dev.mysql.com/why-mysql/white-papers/wp_oem_SecureMySQLOnWindows.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: Replication Features in MySQL 5.5.3
Lars Thalmann
We are happy to announce the new and exciting replication features in the MySQL 5.5.3 development release.
Read the PlanetMySQL BlogPost:
http://larsthalmann.blogspot.com/2010/04/we-are-happy-to-announce-new-and.html
PlanetMySQL Blog: InnoDB recovery is now faster... much faster!
Inaam Rana
One of the well known and much written complaint regarding InnoDB recovery is that it does not scale well on high-end systems. Well, not any more. In InnoDB plugin 1.0.7 (which is GA) and plugin 1.1 (which is part of MySQL 5.5.4) this issue has been addressed. Two major improvements, apart from some other minor tweaks, have been made to the recovery code. In this post I'll explain these issues and our solution for these.
Read the PlanetMySQL BlogPost:
http://blogs.innodb.com/wp/2010/04/innodb-performance-recovery/
PlanetMySQL Blog: Scalability enhancements of MySQL 5.5.4-m3
Mikael Ronstrom
The MySQL 5.5.4-m3 beta version contains a number of interesting new scalability features.
Read the PlanetMySQL BlogPost:
http://mikaelronstrom.blogspot.com/2010/04/scalability-enhancements-of-mysql-554.html
PlanetMySQL Blog: MySQL 5.5.4-m3 scales to 32 cores
Mikael Ronstrom
The newly released MySQL 5.5 beta version MySQL 5.5.4-m3 has a large number of significant performance improvements. These improvements make it possible for MySQL to scale well even on 32-core servers. The graph below shows how MySQL 5.5.4-m3 scales from 12 cores to 32 cores using a single thread per core.
Read the PlanetMySQL BlogPost:
http://mikaelronstrom.blogspot.com/2010/04/mysql-554-m3-scales-to-32-cores.html
PlanetMySQL Blog: MySQL Performance: 5.5.4 @dbSTRESS
Dimitri Kravtchuk
Today we have something to celebrate - the MySQL 5.5.4 was announced! And a huge number of performance improvement made in this version make me very happy :-))
Read the PlanetMySQL BlogPost:
http://dimitrik.free.fr/blog/archives/04-01-2010_04-30-2010.html#104
PlanetMySQL Blog: InnoDB Performance Schema
Jimmy Yang
With the plugin 1.1 release, InnoDB will have full support of Performance Schema, a new feature of MySQL 5.5 release. This allows a user to peak into some critical server synchronization events and obtain their usage statistics. On the other hand, in order to make a lot of sense of the instrumented result, you might need some understanding of InnoDB internals, especially in the area of synchronization with mutexes and rwlocks.
Read the PlanetMySQL BlogPost:
http://blogs.innodb.com/wp/2010/04/innodb-performance-schema/
PlanetMySQL Blog: Better Scalability with Multiple Rollback Segments
Sunny Bains
The original motivation behind this patch was the infamous Bug#26590 - MySQL does not allow more than 1023 open transactions. Actually the 1024 limit has to do with the number of concurrent update transactions that can run within InnoDB. Where does this magic number come from?
Read the PlanetMySQL BlogPost:
http://blogs.innodb.com/wp/2010/04/innodb-multiple-rollback-segments/
PlanetMySQL Blog: MySQL: Partition-wise backups with mysqldump
Roland Bouman
To whom it may concern, in response to a query from André Simões, I slapped together a MySQL script that outputs mysqldump commands for backing up individual partitions of the tables in the current schema. The script is maintained as a snippet at MySQL Forge.
Read the PlanetMySQL BlogPost:
http://rpbouman.blogspot.com/2010/03/mysql-partition-wise-backups-with.html
PlanetMySQL Blog: Hyper Threading Performance
Venu Anuganti
It's been a while anyone talked about Intel's Hyper-Threading performance when it comes to databases. There were enough posts about disabling Hyper-Threading completely when it comes to MySQL/InnoDB workloads way back when we had enough issues with scalability of InnoDB on multi-core systems. But things have changed quite a bit in the past year or two in terms of multi-core support.
Read the PlanetMySQL BlogPost:
http://venublog.com/2010/03/21/hyper-threading-performance/
PlanetMySQL Blog: Index only
Mark Callaghan
A problem with SQL is SQL. It is easy to write queries that require random IO in the worst case. It is usually easy to find queries that do too much random IO on a NoSQL system as you must code the extra data fetches manually.
Read the PlanetMySQL BlogPost:
http://mysqlha.blogspot.com/2010/03/index-only.html
PlanetMySQL Blog: Using ClusterJ (part of MySQL Cluster Connector for Java) - a tutorial
Andrew Morgan
ClusterJ is part of the MySQL Cluster Connector for Java which is currently in beta as part of MySQL Cluster 7.1. It is designed to provide a high performance method for Java applications to store and access data in a MySQL Cluster database. It is also designed to be easy for Java developers to use and is "in the style of" Hibernate/Java Data Objects (JDO) and JPA.
Read the PlanetMySQL BlogPost:
http://www.clusterdb.com/mysql-cluster/using-clusterj-part-of-mysql-cluster-connector-for-java-a-tutorial/
PlanetMySQL Blog: Using ClusterJPA (part of MySQL Cluster Connector for Java) - a tutorial
Andrew Morgan
This is a follow up to the earlier post Using ClusterJ (part of MySQL Cluster Connector for Java) - a tutorial but covers the ClusterJPA interface rather than ClusterJ.
Read the PlanetMySQL BlogPost:
http://www.clusterdb.com/mysql-cluster/using-clusterjpa-part-of-mysql-cluster-connector-for-java-%E2%80%93-a-tutorial/
-------------------------------------------------------------------
Events
Live Webinar: Introducing MySQL Cluster 7.1 - EMEA
Tuesday, April 20, 2010 - 10:00 CET/8:00 UTC
In blazing speed we will cover the most important features of MySQL Cluster 7.1: NDB$INFO, MySQL Cluster Connector/Java and other features that push the limits of MySQL Cluster into new workloads and communities.
Register for this Webinar:
http://dev.mysql.com/news-and-events/web-seminars/display-527.html
Live Webinar: Migrating from Microsoft Access to MySQL Embedded Server
Wednesday, April 28, 2010 - 10:00am PDT
Join Jimmy Guerrero and Mike Frank, MySQL product managers and Windows experts, for this technical presentation. Jimmy and Mike will explore the technical and business benefits of migrating your product's data from Microsoft Access to MySQL Embedded Server. They will also cover migration best practices, and provide an overview of migration tools, scripts and datatype mapping. Finally, they will demonstrate how to leverage Access front-ends with a MySQL Embedded Server back-end.
Register for this Webinar:
http://dev.mysql.com/news-and-events/web-seminars/display-533.html
Live Webinar: Introducing MySQL Cluster 7.1 - German
Wednesday, April 28, 2010 - 15:00 CET/13:00 UTC
In blazing speed we will cover the most important features of MySQL Cluster 7.1: NDB$INFO, MySQL Cluster Connector/Java and other features that push the limits of MySQL Cluster into new workloads and communities.
Register for this Webinar:
http://dev.mysql.com/news-and-events/web-seminars/display-530.html
Live Webinar: Introducing MySQL Cluster 7.1 - Italian
Thursday, April 29, 2010 - 10:00 CET/8:00 UTC
In blazing speed we will cover the most important features of MySQL Cluster 7.1: NDB$INFO, MySQL Cluster Connector/Java and other features that push the limits of MySQL Cluster into new workloads and communities.
Register for this Webinar:
http://dev.mysql.com/news-and-events/web-seminars/display-531.html
-------------------------------------------------------------------
Want to receive the latest MySQL updates and interact with the MySQL community?
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/
--
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.
Gartner Magic Quadrant for Business Process Analysis
