ATC323 Graham Elliott Asia Time Zone Director Global Technical Evangelism and Development Team Microsoft.

Download Report

Transcript ATC323 Graham Elliott Asia Time Zone Director Global Technical Evangelism and Development Team Microsoft. 

ATC323
Graham Elliott
Asia Time Zone Director
Global Technical Evangelism and Development Team
Microsoft
Disaster
Disaster
RTO
Disaster
RTO
Redirect DNS
Fault
Domain
Fault
Domain
Fault
Domain
Geo-Replication*
BACPAC
Custom / 3rd Party
Backup
from DB Copy
BACPAC
from DB Copy
Fault
Domain
Restore
BACPAC
Redeploy
Deployment
Package
Major datacenter
CDN node
Live sub-region
Announced sub-region
Partner-operated sub-region









 Failure detection and FT with single instance.



















Fault
Domain
Fault
Domain
Fault
Domain
Geo-Replication*
BACPAC
from DB Copy
Custom / 3rd Party
Backup
BACPAC
from DB Copy
SQL Data Sync
Fault
Domain
Restore
BACPAC
Fault
Domain
Fault
Domain
Fault
Domain
Custom
Replication or
HA Proxy
Fault
Domain
Fault
Domain
Fault
Domain
Fault
Domain
Custom
Replication or
HA Proxy
Backup to URL / Restore
or Database Mirroring
Fault
Domain
P
S
VM
S
P
VM
• Why?
• Failure detection for SQL
Server not just VM
• Azure service healing
• Azure upgrades
Technology
SQL 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)
S
(DR)
P
• Why?
• If you use multiple disks for
SQL Server
• If Azure storage DR doesn’t
meet your needs
• Freedom to test / execute
DR
Technology
SQL Version
Zero Data Loss
Scope
# Secondaries
Database
Mirroring
SQL Server 2008 R2
SQL Server 2012
Backup to Url
SQL Server 2012
SP1 CU2
Automatic
Failover
Readable
Secondaries
Yes
(High Safety Mode)
DB
1
Yes
(w/ Witness)
No
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
http://channel9.msdn.com/Events/TechEd/Australia/2013
http://www.microsoftvirtualacademy.com/
http://technet.microsoft.com/en-au/
http://msdn.microsoft.com/en-au/