How can Azure notify me when my primary database becomes unavailable? -
I have an active geo-replication setup for the primary SQL Ezur database. How can i be informed that database issues Due to my primary data is not available, can I start our application failover process? Also, how does traffic manager notify failure events?
On most mass outs, your application connectivity will be affected so it is possible that An application will appear as a warning. So your real question is, what else do you want to check to make sure that this is a real accident and the failure of the failover. The answer to that question depends on how your failover process is setup. If it involves a human step, eg Someone has to accept the failure due to its effect, you may want to check the alert in the portal. If this is an incidental warning of a regional level other than an event alert, then you will see your logical server marked as degraded.
If you want to install a fully automated process, you want to check the replication connectivity status. You can do the sys.dm_database_copies query on the targeted master or by the target code You can query sys.dm_continuous_copy_status on. Uncover both is_interlink_connected , which will tell you that the replication link is unhealthy, note that it monitors the health of the overall replication channel, not your specific replication link. If the application receives repeated repetition of time limits and is_interlink_connected = 0 indicates that the outage is possible but it is not 100% guaranteed and false positives are still possible. Your application target RTO can help you decide how long you can wait for the failover firmly before (how to eliminate false positives).
The last question is again, to make sure that there is a real warning. You may have to choose the last point position in your profile.
Comments
Post a Comment