Disable anything that will write to the database Update the my.cnf files for all servers to support circular replication, by adding log-slave-updates and ensuring you have unique server ids and the auto increment values are suitable. Then restart mysql to pick up the config changes. Ensure your existing replication is up-to-date using: SHOW SLAVE STATUS Stop replication on both existing servers using STOP SLAVE Create a backup of the database from the server that will be just before your new server in the circle using: mysqldump --master-data=1 -a -c -Q {db} > {filename} Add the userids for replication to your new server.

For a while I’ve been following the updates on a new plugin for Wordpress - Artsy Editor which gives you a completely clean page in which to write your post with easy access to the formatting options through a popup which appears intelligently when you select text, as seen in the image above. You can also drag an image into the editor to upload and insert it where you are typing.

Here’s a few articles I’ve read recently that are helpful and challenging: In Reminders Are More Effective Than Rebukes, Tullian Tchividjian reminds us of the need as Christians to regularly remind each other of who we are in Christ, rather than focusing on our sin and that we re-focus on Jesus for “because of Christ’s work on your behalf, God does not dwell on your sin the way you do”

I need to be told by those around me that every time I sin I’m momentarily suffering from an identity crisis: forgetting who I _actually_ belong to, what I _really_ want at my remade core, and all that is_ already_ mine in Christ. Tullian Tchividjian - Reminders are more effective than rebukes

ORDER BY SUBSTRING_INDEX(full_name, ' ', -1)

Drawn in pencil, photographed with iPhone - post processed in Camera+ and Iris.

So to celebrate my 30th, with thanks to my mum, here’s 30 photos of me, one for each year:

For a while, I’ve been wondering about putting together a different kind of audio bible, one with a different person reading each chapter, but I didn’t get very far with it - so I’ve decided to test this out and collect recordings of the first 30 psalms for my 30th birthday. So please could you record me a psalm for my birthday? Reserve your psalm in the comments below and then you can either post a link to the recording or email me the file ( ricky at this domain).

New systems bar for HostDB shows the number of systems with actions required and has quick links to recent system records viewed.