There are many good things in the upcoming MySQL 5.6 release. One
thing that caught my eye early on was the ability to start the
server with InnoDB set to a read only mode.
A few months ago Todd Farmer wrote about this ability from the perspective of setting up an instance on read-only media (InnoDB now works with read-only media). And I encourage you to read that post first.
I decided to test this from a data warehouse perspective (as Sunny Bains points out in a comment to Todd's post). I used machines I have …