AWS での SQL Server と WSFC - クイックスタートリファレンスデプロイガイド

1 AWS SQL Server WSFC AWS SQL Server WSFC AWS SQL Server WSFC: Copyright 2019 Amazon Web Services, Inc. and/or its affiliates. All rights 's trademarks and trade dress may not be used in connection with any product or service that is not Amazon's, in any mannerthat is likely to cause confusion among customers, or in any manner that disparages or discredits Amazon. All other trademarks notowned by Amazon are the property of their respective owners, who may or may not be affiliated with, connected to, or sponsored SQL Server WSFC Table of Contents .. 1 .. 2 .. 3 AWS SQL Server 3 .. 3 AWS .. 4 .. 5 .. 9HA 9 .. 9 .. 11 .. 12 WSFC .. 12IP .. 13 WSFC .. 14 Always On .. 15 .. 16 .. 17 1.. 17 2.. 21 3.. 38 4.. 46.

2 50 .. 52 .. 53 .. 54 .. 56iiiAWS SQL Server WSFC AWS SQL Server : Windows Server (WSFC) SQL Server Always On Santiago Cardenas Jay McConnell - 2014 7 ( (p. 55): 2017 8 ) Microsoft Windows Server (WSFC) SQL Server Always On (AWS) AWS CloudFormation NoteAlways On SQL Server Enterprise Edition WSFC AWS AWS WSFC SQL Server IT DevOps SQL Server 2012 2014 2016 Note AWS AWS AWS AWS SQL Server WSFC 1 (p.)

3 5) Virtual Private Cloud (VPC) 3 AWS SQL Server (p. 17) AWS CloudFormation 1 AWS SQL Server WSFC AWS AWS AWS AWS 2 AWS SQL Server WSFC AWS SQL Server WSFC AWS SQL Server WSFC Amazon Elastic Compute Cloud (Amazon EC2) MicrosoftWindows Server SQL Server SQL Server EnterpriseEdition Always On Microsoft SharePoint .NET Framework Microsoft SQL Server Always On Windows Server (WSFC) SQL Server Always On WSFC WSFC AWS AWS WSFC 2 Virtual Private Cloud (VPC) WSFC AWS WSFC SQL Server SQL Server Enterprise Edition 3 : Microsoft SQL Server 2012 2014 2016 Enterprise Edition Amazon (AMI) SQL Server Enterprise Edition SQL : 2014 2016.

4 Microsoft License Mobility through Software Assurance Amazon EC2 SQL Server MSDN AWS MSDN Windows Server 2012 R2 AMI Windows Server AMI 3 AWS SQL Server WSFC AWS AWS AWS CloudFormation Amazon SQL Server AMI AWS AWS AWS AWS (AWS AWS ) Amazon EC2 Amazon Elastic Compute Cloud (Amazon EC2) AMI Amazon EBS - Amazon Elastic Block Store (Amazon EBS) AWS Amazon EC2 Amazon EBS Amazon EBS Amazon VPC - Amazon Virtual Private Cloud (Amazon VPC) AWS AWS IP Windows Server 2012 R2 Windows Server Active Directory DNS Windows Server (WSFC)

5 SQL Server Always On Microsoft 4 AWS SQL Server WSFC VPC AWS 5 AWS SQL Server WSFC 6 AWS SQL Server WSFC 1: AWS WSFC SQL Server ( ) 2 3 7 AWS SQL Server WSFC 8 AWS SQL Server WSFC 2: AWS WSFC SQL Server (3 ) Note VPC AD DS (*) Active Directory Active Directory 2 Virtual Private Cloud (VPC) SQL Server SQL 3 ( 2 ) * * Windows Server (RDGW) (NAT) ( )

6 * NAT RDGW Elastic IP * Active Directory * WSFC Windows Server WSFC SQL Server AlwaysOn SQL Server Enterprise 2 2 2 SQL Server ( 3 (p. 10)) VPC AWS Amazon EC2 AWS 1 WSFC AWS 2 AlwaysOn 2 9 AWS SQL Server WSFC 3.

7 SQL Server AlwaysOn 1 1 2 2 (WSFCNode 2 ) 3 10 AWS SQL Server WSFC 3 AWS AWS Microsoft SQL Server ( ) IT EC2 / IP Microsoft AWS EC2 AD DS Windows Time (DFS) SQL Server WSFC WSFC SQL Active Directory (p.)

8 52) SQL Server Windows Windows TCP 1433 1434 4022 5022 135 11 AWS SQL Server WSFC SQL Server Enterprise EditionSQL Server 2014 2016 Enterprise Edition Amazon (AMI) AWS (p. 3) [Amazon-Provided SQL License] (SQLL icenseProvided) (no) Microsoft SQL Server Enterprise Edition yes SQL Server Enterprise Edition Amazon AMI C:\sqlinstall\ [Run as Administrator] SQL Active Directory sqlsa WSFC NoteAWS Microsoft AWS CloudFormation SQL Server WSFC SQL Server AWS CloudFormation WSFC Amazon Elastic Block Store(Amazon EBS) EBS EC2 EBS IOPS EBS (SSD)

9 I/O R4 Amazon EBS Amazon EC2 Amazon EBS Amazon EBS I/O EC2 EBS WSFC 500 GiB SSD 3 tempdb 12 AWS SQL Server WSFC IP SSD 3 IOPS/GiB SQL Server 1,500 IOPS IOPS IOPS [SQL Server Volume Type] [SQL Server Volume IOPS] IOPS SSD Windows SQL Server EBS 1 SSD (100 GiB) (C :) SQL Server 1 SSD (500 GiB) (D :) SQL Server 1 SSD (500 GiB) (E :) SQL Server tempdb 1 SSD (500 GiB)(F :) 4 SQL Server Z: ( ) EC2 4: WSFC WSFC IP WSFC Always On SQL Server 3 IP 1 IP IP 2 IP WSFC IP 3 IP Always On AWS CloudFormation CIDR 13 AWS SQL Server WSFC WSFC 5.

10 WSFC IP Windows Server Windows Server 2012 AWS CloudFormation 2 PowerShell Install-WindowsFeature failover-clustering -IncludeManagementToolsNew-Cluster -Name WSFC luster1 -Node WSFCNODE1,WSFCNODE2 -StaticAddress , 2 2 IP 3 NodeAndFileShareMajority [Third AZ] [witness] 3 ( ) [Third AZ] [full] 3 3 SQL Server AWS 2 AWS \\WSFCFileServer\witness Active Directory (WSFCNODE1 ) NTFS 14 AWS SQL Server WSFC Always On Set-ClusterQuorum -NodeAndFileShareMajority \\WSFCFileServer\witnessAlways On SQL Server Enterprise Edition Windows Server PowerShell SQL Server Always On ( )