I have made an update to the DBT2 clone where I packed in all my
benchmarking support scripts.

This update adds a new script bench_prepare.sh that should be run
from the benchmark server and uses the input of 3 tarballs, the
DBT2 tarball, the sysbench tarball and a MySQL tarball. It will
automatically build all needed binaries on both the benchmark
server and on the MySQL Server machine (they could be on same
machine or on different machine).

The script only requires one parameter --default-directory where
one configuration file called autobench.conf should be placed.
This directory will also be used to house all result files,
builds and generated configuration files for all involved scripts.

The aim is to continue develop such that we can also benchmark
easily using different Linux versions.

The tarball can be …

Received a "certificate of attendance as speaker" for recently concluded FISL 10.



This is sweet, thanks FISL organizers! It certainly adds a personal touch to the whole experience.

I don't remember receiving a personal certificate like this :)

Technorati: conf fisl brazil glassfish netbeans mysql eclipse

Received a "certificate of attendance as speaker" for recently concluded FISL 10.



This is sweet, thanks FISL organizers! It certainly adds a personal touch to the whole experience.

I don't remember receiving a personal certificate like this :)

Technorati: conf fisl brazil glassfish netbeans mysql eclipse

We like to invite you to the PHP 5.3 release party which is an event to celebrate the 5.3 release, happening Friday, the 17th of July in Munich. The release party offers a chance to come together with other php enthusiasts and enjoy that php is alive and kicking. And of course people in favour of a decent barbecue, together with some beer and other drinks are invited.

The happening will take place at Waldwirtschaft beer garden, at any weather.
We will meet at 19:00 o’clock - open end.

The location is famous for its huge beer garden (2500 available seats, a children’s playground) and its typical Bavarian but also international food. On sunny weather you even may enjoy live-music and listen to the sounds of Jazz, Blues, Swing or Dixi.

Catering will be provided …

We like to invite you to the PHP 5.3 release party which is an event to celebrate the 5.3 release, happening Friday, the 17th of July in Munich. The release party offers a chance to come together with other php enthusiasts and enjoy that php is alive and kicking. And of course people in favour of a decent barbecue, together with some beer and other drinks are invited.

The happening will take place at Waldwirtschaft beer garden, at any weather.
We will meet at 19:00 o’clock - open end.

The location is famous for its huge beer garden (2500 available seats, a children’s playground) and its typical Bavarian but also international food. On sunny weather you even may enjoy live-music and listen to the sounds of Jazz, Blues, Swing or Dixi.

Catering will be provided …

Speed of InnoDB recovery is known and quite annoying problem. It was discussed many times, see:

http://bugs.mysql.com/bug.php?id=29847

http://dammit.lt/2008/10/26/innodb-crash-recovery/

This is problem when your InnoDB crashes, it may takes long time to start. Also it affects restoring from backup (both LVM and xtrabackup / innobackup)

In this is simple test, I do crash mysql during in-memory tpcc-mysql benchmark with 16 running threads.
MySQL params are:

PLAIN TEXT CODE:

1. innodb_buffer_pool_size=16G
2. innodb_log_files_in_group=3
3. innodb_log_file_size=512M

So let's take standard MySQL …

The MySQL Runners Club meets whenever running MySQLers meet. Sun Microsystems GmbH here in Germany also has something similar — and a good week ago, a group of Sunnies teamed up for the 31. Münchner Stadtlauf half marathon. I decided to make myself an embedded reporter, combining Twitter, Flip Mino, YouTube and a bit of surplus electronics and Web 2.0 media.

What’s the result? 37 Tweets, an almost 10 minute YouTube video and, surprisingly, a new personal record (1:44:06).

You’ll see a bit more in the video. Sure, both voice and text are in German — but you’ll get …

I'm pleased to announce the release of Spider storage engine version 0.13.(beta)
http://spiderformysql.com/

The main changes in this version are following.
- Add table parameter "crd_bg_mode" and "sts_bg_mode".
- Add server parameter "spider_crd_bg_mode" and "spider_sts_bg_mode".
  MySQL needs table's analysis informations when select statement is executed. Spider storage engine gets this informations from remote table but this action often generates over-heads.
  This options remove generated over-heads by getting analysis informations at background but you must set this option to 0 if the table's analysis informations change frequently.
  * There are other options for the over-heads reduction of the analysis informations acquisition. I will introduce this at another time.

Please see …

Microsoft makes a patent promise. JBoss is certifiable. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

# Microsoft announced that it will be applying its Community Promise to the ECMA 334 (C#) and ECMA 335 (CLI) specifications, reducing patent concerns related to Mono.

# Red Hat achieved EAL 2+ security certification for JBoss Enterprise Application Platform.

# A European Commission white paper on standards stirred some controversy with regards to open source. …

It seems pretty common to find customers install DRBD for the wrong reasons. There are many pros/cons to compare DRBD to replication, but I've managed to cut down my spiel I give to customers to these two points:

• DRBD's aim (assuming replication mode C) is to provide 100% consistency, and then as much uptime as possible.
• MySQL Replication (with a manager such as MMM) aims to have 100% availability, at the potential loss of some data surrounding a failure.

So if you are installing DRBD with the aim of purely "availability", and are not worried about losing that last write on the crash to your master database that (hopefully) happens only once every few years, you may be using the wrong technology.

While the prized "1 minute failover" is possible in DRBD, it doesn't really explain the full picture. The typical crash …