Transcript Cloud OS Workload Mobility PUBLIC PRIVATE HOSTED Usage-Based and Flexible Automated Hybrid and Managed economics usage based automated elastic Managed Hybrid always up. always on.

Cloud OS
Workload
Mobility
PUBLIC
PRIVATE
HOSTED
Usage-Based and Flexible
Automated
Hybrid and Managed
economics
usage based
automated
elastic
Managed
Hybrid
always up.
always on.
Looking for more on SP? MDC-B213
Windows Azure
Your Data Center
Looking for more on DR? MDC-B371
<subnet 1>
<subnet 2>
<subnet 3>
DNS
Server
On-premises
WA
Gateway
Hardware VPN or
Windows RRAS
Your datacenter
Virtual Network
Looking for more on Virtual Networks? MDC-B360
• Windows Server
New: Software based
VPN gateway
• Routing and
Remote Access
Service (RRAS)
Generic VPN devices
must support
• IKE v1, IKE v2
• AES 128, 256
• SHA1, SHA2
Looking for more on Point-to-site? MDC-B360 and MDC-B370
<subnet 1>
<subnet 2>
<subnet 3>
DNS
Server
On-premises
WA
Gateway
Hardware VPN or
Windows RRAS
Your datacenter
Individual
computers behind
corporate firewall
Virtual Network
IaaS and PaaS together
Pay by the minute
VMs Stops/Payment Stops
MSDN agility
Looking for more on Dev/Test? MDC-B370
MSDN products can be used
on Virtual Machines
Single monetary credit
instead of plethora of meters
Focusing on Dev/Test Usage
Configure SQL Server HA on IaaS
• Failure detection for SQL Server
• Failover takes seconds
P
S
VM
S
P
VM
Technology
SQL Server Version
Zero Data Loss
Scope
# Secondaries
Automatic
Failover
Readable
Secondaries
Availability
Groups
SQL Server 2012
Yes
(Sync Mode)
DB(s)
4
Yes
(w/ additional
cluster
member)
Yes
Database
Mirroring
SQL Server 2008 R2
SQL Server 2012
Yes
(High Safety Mode)
DB
1
Yes
(w/ Witness)
Limited
(database
snapshots)
Availability Groups
Availability Group Listeners
Provision VMs (primary, secondary, cluster member / witness)
Configure SQL Server technology
•
Gotcha:
Workaround
CreateAzureFailoverCluster script
http://gallery.technet.microsoft.com/scriptcenter/Create-WSFC-Cluster-for-7c207d3a
http://msdn.microsoft.com/en-us/library/jj870963.aspx
http://blogs.msdn.com/b/sqlalwayson/archive/2013/01/23/test-lab-create-an-alwaysonavailability-group-in-windows-azure-end-to-end.aspx
Configure SQL Server technology
http://msdn.microsoft.com/en-us/library/jj870961.aspx
Deployments may be inverted
Technology
SQL Server Version
Zero Data Loss
Scope
# Secondaries
Automatic
Failover
Readable
Secondaries
Availability
Groups
SQL Server 2012
Yes*
(Sync Mode)
DB(s)
4
Yes
(w/ additional
cluster
member)**
Yes
Database
Mirroring
SQL Server 2008 R2
SQL Server 2012
Yes*
(High Safety Mode)
DB
1
Yes
(w/ Witness)**
Limited
(database
snapshots)
Log
Shipping
SQL Server 2008 R2
SQL Server 2012
No
DB
N
No
Limited
(standby state)
* Most customers use Async Mode (High Performance) to avoid impacting primary performance
**Async Mode only supports Force Failover to make DR (and potential data loss) a conscious decision
Availability Groups
https://www.windowsazure.com/en-us/manage/services/networking/cross-premises-connectivity/
http://msdn.microsoft.com/en-us/library/jj870959.aspx
http://msdn.microsoft.com/en-us/library/jj870964.aspx
http://msdn.microsoft.com/en-us/library/jj889442.aspx
redmond.corp.microsoft.com
Availability Group
uswest.internal.cloudapp.net
Virtual
Network
All machines in same Windows Cluster
S
(DR)
P
Technology
SQL Server Version
Zero Data Loss
Scope
# Secondaries
Automatic
Failover
Readable
Secondaries
Database
Mirroring
SQL Server 2008 R2
SQL Server 2012
Yes
(High Safety Mode)
DB
1
Yes
(w/ Witness)
No
Backup to Url
SQL Server 2012
SP1 CU2
No
DB
N/A
No
No
* Most customers use Async Mode (High Performance) to avoid impacting primary performance
**Async Mode only supports Force Failover to make DR (and potential data loss) a conscious decision
Availability Groups
Database Mirroring
http://msdn.microsoft.com/en-us/library/jj870960.aspx
Windows Cluster
Availability Group
PRIMARY
On-Premises
SECONDARY
Windows Cluster
Availability Group
PRIMARY
On-Premises
SECONDARY
SECONDARY
Cloud
Windows Cluster
PRIMARY
Cloud
SECONDARY
Windows Cluster
Availability Group
PRIMARY
Cloud
SECONDARY
SECONDARY
On-Premises
Windows Cluster
Availability Group
PRIMARY
Cloud
SECONDARY
SECONDARY
On-Premises
http://msdn.microsoft.com/en-us/library/jj870962.aspx
https://www.windowsazure.com/en-us/manage/services/networking/create-a-virtual-network/
https://www.windowsazure.com/en-us/manage/services/networking/cross-premises-connectivity/
http://www.windowsazure.com/en-us/manage/services/networking/active-directory-forest/
Windows
Azure
mva
http://channel9.msdn.com/Events/TechEd
www.microsoft.com/learning
http://microsoft.com/technet
http://microsoft.com/msdn