Recently I set up a CentOS based mysql server (Actually I used RPMs from mysql.com since the ones that come with CentOS 5.4 contain some ugly replication bugs). I overlooked, that the default storage engine was MyISAM while our corporate standard (and applications requirement) is InnoDB.

In this somehow weekly series of posts I summarize noteworthy problems I encountered during my work week and how I solved them. This week I tried to set up a fully automated installation for Centos 5.3 and ran into some problems.

I am currently in the process of switching some servers from Debian 4.0 to CentOS 5.3. Almost all Linux distributions provide convenient tools to keep the software selection safe and current by installing updates. As I run multiple servers, these update processes are unnecessarily bandwith-hungry, because by default every host connects to the distributions update [...]