June 2010
mysql-newsletter@sun.com
Articles in this newsletter:
Highlights
- Developer Interview: What's New in the MySQL Enterprise Spring 2010 Release?
- White Paper: MySQL Query Analyzer Overview
- White Paper: Scaling Web Services with MySQL Cluster: An Alternative Approach to MySQL & memcached
- Case Study: MySQL Cluster Powers Leading Document Management Web Service
- Case Study: Cashpoint Saves Half a Million Euros per Year as it Bets on MySQL
- TechCast Live: Jono Bacon and Luke Kowalski from Oracle on MySQL Community (Tuesday, June 8)
- Live Webinar: What's New in the MySQL Enterprise Spring 2010 Release (Tuesday, June 15)
New Product Releases
- New Release of MySQL Community Server 5.1.47 (GA)
- New Release of MySQL Enterprise Monitor 2.2 (GA)
- New Release of MySQL Workbench 5.2.22 (RC)
Hints & Tips
- White Paper: What's New in MySQL Enterprise Spring 2010 Release
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: InnoDB recovery gets even faster in Plugin 1.1, thanks to native AIO
- PlanetMySQL Blog: MySQL Sandbox meets plugins
- PlanetMySQL Blog: MySQL Performance: Using Performance Schema
- PlanetMySQL Blog: How To Set Up WebDAV With MySQL Authentication On Apache2 (Ubuntu 9.10)
- PlanetMySQL Blog: A Useful Tool to Centrally Manage Many MySQL Instances
- PlanetMySQL Blog: Replication configuration checklist
- PlanetMySQL Blog: The MySQL Track at Kaleidoscope is set!
Spotlight: Running MySQL Embedded Server on Windows
- White Paper: A Guide to Securing MySQL Embedded Server on Windows
- White Paper: A Visual Guide to Installing MySQL Embedded Server on Windows
- White Paper: A Guide to Migrating from Microsoft SQL Server to MySQL Embedded Server
- Live Webinar: Running MySQL Embedded Server Securely on Windows (Thursday, June 10)
- On-Demand Webinar: Getting Started Using MySQL Embedded Server with Windows Applications
- On-Demand Webinar: Why and How LiveTime Software Provides Microsoft SQL Server to MySQL Migration for its Customers
Events
- Live Webinar: Scaling Web Services with MySQL Cluster, Part 1: An Alternative to MySQL Server & memcached (Wednesday, June 9)
- MySQL track at Kaleidoscope 2010 (June 27 - July 1, Washington DC)
-------------------------------------------------------------------
Highlights
Developer Interview: What's New in the MySQL Enterprise Spring 2010 Release?
In this interview, Mark Matthews and Andy Bang, two core developers in the MySQL Enterprise Monitor team, give us some insight into the new features in the latest MySQL Enterprise Release.
Read this Developer Interview:
http://dev.mysql.com/tech-resources/interviews/markmatthews_and_andybang_2010.html
White Paper: MySQL Query Analyzer Overview
This paper explores common use cases and challenges faced by MySQL developers and DBAs in tuning SQL code. It also introduces the MySQL Query Analyzer and explains how it can be used to optimize queries during development and then to monitor applications in production environments.
Read the English White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_queryanalyzer.php
Read the German White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_queryanalyzer.php.de
Read the French White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_queryanalyzer.php.fr
Read the Italian White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_queryanalyzer.php.it
Read the Japanese White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_queryanalyzer.php.ja
White Paper: Scaling Web Services with MySQL Cluster: An Alternative Approach to MySQL & memcached
MySQL and memcached has become, and will remain, the foundation for many dynamic web services with proven deployments in some of the largest and most prolific names on the web.
On the other hand, there are classes of web services that are highly transactional and update-intensive, demanding real-time responsiveness and continuous availability. In these cases, MySQL Cluster provides the familiarity and ease-of-use of the regular MySQL Server, while delivering significantly higher levels of write performance with less complexity, lower latency and 99.999% availability.
Read this White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_cluster_ScalingWebServices.php
Case Study: MySQL Cluster Powers Leading Document Management Web Service
The DocQ web service eliminates the limitations of sharing physical documents by offering a complete paperless business solution; providing a single place where customers can manage, archive, and send their important documents. DocQ supports secure business transactions and the services to store, edit, collaborate, and publish business documents with MySQL Cluster.
Read this Case Study:
http://dev.mysql.com/why-mysql/case-studies/mysql_cs-cluster_docudesk_WebServices.php
Case Study: Cashpoint Saves Half a Million Euros per Year as it Bets on MySQL
Cashpoint is a betting and gaming enterprise founded in 1996 in Austria and is the market leader in several EU countries. Cashpoint has an extensive network of betting offices, more than 3,000 betting terminals, and an online betting platform.
The Sybase database that was originally deployed at Cashpoint no longer met their ever-increasing data management requirements. The stability, reliability, and performance did not allow Cashpoint to achieve the required level of service availability. Therefore Cashpoint searched for a stable and low administration database environment to optimize their performance levels, maintenance times, and availability demands.
Read this Case Study:
http://dev.mysql.com/why-mysql/case-studies/mysql_cs_cashpoint.php
TechCast Live: Jono Bacon and Luke Kowalski from Oracle on MySQL Community
Tuesday, June 8, 2010 - 10:00am PT
What makes a productive, thriving community? Look no further than the MySQL example. Bring your questions; we'll answer them in this live, interactive Webcast on June 8, 2010 at 10am PDT.
Join the Webcast:
http://www.oracle.com/technetwork/techcastlive/index.html
Live Webinar: What's New in the MySQL Enterprise Spring 2010 Release
Tuesday, June 15, 2010 - 8:00am PT
The MySQL Enterprise Spring 2010 Release includes key improvements designed to help you proactively optimize MySQL performance and identify potential issues before they can become costly outages or slowdowns. In this webinar, we will explore the new features of the MySQL Enterprise Monitor 2.2 that are designed to save DBAs and Developer time and effort in keeping MySQL systems running at the highest levels of security, performance and availability.
Register for the English Webinar (June 15):
http://dev.mysql.com/news-and-events/web-seminars/display-544.html?p=newsletter
Register for the German Webinar (June 17):
http://dev.mysql.com/news-and-events/web-seminars/display-547.html?p=newsletter
Register for the Italian Webinar (June 24):
http://dev.mysql.com/news-and-events/web-seminars/display-549.html?p=newsletter
Register for the French Webinar (June 29):
http://dev.mysql.com/news-and-events/web-seminars/display-548.html?p=newsletter
-------------------------------------------------------------------
New Product Releases
New Release of MySQL Community Server 5.1.47 (GA)
MySQL Community Server 5.1.47, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.47 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-47.html
Download now:
http://dev.mysql.com/downloads/mysql/5.1.html#downloads
New Release of MySQL Enterprise Monitor 2.2 (GA)
We are excited to announce that MySQL Enterprise Monitor 2.2 is now available on the Enterprise web site as our latest GA release.
The flagship features of this release include:
- Plugins for MySQL Connectors now feed Query Analyzer data directly to the Dashboard
- Support for LDAP authentication
- Easy upload of MySQL diagnostic info to Support
Read the Documentation:
http://dev.mysql.com/doc/mysql-monitor/2.2/en/index.html
View the complete list of changes:
http://dev.mysql.com/doc/mysql-monitor/2.2/en/mem-news-2-2-1.html
New Release of MySQL Workbench 5.2.22 (RC)
We're announcing the second Release Candidate of MySQL Workbench. MySQL Workbench 5.2 RC provides:
1. Data Modeling
2. Query (upgrade from MySQL Query Browser)
3. Admin (upgrade from MySQL Administrator)
If you are a current user of MySQL Query Browser or MySQL Administrator, we look forward to your feedback on all the new capabilities we are delivering in a single unified MySQL Workbench.
View the complete list of changes:
http://dev.mysql.com/doc/workbench/en/wb-news-5-2-22.html
Download now:
http://dev.mysql.com/downloads/workbench/5.2.html
-------------------------------------------------------------------
Hints & Tips
White Paper: What's New in MySQL Enterprise Spring 2010 Release
MySQL is proud to announce the Spring 2010 Release of the MySQL Enterprise Monitor. This release improves the flexibility, usability and scalability of the MySQL Enterprise Monitor to alleviate common pain points for DBAs and developers, so that you can deploy advanced MySQL features more efficiently to build, maintain and scale your on-line applications.
Read the English Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_enterprise_spring_whatsnew.php
Read the German Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_enterprise_spring_whatsnew.php.de
Read the French Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_enterprise_spring_whatsnew.php.fr
Read the Italian Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_enterprise_spring_whatsnew.php.it
Read the Japanese Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_enterprise_spring_whatsnew.php.ja
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: InnoDB recovery gets even faster in Plugin 1.1, thanks to native AIO
Michael Izioumtchenko
InnoDB Plugin 1.1 doesn't add any recovery specific improvements on top of what we already have in Plugin 1.0.7. The details on the latter are available in this blog. Yet, when I tried to recover another big recovery dataset I created, I got the following results for total recovery time: Plugin 1.1 recovery is 1.5 times faster.
Read the PlanetMySQL BlogPost:
http://blogs.innodb.com/wp/2010/05/innodb-recovery-gets-even-faster-in-plugin-1-1-thanks-to-native-aio/
PlanetMySQL Blog: MySQL Sandbox meets plugins
Giuseppe Maxia
In the past year I have been working more and more with plugins. The InnoDB plugins, the semi-synchronous replication plugins, the Gearman UDFs, the Spider plugins, and every time I found myself doing a long installation process, with inevitable mistakes.
Read the PlanetMySQL BlogPost:
http://datacharmer.blogspot.com/2010/05/mysql-sandbox-meets-plugins.html
PlanetMySQL Blog: MySQL Performance: Using Performance Schema
Dimitri Kravtchuk
Two weeks ago I was very lucky to meet in Paris Marc Allf (one of developers of MySQL Performance Schema) and get all details about Performance Schema directly from the source.
Read the PlanetMySQL BlogPost:
http://dimitrik.free.fr/blog/archives/05-01-2010_05-31-2010.html#108
PlanetMySQL Blog: How To Set Up WebDAV With MySQL Authentication On Apache2 (Ubuntu 9.10)
Falko Timme
This guide explains how to set up WebDAV with MySQL authentication (using mod_auth_mysql) on Apache2 on an Ubuntu 9.10 server. WebDAV stands for Web-based Distributed Authoring and Versioning and is a set of extensions to the HTTP protocol that allow users to directly edit files on the Apache server so that they do not need to be downloaded/uploaded via FTP.
Read the PlanetMySQL BlogPost:
http://www.howtoforge.com/how-to-set-up-webdav-with-mysql-authentication-on-apache2-ubuntu-9.10
PlanetMySQL Blog: A Useful Tool to Centrally Manage Many MySQL Instances
Sheeri Cabral
I have been talking with a group of folks who have been making a product that has lots of free functionality, including the ability to centrally manage many MySQL instances. The administration functions include starting and stopping MySQL, seeing status and system variables, seeing and managing the MySQL config file (/etc/my.cnf), seeing and managing accounts, a small dashboard of overall health graphs, and more.
Read the PlanetMySQL BlogPost:
http://www.pythian.com/news/12497/a-useful-tool-to-centrally-manage-many-mysql-instances/
PlanetMySQL Blog: Replication configuration checklist
Shlomi Noach
This post lists the essential and optional settings for a replication environment.
Read the PlanetMySQL BlogPost:
http://code.openark.org/blog/mysql/replication-configuration-checklist
PlanetMySQL Blog: The MySQL Track at Kaleidoscope is set!
Sheeri Cabral
The MySQL track at Kaleidoscope in Washington, DC during June 28 - July 1st is set! Here is the schedule, and Lincoln VI is the MySQL track room.
Read the PlanetMySQL BlogPost:
http://www.pythian.com/news/12555/mysql-at-kaleidoscope/
-------------------------------------------------------------------
Spotlight: Running MySQL Embedded Server on Windows
White Paper: A Guide to 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, including understanding the MySQL security model, user account, password management, and more.
Read this White Paper:
http://dev.mysql.com/why-mysql/white-papers/wp_oem_SecureMySQLOnWindows.php
White Paper: A Visual Guide to Installing MySQL Embedded Server on Windows
The goal of this guide is to make getting started with MySQL Embedded Server on the Windows platform easy for commercial application developers who are new to MySQL and/or are used to using SQL Server. This paper will guide you through the steps and tools needed to get up and running quickly with MySQL Embedded Server on Windows using familiar terms, comparisons, and language.
Read this White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_embedded_visual_guide.php
White Paper: A Guide to Migrating from Microsoft SQL Server to MySQL Embedded Server
This paper provides insight into what is needed when considering a move from SQL Server to MySQL Embedded Server and presents a number of options that help make the transition easy.
Read this White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_mssql2mysqlembedded.php
Live Webinar: Running MySQL Embedded Server Securely on Windows
Thursday, June 10, 2010 - 9:00am PT
In this technical webinar, Jimmy Guerrero and Mike Frank, MySQL Senior Product Managers and Windows experts, will show you how to install and configure MySQL Embedded Server to run securely on Windows.
Register for this Webinar:
http://dev.mysql.com/news-and-events/web-seminars/display-546.html?p=newsletter
On-Demand Webinar: Getting Started Using MySQL Embedded Server with Windows Applications
In this presentation Mike Frank, Sr Product Manager at Oracle, covers the benefits of deploying MySQL Embedded Server with your Windows applications. You will learn the basic "How-Tos" of installation, security and configuration. You'll also learn how to use MySQL Connector/NET and Connector/ODBC, and how to ensure high availability and fault tolerance for MySQL on Windows.
Register for this Webinar:
http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-490.html?p=newsletter
On-Demand Webinar: Why and How LiveTime Software Provides Microsoft SQL Server to MySQL Migration for its Customers
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.
Register for this Webinar:
http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-466.html?p=newsletter
-------------------------------------------------------------------
Events
Live Webinar: Scaling Web Services with MySQL Cluster, Part 1: An Alternative to MySQL Server & memcached
Wednesday, June 9, 2010 - 9:00am PT
This webinar will discuss the use cases for MySQL with memcached and for MySQL Cluster, and provide an insight into how MySQL Cluster is enabling users to scale their update-intensive web services.
Register for this Webinar:
http://dev.mysql.com/news-and-events/web-seminars/display-545.html?p=newsletter
MySQL track at Kaleidoscope 2010 (June 27 - July 1, Washington DC)
The Oracle Development Tools Users Group (ODTUG) is holding its annual conference, Kaleidoscope 2010, in Washington, DC, from June 27th to July 1st. By popular demand, there will be a MySQL track organized by the MySQL community filled with technical content. Join us and meet with the MySQL experts!
Learn more:
http://www.odtugkaleidoscope.com/MySQL.html
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?
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.
No comments:
Post a Comment