Azure的怎么能通知我，当我的主数据库变得不可用？ [英] How can Azure notify me when my primary database becomes unavailable?

问题描述

我已经设置了地理复制了我的主要的Sql Azure数据库。
我怎样才能得到通知，我的主数据库不可用，因为数据中心的问题，这样我就可以开始我们的应用程序故障转移手续？此外，如何Traffic Manager的通知故障事件？

I have setup Active Geo-Replication for my primary Sql Azure database. How can I be notified that my primary database is unavailable due to datacenter issues so I can begin our application failover procedure? Also, how does Traffic Manager notify failover events?

推荐答案

对于大多数大规模停运您的应用程序的连接将受到影响这么presumably将表面某种类型的应用程序警报。所以你真正的问题是你需要检查，以确保这是一个真正的灾难和故障切换是必要的什么。该问题的答案取决于你的故障转移过程是如何设置。如果涉及到人类的步骤，例如有人有权批准故障转移，因为它的影响，你可能要检查的警报在门户中。如果是除事故区域尺度的重大事故提醒你会看到你的逻辑服务器标记为降级。

With most large scale outages your application connectivity will be impacted so presumably it will surface as an application alert of some sort. So your real question is what else do you need to check to make sure this is a real disaster and the failover is warranted. The answer to that question depends on how your failover process is setup. If it involves a human step, e.g. somebody has to approve the failover because of its impact, you may want to check the alerts in the portal. If it is a major incident of a regional scale in addition to an incident alert you will see your logical server marked as degraded.

如果您湾设置一个完全自动化的过程，接到申请后，警报，你可能要检查复制连接状态。您可以通过查询 sys.dm_database_copies DMV目标数据库上的目标主机或 sys.dm_continuous_copy_status 做到这一点。这两个揭露 is_interlink_connected ，这将告诉你，如果复制链接是不健康的。注意它监视整个复制渠道的健康，不只是你的特定复制链接。如果应用程序从主接收重复超时和 is_interlink_connected = 0 它表明一个中断是可能的。但它不是100％的保证，误报仍然是可能的。您的应用程序的目标RTO应该帮助你决定​​多久，你可以强制故障转移（作为一种方法来消除误报）前等待。

If you wan to setup a fully automated process, after receiving an application alert you may want to check the replication connectivity status. You can do that by querying sys.dm_database_copies DMV on the target master or sys.dm_continuous_copy_status on the target database. Both expose is_interlink_connected, which will tell you if the replication link is unhealthy. Note it monitors the overall replication channel's health, not just your specific replication link. If the application receives repeated timeouts from the primary and is_interlink_connected=0 it suggests a outage is likely. But it is not a 100% guarantee and false positives are still possible. Your application target RTO should help you decide how long you can wait before forcing the failover (as a way to eliminate false positives).

重新最后一个问题，有一些信息的再监测方法的此处
我不知道有一个实际的警报。您可能需要轮询您的个人资料终点状态。

Re the last question, there is some information re the monitoring methods here I am not sure there is an actual alert. You may have to poll the end point status in your profile.

这篇关于Azure的怎么能通知我，当我的主数据库变得不可用？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！