Ensuring Redundancy for IIS and MySQL Web Hosting Across Two Locations

Other Questions MySQL
1

Hey everyone! I’m trying to set up a fail-safe system for our website. We’ve got two data centers on different coasts, both with the same setup:

  • ESXi hosts running a few virtual machines
  • Veeam for backups and replication
  • IIS web server
  • MySQL database

I want to make sure our site stays up even if one location goes offline. What’s the best way to do this? I’m looking for tips on load balancing, data syncing, and quick failover strategies.

Has anyone tackled a similar setup before? What worked well for you? Any pitfalls to watch out for?

Thanks for any advice you can share! I’m all ears for creative solutions.

2

hey, maybe try a global dns load balancer and setup mysql replication between sites. add a cdn for static files and test your fail over often. latency can be real annoyin sometimes. good luck!