There are various methods to run multiple instances of mysql (on different ports) on the same machine. We can either compile the mysql binary with different defaults and paths, use mysqld_multi or the MySQL Sandbox project. Still the simplest solution I’ve  used in the past for such situations is to use the same binary and use a separate configuration file (with separate port, pid, socket and data directory). This post will explain this method. Read the rest of this entry »

This is my first blog post of 2009 and I just wanted to do a quick review of my past year blogging and also compare it with 2007. My general feeling before doing this, was that even though I have tried to dedicate more time to blogging, work and personal things haven’t allowed me to do this as much as I wanted. But let’s see the raw numbers and then draw a conclusion.

I posted exactly 91 articles during 2008, meaning an average of 8 per month. This sounds very low from the rate I am trying to achieve, but still it is a good improvement compared with 2007 when I had posted only 42 articles. The enthusiasm (and the extra time available I had back then) from my first year of blogging – 2006 – with 139 posts is still far away. I am definitely aiming for 2009 to be my best year in blogging (and not only ) and this should be doable with a little more dedication.

Read the rest of this entry »