When deploying, I am attempting to automate my redundancy system as much as possible. So I a
have two complete installs of my project on two servers. Only one is actually used via domain names. The other is hot standby. Both should normally be configured to use same mysql db. All I have to do, in the case of server problem, is to change domain pointing.
The db redundancy is a bit trickier… as I have a periodic shadow copy of the DB made using cron, and that backup loaded into a standby db. ( i know i could use mysql replication for near realtime, but not worth hassles right now). What I want to do is have a script that I could run that would save me from have to hit the manual production settings. I could then change either the production or standby install to use the primary or standby DB.
Anyone doing anything similar?