Transcript Business Continuity Solutions for SQL Database

Physical security
Geo distribution
Platform security
Compliance
Single Logical
Database
Multiple Physical
Replicas
DB
Ack
Value Read
Write
P
Ack
S
Write
Ack
Write
S
Reads are completed at the primary
Writes are replicated to secondaries
Each replica is backed up independently
Primary Manager Node
Partition Manager
Promote to primary
Global
Partition
Map
Which
replica
lost?
Node down
Reconfigure
Data Node
101
P
S
P
S
Data Node
102
P
S
S
S
Fabric
Data Node
103
Data Node
104
P
S
S
S
P
S
S
Data Node
105
P
S
S
S
No additional administration cost
ACID properties are maintained by the system
Failovers are fully automated
Dynamic routing of connections
No additional charges for database redundancy
RPO=0, RTO=30sec
99.9% availability SLA
Azure
DNS
End
user
Hostname
IP Address
www.contoso.com
North Central US
App
admin
South Central US
DB_MAIN
DB_MAIN_OLD
DBCopy
Contoso
service
DB_06_11_2012
DB_06_12_2012
DB_06_13_2012
DB_MAIN
Minimal charge is prorated day
ALTER DATABASE DB_MAIN
use
MODIFY NAME = DB_MAIN_OLD
GOCopies entire database
You are responsible
for retention
WAITFOR
DELAY '00:00:30'
GOand cleanup
ALTER
DATABASE
Support
databaseDB_06_01_2012
federations is
MODIFY
comingNAME
soon = DB_MAIN
GORTO = time to recognize the error
+ time to rename the database +
rename delays
South Central US
DB_MAIN
DBCopy
Contoso
service
BP_06_11_2012
BP_06_12_2012
BP_06_13_2012
DB_06_01_2012
Leverages import/export service and
Azure storage
Reduces storage cost but increases
backup time
More complex backup/restore
workflow
RTO = time to recognize the error +
time to import database + time to
rename the database
Azure
DNS
Hostname
IP Address
www.contoso.com
North
CentralUS
US
South Central
End
user
App
admin
DNS update
Contoso
V1
(primary
instance)
DBCopy
Copies entire database
South Central US
You are responsible for cleanup
Minimal database charge
is prorated
DB_MAIN
day use
Support for database federations is
coming soon
RTO = time to import +DB_06_11_2012
time to start
DB_06_12_2012
app + DNS change
DB_06_13_2012
RPO = export interval
Activate and verify
application
North Central US
BP_06_11_2012
Contoso V1
(secondary
instance)
BP_06_12_2012
BP_06_13_2012
DB_MAIN
South Central US
BP_06_11_2012
DBCopy
Contoso
V1
(primary
instance)
DB_06_01_2012
DB_05_25_2012
DB_05_18_2012
BP_06_12_2012
BP_06_13_2012
North Central US
BP_06_11_2012
BP_06_12_2012
BP_06_13_2012
Azure storage RT (24 hrs)
Extends replica creation and data
synchronization to geo
User initiated
Automatic data replication and
synchronization
Optional RPO enforcement
Read-only geo-secondary
Multiple geo-secondaries
User-controlled failover
Roadmap: Point in time recovery
Roadmap: Point in time recovery
SQL Server 2012
Eval Copy
Hands-On Labs
mva
Get Certified!
@sqlserver
@ms_teched
http://msdn.microsoft.com/en-us/library/windowsazure/hh852669.aspx
http://msdn.microsoft.com/en-us/library/windowsazure/hh873027.aspx
http://social.technet.microsoft.com/wiki/contents/articles/1695.inside-sqlazure.aspx
http://dacguy.wordpress.com/
AZR203 Business Continuity in the Windows Azure Cloud
AZR204 Hybrid Will Rule: Options to Connect, Extend and Integrate
Applications in Your Data Center and Windows Azure
mva
http://northamerica.msteched.com
www.microsoft.com/learning
http://microsoft.com/technet
http://microsoft.com/msdn