title: MySQL/Apache redundant server setup
body: <p>I am going to buy two servers shortly which will be exact copies of each other in terms of hardware, software and WAMP setup.</p>
  
  <p>I would like to give my users maximum up-time by having one of the servers as a live backup of the other one.</p>
  
  <p>That is, when the main server fails for whatever reason, all traffic is routed to the backup so users don't notice a thing. When the main server comes back up, any new data that went into the database on the backup server is copied over to the main one.</p>
  
  <p>How can I achieve this without having any inconsistencies with the data? Up-time and data integrity are vital.</p>