Testing App Cloud Readiness for Failover Resiliency with SQL Managed Instance

In this episode with Dani Ljepava, we will show you how to manually trigger a planned failover on SQL Managed Instance to test your applications for fault tolerance and will talk about best practices for your applications to achieve tolerance to transient faults typical for the cloud environments. Transient faults in the cloud (for example software patching, security updates, failover, and similar) include a momentary loss of network connectivity, temporary unavailability of a service, or timeouts when service is busy. These faults are often self-correcting due to which your applications need to be able to handle such occurrences with the appropriate retry logic. While migrating legacy apps to the cloud or developing new cloud-born apps, it is strongly advised to ensure that your applications follow the best practices disclosed in this episode helping you build cloud-ready apps.

[00:46]​ About Dani Ljepava
[01:30]​ Transient errors in the cloud
[02:50]​ Cloud Ready Apps
[04:07]​ Understanding failover as part of HA on SQL MI
[06:00]​ Demo: User-initiated failover on SQL Managed Instance
[11:35] How to check if failovers occurred
[12:35]​ Best practices

User-initiated manual failover on SQL Managed Instance