Below is a rough draft of the cornerstone slide for a new presentation deck I am putting together to explain the various business strategies for monetizing open source software. The aim is to explain every single existing strategy using the elements on this one slide (although I am yet to test it out).

In our previous discussions about business strategies we have noted that there are four elements that shape a business strategy around open source software: the open source software license; the development strategy; the end user license strategy; and the revenue trigger.

As can be seen from the slide above, I have added a fifth element: copyright control. Copyright was previously considered in our research around business strategies but was seen more as an underlying influence than a distinct strategy element.

I have recently come to the realisation that copyright control is not just a part of each of the four elements, and …

Monitoring a replication is an important aspect. As replication includes multiple nodes, it is essential to track activity and status across all mysql servers involved in replication. To monitor replication…

The post Monitor multiple mysql replication using php: Updated first appeared on Change Is Inevitable.

Continuing my look at Tokyo Tyrant/Cabinet and addressing some of the concerns I have seen people have brought up this is post #2.

#2.  As your data grows does  Tokyo Cabinet slow down?

Yes your performance can degrade. One obvious performance decrease with a larger dataset  is you start to increase the likelihood that your data no longer fits into memory.  This decreases the number of memory operations and trades them for more expensive disk based operations.    As fast as any application is, as you read off disk opposed to memory performance is going to drop off substantially.  One of the more difficult things to test with Tyrant is disk bound performance.  The FS Cache can make Tyrant seem like small amounts of memory will still make it scream.  Once your data set is larger then that, people start to claim they hit the performance “wall”.

In order to help test this I …

As I mentioned in a previous blog post I was suspicious that the
adaptive hash index in InnoDB added to the scalability issues in
the MySQL Server. So I decided to run a test where I disabled the
adaptive hash index.

The results were fairly much as expected. The adaptive hash
index usage improves performance on low thread counts
(up to about 16) by a few percent. However at 32 threads and
beyond the performance is better without the adaptive hash
index and equal in some cases. In particular the top performance
goes up by about 3% when this is disabled.

This confirms the documentation in the InnoDB manual that the
adaptive hash index improves performance as long as the lock
around it doesn't hurt performance. So for the majority of users
it's a good idea to have it turned on, but for users with high-end
servers it's a good idea to test …

In this second part of our piece on scaling, we talk about running more instances of MySQL either on a single server or multiple servers, to get faster overall response for your queries.  This will require some work with your application making decisions about where it will find its data or where it should make changes, but with some work you can drastically improve overall response for your applications.

Bigger and Better MySQL – DatabaseJournal.com

The latest release of InfiniDB (out this week - 0.9.5.0) contains a new online alter table function that lets you add new columns to existing InfiniDB tables in an online fashion, meaning queries aren't blocked on the table while the alter is running.  You can still use the standard ALTER TABLE ... ADD COLUMN command, which does an offline alter, but if you want to add columns without impacting query activity, you now have that option open to you.

Doing an online column add involvRead More...

I think that most people are missing the point, Oracle included. The main objection of the EU is not that Oracle is swallowing up a major competitor.

To understand this you have to read between the lines of the EU decision:

"The regulators see a major conflict of interest in the world's largest commercial database company owning its largest open-source competitor"

This should actually read: "the world's largest commercial database company owning the largest open-source database"

The database market is divided into 2 parts: the back-office and the online world.

And now you know what I am going to say ... Oracle has an near monopoly in back-office and MySQL has a monopoly in online applications.

So let's do a little maths:

If we assume that back-office and online applications divide the database market into 2 equal parts, and that Oracle owns …

I've kept away from this debate since last April, but this eternal dragging-on is getting to me. Could we please move on already regarding the Oracle-Sun-MySQL decision? I'm a customer of MySQL, and I don't really savor the idea of becoming a customer of Oracle. Even so, I'd much rather see Oracle own it, than leave it straggling, let alone see this process drag on and on. This is helping no one.

I'm using a product from a company from which I buy commercial support, but I could switch to using a binary-compatible Open Source tool any day I chose. I am not bound to remaining a customer of the company I'm buying support from for any period longer than the current contract. I can definitely live with that obligation. I can live with the OSS-tool …

When I did sysbench benchmarks 1 year ago I used a
4-socket server, a Linux kernel based on 2.6.18 and
MySQL 5.1. The sysbench readwrite numbers I got then
was around 2700. When I run the same benchmarks
now the numbers I get are 9300.

These improvements obviously comes from a mixture
of HW development, OS development (now using
a 2.6.31 based kernel) and MySQL development.

The machine is still a 4-socket server, the operating
system is still Linux and the database is still MySQL,
but the performance has improved by 245%. Needless
to say this is an extraordinary performance
improvement in just one year and clearly shows that
the both the HW industry and the open source SW
industry is quickly picking up on how to improve
performance using multi-core multi-socket servers.

This Thursday (November 12th, 14:00 UTC), Giuseppe Maxia of the MySQL Community Team will present Gearman for MySQL. I got the time wrong in my original announcement, sorry.