Last Friday, my mentor from the university came to visit Imtech ICT. To explain him what the project is all about, I gave a short presentation. The presentation contains some of the elements that are also present in the presentation that I posted on the 29th of May, but this new presentation focusses on the project instead of the product.

I'm sorry English readers, this presentation is in Dutch.

The presentation can be downloaded here: Kennismaking

Blog: http://sqlbusrt.blogspot.com/

Project website: http://sqlbusrt.sourceforge.net/

I'm a big fan of the Working Daze comic, but I certainly hope that this comic is indicative of the majority of our users

read more

Hello,

Thanks for stopping by.

I have decided to set up this blog in order to collect, catalog, and contribute to, all things related to MySQL Cluster (and some that are not) floating around the web.

Count on this blog to be a clearing house of sorts for any and all information, how-to's, interviews, tips, news, feedback, gossip and happenings as they relate to MySQL Cluster.

I guess I should add the disclaimer that I am the product manager for MySQL Cluster...so I've got a bit of a personal interest in the subject matter.

Check back for additional content in the coming days, weeks and months.

Thanks for your interest,

Jimmy Guerrero
Sr. Product Manager MySQL

I’ve recently written about techniques for archiving, purging, and re-indexing huge database tables. These techniques exploit both data structure and usage patterns. In this article I’ll develop that theme further, and explain how to write more efficient non-backtracking maintenance jobs when the update and insertion patterns permit. Motivation In my current employment, I’ve been optimizing databases for size, speed, and consistency. As part of my regular monitoring, I checked our master MySQL server for deadlock information and found that a nightly cron job’s query had caused other queries to time out or deadlock, then became a deadlock victim itself and died, after loading the server for a long time.

I will be at FrOSCon 2006 on June 24, with a talk about Pivot tables in MySQL 5.
I will arrive in Sankt Augustin on June 23, flying from Alghero Fertilia, Italy to Frankfurt Hahn, Germany and then driving to the conference site (travel plan).
The funny thing is that, when I booked my flight, I had no idea that I was about to get in the middle of the Soccer World Cup. Being no soccer fan, I realized this fact only when the media circus started and I could not avoid being informed. Oh, well, now I understand why it wasn't easy to find a hotel, even booking two months in advance!

The slides and the source …

I’ve had my blog at Free Software Magazine added the Planet MySQL syndication site.

Digg, for those who have been under a rock for the last year, is a technology web site that gives users the opportunity to rank news stories.  Think of it as a combination of social bookmarking and nerdly news.  Digg grew out of founder Kevin Rose's desire for a feature within Slashdot to let users vote on their favorite stories.  Unfortunately, Slashdot couldn't accomodate the feature.  Necessity (or perhaps envy) being the mother invention, Rose created Digg.com.  Digg raised $2.8 million in venture funding from Marc Andreessen, Pierre Omidyar and Greylock partners last year. 

Digg has continued it's rapid growth with nearly a four-fold increase in traffic in just over a year. It's daily page …

Documentation is a vital part of any application, proprietary or free software, as it is often the first way to communicate with users about the application or software and how it should be used. I also think it tends to be one of the areas most taken for granted; most users expect it to be there and often forget just how much effort goes into producing it.

Many users also complain about the documentation itself. Often this is because it?s been written by programmers and, as a rule, they really aren?t that great at writing documentation that is particularly human readable.

read more

I have begun work on the next set of features for MDB2. I just implemented a feature inspired by the popular ADODB abstraction layer. John calls it smart transactions, while I am currently planning on calling it nested transactions. However I will wait until Lorenzo has some time to look at things to see if we can fit native nested transactions in there or not. Interbase/Firedbird really shines in this department.

I have written up a little script to show the current implementation available in CVS:

<?php

$mdb2 =& MDB2::singleton($dsn);

$mdb2->setOption('debug', true);

$query = "DELETE FROM autoinc";
$result = $mdb2->exec($query);

$query = "SELECT id FROM autoinc";
$result = $mdb2->queryCol($query);
var_dump($result);

$query = "INSERT INTO autoinc (id) VALUES (?)";
$stmt = $mdb2->prepare($query);

$mdb2->beginNestedTransaction(); …