MySQL Newsletter August 2006

Newsletters older than 6 months may have links that are out of date. Please use the Search to check for updated links.

Articles in this newsletter:

Training, Consulting, & Certification

Partner Corner

Alpha Five Rapid Application Development IDE/RAD Tool for MySQL

Highlights

White Paper: MySQL High Availability Solutions

The MySQL High Availability Solutions White Paper is for organizations interested in making their applications more highly available, and in some cases, available to the point where they approach mainframe reliability. MySQL offers a wide array of options when selecting a high availability solution. In this paper, we will examine in greater detail MySQL Replication, MySQL Cluster, free and open-source solutions, as well as, products from our network of certified partners.

Download the White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_ha_solutions.php)

White Paper: A Look at MySQL 5.0 Performance Benchmarks

Web 2.0 is the second generation of services available on the Web that lets people collaborate and share information online. One of the defining characteristics of Web 2.0 is the fact that it's the data that is driving this evolution. In this web seminar we explore how companies can increase performance, scalability and availability for Web 2.0 architectures using MySQL and MySQL Cluster.

Webinar: Web 2.0 Tags, Schema and Folksonomy

This webinar will be an examination of the prototypical Web 2.0 concepts and how the database schema lies at the heart of a scalable, high performance modern web application. The content of this webinar will be highly technical, with a focus in:

Tag and social networking schema guidelines
Storage engine optimizations for key-mapping tables
Example SQL solutions for common relational problems
Scalable replication scenarios and strategies
Textual indexing considerations (FULLTEXT)

MySQL in Telco: Why MySQL is a Great Solution

Open source software has played a key role in application development, allowing them to build custom applications that are highly reliable at a price they can afford. Discover now how MySQL his helping leading telecommunications companies improve operational efficiency and customer satisfaction.

Learn Why MySQL is Great Solution for Telcos » (http://www.mysql.com/industry/telecom/)

MySQL European Customer Conferences

Northern Europe Customer Conference: London, October 17th, 2006
Central Europe Customer Conference: Munich, October 19th, 2006

The MySQL European Customer Conferences are a great way to:

Meet and network with the MySQL team including executives and engineers
Learn a lot in only one day about the MySQL roadmap, MySQL Cluster, Web 2.0 strategy with MySQL, performance tuning, and more
Discover how other MySQL customers are leveraging MySQL for their mission critical applications

Early Registration Discounts Available until August 31st, Register Now » (http://www.mysql.com/news-and-events/european-conferences/ )

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:

Senior Software Developer - Storage Engine
Senior Software Developer - MySQL Cluster Maintenance
Software Developer - MySQL Server Maintenance
ODBC Developer
QA Engineer - MySQL Server
QA Engineer - MySQL Network
Corporate Controller
Sales Executives
Consultants

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

Products

New Release of MySQL 5.0.24 Community Edition (GA)

This is a bugfix release for the current production release. Enhancements to MySQL 5.0.24 include:

Security Fix: relating to MyISAM and Merge Tables
MySQL Cluster Fix: resolving insufficient space resulting form repeated creating and dropping of a table
Mysqldump Fix: mysqldump produced a malformed dump file when dumping multiple databases that contained views.

For the complete list of changes visit »

Download Now »

New Release of MySQL Connector/PHP

The MySQL Connector/PHP consists of the mysql/mysqli PHP extensions built against the latest version of the MySQL client libraries for Microsoft Windows for connecting MySQL to PHP, with MySQL 5.0.24 and a new PHP 5.1.5.

Download Now »

MySQL Connector/Net 5.0.0 (Alpha)

MySQL Connector/Net is an all-managed ADO.Net provider for MySQL. While this release is suitable for any version of MySQL, it is strongly encouraged that this release not be used on any production data. Highlights of this release include:

Support for ADO.Net 2.0 interfaces and subclasses
Re-architected to improve speed and flexibility
Implemented Usage Advisor
Implemented asynchronous query methods
Implemented stored procedure metadata caching
Added PerfMon hooks
And more..

Download Now »

Hints & Tips

Documentation: Updated Connector/J section of the MySQL Reference Manual

MySQL Connector/J provides connectivity for client applications developed in the Java programming language via a JDBC driver.

Read the Documentation

MySQL 5.1 »

MySQL 5.0 »

Documentation: Updated Connector/MXJ section of the MySQL Reference Manual

MySQL Connector/MXJ is a Java Utility package for deploying and managing a MySQL database.

Read the Documentation

MySQL 5.1 »

MySQL 5.0 »

Documentation: MySQL Provides Documentation in Eclipse Format

You can make MySQL documentation available in Eclipse as a Eclipse Doc plugin. This is brand new, so if you find any issues with that format, contact docs@mysql.com. At the moment, we provide the Eclipse format for the English versions of the Reference Manual only but we plan to provide it for other languages and other MySQL documentation, too. You can install the Eclipse documentation plugin by extracting the Eclipse package and dropping the directory into your Eclipse plugins directory.

Download the MySQL Reference Manual »

Article: MySQL 5.1 New Features: MySQL Partitions

Partitioning is a way of pre-organizing table storage. You can say "some of the table's rows will go here, some will go there, still others will go to to still other places". Often, depending on the storage engine, the effect is to spread the table's rows over different files or even different disks.

Read the Article »

White Paper: A Guide to Database High Availability

It is no secret that "data" has become the most important, and valuable component of almost every modern application. It is precisely what is driving some of the most revolutionary developments we currently see in computing and the internet, including Web 2.0 applications. In this paper of the high availability white paper series, we introduce high availability and the concepts around the subject and explore the consideration when selecting a high availability database solution.

Download the White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_db_high_availability.php)

White Paper (German): A Guide to Developing an Enterprise Open Source Strategy

Not only is open source ready for the enterprise, it's also proven there. In this white paper, you'll learn how both large and small organizations have successfully implemented open source strategies.

Download the White Paper (German) » (http://www.mysql.de/why-mysql/white-papers/mysql_wp_oss.php.de)

White Paper (French): A Practical Guide to Migrating to MySQL 5.0

This paper attempts to address these and all other major questions that naturally occur when one thinks about migrating a key database-driven system to MySQL. Both the business and technical sides of migrating to MySQL will be dealt with, so whether you are a manager or a seasoned DBA, you will find the needed answers to your questions

Download the White Paper (French) » (http://www.mysql.de/why-mysql/white-papers/mysql_wp_oss.php.de)

PlanetMySQL: How to Track What Owns a MySQL Connection

by Baron Schwartz

This article demonstrates an easy way to solve the problem of recording who owns a MySQL database connection, so long-running transactions can be traced back to the source.

Read the PlanetMySQL Post »

PlanetMySQL: MySQL EXPLAIN Limits and Errors

by Peter Zaitsev

Running EXPLAIN for problematic queries is very powerful tool for MySQL Performance optimization. If you've been using this tool a lot you probably noticed it is not always provide adequate information. Here is list of things you may wish to watch out.

Read the PlanetMySQL Post »

PlanetMySQL: Relay Log File Size and Limit

by Frank Mash

For any DBA, broken replication represents a dreaded moment. Replication can break for many factors including when the master server issues a 'Duplicate entry' error. At that point you can either skip the slave counter (recommended) or ignore/skip the errors (slave-skip-errors=1062) if you are sure that ignoring such errors won't cause a nasty effect somewhere.

Read the PlanetMySQL Post »

PlanetMySQL: Using ON DUPLICATE KEY UPDATE to improve MySQL Replication Performance

by Kevin Burton

Here's a fun little performance tweak you can use to increase the throughput of your MySQL slave boxes.

Read the PlanetMySQL Post »

PlanetMySQL: Range Partitioning in MySQL 5.1

by Carlos Mafia

There are 5 types of table partitions in mysql: range, list, hash, key and composite (or subpartitioning), i think the most commonly used type in the database world (at least in oracle) could be range partition, in this way a expression is evaluated and according to it different partitions are created with ranges of rows.

Read the PlanetMySQL Post »

Events

Live Web Seminar: MySQL Network for the Modern Enterprise

Thursday August 24, 2006, 10:00 am PDT; 1:00 pm EDT; 17:00 GMT

Achieving the highest levels of database reliability, security and uptime are the primary requirements for successfully running business critical applications. MySQL Network gives you everything you need in a single, unified offering so you can cost-effectively develop, deploy and maintain enterprise database applications.

Live Web Seminar: MySQL 5.0 for OEMs, ISVs und VARs

Thursday, August 31st, 10:00am CET (Central Europe)
Thursday, September 7th, 10:00am CET (Central Europe)

MySQL is the most popular database for ISVs, VARs, hardware vendors, and network appliance manufactures who want to cost-effectively embed or bundle a reliable, high-performance relational database.

Live Web Seminar (French): MySQL Performance Tuning Best Practices

Tuesday August 29th
Central European Time (CET): 10:00am (Paris)

In this Web Seminar you will get expert insight and learn best practices to help you improve performance. We will discuss the main performance optimization possibilities including:

Schema Optimization
Server Options Tuning
Operation Server Tuning
Hardware Selection and Tuning
Storage Engine Selection

Live Web Seminar (in French): What's New in MySQL Cluster 5.1

September 13th, 10:00am CET (Paris)

In this presentation we will explore in technical detail the new features which have been introduced in MySQL Cluster 5.1 including:

Disk-based Data
Row-based Replication
Online ADD INDEX
Hardware Selection and Tuning
True VARCHAR support for memory data

Live Web Seminar (in German): Strategies for Migrating from Oracle to MySQL

Thursday, September 14th - 14:00, Berlin Time

This web seminar will provide insight into what is needed for considering a move from Oracle to MySQL, and presents a number of options that help make the transition easy. Both the business and technical sides of migrating to MySQL will be dealt with, so whether you are a manager or a seasoned DBA, you will find the needed answers to questions that revolve around migrating to the world's most popular open source database - MySQL.

Training, Consulting, and Certification

MySQL High Availability (3 Days)

San Francisco, Atlanta, London, Munich

The MySQL High Availability course is designed for experienced database administrators and system architects that want to analyze and form a basis of understanding different high availability options, including clustering and replication solutions within MySQL. This course will provide the tools required to make the decision of what high availability solution is appropriate and how to implement a system with the correct design.

Training: MySQL 5.0 Upgrading and New Features (3 Days)

Munich, Edison, Chicago, San Francisco, London

MySQL 5.0 Upgrading and New Features class is designed for Developers and Database Administrators who wish to migrate to MySQL 5.0. This course will prepare each student with the skills needed to utilize Stored Procedures, Triggers, Views, and the INFORMATION_SCHEMA metadata to enhance their productivity. Students will be exposed to the new storage engines, the ANSI SQL features and commands, the new status and configuration variables, the new precise math features and commands, and the new indexing and optimization features. In addition, this course will explain the MySQL recommended migration strategy.

Partner Corner

Alpha Five Rapid Application Development IDE/RAD Tool for MySQL

With Alpha Five, you create your code by pointing and clicking. Alpha Five also includes a powerful programming language called Xbasic (for times when you need even more power and control). As you'll see, the combination of Xbasic and point and click code building makes Alpha Five an extremely efficient way to build your MySQL applications.

Download the Article and Trial Software »

The MySQL Team