My friend and colleague Julian Hyde of Mondrian fame just blogged about this: help out the OpenMRS project , please!

The folks behind the OpenMRS are helping to improve the health-care systems in developing countries. More in particular, they are fighting AIDS with this software. OpenMRS has certainly shown to be up to the task at hand: it is currently tracking the medical conditions of over a million people in 12 countries.

Because of the exponential growth of users, this project is in urgent need of BI manpower. Julian and myself have both agreed to help out with strategical advice for the BI part of OpenMRS.

If you want to be part of the team, if you know a bit about the …

Ok, I'm a little travelled out with recent trips to around the US visiting customers, the Gartner conference and a trip to Europe for our developer meeting in Germany. So I'm glad that the upcoming Zend PHP conference (Oct 8-11) is in the bay area. I've been to this conference the last few years and it's a good one. Not as large as the MySQL conference, but if you're into PHP, it's got all the technical meat you could want, and then some. I expect the Zend execs (Harold Goldberg, Andi Guttmans and Mark DeVisser) will kick things off with... READ MORE

For those of you who enjoy running exotic operating systems: I just stumbled over a port of MySQL 5.0.45 for OS/2 and eComStation. Thanks a lot to Paul Smedley for maintaining this version! He also maintains a large number of other Unix applications that he ported over to OS/2 - very impressive.

Data warehouse administrators often want to give different users access to different subsets of the data. The OLAP model is a powerful paradigm for exploring data, and this paradigm also allows complex access-control rules to be expressed easily.

Mondrian already implements a rich set of access-control primitives (see mondrian schema guide), but we are considering some features to make mondrian more expressive in future releases.

Introduction: Access control in mondrian-2.4

In the current version of mondrian, roles are defined by elements in the mondrian schema file. A role can have access granted, or denied, for cubes, hierarchies, and members of hierarchies.

The type of access granted to an object is inherited by its children. For example, if you deny access to a schema, then access to cubes in …

Earlier this month (on the 4th, to be exact), OmniTI celebrated its 10th birthday. From humble beginnings in Theo's basement to a company of almost 50 employees, things have certainly changed. We now have an entire division devoted to email (Message Systems), a new office opening in New York, and a strong reputation that we all cherish. I haven't been here since the beginning, but I'm very proud to be a part of this team.

On his blog, Theo shares his thoughts on the occasion:

OmniTI is my other child, and the stresses and accommodations that I and everyone close to me have shouldered for …

The sixth annual MySQL Conference & Expo, co-presented by MySQL AB and O'Reilly Media, will take place April 14-17, 2008 in Santa Clara, California. The event is expected to bring over 1,500 open source and database users together to harness the power of MySQL and celebrate the large and active MySQL ecosystem. The call for participation is now open for prospective speakers -- submissions will be accepted until October 30, 2007.

To submit a proposal or learn more about the conference, please visit www.mysqlconf.com.

This year, it seesm that whenever I go out for significant travel, the following things will break on my trip:

• a laptop power supply
• a disk

At least this time the disk is part of a RAID1 array.

Oh, and for some reason my mythbackend stopped doing anything a few days ago…. and I wasn’t checking it. grr… annoying. At least there’s not much on TV.

There was long played scalability issue with InnoDB auto-increment field. For details check Bug 16979. In short words the problem is in case of insert into table with auto-increment column the special AUTO_INC table level lock is obtained, instead of usual row-level locks. With many concurrent inserted threads this causes serious scalability problems, and in our consulting practice we had a lot of customers who was affected by InnoDB auto-inc. For several of them we even advised to replace auto-inc column by that or another solution.
Good news is the bug is fixed. Bad news is it is fixed only 5.1.22, which is not released yet.
I wonder if the fix is going to be ported to 5.0, as I mentioned it affected many production systems and not all of them are ready to upgrade to 5.1.
…

So, I'm developing a new application that's in the capacity planning phase. The application is designed to scale linearly and scale is very easy to do just by adding another database server. But, at what point do you upgrade? What point in the applications life do you add new servers to serve the expectation of the users?

To figure out these questions, thresholds need to be defined. When these thresholds are exceeded then upgrades need to occur.

Here is a process (my process) of questions to ask to define thresholds: First I start out with generic questions listed below.

What is the expected amount of users who are going to use the product initially?

What is the expected usage pattern? For instance if they are adding data what is the add rate? If they are reading data what is the read rate?

Given that the first two questions are answered now ask when is it going to …