I hope I got your attention with the title. The politically correct term should be "how to redirect MySQL traffic on Linux", but you probably wouldn't have noticed.
The scenario is this. You want to switch servers without need for the clients to change connection parameters.
Why would you want to do this? Some reasons:

• You want to test a new server version, which you installed to listen to port 13306, and you want to do it without modifying the applications parameters;
• You ant to use MySQL Proxy on port 4040 to log the traffic for a while without restarting the server, in order to debug an inexplicable problem;

Whatever the reason, you can do it.

Here is how you can proceed on Linux.

Set a iptables rule to redirect port 3306 to port 13306 or to port 4040:

sudo …

MySQL AB is a global company. The employees are spread around the globe. It is impressive to see that this works for a technology company, where high-bandwidth communication between its main players is crucial to their success.

Once in a while though, they need to meet in person. This year, all developers meet in Heidelberg, Germany for a week. They will have workshops, training and lots of get-togethers.

MySQL AB even invited a few community members to take part in the event for two days. I managed to sneak in there and I am looking forward to see a lot of the people I met in Santa Clara earlier this year and those I have not met, yet, but read a lot online. To top it all, Damien is there. Guess what we are going to talk about.

I promised to blog my hands off in exchange for the invitation, so expect some coverage …

I finally got my visa so I'm going to MySQL Developers meeting in Heidelberg, Germany next week.
Hopefully it will be great source of "technical insight" information, either from organized sessions or from developers themselves.

Plus I'm looking forward meeting a lot of friends our where both MySQL Developers and active community members.

Entry posted by peter | 2 comments

Add to: | …

Ok, another blog post tying together MySQL and Frisbee. It all started back in June. First round of the Swiss Mixed Ultimate Frisbee Championships. We played well, lost only 1 game. So good so far. Last weekend was round two. We did not loose a single game and surprise, we are already in the final, even before playing the final 2 games on Saturday next week. Hmm, now I realize it started a year ago in Viareggio. One of the top beach Frisbee tournaments in Europe, where I was planning with the Viareggio only "Strandlaeufer" team. We all swore an oath to come to play together the follow year again.

Only trouble was, that this coincided with the final round of the Swiss Championships. Bummer, I would miss out on the final! So I …

Ok, another blog post tying together MySQL and Frisbee. It all started back in June. First round of the Swiss Mixed Ultimate Frisbee Championships. We played well, lost only 1 game. So good so far. Last weekend was round two. We did not loose a single game and surprise, we are already in the final, even before playing the final 2 games on Saturday next week. Hmm, now I realize it started a year ago in Viareggio. One of the top beach Frisbee tournaments in Europe, where I was planning with the Viareggio only "Strandlaeufer" team. We all swore an oath to come to play together the follow year again.

Only trouble was, that this coincided with the final round of the Swiss Championships. Bummer, I would miss out on the final! So I …

Sorry that I need to abuse my blog for this. Usually my posts always say something about PHP, PostgreSQL and MySQL, even if sometimes most of the blog post is about Frisbee. But this time its entirely off topic, because I am trying to help my sister and her husband who was just layed-off from work without any prior notice. As a result he was pushed to do what he was thinking in the back of his head anyways, start his own business as an A/C repair service company. Of course now things are a bit rushed and so he is having trouble finding enough clients to keep him busy enough.

So I am calling out to all people in Florida. Ok he can probably not cover all of Florida. My sister and her husband are based in Sarasota. I asked and the work range is from North Port and Punta Gorda in the south to as far north as St. Pete. Anyways here is a partial "reprint" of a letter Bob send out to a potential customer:

I am a maintenance, service and …

Sorry that I need to abuse my blog for this. Usually my posts always say something about PHP, PostgreSQL and MySQL, even if sometimes most of the blog post is about Frisbee. But this time its entirely off topic, because I am trying to help my sister and her husband who was just layed-off from work without any prior notice. As a result he was pushed to do what he was thinking in the back of his head anyways, start his own business as an A/C repair service company. Of course now things are a bit rushed and so he is having trouble finding enough clients to keep him busy enough.

So I am calling out to all people in Florida. Ok he can probably not cover all of Florida. My sister and her husband are based in Sarasota. I asked and the work range is from North Port and Punta Gorda in the south to as far north as St. Pete. Anyways here is a partial "reprint" of a letter Bob send out to a potential customer:

I am a maintenance, service and …

So not too long ago, I ran some simple (and perhaps archaic) benchmarks pitting different engines against each other in terms of how they performance with BLOBs. While I ran into some interesting results, there was one fairly important storage engine that I neglected to test - Falcon. So this time around, I thought I would try some similar tests against MyISAM, InnoDB, and Falcon. I wanted to do PBXT as well, but was unable to get it to work with MySQL 6.0, and didn't think it fair to run PBXT on MySQL 5.1 since 6.0 appears to be slower (likely due to debugging options I would imagine).

Anyways, this time around I opted to use SQLBuster, a little PHP-based script I wrote to help test various queries and concurrency. It works quite well, but the problem is that I am using multiple processes, not threads, to perform the test, which I think tends to skew the …

I was browsing around the MySQL web site tonight and ran across some free webinars (recordings). Seeing as how I once did a podcast on Oracle partitioning, one webinar that jumped out at me was Partitioning in MySQL 5.1 and onwards.

I didn't even know MySQL did partitioning. Here is a description of the webinar:

In this webinar we will provide further insight into MySQL partitioning, including:

• Introduction to MySQL Partitioning
• Linear Key Partitioning
• Partition Function
• Partition Options
• Information …

Welcome to the 62nd edition of Log Buffer, the weekly review of database blogs. You know, I haven’t actually written one of these since LB#46, way back in May, so I hope I haven’t lost my touch. I guess we’ll see, eh? An item in last week’s Database Column by Mike Stonebraker, a guru [...]