Windows Server 2016 Technical Preview 4 Cluster Build and SQL Server Installation – standalone SQL installs with Storage Replica,floating IP and manual failoverPosted: January 12, 2016
Following on from the previious attempt at Windows Server 2016 Storage Replica with Cluster Shared Volumes which did not work completely I tried a manual approach.
I did not give up, what if we do not use Windows Clustering but do all the steps manually?
This is 2 standalone SQL Servers both installed with data on the F: drive and then Storage Replica used to keep them in sync.
– add a DNS entry and a floating IP address
– manually setup Storage Replica
– manually handle stopping/starting services, failing over/back the Storage Replica and moving the floating IP
does it work?
The answer is yes-ish if you are careful and ignore the warning about data loss!
There does not seem to be an option to failover (Set-SRPartnership) synchronously to guarantee no data loss!
Also we could do with an option to validate everything is in sync or resync even if we would have to suspend writes to allow this.
Windows Server 2016 Technical Preview 4 Cluster Build and SQL Server Installation – standalone SQL installs with Storage Replica,floating IP and manual failover
Powershell to manage Storage Replicas
Get-Module -ListAvailable : List available modules
Get-Module : List modules loaded
Get-Module | ft Version,Name
Version Name ------- ---- 18.104.22.168 Microsoft.PowerShell.Management 22.214.171.124 Microsoft.PowerShell.Utility 1.1 PSReadline 1.0 StorageReplica
Get-Command -Module StorageReplica | ft CommandType,Name
CommandType Name ----------- ---- Function Clear-SRMetadata Function Export-SRConfiguration Function Get-SRDelegation Function Get-SRGroup Function Get-SRPartnership Function Grant-SRAccess Function Grant-SRDelegation Function New-SRGroup Function New-SRPartnership Function Remove-SRGroup Function Remove-SRPartnership Function Revoke-SRDelegation Function Set-SRGroup Function Set-SRPartnership Function Suspend-SRGroup Function Sync-SRGroup Cmdlet Test-SRTopology
I have been playing with SQL Server Clustering (FCI) setup with a Widnows Server 2016 Preview 4 and Windows Storage Replica.
This involves local storage and Cluster Shared Volume with Replication Enabled.
This is incomplete – if Node 1 goes offline the SQL Server role fails!