We have recently decided to set up a mirror of our site on a second server in the event of an outage on server #1 and I was looking for some assistance and clarification on the best practices for this...really dumb it down
As I understand it what should be done is DNS2 should be set to the ip address of the site on server #2. If DNS1 times out, DNS2 kicks in and the user would end up at server #2. Is that correct?
If server #1 comes back online will users that are on server #2 be directed back there on a page change?
We use a mysql database to keep customer records, if they end up on server #2 how can we synch up with server #1? For example there are several auto increment fields.
Any input on this would be great, thanks in advance.