Subject: MySQL Newsletter: July 2007

From: MySQL AB <[email-masked]>
Date: Tue, 31 Jul 2007 01:04:47 +0000

MySQL Newsletter
July 2007
[email-masked]

Articles in this newsletter:

Highlights

30 Day Trials for MySQL Enterprise

Boot Camp: MySQL for the Oracle DBA

Case Study: Adobe Relies on MySQL to Improve User Productivity

CIO Resources Available in the MySQL CIO Corner

Jasper for MySQL: OEM Edition

New Product Releases

MySQL Proxy 0.5.0 (Alpha)

MySQL Enterprise Server 5.0.44

MySQL Community Server 5.1.20 (Beta)

MySQL Connector/ODBC 3.51.17 (GA)

MySQL Connector/J 5.0.4 (GA)

Hints & Tips

Article: Getting Started with MySQL Proxy

Article: 3 Tips for Customizing MySQL Enterprise to Achieve Monitoring Best Practices

Article: MySQL Data Loading with Lookup Tables

White Paper: MySQL - The Best Choice for Modern Online Database Applications

PlanetMySQL Blog Posts

PlanetMySQL Blog: Replication Syncing MASTER_POS_WAIT

PlanetMySQL Blog: mysql query cache

PlanetMySQL Blog: Session clustering, who is online and replication lag

PlanetMySQL Blog: Internals of MyISAM's Concurrent Insert Functionality

PlanetMySQL Blog: A Innodb Recovery - Is large buffer pool always better?

PlanetMySQL Blog: MySQL 5 High Availability with DRBD 8 and Heartbeat 2

Events

Live Web Seminar: Designing, Evaluating and Benchmarking MySQL Cluster (August 8 & 15)

Live Web Seminar: Embedded Databases - Reducing ISV Risk with MySQL (August 9 & 11)

Conference: MySQL Users Conference Japan 2007

Conference: MySQL European Customer Conferences 2007

MySQL Camp II (August 23-24)

Training, Consulting & Certification

Training: MySQL 5.0 for Developers (5 Days)

Training: MySQL 5.0 for Database Administrators (5 days)

Partner Corner

MySQL Gold Partner, PremiumSoft: Introduces Navicat GUI for MySQL, version 8

Do you have a MySQL Solution for end users? Become a MySQL partner and grow your business today.

Highlights

30 Day Trials for MySQL Enterprise Now Available

For the first time, you can experience the power of the MySQL Network Monitoring and Advisory Service 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.

Register for the Trial »

Boot Camp: MySQL for the Oracle DBA

The demand for MySQL Certified DBAs has been growing in parallel with the rapid adoption of MySQL for enterprise database applications. In a 2006 installed base survey, the IOUG (Independent Oracle Users Group) found that over 33% of Oracle DBAs are also managing production MySQL databases. This "MySQL DBA Boot Camp" provides an intense 1-day immersion training for Oracle DBAs at no charge.

Register Today »

Case Study: Adobe Relies on MySQL to Improve User Productivity

Adobe embeds MySQL into several Adobe Creative Suite 3 components including Adobe Acrobat CS3, Adobe Bridge CS3, and Adobe Version Cue CS3 so that workgroups can work more efficiently on complex projects.

Download the Case Study »

CIO Resources Available in the MySQL CIO Corner

We increasingly get asked by CIOs how they can make best use of open source and MySQL. That is why we have assembled information, best practices, third-party materials and more in the MySQL CIO Corner.

Learn More »

Jasper for MySQL: OEM Edition

Jasper for MySQL is a high-performance interactive report server optimized for MySQL users. ISVs and OEMs can cost-effectively embed Jasper for MySQL into their applications, which adds value to their solutions and gives users access to a complete reporting functionality.

Learn More »

New Product Releases

MySQL Proxy 0.5.0 (Alpha)

We are proud to present a new kid in the block: MySQL Proxy 0.5.0 alpha. MySQL Proxy is a simple program that sits between your client and MySQL server(s) that can monitor, analyze or transform their communication. Its flexibility allows for a wide variety of use cases, including:

Load balancing

Failover

Query analysis

Query filtering and modification

and many more

We welcome and appreciate your feedback, bug reports, bug fixes, patches etc. You'll find preliminary documentation and plans on our project page on MySQL Forge:

View the Documentation »

Download Now »

Discussion Forum »

New Release of MySQL Enterprise Server 5.0.44

This is a Monthly Rapid Update release of the MySQL Enterprise Server 5.0. The following is a partial list of changes:

Security Fix: A malformed password packet in the connection protocol could cause the server to crash. Thanks for Dormando for reporting this bug and providing details and a proof of concept. (CVE-2007-3780, Bug#28984)

Security Fix: CREATE TABLE LIKE did not require any privileges on the source table. Now it requires the SELECT privilege. (CVE-2007-3781, Bug#25578)

A new status variable, Com_call_procedure, indicates the number of calls to stored procedures. (Bug#27994)

View the complete list of changes »

Download Now (Login Required) »

New Release of MySQL Community Server 5.1.20 (Beta)

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

mysqld_safe now supports error logging to syslog on systems that support the logger command

DROP USER statements that named multiple users, only some of which could be dropped, were replicated incorrectly. (Bug#29030) Using events in replication could cause the slave to crash. (Bug#28953)

View the complete list of changes »

Download Now »

MySQL Connector/ODBC 3.51.17 (GA)

MySQL Connector/ODBC 3.51.17, a new version of the ODBC driver for the MySQL database system, has been released. This release is the latest release of the 3.51 series and is suitable for use with any MySQL version including MySQL 4.1, 5.0, or 5.1. The following is a partial list of changes:

The setup library has been split into its own RPM package, to allow installing the driver itself with no GUI dependencies.

Added an option (CHARSET) for specifying the default character

set for a connection. This must be used instead of a "SET NAMES" statement. Also available from the GUI setup dialog. (Related to Bug #6667 and Bug #9498.)

* SQLProcedures() did not handle NULL parameters, which could lead to crashes (Bug #28316)

View complete list of changes »

Download Now »

New Release of MySQL Connector/J 5.0.4 (GA)

This is a bug fix release for the current production branch of Connector/J. Version 5.0.7 is suitable for use with any MySQL version including MySQL-4.1, MySQL-5.0, MySQL-5.1 beta or the MySQL-6.0 Falcon development releases. The following is a partial list of changes:

Setting the configuration parameter "useCursorFetch" to "true" for MySQL-5.0+ enables the use of cursors that allow Connector/J to save memory by fetching result set rows in chunks (where the chunk size is set by calling setFetchSize() on a Statement or ResultSet) by using fully-materialized cursors on the server.

Added configuration property "useNanosForElapsedTime" - for profiling/debugging functionality that measures elapsed time, should the driver try to use nanoseconds resolution if available (requires JDK >= 1.5)?

View complete list of changes »

Download Now »

Hints & Tips

Article: Getting Started with MySQL Proxy

The launch of MySQL Proxy has caused quite a commotion in the community. And with reason. For feature-hungry people, this is undeniably the most exciting addition to MySQL set of tools. Get ready for a wonderful trip to Proxyland.

Read the Article »

Article: 3 Tips for Customizing MySQL Enterprise to Achieve Monitoring Best Practices

This article focuses on customization tips for three specific areas of the Monitoring and Advisory Service. We'll start with Advisors and Rules and then move into Alerts and Notifications. , we'll take a look at scheduling options that allow you to disable/enable monitoring around maintenance windows or other calendar-based events such as weekends and holidays.

Read the Article »

Article: MySQL Data Loading with Lookup Tables

In this article I will show you standard lookup data loading procedure and the generic classes object to store and read-only the values of the ID and Name columns from the lookup tables.

Read the Article »

White Paper: MySQL - The Best Choice for Modern Online Database Applications

This paper examines both the business and technical reasons that MySQL is used by the vast majority of successful online enterprises and helps clarify why anyone considering a database for busy, always-online applications, should first consider MySQL.

Download the White Paper »

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: Replication Syncing MASTER_POS_WAIT

Dathan Pattishall

This function is useful for control of master/slave synchronization. It blocks until the slave has read and applied all updates up to the specified position in the master log. The return value is the number of log events the slave had to wait for to advance to the specified position.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: TO COUNT(*) or NOT TO COUNT (*)

Jayant Kumar

MySQL 4+ has a feature known as query cache. Here MySQL caches the result set. Now lets check out the variables in mysql configuration file (my.cnf) which control the query cache.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: Session clustering, who is online and replication lag

Lukas Kahwe Smith

So I need to create a portal site, where we will require multiple frontends. As most portal's we need to store some state information inside a session. We also need to show how many users are online, but more importantly be able to filter searches in the member database by who is online.

Read the PlanetMySQL Blog Post »

PlanetMySQL Blog: Internals of MyISAM's Concurrent Insert Functionality

Jay Pipes

OK, so we're going to get pretty down-and-dirty in the C source code that handles concurrent inserts... you've been warned. Here are the topics and areas of the MySQL code that we'll be looking at in a discussion on concurrent inserts with MyISAM.

Read the PlanetMySQL Blog Post »

PlanetMySQL Blog: A Innodb Recovery - Is large buffer pool always better?

Peter Zaitzev

How does Buffer Pool size affects Innodb Performance? I always expected Innodb with a large buffer pool to perfor better. Including Recovery of course.

Read the PlanetMySQL Blog Post »

PlanetMySQL Blog: MySQL 5 High Availability with DRBD 8 and Heartbeat 2

Mark Schoonover

In this article, we're going to go through the entire process of installing, configuring and testing DRBD, Heartbeat and MySQL running in a 2 node cluster environment. This will be a bare bones configuration, best practices and security will take a back seat while we learn how all the different pieces work together.

Read the PlanetMySQL Blog Post »

Events

Live Web Seminar: Designing, Evaluating and Benchmarking MySQL Cluster

Wednesday, August 08, 2007 (Americas)
Wednesday, August 15, 2007 (EMEA)

In this webinar learn the fundamentals of how to design and select the proper components for a successful MySQL Cluster evaluation. We will explore hardware, networking and software requirements. Work through a basic installation, functional testing and ongoing best practices for maintaining the system. Finally, we will close with an examination of the recent benchmark results performed in conjunction with Intel and Dolphin Interconnect Solutions.

Register for this Webinar (Americas) »

Register for this Webinar (EMEA) »

Live Web Seminar: Embedded Databases - Reducing ISV Risk with MySQL

Thursday, August 09, 2007 (Americas)
Tuesday, September 11, 2007 (EMEA)

This Webinar will explore some of the most common obstacles encountered on the road to product success, especially as related to embedded technologies. We'll examine the impact of market, competitive, cost-of-goods-sold, technology, and support factors. In each case, we'll demonstrate how embedding a proven, market-leading database such as MySQL can go a long way toward building a solid technology foundation while concurrently helping to mitigate risk.

Register for this Webinar (Americas) »

Register for this Webinar (EMEA) »

Conference: MySQL Users Conference Japan 2007

September 11-12, 2007

MySQL AB will hold its first ever MySQL users conference in Asia. There will be a keynote, more than 15 sessions, and exhibition booths over the course of two days. About half the sessions are presented in English with English-Japanese simultaneous translation. If you are interested in becoming a sponsor or exhibitor at this conference, please contact [email-masked]

Learn More »

Conference: MySQL European Customer Conferences 2007 (October)

London, Munich, Paris

A yearly event, the MySQL European Customer Conferences offer you the opportunity to:

Learn best practices to get the most out of MySQL

Network with fellow European customers and discover how they are leveraging MySQL

Meet with MySQL European executives, engineers, consultants and MySQL partners

Learn More »

Register before August 31st and receive an early bird discount!

London, October 16 »

Munich, October 18 »

Paris, October 23 »

MySQL Camp II

August 23-24, Brooklyn, New York

Thanks to everyone for making the first MySQL Camp (http://mysqlcamp.org) a huge success. MySQL Camp II, the second community-driven MySQL user and hackfest will be August 23rd and 24rh at the Polytechnic University in Brooklyn, New York.

For advanced information, please contact Jay Pipes

Training, Consulting, and Certification

Training: MySQL 5.0 for Developers (5 Days)

Salt Lake City, Paris, Lyon, Madrid and more

Do you want to learn how to develop database applications on MySQL?

Do you need to use MySQL Stored Procedures, Triggers, Views, and Information Schema?

Do you want to create complex reports, use complex queries to retrieve data and aggregate results?

Attend any MySQL for Developers class before September 30th and get a free copy of O'Reilly's book, "MySQL Cookbook" by Paul DuBois.

Register Now for an Upcoming Date »

Training: MySQL 5.0 for Database Administrators (5 Days)

Boston, Vancouver, Denver, Stockholm, 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?

Attend any MySQL for Database Administrators class before September 30th and get a free copy of Robert Schneider's book, "MySQL Database Design and Tuning".

Register Now for an Upcoming Date »

Partners

MySQL Gold Partner, PremiumSoft: Introduces Navicat GUI for MySQL, version 8

Navicat enables users to connect to multiple MySQL databases locally or remotely, and is available for Windows, Mac OS X and Linux. The latest release includes over 100 significant improvements, including new features such as Form View, Email Notification Services, Code Completion and Virtual Grouping, and much more! For special offers, email [email-masked]

Learn More »

Download Now »

Do you have a MySQL Solution for end users? Become a MySQL partner and grow your business today.

If you market a MySQL-based software application or hardware solution to end users, you can increase your business by advertising your product(s) in our Solutions Catalog. Join hundreds of existing partners and let millions of MySQL users find your solution by becoming a partner. All it takes is a few minutes to understand the program, and your company and product information.

Sign up and become MySQL's newest partner »

The MySQL Team

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.