The latest from the MySQL community

Sheeri Kritzer Cabral sent out a tweet yesterday wishing she could change the default MySQL exit text from “Bye” to “kthxbai!”. I figured that it was something that could be quickly done using a pager, but that turned out not to work because it is written after the pager would have been called. [...]

Last weekend I finally found some time to upload pictures that I had taken during various events that I attended in the past few months. So here are my impressions from the following events:

• PHP Unconference in Hamburg on 2008-04-26
• MySQL Meetup Mashup in Hamburg, 2008-04-07
• MySQL Meetup Mashup in Berlin, 2008-04-08
• MySQL Conference & Expo 2008 in Santa Clara, 2008-04 (these are available from …

The MySQL Telecom sales team is a global team, but it happens to be organized under the EMEA region of the MySQL sales department. Since the EMEA region is having a staff meeting in Dublin this week, it means also we in the telecom team are gathered here. A good opportunity to meet your globally dispersed collagues.

Zack Urlocker was the special guest star from headquarters. He presented a freudian-slip-slide saying that MySQL 5.1 will be released GA in July 2009. After lots of laughter he concessed that maybe engineering can pull it of faster, like maybe July 2008.

Another hot topic Zack talked about was to review how the integration with Sun is going...

...we concluded at least some of us are adapting just fine :-)

Sheeri Cabral, an active MySQL blogger and two-time winner of MySQL Community Contributor awards has written a great review on MONyog.

Read the full review here

Our favorite highlights:

As an overall review — MONyog is the best out-of-the-box GUI monitoring tool for MySQL that I have seen. It “just works.” As promised, getting up and running quickly is easy, and having a centralized location for monitoring is very useful. The graphs are beautiful and the statistics that are graphed are useful time-savers.

The biggest difference between MySQL’s Enterprise Monitor and MONyog is that MONyog is agentless. At Pythian, we have many clients with differing security requirements. Requiring a daemon process to be running is not something we currently do, and it might be a hard sell for some clients. Even if every client was …

Bug fixes and Enhancements:

• Optimized SFTP code. This means that the Log Analyzer is now several times faster than previous Betas
• Fixed an issue with trending
• Log file parsing issue with MySQL 5.1.x resolved

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

When writing scripts for running MySQL in batch mode, it is often desired to be able to change the SQL queries on-the-fly so that we can use the script to solve more generic problems.

For example, I need to use my script for different storage engines and table names and I want to be able to do it at runtime instead of manually changing my script every time.

Here is how I do it:

I have a template file which is my script but with the variables having generic names. In this case, I have considered plugin_name as the storage engine name , and table_name as the table name.

Consider the following script:

# automation-script-template
# Mixing shell commands and SQL queries in batch mode- demo script

# Replace variables: plugin_name, table_name with appropriate names- done automatically by …

When writing scripts for running MySQL in batch mode, it is often desired to be able to change the SQL queries on-the-fly so that we can use the script to solve more generic problems.

For example, I need to use my script for different storage engines and table names and I want to be able to do it at runtime instead of manually changing my script every time.

Here is how I do it:

I have a template file which is my script but with the variables having generic names. In this case, I have considered plugin_name as the storage engine name , and table_name as the table name.

Consider the following script:

# automation-script-template
# Mixing shell commands and SQL queries in batch mode- demo script

# Replace variables: plugin_name, table_name with appropriate names- done automatically by …

The MySQL Telecom sales team is a global team, but it happens to be organized under the EMEA region of the MySQL sales department. Since the EMEA region is having a staff meeting in Dublin this week, it means also we in the telecom team are gathered here. A good opportunity to meet your globally dispersed collagues.

Zack Urlocker was the special guest star from headquarters. He presented a freudian-slip-slide saying that MySQL 5.1 will be released GA in July 2009. After lots of laughter he concessed that maybe engineering can pull it of faster, like maybe July 2008.

Another hot topic Zack talked about was to review how the integration with Sun is going...

...we concluded at least some of us are adapting just fine :-)

The MySQL Telecom sales team is a global team, but it happens to be organized under the EMEA region of the MySQL sales department. Since the EMEA region is having a staff meeting in Dublin this week, it means also we in the telecom team are gathered here. A good opportunity to meet your globally dispersed collagues.

Zack Urlocker was the special guest star from headquarters. He presented a freudian-slip-slide saying that MySQL 5.1 will be released GA in July 2009. After lots of laughter he concessed that maybe engineering can pull it of faster, like maybe July 2008.

Another hot topic Zack talked about was to review how the integration with Sun is going...

...we concluded at least some of us are adapting just fine :-)

Progress acquires IONA. Red Hat announces quarterly earnings. Optaros raises new round of funding. (and more)

Progress Software Corporation to Acquire IONA Technologies, Progess Software / IONA Technologies (Press Release)

Red Hat Reports First Quarter Results, Red Hat (Press Release)

Optaros Closes $12 Million in Series C Financing Co-Led by .406 Ventures & Globespan Capital Partners, Optaros (Press Release)

Sourcefire, Inc. Responds to Barracuda Networks …