10/10/10 10:10
10/10/10 10:10 - where I was:
Blog
Review: Surprised by Grace
Surprised by Grace: God's Relentless Pursuit of Rebels by Tullian Tchividjian
My rating: 5 of 5 stars
Very clear and challenging look at the book of Jonah, showing us that the gospel is not just for those who haven't yet heard it but something that we as Christians need to keep coming back to. The book of Jonah points us to God and how he deals with Jonah's rebellion and ultimately our own rebellion.
MySQL Locking
After experimenting a bit with MySQL locking today, I thought I'd make a note of what I'd discovered:
To create a lock, you need to use:
<code>LOCK TABLES table1 [READ |WRITE], table2 [READ |WRITE]</code>
READ is used to stop other people changing the table while you read from it. WRITE is used to stop other people reading the table while you write to it.
Once you have issued a LOCK TABLES statement, you will not have access to any tables you didn't include.
When you have finished, you can issue the UNLOCK TABLES command.
The lock remains until you issue the UNLOCK TABLES command, your session ends, you start a transaction or your client is disconnected.
The MySQL locking mechanism is no use if you need to lock something between PHP requests, unless you have a separate process running persistently to maintain the connection to the database.
Jonah Header
Our new Momentum devotional series on Jonah started today - here's a glimpse of my header design.
Recover from "Failed to open the relay log"
If you find that after rebooting your MySQL slave it stops replicating with the master and you see the "Failed to open the relay log" error in the logs it is probably caused by MySQL putting it's relay logs in /var/run by default, which gets cleared out on boot.
To fix this, you need to change the location MySQL uses for the logging by adding the following line to the [mysqld] section of /etc/my.cnf
relay-log = /var/lib/mysql/relay-bin
Then edit /var/lib/mysql/relay-log.info to point to the first new relay log (leaving the master information the same.
/var/lib/mysql/relay-bin.000001 1 mysql-bin.12345 123456789
Then from the mysql prompt start the slave:
mysql> START SLAVE;
(Source: Arjen's Journal)
Drawing of me
Abi drew this for me. She says I'm not a monster, I just have my teeth out!
Self portrait
A traced picture on my iPhone, styled and touched up a bit for my twitter avatar and if you look closely, you can find it on my blog too... I'm really liking Adobe Ideas for quick sketches, so there might well be more pictures of family and friends coming soon!
Monster #2
Same as #1 this was sketched in Adobe Ideas and finished in Sumo paint. I will give them names eventually, but for now Abi wants to call this one "princess bird"
Monster #1
This is Monster #1, his outline was drawn in Adobe Ideas on the iPhone, and then the colouring was added using Sumo Paint
Walking on water and developing software from a specification are easy if both are frozen.
Walking on water and developing software from a specification are easy if both are frozen.