Skip navigation links

MySQL Newsletter - Subscribe Today!

MySQL Newsletter March 2007

MySQL Newsletter - Subscribe Today

Articles in this newsletter:

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

New Product Releases

Hints & Tips

Events

Training, Consulting & Certification

Partner Corner

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 » (http://www.mysql.com/consulting/packaged/performance.html)

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 » (http://www.mysql.com/training/workshops/mysql_dba.html)

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) » (http://solutions.mysql.com/MySQLExpo2007_prospectus.pdf)

The MySQL Team