SQL Server on EC2 and FSx maintenance

0

For SQL Server running on EC2 and using FSx, when the FSx maintenance window happens, will there be an interruption to SQL Server ? Do the databases become disconnected?

AWS
已提問 4 年前檢視次數 511 次
1 個回答
1
已接受的答案

Short answer: There will be no database interruption for SQL Server Always On deployments in the event of file system failover/failback as long as you're using continuously available (CA) shares on Amazon FSx multi-AZ file systems. https://docs.aws.amazon.com/fsx/latest/WindowsGuide/sql-server.html

Details: With file shares configured as CA on multi-AZ file systems, server applications like SQL Server will get uninterrupted access to the file share even in the event of a failover/failback (by transparently reconnecting to another file server node without interruption of the server applications). These server applications expect their storage to reliable and always available and they do not generally handle IO errors or unexpected closures of handles very well. If the server application cannot access its storage this often leads to databases going offline or virtual machines stopping or crashing because they can no longer write to their disk. This is why Amazon FSx supports SMB CA shares (aka SMB Transparent Failover) as one of the key features on multi-AZ file systems.

AWS
已回答 4 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南