zero-down is an example implementation of zero downtime approaches to upgrading database driven applications.
Requirements
MySQL - for the application database HAProxy - Load balancer used to demonstrate zero downtime
I wrote a short blog article on the topic http://www.grahambrooks.com/blog/zero-down-time-relational-databases/