The Linux Professional Institute (LPI), (http://www.lpi.org), the world's premier Linux certification organization, and MySQL AB, developer of the world's most popular open source database, today announced a joint initiative to offer MySQL 5.0 certification exams through LPI's global proctor network, beginning with the C3 Expo, June 27th ? 29th, 2006 at the Javits Center in New York City. Prosoft Learning Corporation, LPI's affiliate in North America will be offering these exams at C3 Expo along with LPI Certification exams.

are you a committer or a member of a large OSS project?

do you participate in any other large open source project?

I’m trying to get a understanding of how all the different major oss projects are being cross pollinated by having people participating in different projects.

feel free to comment, or mail me directly at ian at holsman.net

Thanks!

I've been working on a presentation the last couple of days with a few of my colleagues. The presentation is centered around looking at MySQL Cluster from various perspectives within the company to help determine some future initiatives. It was an excellent exercise in discovering all the things that are great about the product, but also in helping prioritize a few things we need to work on.

One of the great things about working at MySQL is that there is never a shortage of ideas or opinions on how to make things better (even if we manage to "build a bike shed" now and again...what software company doesn't?) . Fortunately, everyone that works on the Cluster product in whatever capacity here at MySQL, really wants the product to be a success. Their day to day efforts show it and its always great to be a part of that.

One of things we really sharpened during this process, was the definition of the product itself. I think …

The modular concept of MySQL that separates the storage engines from the SQL parser and optimizer has recently caused a number of new, independently developed storage engines to surface. Here's an incomplete selection of projects around this concept:

• DDE - Distributed Data Engine, a research project of the Technical University of Dresden
• mdbtools - a storage engine that allows readonly access to Microsoft Access .mdb database files
• PBXT - a new, transactional storage engine by Paul McCullagh
• ritmarkFS - a storage engine that represents the content of a directory as a table
• …

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 …