MySQL Newsletter June 2010
Articles in this newsletter:
- 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 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)
- 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!
- 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
- 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)
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.
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://www.mysql.com/why-mysql/white-papers/mysql-query-analyzer-overview/)
Read the German White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql-query-analyzer-uberblick/)
Read the French White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql-query-analyzer-vue-densemble/)
Read the Italian White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql-query-analyzer-panoramica/)
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.
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.
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.
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.
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.
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.
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
We're announcing the second Release Candidate of MySQL Workbench. MySQL Workbench 5.2 RC provides:
- Data Modeling
- Query (upgrade from MySQL Query Browser)
- 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.
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://www.mysql.com/why-mysql/white-papers/mysql_wp_enterprise_spring_whatsnew.php)
Read the German Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_enterprise_spring_whatsnew.php.de)
Read the French Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_enterprise_spring_whatsnew.php.fr)
Read the Italian Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_enterprise_spring_whatsnew.php.it)
Read the Japanese Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_enterprise_spring_whatsnew.php.ja)
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.
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.
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.
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.
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.
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.
This post lists the essential and optional settings for a replication environment.
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.
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.
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://www.mysql.com/why-mysql/white-papers/guide-to-installing-mysql-embedded-server-on-windows/)
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://www.mysql.com/why-mysql/white-papers/guide-to-migrating-from-microsoft-sql-server-to-mysql/)
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.
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.
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.
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.
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!
More free MySQL webinars are scheduled and added between each Newsletter edition, so visit our website frequently for the most updated information.