Last year I visited Utrecht where we installed some MySQL Cluster. This week I had the chance to attend a training (again MySQL Cluster) in Leiden. Tuesday I had a good excuse to visit Amsterdam and next day Leiden.

Both Amsterdam and Leiden have all these canals which were preserved unlike in Brussels where they actually made the river run under the city (stupid).. I did in both cities a tour on the water but Leiden won. I guess it was more romantic and I had lots of colleagues on the boat too.

One can actually get easy lost in Leiden, or I guess everywhere, but I just lost my colleagues whiles looking at some vinyl shops and old turntables (drool). That was the start of some 3 hours of interesting stuff..

Tomorrow I leave The Netherlands again for Germany after spending some weeks with my family in Belgium. I wonder how cluttered my mailbox is going to be.

(pictures will be posted later …

We think it's time to commoditize PHP web application security. You may have heard of Chorizo!. We're proud to announce that from now on it's possible to register for a free account on chorizo-scanner.com.

With this free account, it's possible to use the Chorizo! application service as a proxy and scan 1 host. All scan datas are encrypted, your data is only visible to you. There are also some valuable help documents available that explain the whole process from registering up to uploading the signature file onto your host and how to analyze the results. Please note: as Chorizo! is an application service, you can only scan your hosts that are publicly available or their firewall has the chorizo-scanner.com IP configured. For those of you who want to …

I’m playing with the latest 5.1.11 beta in a master/slave replication situation. Given a lack of H/W lying around I’m configuring a mixed H/W setup to leverage an existing office’s after hours CPUs running Windows XP for my slaves. So here is my test setup.

Server

Linux - 192.168.100.170

The following are the relevent my.cnf settings

[mysqld]
port=3307
server-id = 1
log-bin=mysql-bin

Confirming the server. I did some test commands prior to confirm the position.

$ mysql -uroot -p mysql
Your MySQL connection id is 47 to server version: 5.1.11-beta-log
mysql> show master status;
+------------------+----------+--------------+------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000001 |     1759 |              |                  | …

At both my current and previous employer I've been involved in designing and maintaining aggregate, or "rollup" tables for advertising traffic data. I have learned several methods of propagating changes from the atomic data through to its aggregations. This article discusses these methods, how to implement them, and their pros and cons.

We had a great question from a reader yesterday:

Is there a todo/nice-to-have list anywhere for MySQL documentation? Or perhaps a list of Devs who require documentation support? Or is all documentation a function of the core Documentation team?

read more

OK, so today, I was following up on a headline about the free wireless network project called CUWiN. The project looks pretty awesome; check it out to see how a few people are creating a wireless network mesh from commodity (I mean, really commodity hardware - think 486!). I have no idea whether MySQL could be ovf use for the project -- perhaps, not sure... I might follow up on that at a later date once I find out more information about the project.

However, in perusing the CUWiN website, I happened to come across a really cool web page that maps the CUWiN local area network. So, I tracked the mashup project that is used to display this page through the link on the bottom of the page to the …

Many of you have responded very positively on the first and second partitioning articles that I wrote some time back. It?s clear that a lot of you are excited about the upcoming MySQL 5.1 release, and in particular, the new data partitioning feature that?s being offered. That?s no surprise because, as we covered in the previous two articles, partitioning has some excellent performance and management benefits for anyone who?s building data warehouses or other large databases with MySQL.

I saw this on a Channel 9 forum thread:

Library of Free Data Models

There are quite a few starter data models (what the author calls Kick-Start Data Models). Data modeling can be a very challenging endeavor to anyone who isn't familiar with the practice. There are some good examples in this collection which show how to take a problem space and distill it down into a workable set of entities and relationships. Of course, these represent starting points, as the author indicates. They won't fit every situation. However, they do provide a point to work from, especially for the novice data modeler.

Technorati Tags: …

We are going to release several patches which are not included in official MySQL releases.
First one is automatically stack trace for x86_64 systems. Currently MySQL resolves stack in crash only for x86 boxes.
You can download patch for 5.0.22 source tree here.
How to use: place stack64.diff into main source dir; execute patch -p1 < stack64.diff.
One important one: flag -fno-omit-frame-pointer must be added to CFLAGS and CXXFLAGS, by default GCC uses
-fomit-frame-pointer on x86_64 systems (on x86 by default -fno-omit-frame-pointer).

I must admit, I am a fickle browser user.  Much to the chagrin of colleagues, I often end up using IE as a browser on Windows.  My rationale is, that for good or for bad, it's what's used by the majority of users and so I try to make sure that the www.mysql.com site looks good in IE.  However, I also occasionally run Firefox and Opera, which until recently have been the only way to have a half-way decent tabbed browsing system.  Not only is Opera fast, it's introduced a number of innovative features including their "rewind" and "fast forward" buttons shown above, which enable …