The latest from the MySQL community

Here are my slides used for presentation at Red Hat Summit in Boston last week:

Zmanda: Open Source Backup (.odp open office format, 1.7MB)

I have *never* had this happen to me.

Maybe it’s because it’s MySQL 6.0.4, maybe it’s because it’s on Windows, or perhaps I am just up working too late.

I have seen mojibake before, but usually it is unintelligible. But this? After I post this I am backing away slowly from my computer.

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 6.0.4-alpha-community MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use test;
Database changed
mysql> create table bits (val bit);
Query OK, 0 rows affected (0.09 sec)

mysql> insert into bits (val) VALUES (1),(0),(1),(1),(0);
Query OK, 5 rows affected (0.05 sec)
Records: 5  Duplicates: 0  Warnings: 0

mysql> select * from bits;
+------+
| val  |
+------+
| ?    |
|      |
| ?    |
| ?    |
|      |
+------+
5 rows …

Red Hat releases Spacewalk. It is described as: “the upstream community project from which the Red Hat Network Satellite product is derived“. Congratulations to all whom have worked on it, especially my friends who tired endlessly over it in the past.

Red Hat, is sticking true to its promise, of open sourcing everything they make. Best of all, they recognise Fedora (they always did, since say, Fedora Core 2 or 3), CentOS (a direct “competitor”/rebuild of RHEL), and Scientific Linux (I know of a certain university’s sysadmin who will be blessing Spacewalk, as her life will now be a lot easier).

There have been a few blogs about it… Matt Asay asks about a community (Red Hat traditionally wasn’t good at this, but with Fedora, I believe they’ve learned, and I’m happy …

KEY ACCOMPLISHMENTS LAST WEEK

• Set up automated runtime information collection tasks on 6 machines; These machines are compiling and testing MySQL 24/7 and uploading the results to Skoll server for future analysis.
• Modified Skoll's upload manager and data processor to handle the separate log files collected by the new Skoll Client. The separate log files include a Skoll Client log and a set of logs for each command (e.g. configure, compile, test) in a test run. The command logs are zipped together by the client before uploading to the server.

KEY TASKS THAT STALLED LAST WEEK

• None

KEY CONCERNS

• Future progress of the project depends on have push-build tar balls.

TASKS IN THE UPCOMING WEEK

• Add more information from the separate log files to the HTML results pages; this task would require database changes to Skoll server. …

Since you're reading this, you probably know that Sun is switching to the Bazaar version control system for all development work on the MySQL server. Unlike the version control system that we've been using previously, Bazaar is an open source project and freely available to anyone. This means that it is now much easier to follow ongoing development, or even to participate in it! On the downside, just like our previous tool, Bazaar is not quite as straight-forward as traditional version control systems such as CVS or subversion. The aim of this article is to give an overview and a general idea of how to set up Bazaar, how to access the MySQL server source code repositories, and the basic commands for working with the source code.

How many of you use the mysql command-line client?  And did you know about the pager command you can give it?  It's pretty useful.  It tells mysql to pipe the output of your commands through the specified program before displaying it to you.

Here's the most basic thing I can think of to do with it: use it as a pager.  (It's scary how predictable I am sometimes, isn't it?)

PLAIN TEXT SQL:

1. mysql> pager less
2. mysql> SHOW innodb STATUS\G

For big result sets, it's a pretty handy way to be able to search and scroll through. No mouse required, of course.

But it doesn't have to be this simple! You can specify anything you want as a pager. Hmm, you know what that means? It means you can write your own script and push the output through it. You can't specify arguments to the script, but since you can write your own, that's not really a …

Over the weekend I received a few emails asking for sample questions for the four MySQL Certification exams. There is a CDROM that comes with the MySQL 5.0 Certification Study Guide that covers the Developer and DBA Questions. The MySQL 5.1 Cluster Certification Study Guide (next edition due any day) has questions at the end of every chapter.

And there are questions that are just slightly modified from each ofthe four exams at http://www.mysql.com/certification/selftest/core/index.php

Last week at the Red Hat Summit in Boston, Jaspersoft announced their new version 3 suite, aimed at taking the company beyond their namesake widely-used reporting system. This latest version focuses on ad-hoc BI with a more flexible "Web 2.0" AJAX interface making it easy to build dashboards via drag and drop. By creating metadata domains, the eliminate the need for users to understand the underlying database schemas and queries. You can also easily embed the dashboard in any web application. JasperSoft's latest update appears to be a significant improvement in making open source BI offerings more competitive in the... READ MORE

The second half of last week I attended the Red Hat Summit and FUDCon which Sun and MySQL were silver sponsors of.  The events were co-located at the Hynes convention center in Boston. 

Although both events featured an impressive list of topics and tracks, other than the keynotes I spent the majority of my time meeting and talking to people.   One of my goals was to figure out how Sun can better work with Fedora to get more of our software into their distro. 

A few key Fedorans: Max Spevak, Dennis Gilmore, Tom "Spot" Callaway, Jeremy Katz, Paul Frields, Jesse Keating. 

President and CEO Jim Whitehurst chats with Fedora board member, Karsten Wade, …

My post on what it’s like to write a technical book was a stream-of-consciousness look at the process of writing High Performance MySQL, Second Edition. I got a lot of responses from it and learned some neat things I wouldn’t have learned if I hadn’t written the post. I also got a lot of questions, and my editor wrote a response too. I want to follow up on these things.

Was I fair, balanced and honest?

I really intended to write the post as just “here’s what it’s like, just so you’re prepared.” But at some point I got really deep into it and lost my context. That’s when I started to write about the things that didn’t go so smoothly with the publisher, …