Hello,

Please help us determine the priorities for MySQL Replication in upcoming releases by taking a few minutes to fill out our comprehensive online survey!

http://www.zoomerang.com/survey.zgi?p=WEB226PA9AV32W

We need your feedback on the following features:

- Event Checksums
- Table Checksums
- Group IDs (Global Transaction IDs)
- C/C++ API to Binlog
- Semi-Synchronous replication
- Multi-source replication
- Multi-threaded replication
- Replication Heartbeat
- Table/Database filtering on Master
- Time delayed replication
- Interleaved transactions in binlog
- Convert SHOW SLAVE HOSTS to a table
- Replication to and from tables with more or less columns
- Replication from old to new version ? new to old version
- Semi Synchronous Replication
- and more...

Thanks,
…

There is a song that keeps popping on my mind when I test something difficult. Usually, when I can't get the result I am seeking with normal operations, and I have to resort to some trick, I hear Joe Cocker singing With a little help from my friends. My best friends when I test are bash, vim, and perl.
Today, I was testing Falcon on my Intel based MacBook. The last Falcon release does not compile on Macs, but it has been recently patched, and today with my delight it built smoothly.
Having got the binaries, I ran the test suite, because that's the fastest way of finding out if something is broken. Soon enough, something nasty popped up. Test "falcon_bug_29040" failed with timeout. Thus, I …

MySQL AB today announced that popular UK dating site mysinglefriend.com has selected the MySQL database server for its fast-growing Web 2.0 site.

MySQL AB today announced a new series of 'MySQL Boot Camps', free one-day technical training classes for senior Oracle database administrators (DBAs) interested in expanding their professional skill-sets by learning advanced MySQL techniques. Qualifying attendees of the in-person classes will also receive a free copy of the 'MySQL Certification Study Guide' and a complimentary pass to sit for a pair of MySQL DBA Certification exams -- a $460 value.

I haven’t been blogging about the things I used to – how-tos and technical hacks – because I’ve been working quite hard on MySQL Toolkit and, believe it or not, innotop. I’ve made it possible to write innotop plugins, which have been very useful to our team at work, and I’m working on documentation. Plugins won’t make it into the upcoming release; it’ll just be bug fixes and documentation. These projects have taken up most of my free time.

This release fixes some bugs and improves the chunking functionality. MySQL Table Checksum had a few minor bugs and one major bug with the chunking functionality. I also rewrote the chunking, though the behavior is backwards compatible. I am very happy with the way it works now, and will probably not make any more incompatible changes to it. The changes enabled me to add support for chunking on float, double and decimal columns.

So, we did it! New Best Tech Videos site version has been released today. Of course, it could have some issues, and we are really looking forward for your feedback on our support forums.

Let’s review main improvements we’ve made here:

• First of all, I want to mention our first step to socialization of the BTV - all our users could signup now and get their own lists of favorited, commented and voted videos and much more - they could have their own personal RSS feeds.
• Next cool thing we’ve prepared for you is user-generated content! You can find some great videos on the Net and share them with fellow BTV readers. At this moment our posting system works in pre-moderated mode to keep really high level of videos we post here, but later we want to delegate …

Savio has had some interesting posts lately crunching numbers related to open source investments and, most currently, the FSF's financial ability to litigate GPLv3. In both cases, though, I think he's getting a bit too attached to the calculator and detached from reality. (Not that I ever stray from reality.... :-)

(That said, in both cases I appreciate the exercise that he walks us through. It's useful.)

With regard to the FSF's ability to litigate over GPLv3, this misses the point. The FSF has never needed to rely on litigation to enforce the GPL. That's what public pressure is all about, and the open source community can deliver that in abundance. I've yet to see it fail.

To the extent that the FSF …

Checking out the state of tables of your MySQL setup in production is important for fine tuning server parameters. MySQL's SHOW TABLE STATUS command comes very handy in determining table states from a running environment. Here, I explain the output of the command.

mysql> SHOW TABLE STATUS LIKE 'mytable' \G
****************** 1. row ******************
           Name: mytable
         Engine: InnoDB
        Version: 9
     Row_format: Dynamic
           Rows: 2465222
 Avg_row_length: 370
    Data_length: 913326080
Max_data_length: NULL
   Index_length: 146817024
      Data_free: 0
 Auto_increment: 18357110
    Create_time: 2007-05-11 22:27:56
    Update_time: NULL
     Check_time: NULL
      Collation: latin1_swedish_ci
       Checksum: NULL
 Create_options:
        Comment: InnoDB free: 869376 kB
1 row in set (0.34 sec)

Leaving behind the obvious …

I finally got around to installing a SlimDevices SqueezeBox at home. It was a gift from my wife some months back, but the idea of wrestling with our in-wall cabinetry to hookup the audio cables and get my MP3 collection onto the living room stereo put me off for a long time.  But I was in a cleaning mood this weekend and wanted to get rid of a bunch of boxes, books, and other clutter, so I figured this was as good a time as any.  The installation was fairly simple, as long as you know how to convert a WEP key into hex.

All tolled it took about 15 minutes, including messing with the …