First of all, I want to link to a blog article written by the founder of MySQL to help MySQL being rescued - everybody can stand up and tell the European Commision why the Oracle/Sun deal threatens MySQL. Second, due to a personal request, I want to make clear that this posting reflects my personal opinion of the case.

Third, I have been thinking about the markets both database systems address and why MySQL really competes to Oracle in one way or another. There are several voices who claimed that MySQL is not a competitor to Oracle, but if you know "Project Peter", Sun (the current owner of the trademark MySQL and its source code) targets Oracle customers in order to convince them migrating to MySQL.

…

Today, I twittered with Matthew Aslett from 451 group and pointed him to "Project Peter" which lead to a blog post by him (see tweet).

There's an interesting statement in his blog entry:

[...] on the theory that Oracle will not invest in the ongoing development of MySQL, which is something it has publicly committed to doing.

He links to an ad by Oracle. Come …

According to the sources, Ellison is now willing to create a separate entity within a combined Oracle-Sun that houses Sun's MySQL open database software business in order to get the deal completed before a hearing Thursday by the European Commission.

Read more at New York Post. Via Kris Köhntopp.

UPDATE: this has already been declined by Oracle (thx to @janl).

For monitoring replication we know a lot of tools and codes – but this one is different because I wrote it 😉 Well this is fairly simple php code for…

The post MySQL master master replication monitor with php code first appeared on Change Is Inevitable.

I’ve just published an article that explains how a PHP-based product can gain a good position in the market and be made appealing to customers by using marketing communication. The focus is on products licensed under an Open Source license. Yet, most of the recommendations also apply to proprietary offerings.

The article has initially been published in German by PHPmagazin. It has now been translated to English and is available on the Initmarketing website: Commercialization of PHP Software.

Installing Apache2 With PHP5 And MySQL Support On OpenSUSE 11.2 (LAMP)

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an OpenSUSE 11.2 server with PHP5 support (mod_php) and MySQL support.

When I talked with journalists, lawyers and analysts about the Oracle/Sun merger case questions were raised about the possibility to fork MySQL and that everybody who is not satisfied with Oracle's future way regarding MySQL could do this. I don't agree with that and I think it's best to put Monty's own words (found in a comment in his blog) here because I can't explain it better:

In addition, the MySQL trademark is so strong that it's hard to impossible for a fork to attract enough attention to be able to compete in a meaningful manner if MySQL would be owned by a vendor that refuses to cooperate and works against the fork.

These are tough days in the case of the Oracle/MySQL decision the EU faces. First of all, the lobbyists of Oracle achieved that the decision deadline will be extended from January, 19th to January, 27th 2010. Secondly, Monty recommended that a license change from GPL to BSD would be a great idea for MySQL's future.

Today, Johann pointed me to a document called "Project Peter" which can be found at wikileaks.org (download PDF from wikileaks.org server in Sweden). It's a presentation of MySQL's Robin Schumacher. You may ask "What is Project Peter?". The presentation says:

…

In the article ‘Versioning MySQL data‘, I showed the basics of implementing a revisioning system using trigger. As Jens Schauder already pointed out, often the data of a record is spread across multiple tables, like an invoice with multiple invoice lines. Having each invoice line versioned individually isn’t really useful. Instead we want a new revision of the whole invoice on each change.

The perfect solution
Ideally a change of one or more parts of the invoice would be changed, a new revision would be created. There are several issues in actually creating this those. Detecting the change of multiple parts of the invoice at once, generating a single revision, would mean we need to know if the actions are done within the same transaction. Unfortunately there is a connection_id(), but no transaction_id() function in …

Installing Apache2 With PHP5 And MySQL Support On Ubuntu 9.10 (LAMP)

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an Ubuntu 9.10 server with PHP5 support (mod_php) and MySQL support.