Database News: MySQL Newsletter: September 2010

MySQL Newsletter
September 2010
mysql-newsletter@sun.com

Articles in this newsletter:

Highlights

- 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 Product Releases

- 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)

Hints & Tips

- 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

Events

- 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)

-------------------------------------------------------------------

Highlights

Event: MySQL Sunday at Oracle OpenWorld - Last Chance to Register! (September 19)

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.

Learn More:
http://blogs.sun.com/datacharmer/entry/marten_mickos_strikes_back

View the Sessions and Speakers:
http://blogs.sun.com/MySQL/entry/mysql_sunday_tracks_at_oracle

Event: MySQL Sessions at DOAG Conference 2010 - Nuremberg, Germany (November 16-18)

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.

View the full list of MySQL sessions:
http://www.lenzg.net/archives/306-Speaking-at-the-DOAG-Conference-in-Nuremberg.html

Announcing the MySQL Japanese Newsletter

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.

Edit your MySQL Account (Log-in Required):
http://dev.mysql.com/profile/

Quickpoll: What concerns you most about your current MySQL backup solution?

A new quickpoll is posted on the MySQL Developer Zone about your MySQL backup solution.

Take the Quickpoll:
http://dev.mysql.com/tech-resources/quickpolls/

The MySQL Community Team is Hiring!

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.

Learn More:
http://blogs.sun.com/MySQL/entry/the_mysql_community_team_is

White Paper: Session Management with MySQL

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.

Read this White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_session_mngmnt.php

White Paper: Guide to Optimizing Performance of the MySQL Cluster Database

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.

Read the English White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_cluster_perfomance.php

Read the French White Paper:
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_cluster_perfomance.php.fr

Case Study: Promovacances.com boosts its performance with MySQL Enterprise and the Query Analyzer

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.

Read this Case Study:
http://dev.mysql.com/why-mysql/case-studies/mysql_cs_karavel_travelling.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.

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.

Read this Case Study:
http://dev.mysql.com/why-mysql/case-studies/mysql_cs-cluster_docudesk_WebServices.php

Live Webinar: Getting the Best MySQL Performance in Your Products: Part 2, Beyond the Basics
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.

Live Webinar: MySQL Essentials Part 4: How to Develop Simple .NET Applications for MySQL
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.

-------------------------------------------------------------------

New Product Releases

New Release of MySQL Community Server 5.1.50 (GA)

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.

View the complete list of changes:
http://dev.mysql.com/doc/refman/5.1/en/news-5-1-50.html

Download now:
http://dev.mysql.com/downloads/mysql/5.1.html#downloads

New Release of MySQL Connector/ODBC 5.1.7 (GA)

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.

View the complete list of changes:
http://dev.mysql.com/doc/refman/5.1/en/connector-odbc-news-5-1-7.html

Download now:
http://dev.mysql.com/downloads/connector/odbc/5.1.html

New Release of MySQL Workbench 5.2.27 (GA)

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.

View the complete list of changes:
http://dev.mysql.com/doc/workbench/en/wb-news-5-2-27.html

Download now:
http://dev.mysql.com/downloads/workbench/

-------------------------------------------------------------------

Hints & Tips

CEO Interview: AlSego develops financial applications with MySQL Enterprise

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:
http://dev.mysql.com/tech-resources/interviews/marc-van-oost-alsego.html

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: MySQL Cluster on Windows
Anders Karlsson

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!

Read the PlanetMySQL BlogPost - Part 1: NDB API:
http://karlssonondatabases.blogspot.com/2010/08/mysql-cluster-on-windows-ndb-api-part-1.html

Read the PlanetMySQL BlogPost - Part 2: Set up a dev environment:
http://karlssonondatabases.blogspot.com/2010/08/mysql-cluster-on-windows-not-so-ndb.html

Read the PlanetMySQL BlogPost - Part 3: The Code:
http://karlssonondatabases.blogspot.com/2010/08/mysql-cluster-on-windows-ndb-api-part-3.html

Read the PlanetMySQL BlogPost - Part 4: Finishing it up:
http://karlssonondatabases.blogspot.com/2010/08/mysql-cluster-on-windows-ndb-api-part-4.html

PlanetMySQL Blog: MySQL Master High Availability at Yahoo
Jay Janssen

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.

Read the PlanetMySQL BlogPost:
http://mysqlguy.net/blog/2010/08/03/mysql-master-ha-yahoo

PlanetMySQL Blog: Binary Log Group Commit - Recovery
Mats Kindahl

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.

Read the PlanetMySQL BlogPost:
http://mysqlmusings.blogspot.com/2010/08/binary-log-group-commit-recovery.html

PlanetMySQL Blog: PHP @ FrOSCon: the power of mysqlnd plugins
Ulf Wendel

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.

Read the PlanetMySQL BlogPost:
http://blog.ulf-wendel.de/?p=293

PlanetMySQL Blog: Improving InnoDB Transaction Reporting
Mark Leith

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.

Read the PlanetMySQL BlogPost:
http://www.markleith.co.uk/?p=367

PlanetMySQL Blog: No, DRBD doesn't magically make your application crash safe
Florian Haas

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.

Read the PlanetMySQL BlogPost:
http://fghaas.wordpress.com/2010/08/17/no-drbd-doesnt-magically-make-your-application-crash-safe/

PlanetMySQL Blog: Easy MySQL: how to backup databases to a remote machine
Matt Reid

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.

Read the PlanetMySQL BlogPost:
http://themattreid.com/wordpress/2010/08/13/easy-mysql-how-to-backup-databases-to-a-remote-machine/

PlanetMySQL Blog: MySQL Workbench Plugin: Execute Query to Text Output
Alfredo Kojima

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.

Read the PlanetMySQL BlogPost:
http://wb.mysql.com/?p=677

PlanetMySQL Blog: Upcoming MySQL Conferences
Ronald Bradford

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.

Read the PlanetMySQL BlogPost:
http://ronaldbradford.com/blog/upcoming-mysql-conferences-2010-08-09/

PlanetMySQL Blog: Managing load-balanced Connector/J deployments with MySQL Cluster
Todd Farmer

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.

Read the PlanetMySQL BlogPost:
http://mysqlblog.fivefarmers.com/2010/08/03/managing-load-balanced-connectorj-deployments-2/

PlanetMySQL Blog: Why GRANT ALL is bad
Ronald Bradford

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.

Read the PlanetMySQL BlogPost:
http://ronaldbradford.com/blog/why-grant-all-is-bad-2010-08-06/

PlanetMySQL Blog: Tips for taking MySQL backups using LVM
Shlomi Noach

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.

Read the PlanetMySQL BlogPost:
http://code.openark.org/blog/mysql/tips-for-taking-mysql-backups-using-lvm

-------------------------------------------------------------------

Events

Live Webinar: MySQL Cluster: 5 Steps to Getting Started, then 5 More to Scale for the Web
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.

Live Webinar: Scaling Web Services with MySQL Cluster - Italian
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.

Live Webinar: Oracle Outlines Strategy for MySQL - Portuguese
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.

Live Webinar: Getting Started with MySQL on Windows - Japanese
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.

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/

Problems reading the newsletter in your email client? View the newsletter on the web.
http://dev.mysql.com/news-and-events/newsletter/2010/2010-08.html

--
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.

Database News

Thursday, September 2, 2010

MySQL Newsletter: September 2010

No comments:

Post a Comment

Followers

Blog Archive

About Me