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?

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년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인