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

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

Thanks to Christian Hammers, we finally have MySQL 5.1 in Debian unstable, which completely replaces MySQL 5.0. Please update all build-dependencies from libmysqlclient15-dev to libmysqlclient-dev and upload a rebuild version of your package.

As a positive side-effect, we no longer care about MySQL bug #41728, which was the reason why no newer version of MySQL 5.0 made it into testing since lenny got released.

Thanks to Christian Hammers, we finally have MySQL 5.1 in Debian unstable, which completely replaces MySQL 5.0. Please update all build-dependencies from libmysqlclient15-dev to libmysqlclient-dev and upload a rebuild version of your package.

As a positive side-effect, we no longer care about MySQL bug #41728, which was the reason why no newer version of MySQL 5.0 made it into testing since lenny got released.

Several months ago, I started a little project at work, called Mockload. It started as a fun way of using the MySQL Proxy, to test our monitoring agent, as well as the rules engine and graphs on the Service Manager.

Why?
I needed a tool that would be easy to use, and improve over time. And that it would allow our QA team to send custom values to the service manager. The goal was to pretend having some very busy MySQL servers.

And what better tool, than the MySQL Proxy itself to pretend being a busy MySQL Server!
The way our agent collects the MySQL related data, is by issuing different sql queries. So, I thought that I could have a MySQL proxy instance in between …

You can do all sorts of magic with LVM, like backing up MySQL using file system snapshots, but in order to do so you need to set it first. When installing a new computer with Suse Linux I found that this was harder than expected, unless you know what to do. Needless to say, I didn't, but some friends gave me a hand on IRC, and now I do. :-)

So I wrote a little article about this which you can find here, in an effort to save others some time. The article is about setting up LVM with Suse Yast, but you can probably use it for other flavors of Linux, too.

You can do all sorts of magic with LVM, like backing up MySQL using file system snapshots, but in order to do so you need to set it first. When installing a new computer with Suse Linux I found that this was harder than expected, unless you know what to do. Needless to say, I didn't, but some friends gave me a hand on IRC, and now I do. :-)

So I wrote a little article about this which you can find here, in an effort to save others some time. The article is about setting up LVM with Suse Yast, but you can probably use it for other flavors of Linux, too.

This blog post was inspired by Masood Mortazavi's comment: "OSCon to be somewhat disappointing this year -- many low quality sessions and a celebration of forks"I did not attend OSCON, even though I live in California. I did not even bother to submit a presentation proposal, even though people who attended my talks at the MySQL Conference and Expo earlier this year and the year before, all

As I’ve blogged many times, MySQLers frequently share off-work interests and running is one of them. I’ve also blogged about social media, which usually use MySQL under the hood. Now I’ve combined the two (running and social media) with the insight that running is a religion: I’m propagating Runnism, the Religion of Running.

It started as a thought …

In a blog entry I’ve explained why I consider running a religion and why I want to spread this religion with social media. Still, what’s the point with doing it worldwide? Isn’t enough to do it close to my own front door, either at home in Munich, Germany or in my native Finland?

The reason relates to my interest for other countries, cultures and languages. Through my work, I’ve travelled a lot especially last year, as Ambassador of the product of my former employer. As I …

Ryan posted an article on the MySQL Performance Blog about how to use mk-query-digest to analyze and understand your memcached usage with the same techniques you use for MySQL query analysis. This is an idea that came to me during the 2009 MySQL Conference, while talking to our friends from Schooner, who sell a memcached appliance.

It suddenly struck me that the science of memcached performance is basically nonexistent, from the standpoint of developers and architects. Everyone treats it as a magical tool that just performs well and doesn’t need to be analyzed, which is demonstrably and self-evidently false. memcached itself is very fast, true, so it doesn’t usually become a performance bottleneck the way a database server does. But that’s not the point. There is a …