... I didn't get two-way sync done, and I didn't get the Nibble algorithm done. That much I expected. But I also didn't get the current work released tonight because I'm paranoid about breaking things. I'm trying to go through all the tools and write at least a basic test for them to be sure they can do the simplest "unit of work" (such as mk-find running and printing out that it finds the mysql.columns_priv table).

It's good that I'm doing this. I found that mk-heartbeat suddenly doesn't work on my Ubuntu 7.10 laptop. It goes into infinite sleep. Can anyone repro this and/or diagnose? The same code works fine on my Gentoo servers at work.

Hopefully I'll be able to release something very soon. Release early/often is fine, but "knowingly release brokenness" isn't in my code of conduct :)

That is the good news. The bad news is, it is still affected by CVE-2007-5925, which allows remote authenticated users to cause a denial of service (database crash). Jörg Brühe wrote on the packagers mailinglist that is because the sources for 5.0.51 were cloned before the fix got in. I do not know exactly how their release model works, but looks like it needs to be improved, especially because 5.0.52 is not affected.

To make it even worse, bug #32125 which has a patch for the problem, was set to private a few days ago. Because we already have the patch in our MySQL packages since exactly three weeks, it …

I was reminded the other day how SQL Server was annoying in regards to table structure changes. All I wanted to to was copy a table (with structure intact - keys, dependancies) with its data.How hard could that be?MS SQL in ActionFirst, I needed to do a complete DDL on TableOne and replace every instance of the word "TableOne" with "TableTwo". It works, even though it is bulky and takes time,

When I was playing some Windows games before, there used to be eggs like a combination of certain keys would produce messages like the program pays tribute to blah, blah, blah. I wish MySQL has something like that... that if I press certain combination of keys that instead of the language in English, it would become a combination of English and unknown language. Just a thought.

When you look at the new feature set of MySQL, they are just so serious in trying to become the no. 1 database out there. Where is the fun??

SELECT OUTFILE should be able to write to a popen pipe. And it should be able to write to a URL. And it should be able to do XML, JSON, YAML, and the various known database dump formats, and various known script pickling and serialization formats.

LOAD DATA INFILE should be able to read from an popen pipe. And it should be able to read from a URL. And it should be able to understand XML, JSON, YAML, and the various known database dump formats, and various known script pickling and serialization formats.

In the MySQL command line client, it should be able to source a URL on the command line. Inside the MySQL command line client, it should be able to source from a URL and from a popen, and tee to a URL and a popen.

It's been an interesting experience. Most of my classmates are from a rather different pool of "computer geek" than either the west coast "open source gods", or from big corporate IT. Most of them are from very small IT/dev shops. There are two guys from a Texan WISP. There is a guy who's the sole IT guy from an out of control academic dev project that is about to centralize all their random Oracle, Access, and MS-SQL databases into MySQL. There is the IT guy from a company that makes venetian blinds. The IT guy from a company that manufactures farm trailers and horse trailers. There is a semifreelance investigative reporter who wants to use MySQL for storing and sharing collected government data. There is an academic from a bio/gen research dept who's moving to MySQL.

As for the class, going in, I was afraid it was going to be a lot of memorization of configuration parameters, deep explanations of the query optimizer, and lots of very …

A

This morning I was looking for something on Ohloh and realized I should “stack” maatkit. Since I couldn’t find “maatkit” nor “mysql toolkit” in Ohloh, I created a new project for it at:

http://www.ohloh.net/projects/10083

If you’re on Ohloh, stack it!

www.ohloh.net is a neat social networking tool for open source software. Instead of searching freeware lists, search ohloh, and you can find reviews, # of people using the software, and direct links to download pages. My profile is at:

http://www.ohloh.net/accounts/8446http://www.ohloh.net/accounts/8446
and you can see my stack at:
http://www.ohloh.net/accounts/8446/stacks/default

This is the last day I'm taking off work to hack on mk-table-sync, and I thought it was time for (yet another) progress report. Here's what I have done so far. (Click through to the full article to read the details).