Azure SQL Virtual Machines Reimagined: Simplify HA & DR configuration (Ep.5) | Data Exposed Live
3.6 هزار بار بازدید -
3 سال پیش
-
In part five of the
In part five of the Azure SQL Virtual Machine Reimagined series, we will a do deep dive of HA & DR technologies for Azure SQL VMs. We'll cover how to simplify HA & DR configuration by adopting multi subnet approach and thus eliminating the need for an Azure Load Balancer. Multi subnet configuration is natively supported by SQL Server and Windows Server Failover Cluster and simplifies deployment, maintenance and improves failover time.
0:00 Stream begins
1:16 Introductions
3:08 SQL VM HA & DR Overview
26:30 Simplify HR & DR configuration
32:20 Demo: Secondary IP, Add Secondary IP
34:10 Multi subnet configuration - steps involved
36:48 Demo: Windows cluster, AG resources in cluster, AG & AG Listener in SSMS, Test connectivity from client, Test failover, Test connectivity from client
48:50 Demo: Zone Redundant Shared disk, Windows cluster, SQL FCI resources in cluster, Test connectivity from client, Failover in cluster, Test connectivity from client
56:00 Comparing available HA DR configurations
✔️Resources:
SQL Server on Azure VM documentation: https://docs.microsoft.com/en-us/azur...
📝 Azure SQL Virtual Machine Reimagined Series playlist: https://aka.ms/azuresqlvmyt
📌 Let's connect:
Twitter: Pam Lahoud, Twitter: SQLGoddess
Twitter: Rajesh Setlem, Twitter: RajeshSetlem
Twitter: Anna Hoffman, Twitter: AnalyticAnna
Twitter: AzureSQL, https://aka.ms/azuresqltw
🔴 To check out even more Data Exposed Live episodes, see our playlist: https://aka.ms/dataexposedlive
🔔 Subscribe to our channels for even more SQL tips: https://aka.ms/msazuresqlyt
✏️ If you are interested in finding out about Reactor sessions please check out our Reactor meetup page or sign up for our monthly newsletter:
https://aka.ms/MicrosoftReactorMeetup
https://aka.ms/ReactorEmailSignUp
#AzureSQL #AzureSQLVM #AzureSQLVirtualMachine
0:00 Stream begins
1:16 Introductions
3:08 SQL VM HA & DR Overview
26:30 Simplify HR & DR configuration
32:20 Demo: Secondary IP, Add Secondary IP
34:10 Multi subnet configuration - steps involved
36:48 Demo: Windows cluster, AG resources in cluster, AG & AG Listener in SSMS, Test connectivity from client, Test failover, Test connectivity from client
48:50 Demo: Zone Redundant Shared disk, Windows cluster, SQL FCI resources in cluster, Test connectivity from client, Failover in cluster, Test connectivity from client
56:00 Comparing available HA DR configurations
✔️Resources:
SQL Server on Azure VM documentation: https://docs.microsoft.com/en-us/azur...
📝 Azure SQL Virtual Machine Reimagined Series playlist: https://aka.ms/azuresqlvmyt
📌 Let's connect:
Twitter: Pam Lahoud, Twitter: SQLGoddess
Twitter: Rajesh Setlem, Twitter: RajeshSetlem
Twitter: Anna Hoffman, Twitter: AnalyticAnna
Twitter: AzureSQL, https://aka.ms/azuresqltw
🔴 To check out even more Data Exposed Live episodes, see our playlist: https://aka.ms/dataexposedlive
🔔 Subscribe to our channels for even more SQL tips: https://aka.ms/msazuresqlyt
✏️ If you are interested in finding out about Reactor sessions please check out our Reactor meetup page or sign up for our monthly newsletter:
https://aka.ms/MicrosoftReactorMeetup
https://aka.ms/ReactorEmailSignUp
#AzureSQL #AzureSQLVM #AzureSQLVirtualMachine
3 سال پیش
در تاریخ 1400/08/05 منتشر شده
است.
3,683
بـار بازدید شده