The service fully supports continuously available shares, a feature that permits SQL Server uninterrupted access to shared file data. Amazon FSx provides high availability with automatic failure detection and automatic failover if there are any hardware or storage issues. With Amazon FSx, you get a fully managed and shared file storage solution, that automatically replicates the underlying storage synchronously across multiple Availability Zones. You can build the VPC peering or AWS Transit Gateway to have seamless connectivity between the two Regions for the opened ports (SQL Server, SMB for file share, and others.) Or it can have an identical configuration to Region 1, but with different hostnames, and an SQL network name (SQLFCI02) to avoid possible collisions. The primary cluster in Region 1 is initially configured with SQL Server failover cluster instance (FCI) using Amazon FSx for its shared storage. Region 2 can have a standalone Amazon EC2 server with SQL Server and Amazon Elastic Block Store (EBS) as storage. Log shipping DR solution for SQL Server FCI with Amazon FSxįigure 1 shows an SQL cluster in Region 1 and standalone SQL cluster in Region 2. This will also serve as the reference architecture for our solution.įigure 1. It uses a log shipping feature for replication and DR. It uses a standalone or a similar setup on Region 2. The architecture diagram in Figure 1 depicts SQL Server failover cluster instance (FCI) using Amazon FSx as storage (multiple Availability Zones) in Region 1. Log shipping DR solution for SQL Server FCI with Amazon FSx You don’t need the SQL Server version to be the same for source and destination instances. There’s no need for clustering setup at the OS level.It lowers total cost of ownership (TCO) as you only need one SQL Server Standard edition license at the primary/DR site.Log shipping works with SQL Server Standard edition.Here are some advantages of using log shipping versus Always On distributed availability group DR setup. We’ll explain the architecture patterns so you can follow along and effectively design a highly available SQL Server deployment that spans two or more AWS Regions. We describe how to set up a multi-Region DR using log shipping. This blog post explores SQL Server DR architecture using SQL Server failover cluster with Amazon FSx for Windows File Server for the primary site and secondary DR site. A multi-Region architecture for Microsoft SQL Server is often adopted for SQL Server deployments for business continuity (disaster recovery) and improved latency (for a geographically distributed customer base). It has less maintenance overhead, doesn’t introduce latency, and meets RPO/RTO requirements. Snapshots have additional overhead and may breach their stringent recovery point objective/recovery time objective (RPO/RTO) requirements.Ī log shipping solution can take advantage of cross-Region replication of data using Amazon FSx for Windows File Server. It can cause latency issues when synchronously replicating data cross-Region. Solutions such as Always On can be a more expensive, complex configuration across Regions. We’re showcasing women in the industry who are building, creating, and, above all, inspiring, empowering, and encouraging everyone-especially women and girls-in tech.Ĭompanies choosing to rehost their on-premises SQL Server workloads to AWS can face challenges with setting up their disaster recovery (DR) strategy. For International Women’s Day and Women’s History Month, we’re featuring more than a week’s worth of posts that highlight female builders and leaders.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |