From Vagrant to NixOps

I have been following the development of NixOps for some months. NixOps is a cloud deployment tool using nix, the functional package manager for unix systems. Nix makes it very intuitive to define absolute package dependencies. No more thinking and guessing about required runtime dependencies.
NixOps supports deploying to different platforms. Bare-metal, cloud, and even virtual environments like virtualbox work out of the box. I have worked in many projects using vagrant. Out of curiosity I migrated an existing vagrant project using wasted (Web Application STack for Extreme Development) to nix and NixOps.
This post is a walkthrough to configure a symfony2 project with nginx, mysql, and php-fpm from scratch. Weiterlesen

InnoDB Buffer Pools: Warum Deine Indexgröße wichtig ist

In der Entwicklung MySQL/InnoDB-gestützter Projekte ist es allzu leicht dem „Index für alles und jeden!“-Mantra zu verfallen, speziell wenn der Kunde drängt und mehr Geschwindigkeit verlangt. Jedoch führt dies nur selten zum Ziel und in hartnäckigeren fällen so einer deutlichen Verschlechterung des Problems. Nun sind ein paar Anfragen schneller, aber alle anderen langsamer. Woran liegt es? Was ist passiert? Und was macht meine MySQL da eigentlich? Wie geht es besser? Weiterlesen

Percona-Tools für Entwickler, Teil 1

Percona-Toolkit… das ist doch nur für Admins? Mag man denken, aber es gibt in dieser großen Sammlung von Werkzeugen (der Nachfolger von Maatkit) auch Dinge, die ein reiner Developer nutzen kann und sollte. Und ich meine da nicht nur DevOps. Im Artikel wird genau erklärt, welche Tools das sind und wie ihr sie insbesondere als reiner Developer sofort nutzen könnt.


IPC Spring Edition 2012: Der Versuch einer Zusammenfassung, stattdessen aber kunterbuntes Allerlei

Ursprünglich dachte ich, der Bericht wäre nur für unser internes Blog geeignet, da er zu viel eigene Meinung enthält. :) Aber Johann meinte „Wieso, ist doch interessant?“

Hier also – unsortiert das, was davon im Gedächtnis geblieben ist (es gab natürlich noch viel mehr, zum Beispiel diese Party in der Münzstraße… aber das ist nicht so interessant) – ein nochmals leicht überarbeiteter Bericht über die IPC Spring-Edition 2012. Diese fand vom 03. bis 06. Juni in Berlin statt. Ich war vom 5. auf den 6. Juni dort, das war auch mal wieder notwendig, denn das letzte mal war ich 2009 auf einer IPC gewesen.


05.12. Doctrine 2

Object-relational mapping (ORM) frameworks have been around for several years now and for some people, ORM is already outdated by now. As we have seen with other technologies and concepts before, PHP is not exactly what we call an early adopter among the programming languages. Thus it took some time for ORM to grow up in the PHP context.

There have been some frameworks before Doctrine 2 that implement ORM (remember e.g. Propel) specific tasks but most of them lack the required maturity to be used in large projects. With Doctrine 2, PHP takes a huge step into the right direction – Doctrine 2 is fast, extensible and easy to use.

This article will take you on a tour through the main concepts of Doctrine 2 in the first part and then explain how to use it in a real world application in the second part. Since at the time of writing Zend Framework 1.11.xx (ZF) is very popular, we will integrate Doctrine 2 into a ZF project.


MySQLnd Plugins: Writing a MySQL Query Logger in PHP

During the development of an application, not all time is spent on writing code. A lot of time is spent on reading debug output, crawling through log files and firing up the debugger to figure out what the application does. While the debugger helps us to inspect details of a running application on a testing environment, logfiles are often the only indication of the origin of an error on a production system. In this blogpost I want to describe how to log SQL statements on an existing application without touching any existing line of code at all. We will use a new MySQLnd Extension developed at the Mayflower OpenSource Labs for
that purpose.

As an example, I will use PHProjekt 6. The project is particularly suitable for demonstration purposes as it has a logging infrastructure for function calls, but does not log SQL statements.


MySQLDumper: Praktische Anwendung Vortrag@Mayflower München

Am kommenden Donnerstag, den 11.03.2010 findet wieder ein öffentlicher Vortrag im Mayflower Büro in München statt (Mannhardtstraße 6, S-Bahn Isartor).
Beginn ist um 18:00 Uhr, Thema des Vortrags ist „MySQLDumper: Praktische Anwendung„.

Intelligentes Backup-Management bei MySQL-Datenbanken? Kein Problem, denn mit dem MySQLDumper kann jeder Sicherungskopien seiner wichtiger Datenbestände erstellen – und bei Bedarf auch kinderleicht wieder herstellen. Daniel Schlichtholz zeigt wie MySQLDumper einem das Leben erleichtert. Frei nach dem Motto: back it up the easy way…

Die „Donnerstags-Vorträge“ werden sowohl in München als auch in Würzburg gehalten. Bei Interesse einfach das Blog beobachten, um auf dem Laufenden zu bleiben!
Wir freuen uns auf viele Teilnehmer!

Everybody can fork MySQL. But what about market penetration?

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.

Oracle/MySQL – Project Peter – Monty’s dreams for BSD license

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 (download PDF from server in Sweden). It’s a presentation of MySQL’s Robin Schumacher. You may ask „What is Project Peter?“. The presentation says:

Project Peter is an internal effort to assist Sun/MySQL customers in migrating from Oracle to MySQL by offering them a comprehensive solution that consists of Professional Services, Best Practices, and a set of approved third party migration tools and utilities that will enable them to move to MySQL in a way that is as easy as possible.

Marten Mickos, former CEO of MySQL, tweeted some time ago about an interview in eWeek where he was asked if Oracle and MySQL compete directly against each other. On page 2 of this interview, he claims that certainly Oracle and MySQL compete to each other:

„MySQL most certainly competes with Oracle,“ Mickos said. „And successfully so. But what must be remembered in terms of dollars in that competition, it is not significant enough to warrant an antitrust consideration. Secondly, this competition happens partly outside of the business—in the free, installed base.

„So no matter who owns MySQL, the competition will continue to exist.“

Even if Oracle does ultimately own the MySQL code base and act as the enterprise headquarters for the database, „MySQL will still apply price pressure on Oracle,“ Mickos said. „That won’t change. This is why there’s no reason to stop the acquisition.“

Asked about the future of MySQL, Mickos claimed: „The MySQL business is a very strong business, with enormous potential in the next 10 to 20 years.“


So, maybe MySQL doesn’t compete in terms of dollars today. But if MySQL does have a bright future in the next 10 or 20 years, there’s evidence that numbers will climb up in the era of the „database for the web“. So that’s why there’s Project Peter for the sales force of Sun to try to convert Oracle customers to MySQL. I’m not sure if Oracle will accept a Project Peter if Oracle will own Sun and MySQL in the future – I guess they’ll shut down Project Peter because MySQL may be kind of a threat to Oracle’s business in certain areas.


And this is why Oracle mustn’t own MySQL.

EU to probe Oracle Sun deal

According to Yahoo News (and WSJ, only for subscribers – thanks to @Oswald for mentioning it on twitter, see also Reuters), the EU opens an in-depth probe to the Oracle-Sun deal.


According to the source, EU Competition Commisioner Neelie Kroes said:

„The (European) Commission has an obligation to ensure that customers would not face reduced choice or higher prices as a result of this takeover,“


Furthermore, the commision set a January 19, 2010 deadline for its decision, Yahoo News said.


PS: U.S. already approved the deal.