I would say this is an awesome presentation. I rarely see people are prepared like your whole set of live demo and preparation. you deserve a big thumbs up from my side. Started subscribing to you. A great job is done. Thanks a lot.
You manually triggered Failover..!!! in this case the secondary server ( that actually became primary after failover) will still be read only for next 1 hour and would not be able for insert/write requests ? ( as you set 1 hour grace period for R/W while creating Failover group). or immediately it will be available for write queries? need more clarity on this.
Grace Period is the window only post to which the failover will flip the DNS. As Azure currently does not support grace less than hour hence flip for DNS will only action post 1 hr window.
Thanks for comments vipul, if the credentials are not in sync auto failover using failover groups can not be achieved. Azure SQL recommends the same docs.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview#keeping-credentials-and-firewall-rules-in-sync
I would say this is an awesome presentation. I rarely see people are prepared like your whole set of live demo and preparation. you deserve a big thumbs up from my side. Started subscribing to you. A great job is done. Thanks a lot.
Thanks a lot Nawal for kind comments really appreciated 👍
3 yrs on and the automatic Failover Policy grace period is still 1hr minimum, boggles the mind!
Thanks you so much sir.
Great tutorial thanks
Thanks great you liked it
You manually triggered Failover..!!! in this case the secondary server ( that actually became primary after failover) will still be read only for next 1 hour and would not be able for insert/write requests ? ( as you set 1 hour grace period for R/W while creating Failover group).
or immediately it will be available for write queries? need more clarity on this.
Grace Period is the window only post to which the failover will flip the DNS. As Azure currently does not support grace less than hour hence flip for DNS will only action post 1 hr window.
@@techscout7012 After DNS flip it will be available for write queries immediately at the same time?
@@umerazeem7606 yes you are right as soon as failover is is completed you will be all ready to writes on old secondary now primary due to DNS flip
nice!
If primary and secondary DB servers have different username/passwords then which username/password is used to connect when using failover group?
Thanks for comments vipul, if the credentials are not in sync auto failover using failover groups can not be achieved. Azure SQL recommends the same docs.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview#keeping-credentials-and-firewall-rules-in-sync