show processlist;

If you’re a phpMyAdmin user, then there’s a link for “processes” on the front page of your installation. Give it a try when things seem to be taking longer than they should!

Choosing a Topic

This actually wasn’t hard because I wanted to pick something that I have particular knowledge of. As a part-trained Oracle DBA with experience of Oracle and PHP, these two topics seemed like an obvious choice.

Preparing the ‘Cast

I was quite determined not to read aloud from a script, so I put together some bullet points and practised doing the talk from those quite a lot. Playing back these attempts helped me to see what worked and what didn’t – those points got added, removed and re-ordered quite a few times. Even after a lot of practise, I was still pausing too much between points. I ended up transcribing my unscripted version and then re-recording it, which worked well as I had my own natural language but no pauses!

Sound and Software

I was concerned that I would need additional equipment, such as a better microphone. However my partner has a macbook and the built-in microphone on that proved to be up to the job. I used Garageband from Apple’s ilife to record the track (and also to edit out the clicking I got from pressing the mouse to start/stop recording!). This saves files in .m4a format, but this can be converted to .mp3 using itunes.

Rsnapshot is a perl-based backup script manager. It is a journalised backup system – meaning that it copies all your files across to the backup media once – and then the only data it transfers after that is the changes. The backups appear on disk as complete copies – but where two generations are exactly the same file, they’re actually symlinked to the same data.

Backup Strategies

Rnsapshot has hooks for scripts that run before and after the actual snapshotting. I use the “before” script to:

• dump the mysql databases (see my earlier comments about mysql backups)
• take a copy of the svn repository
• mount the drive to back up to

The after script just unmounts the drive. To add these extra scripts you just uncomment the lines containing the cmd_preexec and cmd_postexec paths and point them to your scripts.

Getting Started

Well I could write a lot about this but to be honest I doubt I’d do better than the excellent rsnapshot howto so I suggest you read that for how to do it. Basically, enter the path you’d like to back up to, the interval you’d like to use, and then a bit further down the page which directories you want backing up (the default is /home, /etc and /usr/local) – then run the command! The howto even includes instructionsn on setting up cron to call the command regularly.

Rsnapshot Conclusion

Rsnapshot was a good tool to stumble upon as a learner sysadmin (which I am) and its very easy to use. I love the fact that it isn’t rocket science, but its a really nice, usable version of a collection of scripts which are duplicated by system administrators the world over. The file structure of the backups is the same as the content that is backed up and retrieving any generation is as simple as copying a file over. I’m sure there are other solutions out there, but I’m a convert and use it on all the local servers I administer (Ubuntu boxes, it works a treat).

That is to say, some top tips for the command-line program top. Top is a program to show you the top processes consuming resources on the system. You can then press other keys and the program will respond. For example:

q to quit

z to get a colour output

x to highlight which field the results are sorted by

< and > to change which field it is sorted by

c to tooggle between the program name and the full command that was run

I don’t use every program often enough to just remember the keyboard shortcuts so its nice to keep a virtual crib sheet :)

Subversion is a source control system – an excellent accompaniment to software development especially in a team setting. When working with a number of people, it is likely that at one time or another there will be collisions – for example at the moment a project I am working on has a team making some amendments requested by the client for a website. Subversion is handling it all well but the main template files and stylesheets are colliding often as everyone is making changes.

Commit First!

The collision will only occur if you check in a change and someone else has already changed that line in a file. To avoid getting a collision in your working copy, the best thing to do is to commit your change before the other person does.

This approach of commit early, commit often will help you to develop more smoothly without the interruptions of a collision and without struggling with lots and lots of merged files when you’ve left it too long between commits. Additionally you’ll have more checkpoints in your own development history so if you need to go back a few steps, the repository will be able to help you whereas if you didn’t check in, it won’t!

That’s my tip for the day – on a day in a place where many people are bug fixing a single project!

I had some difficulty setting up mysql to listen to external ports on a server – the development web server uses databases on another box. The important setting was in /etc/mysql/my.cnf where I removed the line:


bind-address = 127.0.0.1


You should then be able to connect a client from another server to this mysql server.

As a warning – bear in mind that it is usually good practice to set up user permissions to only be valid when accessing from localhost if that is the intention – check your mysql table if you can log into the server but then start getting permission problems for other users.

Hope this helps someone!

Having recently embraced the social networking revolution, or not, I have recently been getting exasperated by how out-of-date my status gets when I can’t be bothered to update it. And how annoying that there are statuses on both Facebook and Twitter which are both out of date.

I stumbled across the instructions at http://www.jeffsandquist.com/HowToPublishYourFacebookStatusToTwitter.aspx and used these so that when I update facebook, the same status appears as a tweet¹ on twitter!

If you use both applications then I’d recommend giving this a try. It uses twitterfeed as a go-between to get your RSS feed of statuses out of Facebook and in to Twitter. If you give it a try, let me know how you get on?

¹ I am assured that “a tweet” is the singlar label for an entry on twitter. And furthermore that a person posting these entries can be said to be “tweeting”. So now you know!