Introducing automated failover for private workloads using Cloud DNS routing policies with health checks