MySQL Newsletter November 2007

Articles in this newsletter:

Training, Consulting & Certification

Partner Corner

XAware 5 Open Source Data Integration Project for MySQL

Highlights

MySQL Lunch & Learn Program

The "MySQL Lunch-n-Learn Program" is designed to be a fun and informal educational event for your team. MySQL provides the technical experts, and brings lunch! Select a topic of your choice:

MySQL Enterprise Monitor, Replication Monitor, and Scale-Out
MySQL High Availability and Scalability Architectures
MySQL Performance Tuning - Advanced Tips & Tricks
MySQL Partitioning
MySQL for Data Warehousing
MySQL for the Oracle DBA
MySQL Cluster - Carrier Grade Edition (for Telecoms only)
Embedded Databases: Why MySQL is a perfect fit for ISV applications

Win a MySQL Conference Pass - Take the MySQL User Survey

Please take a few moments to complete our annual user survey, and you could win a pass to join over 1600 MySQL enthusiasts at the MySQL Conference, April 14-17, 2007 in Santa Clara, California.

Take the Survey (On Zoomerang) »

Case Study: iStockphoto Grows to a Top-100 U.S. Website using MySQL

iStockphoto is the world's busiest image market, with an image downloaded every 2.5 seconds. For their Web site, scalability has become mission-critical. Being able to manage increasing volumes of data and transactions has to be carefully balanced with IT budgets and resource expenditures.

Read the Case Study » (http://www.mysql.com/why-mysql/scaleout/istockphoto.html)

30 Day Trials for MySQL Enterprise Monitor

You can experience the power of the MySQL Enterprise Monitor at no charge for 30 days. This Service continuously monitors your MySQL servers and alerts you to potential problems before they impact your system. It is like having a "Virtual DBA Assistant" at your side to recommend best practices to eliminate security vulnerabilities, improve replication, optimize performance and more.

MySQL is Hiring

Apply today to join one of the largest and fastest growing open source companies! MySQL is a global organization with over 300 employees in 25 countries. We have openings for the following positions:

Support Engineers
Senior Software Developers
QA Engineers
Senior Sales Representatives
Sales Engineers
And More ...

Apply Now » (http://www.mysql.com/jobs/)

New Product Releases

Fall 2007 Release of MySQL Enterprise Monitor

This latest release adds new advanced replication monitoring, graphs and best practice advisor rules. The new feature set includes:

New Replication Monitor provides real time visibility into Replication health and status, master/slave performance, and latency issues. (Gold and Platinum)
Master/slave relationships are now auto detected and grouped giving DBAs immediate visibility into their Replication topologies
New rules for monitoring master and slave configuration, status, performance and latency

Download the White Paper, What's New: MySQL Enterprise Monitor » (http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-fall-whatsnew.php)

Download the MySQL Enterprise Monitor: (Login Required) »

New Release of MySQL Enterprise Server 5.0.50

This is a Monthly Rapid Update release of the MySQL Enterprise Server 5.0. Following is a partial list of changes and bug fixes:

Bug Fix: Server parser performance was improved for expression parsing by lowering the number of state state transitions and reductions needed. (Bug#30625)
Incompatible Change: The parser accepted statements that contained /* ... */ that were not properly closed with */, such as SELECT 1 /* + 2. Statements that contain unclosed /*-comments now are rejected with a syntax error. (Bug#28779)
Bug Fix: A server crash could occur when a non-DETERMINISTIC stored function was used in a GROUP BY clause. (Bug#31035)

View the complete list of changes »

Download Now: (Login Required) »

New Release of MySQL Community Server 5.1.22 (Release Candidate)

MySQL Server 5.1.22-rc release is the first 5.1 "Release Candidate" version of MySQL. Following is a partial list of changes and bug fixes:

There is a new innodb_autoinc_lock_mode system variable to configure the locking behavior that InnoDB uses for generating auto-increment values.
Bug fix: MySQL Cluster: (Replication): Multi-master replication setups did not handle --log-slave-updates correctly.
Bug fix: Row-based replication from a pre-5.1.22 MySQL Server to a MySQL 5.1.22 was unstable due to an uninitialized variable.

View the complete list of changes »

Download Now »

Hints & Tips

Article: A look at MySQL on ZFS

John David Duncan

When Sun Microsystems released the ZFS filesystem in 2004, they set out to remove all of the practical limits on filesystem storage, and to make the arcane details of storage management a thing of the past. ZFS is a 128-bit filesystem with - to name just a few features - copy-on-write transactional semantics, fast snapshots, and optional compression.

Read the Article »

Article: MySQL Failover Strategy using State Management, introducing MPP - Part 1

Russell E Glaue

Having a strategy for failover has become almost standard in the business world. Whether it is a total site failover from a NOC in one city to another, or just a simple redundant server. Over the years many technology solutions have been created for or adapted to MySQL to provide this type of strategy.

Read the Article »

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 MySQL, including technical tips and best practices.

Visit PlanetMySQL »

Submit Your Blog Feed »

PlanetMySQL Blog: Using MySQL Table Checksum

Ronald Bradford

The MySQL Table Checksum, part of the MySQL Toolkit is an invaluable community tool for use with MySQL. Most sites or installations of any volume will use MySQL Replication for one purpose or another, be it for read scalability, backups, testing, upgrading etc.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: How to Keep MySQL Replication in Sync

Mark Callaghan

There is a great article on how using LIMIT clauses in update and delete statements can produce different results on a slave than it did on the master. If you really want to keep a master and slave in sync, I have a larger list of rules to follow for SQL that is run on a master.

Read the PlanetMySQL Blogpost »

BLOB Streaming presentation at the Hamburg MySQL User Group

Paul McCullagh

I have just posted the presentation that I gave at the Hamburg MySQL User Group last Tuesday. You can download the presentation here. I have added a few slides on advanced topics: backup, replication and the distributed repository, which did not actually make it into my talk. However, these topics came up in the discussion over a few drinks afterwards.

Read the PlanetMySQL Blogpost »

New Forums

memcached and MySQL

Since many leading web sites use memcached with MySQL, we have now created a dedicated discussion forum. MySQL Engineers will be participating in the discussions.

Visit the Forum »

Events

Live Web Seminar: Backup and Recovery of MySQL Servers

Thursday November 15, 2007 (German)
Tuesday November 20, 2007 (French)

Join us for a webinar covering best practices for doing full and incremental backups of your MySQL servers. In this webinar we will cover:

MySQL Backup Principals
Physical and Logical Security
Backups using multiple storage engines
mysqldump
Replication
Recovering secure data

Live Web Seminar: Advanced Techniques: MySQL Circular Replication

Wednesday, December 05, 2007
Mike Gaydos, System Architect, EDS

Join us for this webinar where you can learn about a practical implementation of MySQL multi-master circular replication.

In this webinar learn about a use case along with operational process sequences that can be used to effectively manage the environment. We will explore what multi-master replication is, considerations for setting it up and then how it can be used to provide value to your applications.

Live Webinar: MySQL vs. Oracle Express: an ISV Perspective

Tuesday, December 11, 2007

When bringing a new product to market, an ISV faces a collection of key business and technology decisions. One of the most important determinations revolves around selecting an embedded database to include with their new product. Hundreds of successful ISVs have already done their homework and chosen MySQL as their data storage architecture. This has radically changed the game in the relational database market, especially with regard to embedded solutions.

Training, Consulting, and Certification

Consulting: MySQL Scale-Out, High-Availability and Replication Jumpstart (4 Days)

In this engagement, a dedicated MySQL certified consultant will work closely with your team to:

Analyze your Scale-out and High-Availability database requirements
Identify potential issues and limitations
Install, Configure and Fine-Tune MySQL
Configure MySQL or MySQL Cluster to work with HA Technologies (e.g. DRBD, SAN, Shared SCSI, Heartbeat, etc), as required
Secure your database environment against failures and downtime
And more ...

Schedule your Engagement Now » (http://www.mysql.com/consulting/packaged/scaleout.html)

Training: MySQL Partitioning (Virtual Course, 1 Day)

November, 20 2007

This instructor-led course is designed for MySQL users who would like to use the new partitioning features available in the MySQL 5.1. This course provides in-depth information in an E-Learning classroom format that is easily accessible and affordable.

Partners

XAware 5 Open Source Data Integration Project for MySQL

The XAware 5 Open Source Data Integration Project adds comprehensive XML capabilities to MySQL. Easily create, update, join, federate, construct, and expose MySQL data as services. XML provides the most effective way of representing and manipulating business data. It has become the de-facto method for transforming data to and from web-based applications and between business partners in B2B exchanges.

Learn More »

The MySQL Team