Recovering From a Failed Database Migration in Production

You deploy your latest release. The deployment log is scrolling through your hooks, and then you see it: SQLSTATE[42S21]: Column already exists or worse, the migration runs halfway through and the process times out. Your database is now in a partiall...