Subject: MySQL Newsletter: March 2007

From: MySQL AB <[email-masked]>
Date: Fri, 9 Mar 2007 15:55:15 +0100

MySQL Newsletter
March 2007
[email-masked]

Articles in this newsletter:

Highlights: MySQL Conference & Expo - Register Before March 14th

Early Registration Ends March 14th - Save $200

15 In-depth Half-day Tutorials

100+ Technical Sessions

MySQL Expert Speakers

Get Certified at the Conference

Learn About New Products & Technologies

New Product Releases

MySQL 5.1.16 (Beta)

MySQL Connector/J 5.0.5 (GA)

Hints & Tips

PlanetMySQL Blog: Jay Pipes Speaks About the MySQL Conference

PlanetMySQL Blog: Benchmarking Node Restarts Times in MySQL Cluster 5.1

PlanetMySQL Blog: Analyzing Complex Queries

PlanetMySQL Blog: MySQL Conference Speaker Spotlight: Joe O'Brien

Article: A Look at the PBXT Storage Engine

Events

Live Web Seminar: Cost-effective Scale-out with MySQL

Live Web Seminar: Jasper for MySQL, OEM Edition Empowers MySQL Customers to Deliver Embeddable Operational Reporting

Live Web Seminar: An Introduction to High Availability Architectures with MySQL and DRBD

Training, Consulting & Certification

Consulting: MySQL Performance Tuning & Optimization (3+ Days)

Training: MySQL 5.0 for Database Administrators (5 days)

Partner Corner

Showcase Your Solution at the 2007 MySQL Conference and Expo

Highlights

Early Registration Ends March 14th - Save $200

The MySQL Users Conference 2007, April 23-26, in Santa Clara, California will be the largest gathering with over 2000 MySQL developers, DBAs and users. The theme this year is "Scale to New Heights with MySQL". At the upcoming conference you will:

Learn how to optimize the performance of MySQL

Get expert insight into MySQL Replication

Scale-out PHP, LAMP, and Java applications

Uncover new High Availability architectures

Find out how Google, Yahoo, and Digg Scale

Geek out with the Developers who built MySQL

And much more ...

Register by March 14th and Save $200 »

15 In-depth Half-day Tutorials

Take advantage of this rare opportunity to get hands-on knowledge from MySQL Experts on numerous topics. Tutorials are half-day presentations that give you the opportunity to learn a topic in-depth, in a collaborative environment. Register early, so you won't be disappointed when tutorials sell out.

Real-World MySQL Performance Tuning

Ask Bjørn Hansen, Develooper.com

Jay Pipes, Community Relations Manager, MySQL AB

MySQL Replication: The Complete Tutorial

Lars Thalmann, Replication and Clustering Technology, MySQL

MySQL 5.1 In-depth

Brian Aker, Director of Architecture, MySQL AB

MySQL Cluster: The Complete Tutorial

Stewart Smith, MySQL Cluster Developer, MySQL AB

MySQL Network Monitoring and Advisory Services: From Soup to Nuts

Andy Bang, Director of MySQL Network, MySQL

View all the Tutorials »

100+ Technical Sessions

We will have over 100+ hands-on Tutorials and Sessions covering Security, Replication, Performance Tuning, High Availability, and Scalability. The Sessions will be run by MySQL developers and MySQL experts who know the product inside and out, and have real world experience implementing MySQL Projects. Here are some more session highlights:

MySQL Performance Cookbook

Peter Zaitsev, Co-Founder, Percona Ltd

Managing MySQL the Slack Way: How Google Deploys New MySQL Servers

Michael Still, Corporate Reliability Engineer, Google Inc

Grant Allen, Google, Inc.

Federation at flickr: Doing Billions of Queries Per Day

Dathan Pattishall, Senior Support Engineer, flickr.com

The 7 Stages of Scaling Web Applications: Strategies for Architects

John Engates, CTO, Rackspace Managed Hosting

High Performance Data Warehousing with MySQL: Tricks and Tips from the Field

Brian Miezejewski, Principal Consultant, MySQL inc.

Inside Falcon: MySQL's Newest Storage Engine

Jim Starkey, Senior Software Architect, MySQL AB

Scaling MySQL for Mission Critical Applications

Jacob Taylor, Co-founder and CTO, SugarCRM

View the complete list of sessions »

MySQL Expert Speakers

MySQL Conference Speakers include both the engineers who build MySQL and leading experts who are implementing MySQL in real-world environments.

Rasmus Lerdorf - PHP Guru, Yahoo!

Brian Aker - Director of Architecture, MySQL

Ask Bjørn Hansen - Develooper.com

Kevin Rose - Founder & Chief Architect - digg

Andi Gutmans - CTO, Zend Technologies, Inc

Jeremy Cole - MySQL Geek, Proven Scaling

Barry Klawans - CTO, JasperSoft

Mike Hillyer - OmniIT

John Newton - CTO, Alfresco.org

Julian Hyde - Chief Architect OLAP, Pentaho

Dathan Pattishall - Software Engineer, flickr.com

Mark D. Matthews - Developer Connector/J, MySQL

Michael Still - Google

Lars Thalman - Replication Technical Lead, MySQL

View the Complete List of Speakers »

Get Certified at the Conference

Certification Exams are being offered at special discounted price of $25 ($175 value). Space is limited, so pre-register to guarantee your seat at the conference.

Sign up Now »

Learn About New Products & Technologies

Every year, the MySQL Conference also features an Expo Hall where you will have the chance to meet with some of the leading innovators driving change in the open source market. The Expo Hall will give you plenty of opportunities to spend time with MySQL partners to learn more about the latest products that help you get the most out of your MySQL environment. 2007 Exhibitors and Sponsors include:

Google

Hewlett Packard

Zmanda

Alfresco

Webyog

Four J's

Dolphin Interconnect

Nitro Security

JasperSoft

Pentaho

Actuate

BakBone

Unisys

Sun

And many more.

View the Current List of Sponsors and Exhibitors »

New Product Releases

New Release of MySQL 5.1.16 (Beta)

This is a new Beta development release, fixing recently discovered bugs. The following is a partial list of changes:

In the INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS table, the UNIQUE_CONSTRAINT_NAME column incorrectly named the referenced table. Now it names the referenced constraint, and a new column, REFERENCED_TABLE_NAME, names the referenced table.

The bundled yaSSL library was upgraded to version 1.5.8

NDB Cluster: A number of new and more descriptive error messages covering transporter errors were added.

View the complete list of changes »

Download Now »

New Release of MySQL Connector/J 5.0.5 (GA)

MySQL Connector/J 5.0.5 is a new version of the Type-IV pure-Java JDBC driver for MySQL. Version 5.0.5 is suitable for use with any MySQL version including MySQL-4.1, MySQL-5.0, MySQL-5.1 beta or the MySQL-5.2 Falcon "Preview". The following is a partial list of changes:

Improved speed of datetime parsing for ResultSets that come from plain or non-server-side prepared statements. If any regressions are noticed, you can enable the old implementation with useFastDateParsing=false as a configuration parameter.

Changed cached result set metadata (when using cacheResultSetMetadata=true) to be cached per-connection rather than per-statement as previously implemented.

Fixed cases where ServerPreparedStatements weren't using cached metadata when cacheResultSetMetadata=true was used.

View the complete list of changes »

Download Now »

Hints & Tips

PlanetMySQL Blog: OurSQL Episode 9: Jay Pipes Speaks About the MySQL Conference

Sheeri Kritzer

This week I spoke with MySQL Conference Chairperson, Jay Pipes about the exciting sessions, tutorials and events scheduled at the upcoming MySQL Conference, April 23-26 in Santa Clara, California, USA.

Read the PlanetMySQL Blog post »

PlanetMySQL Blog: Benchmarking Node Restarts Times in MySQL Cluster 5.1

Johan Andersson

When you have a node failure the best practice is to restart the ndbd node as soon as possible. This blog illustrates what happens with restart times:

If you have configured TimeBetweenLocalCheckpoints wrong and have a high load

If you don't restart the failed ndbd node immediately

How long time it takes to resync 1GB of data with and without ongoing transactions.

Read the PlanetMySQL Blog post »

PlanetMySQL Blog: Analyzing Complex Queries

Jan Kneschke

When you ask someone how to optimize SQL queries you will always get the following answer:

Enable the slow query log

Set the long-query-time to 1-2 seconds

Enable the logging of query which aren't using an index

Run EXPLAIN on the queries that are shown and optimize them with proper indexes

But how do you understand what the EXPLAIN is telling you?

Read the PlanetMySQL Blog post »

PlanetMySQL Blog: MySQL Conference Speaker Spotlight: Joe O'Brien

Jay Pipes

Joe is teaching a 3 hour tutorial on Monday called "Vital Rails: An Introduction to the Rails Framework". The tutorial promises to be one of the most popular ones, as Ruby, and Rails in particular, is always a highly requested conference topic. Joe will be covering the Rails framework, with a focus on ActiveRecord, the framework's critical component for accessing and updating data in the database using the, uh, ActiveRecord pattern.

Read the PlanetMySQL Blog post »

Article: A Look at the PBXT Storage Engine

Paul McCullagh from PrimeBase (www.primebase.com) has created the PBXT transactional storage engine for MySQL. PBXT is an ACID compliant transaction engine that offers all the right features for MySQL users who are on the hunt for an engine to keep their transactional data safe. PBXT sports crash recovery, unlimited row-level locking, MVCC, foreign keys/server-enforced referential integrity, automatic storage management, minimal configuration setup, and online backup support.

Read the Article »

Events

Live Web Seminar (German): Cost-effective Scale-out with MySQL

March, 14, 2007, 14:00 Central European Time Zone

Scaling out (or Horizontal Scaling) means distributing the computing and data workload among multiple commodity servers by load balancing, with the ability to add servers to increase capacity. By distributing the workload, processing resources are spread among multiple low-cost servers, which improves both performance and the availability of the overall service at a dramatically lower cost.

Register for this Webinar »

Live Web Seminar: Jasper for MySQL, OEM Edition Empowers MySQL Customers to Deliver Embeddable Operational Reporting

Europe: March 20th, 15:00 CET
Americas: March 22nd, 10:00am PST

JasperSoft Corporation, the market leader in open source business intelligence, and MySQL AB have teamed together to offer Jasper for MySQL: OEM Edition. With Jasper for MySQL, OEMs and ISVs building MySQL-based products can now add rich reporting capabilities to their applications, including the ability to create, store, schedule, distribute, share, drill-down, and interact with reports as well as deliver Web-based ad hoc reporting to their customers.

Register for the Webinar (EMEA) »

Register for the Webinar (Americas) »

Live Web Seminar: An Introduction to High Availability Architectures with MySQL and DRBD (Distributed Replication Block Device)

March 28th, 10:00am PST

Join us for this webinar where you can learn how to combine MySQL, with other open-source high-availability components like DRBD and Linux-HA, to create scalable database clusters. For organizations who cannot afford costly components like SAN (Shared Area Network) or proprietary clustering hardware or software, DRBD presents an excellent alternative.

Register for this Webinar »

Training, Consulting and Certification

Consulting: MySQL Performance Tuning & Optimization (3+ Days)

Do your applications slow down during busy times?

Are you having difficulties pinpointing performance bottlenecks?

Will finding and fixing performance issues take weeks and expertise that you just don't have?

Then MySQL Performance Tuning & Optimization is for you. You will get expert insight and learn best practices to help you improve performance and scalability.

Register Now for an Upcoming Date »

Training: MySQL 5.0 for Database Administrators (5 Days)

San Francisco, London, Paris, Munich, Tokyo, and more.

Is your MySQL database secure?

Do your users have the correct privileges and access rights?

Is your MySQL database operating at optimal efficiency? Do you want to increase the performance of your database and make sure it scales?

Do you want to save time using features like Stored Procedures, Triggers and Views?

Do you want to utilize the new enterprise features of MySQL 5.0?

Register Now for an Upcoming Date »

Partners

Showcase Your Solution at the 2007 MySQL Conference and Expo

April 23-26, 2007

The MySQL Conference & Expo is one of the most targeted events in the industry to expose your products and services to the growing open source marketplace. You will enjoy meeting with the hundreds of attendees, speakers, press, and MySQL staff-all with the common goal of promoting the open source community and MySQL database applications.

Download the Brochure (PDF) »

About the Newsletter

You can send us queries and give us feedback online.

You can unsubscribe from this newsletter online or by replying to this e-mail with subject 'unsubscribe <[email-masked]>'.

Read more about the newsletter and view previous issues.

Copyright © 2007 MySQL AB. All rights reserved.
You are free to distribute this newsletter, as long as you don't make any changes.