MySQL Newsletter September 2010
Articles in this newsletter:
- Event: MySQL Sunday at Oracle OpenWorld - Last Chance to Register! (September 19)
- Event: MySQL Sessions at DOAG Conference 2010 - Nuremberg, Germany (November 16-18)
- Announcing the MySQL Japanese Newsletter
- Quickpoll: What concerns you most about your current MySQL backup solution?
- The MySQL Community Team is Hiring
- White Paper: Session Management with MySQL
- White Paper: Guide to Optimizing Performance of the MySQL Cluster Database
- Case Study: Promovacances.com boosts its performance with MySQL Enterprise and the Query Analyzer
- Case Study: MySQL Cluster Powers Leading Document Management Web Service
- Live Webinar: Getting the Best MySQL Performance in Your Products: Part 2, Beyond the Basics (Wednesday, September 15)
- Live Webinar: MySQL Essentials Part 4: How to Develop Simple .NET Applications for MySQL (Thursday, September 30)
- New Release of MySQL Community Server 5.1.50 (GA)
- New Release of MySQL Connector/ODBC 5.1.7 (GA)
- New Release of MySQL Workbench 5.2.27 (GA)
- CEO Interview: AlSego develops financial applications with MySQL
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: MySQL Cluster on Windows
- PlanetMySQL Blog: MySQL Master High Availability at Yahoo
- PlanetMySQL Blog: Binary Log Group Commit - Recovery
- PlanetMySQL Blog: PHP @ FrOSCon: the power of mysqlnd plugins
- PlanetMySQL Blog: Improving InnoDB Transaction Reporting
- PlanetMySQL Blog: No, DRBD doesn't magically make your application crash safe
- PlanetMySQL Blog: Easy MySQL: how to backup databases to a remote machine
- PlanetMySQL Blog: MySQL Workbench Plugin: Execute Query to Text Output
- PlanetMySQL Blog: Upcoming MySQL Conferences
- PlanetMySQL Blog: Managing load-balanced Connector/J deployments with MySQL Cluster
- PlanetMySQL Blog: Why GRANT ALL is bad
- PlanetMySQL Blog: Tips for taking MySQL backups using LVM
- Live Webinar: MySQL Cluster: 5 Steps to Getting Started, then 5 More to Scale for the Web (Wednesday, September 8)
- Live Webinar: Scaling Web Services with MySQL Cluster, Part 1: An Alternative to MySQL Server & memcached - German (Wednesday, September 8)
- Live Webinar: Scaling Web Services with MySQL Cluster - Italian (Thursday, September 9)
- Live Webinar: Oracle Outlines Strategy for MySQL - Portuguese (Tuesday, September 14)
- Live Webinar: Getting Started with MySQL on Windows - Japanese (Thursday, September 30)
MySQL Sunday is a half-day conference with 4 highly technical tracks, covering the latest on MySQL High Availability, Scalability, MySQL Performance Tuning, and more. Don't miss this great opportunity to learn from the MySQL experts and hear the keynotes from Edward Screven, Oracle's Chief Corporate Architect, and Marten Mickos, CEO of Eucalyptus. MySQL Sunday is happening as part of Oracle OpenWorld in San Francisco, one of the largest IT events worldwide.
The DOAG is the German association of users for Oracle products. In November 16-18, they will hold their annual Oracle Users Conference 2010, which will take place in Nuremberg, Germany. For the first time, this year's conference will also have a dedicated stream of sessions about MySQL.
MySQL Newsletter is now available in Japanese, in addition to the English and German versions. You can subscribe to the Japanese Newsletter by editing newsletter subscriptions in your MySQL account profile.
日本語版 MySQL ニュースレターのご案内
毎月1回、日本語の MySQL ニュースレターを配信しています。この日本語版MySQLニュースレターの購読は、MySQLアカウントのプロファイル設定をご変更いただくことで可能になります。下記リンクより MySQL アカウントにログイン後、MySQL アカウントの編集ページ下部にある「サブスクリプション(Subscription)」 個所の 「ニュースレターや通知メールの言語 (Send me the newsletter and/or notifications in)」 項目で、"Japanese" をご指定ください。
A new quickpoll is posted on the MySQL Developer Zone about your MySQL backup solution.
Our team at Oracle needs to grow in order to better serve the growing MySQL Community, and we are starting by filling the position for MySQL Community Manager in a place with a significantly large MySQL user base: North America.
An inherent characteristic about the web and one of the most common technical issues when designing and maintaining the web infrastructure, is addressing the stateless interaction between the user's browser and the web server from which the pages are requested. In this paper we explore how MySQL and MySQL Cluster can be used as part of a cost-effective, high-performance, open-source solution for database-centric session management.
This guide explores how to tune and optimize the MySQL Cluster database to handle diverse workload requirements. It discusses data access patterns and how to build distribution awareness into applications, exploring schema and query optimization, tuning of parameters and how to get the best out of the latest innovations in hardware design.
Launched in 1998, Promovacances is a brand of the Karavel group, the leading provider of vacation packages online in France. Promovacances.com gets about 40 million individual visitors per year and 250,000 per day during the high season.
The MySQL Enterprise Platinum subscription gives Karavel access to 24/7 technical support as well as to the MySQL Enterprise Monitor including the MySQL Query Analyzer.
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.
MySQL Cluster was selected as it met all of the requirements of the service with one, integrated solution out of the box. MySQL Cluster is handling 1 million queries on average per day across both in-memory and disk-based tables, with the database growing at up to 2% daily.
Wednesday, September 15, 2010 - 9:00am PT
In Part 2 of a three-part performance series, MySQL performance expert Brian Miezejewski will take you beyond the basics and show you the next set of steps to take when architecting your product's MySQL embedded or bundled database for higher performance and customer satisfaction.
In this session, Brian will build on the steps he covered in Part 1, the Fundamentals and will review more advanced topics, including monitoring, data and key caches, sessions, tuning, sorting and other server tuning tips.
Thursday, September 30, 2010 - 9:00am PT
In this webinar we will explore the use of MySQL as the underlying database for .NET applications. Using several example programs, we will dive into how to develop a few starter applications for MySQL in C# and ASP.Net using Visual Studio. We will also guide you through the process from installing MySQL Connector/NET, setting up Visual Studio, starting a project, designing, coding and running these simple .NET applications.
MySQL Community Server 5.1.50, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.50 is recommended for use on production systems.
MySQL Connector/ODBC 5.1.7, 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.
We're proud to announce the next release of MySQL Workbench, version 5.2.27. This is the second maintenance release for 5.2 GA (Generally Available) and focuses on general product improvement and usability. We hope you will make MySQL Workbench your preferred tool for Design, Development, and Administration of your MySQL database applications.
AlSego, based in Luxembourg, builds business intelligence reporting and integration solutions with MySQL Enterprise. Marc Van Oost, the CEO of AlSego, shares how MySQL addresses the flexibility, security and performance challenges of AlSego's financial applications.
Read the Interview »
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.
So you thought that just because MySQL Cluster 7.1 is GA on Windows that NDB API was available and you could just download the MySQL Cluster 7.1 binary for Windows and start hacking the NDB API. Nope. But fear not, there is help!
I was asked to write a blog post about MySQL High Availability at Yahoo, particularly for writes. Our standard practice is not particularly high-tech, but we've been using it for over 4 years now and it has become a company-wide standard with a few exceptions.
In the previous article, an approach was outlined to handle the binary log group commit. The basic idea is to use the binary log as a ticketing system by reserving space in it for the transactions that are going to be written. This will provide an order on the transactions as well as allowing writing the transactions in parallel to the binary log, thereby boosting performance.
Slowly the power of mysqlnd plugins becomes visible. Mysqlnd plugins challenge MySQL Proxy and are often a noteworthy, if not superior, alternative to MySQL Proxy for PHP users.
Everybody knows that parsing the output of SHOW ENGINE INNODB STATUS is hard, especially when you want to track the information historically, or want to aggregate any of the more dynamic sections such as the TRANSACTIONS one.
It is a common misconception that DRBD (or any block-level data replication) solution can magically make an application crash-safe that intrinsically isn't.
Here's a simple answer to a simple question. "How do I run a backup of MySQL to another machine without writing to the local server's filesystem?" - this is especially useful if you are running out of space on the local server and cannot write a temporary file to the filesystem during backups.
In MySQL Workbench 5.2.26 a new query execution command is available, where query output is sent as text to the text Output tab of the SQL Editor. Some MySQL Workbench users liked the "Results to Text" option available in Microsoft SQL Server Management Studio. Cool thing is with a few lines of Python we implemented this command using the SQL Editor scripting API.
Unlike previous years when the number of conferences with MySQL content diminishes after the O'Reilly MySQL and OSCON conferences (Open SQL Camp excluded), this year has a lot to offer.
Connector/J has long provided an effective means to distribute read/write load across multiple MySQL server instances for Cluster or master-master replication deployments, but until version 5.1.13, managing such deployments frequently required a service outage to redeploy a new configuration.
A common observation for many LAMP stack products is the use of poor MySQL security practices. Even for more established products such as Wordpress don't always assume that the provided documentation does what is best for you.
LVM uses copy-on-write to implement snapshots. Whenever you're writing data to some page, LVM copies the original page to the snapshot volume. The snapshot volume must be large enough to accommodate all pages written to for the duration of the snapshot's lifetime. In other words, you must be able to copy the data somewhere outside in less time than it would take for the snapshot to fill up.
Wednesday, September 8, 2010 - 9:00am PT
This session will demonstrate how to start an evaluation of the MySQL Cluster database in 5 easy steps, and then how to expand your deployment for web and telecoms-scale services.
Live Webinar: Scaling Web Services with MySQL Cluster, Part 1: An Alternative to MySQL Server & memcached - German
Wednesday, September 8, 2010 - 15:00 CET
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. There are classes of web services, however, that are 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.
This webinar will discuss the use-cases for both approaches, and provide an insight into how MySQL Cluster is enabling users to scale their update-intensive web services.
Thursday, September 9, 2010 - 10:00 CET
There are two common choices to power web applications. 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. The MEMORY storage engine has also been widely adopted by MySQL users to provide near-instant responsiveness with use cases such as caching and web session management.
The MySQL Cluster database, which itself can be implemented as a MySQL storage engine, is a viable alternative to address increased web service demands. This webinar will discuss the use-cases for all three approaches, and provide an insight into how MySQL Cluster is enabling users to scale their update-intensive web services.
Tuesday, September 14, 2010 - 9:30am Brazil Time
MySQL is the world's most popular open source database software, with over 100 million copies of its software downloaded or distributed throughout its history. Many of the world's largest and fastest-growing organizations use MySQL to save time and money powering their high-volume websites, critical business systems, and packaged software - including industry leaders such as Yahoo, Globo, TRF4, Google, Facebook, Paggo and Banco de Republica.
In this webinar you will learn more about the current and future state of MySQL, now part of the Oracle family of products. We will also cover Oracle's investment in MySQL technology and community, directed toward making MySQL an even better MySQL.
Thursday, September 30, 2010 - 14:00 JST
MySQL has been widely adopted and popular on Windows, with 45,000 downloads per day for Windows packages. Its ease of use allows you to download, configure and start using MySQL very quickly.
In this webinar, you will learn the basic "How-To's" for MySQL installation, security and configuration. We will also show you how to get started using MySQL tools on Windows.
More free MySQL webinars are scheduled and added between each Newsletter edition, so visit our website frequently for the most updated information.