Posts by Andrew Moore

Scheduled Headache, Lost Time.

Just a silly article about a couple of instances recently where my colleague and I have both been duped by scheduled jobs. The feint and obvious lesson here is to be aware of your surroundings.

MySQLboy @ MySQL Conf 2012 [part 1/2]

The Keynote talks included some words from Peter and Baron of Percona, Martin Mickos now of Eucalyptus Systems and then Brian Aker of HP. I was impressed by the new HP cloud product powered by OpenStack and now with an Aker driven DaaS backed by a tuned Percona Server. It was interesting watching the demo video of creating new instances and also the snapshots of existing instances to create cloned instances. I would like to review this for myself and will now that the HP guys were offering to send beta access to the attendees.

The Empty Error Log

The MySQL errorlog is an important point of reference when administering a MySQL Server. We can grasp much about the state of our MySQL instance by the informational and error messages written out to it by our MySQL daemon. I was asked to investigate some replication outage alerts a colleague had received overnight. One of the primary directions I took was the error log file. This is where I would expect find any evidence of replication being stopped or crashes etc. When I ran the command to tail the log I was shocked to see the log was totally empty.