SQL Server Installation on S2D: Step by Step
This video demonstrates how S2D can be created in your lab environment and how you can enable S2D and install SQL Server on a Windows Cluster.
======================================================
1. Create two VirtualBox VM with 30 GB of storage:
WMNODE088
WMNODE099
2. Enable Hyper-V
3. Install Windows Server 2016
4. Disable Firewall
5. Set the network to use the DNS server.
6. Add both the VMs to Active directory ABC.com
======================================================
7. Enable Hyper-V in VirtualBoxes
Enable-WindowsOptionalFeature -Online -FeatureName Microsoft-Hyper-V -All -NoRestart
8. Install Windows features
Install-WindowsFeature -Name "Hyper-V", "Failover-Clustering", "Data-Center-Bridging", "RSAT-Clustering-PowerShell", "Hyper-V-PowerShell", "FS-FileServer"
9. Check the storage
Fill in these variables with your values
$ServerList = "localhost"
Invoke-Command ($ServerList) {
Update-StorageProviderCache
Get-StoragePool | ? IsPrimordial -eq $false | Set-StoragePool -IsReadOnly:$false -ErrorAction SilentlyContinue
Get-StoragePool | ? IsPrimordial -eq $false | Get-VirtualDisk | Remove-VirtualDisk -Confirm:$false -ErrorAction SilentlyContinue
Get-StoragePool | ? IsPrimordial -eq $false | Remove-StoragePool -Confirm:$false -ErrorAction SilentlyContinue
Get-PhysicalDisk | Reset-PhysicalDisk -ErrorAction SilentlyContinue
Get-Disk | ? Number -ne $null | ? IsBoot -ne $true | ? IsSystem -ne $true | ? PartitionStyle -ne RAW | % {
$_ | Set-Disk -isoffline:$false
$_ | Set-Disk -isreadonly:$false
$_ | Clear-Disk -RemoveData -RemoveOEM -Confirm:$false
$_ | Set-Disk -isreadonly:$true
$_ | Set-Disk -isoffline:$true
}
Get-Disk | Where Number -Ne $Null | Where IsBoot -Ne $True | Where IsSystem -Ne $True | Where PartitionStyle -Eq RAW | Group -NoElement -Property FriendlyName
} | Sort -Property PsComputerName, Count
======================================================
10. Validate Cluster
Test-Cluster –Node "WMNODE98", "WMNODE99" –Include "Storage Spaces Direct", "Inventory", "Network", "System Configuration"
11. Create cluster
New-Cluster –Name WMCLUSTEST –Node WMNODE98, WMNODE99 -StaticAddress 10.80.3.101 –NoStorage
12. Install cluster administration tools
13. Enable Storage spaces direct
Enable-ClusterStorageSpacesDirect –CimSession WMCLUSTEST
14. Create a Volume
New-Volume -FriendlyName "DataDisk" -FileSystem CSVFS_ReFS -StoragePoolFriendlyName S2D* -Size 5GB
15. Enable Quorum in cluster using a shared location
16. Validate cluster again
Test-Cluster –Node "WMNODE98", "WMNODE99" –Include "Storage Spaces Direct", "Inventory", "Network", "System Configuration"
17. Install SQL server on the same volume.
18. Add node to SQL Server cluster
======================================================
DISCLAIMER:
This video is for learning purpose only. This demo is not to show the disk performance or best practices. This is a long road and there are so many concepts, this is just a basic demo so that you can create S2D in your laptop or desktop and learn.
Смотрите видео SQL Server Installation on S2D: Step by Step онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Coding Studio 03 Июнь 2019, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 932 раз и оно понравилось 9 людям.