Martello

Just upgraded to a newer version of WordPress and forgot to re-enable by home-grown anti-spam hack on the comments page. Got hit with over 50 bogus comments in the space of 30 minutes or so. Big brother is watching!

I reluctantly bought a copy of OmniGraffle for Mac some weeks back, purely to do some updates to diagrams originally created with Visio on Windows (which is not available for Mac). At first, I thought the selection pre-made images (stencils to use their technology) was quite poor and very much lacking from those available for Visio. However, that was before I discovered Graffletopia.

Nice, very nice!

If you’ve been considering moving your domain to Google Apps, and you are likely to need more than 10 accounts, you might want to consider moving before 10 May 2011 as they are tightening the rules on the maximum number of user accounts you can have on the free account from that date.

Here’s the official announcement I received from Google earlier today:

We recently announced upcoming changes to the maximum number of users for Google Apps. We want to let you know that, as a current customer, the changes will not affect you.

As of May 10, any organization that signs up for a new account will be required to use the paid Google Apps for Business product in order to create more than 10 users. We honor our commitment to all existing customers and will allow you to add more than 10 users to your account for xxxxx.com at no additional charge, based on the limit in place when you joined us.

Still though, a 10 user limit is probably good enough for most personal uses and to be fair, $50 per user per year, it’s still very good value for money.

Here is a useful MySQL command that shows (an approximation of) the amount of storage (disk and memory) consumed by each table in a MySQL database.

SELECT
 TABLE_NAME,
 TABLE_ROWS,
 DATA_LENGTH / (1024*1024),
 INDEX_LENGTH / (1024*1024),
 (DATA_LENGTH + INDEX_LENGTH) / (1024*1024) as total
FROM
 information_schema.TABLES
WHERE
 TABLE_SCHEMA = (SELECT DATABASE())
GROUP BY
 TABLE_NAME
ORDER BY
 total;

Please bear in mind that the data returned will be an approximation, but should still show you a reasonable enough split which of your tables are consuming most of the resources.

One of our test Amazon EC2 instances decided to go for a holiday last week (reason still under investigation), and as part of the attempted recovery process we tried the eventual obligatory “system reboot”. Unfortunately, this failed to fix the problem, and we then also discovered that an unsupported setting previously added to the OpenSSH configuration (/etc/ssh/sshd_config) actually prevented the SSH daemon from starting at all (we found this out from “View System Log” option in the AWS Management Console).

In any case, as you may know, SSH is pretty much the only way to gain administrative access to an Amazon instance (there is no Unix/Serial console or Remote Desktop to speak of), so if you mess up your SSH configuration, you really are in big trouble!

Actually, that’s not entirely true. As it happens, if your instance is EBS-backed (i.e. uses an EBS volume for its root/system partition), you can actually detach the root partition from the broken instance, attach and mount it on another running instance, fix the erroneous configuration setting, re-attach to the broken instance, and reboot again. Voila, Problem solved!

This is all very reminiscent of that call from a family member saying their computer won’t boot any more, whereupon you remove their hard disk and insert it as a second drive in your own PC in order to get a copy of all the files they invariably haven’t backed up.

For the record we found the solution on the Amazon Forums, and also uncovered another useful command in the process:

sshd -t

Very much like the “apachectl -t” command, this will syntax-check your SSH configuration files for you. You should run this command every time you make a change to your SSH configuration settings.