Transcript > > > > > > > > > > > > > > > > L Applications use standard SQL client libraries: ODBC, ADO.Net, PHP, … Application Internet Azure Cloud TDS (tcp) Security Boundary LB Load balancer forwards ‘sticky’ sessions to TDS protocol tier TDS (tcp) Gateway Gateway Gateway Gateway Gateway Gateway Gateway:

>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
L
Applications use standard SQL
client libraries: ODBC,
ADO.Net, PHP, …
Application
Internet
Azure
Cloud
TDS (tcp)
Security Boundary
LB
Load balancer forwards ‘sticky’
sessions to TDS protocol tier
TDS (tcp)
Gateway
Gateway
Gateway
Gateway
Gateway
Gateway
Gateway: TDS protocol gateway, enforces AUTHN/AUTHZ policy; proxy to CloudDB
TDS (tcp)
SQL
SQL
SQL
SQL
Scalability and Availability: Fabric, Failover, Replication, and Load balancing
>
>
>
>
>
>
>
L
Gateway Process
AdminSvc
Endpoint
TDS Endpoint
Provisioning Endpoint
Protocol Parser
Business Logic Services
Connection Mgmt
SQL
SQL
SQL
SQL
Scalability and Availability: Fabric, Failover, Replication, and Load balancing
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
Live DNS Cluster
Customer
Browser
Live DNS Svc
1
Datacenter (Sub-Region)
Portal LB
2
4
5
Gateway LB
3
6
Front-end Node
Front-end Node
Front-end Node
Front-end Node
Admin Portal
Admin Portal
Gateway
Gateway
7
Backend Node
SQL Server
Fabric
Mgmt.
Services
Backend Node
SQL Server
Fabric
Mgmt.
Services
Backend Node
SQL Server
Fabric
Mgmt.
Services
>
>
>
>
>
>
>
1
TDS Gateway
Front-end Node
TDS Session
Protocol Parser
2
3
Gateway Logic
Master Cluster
Master Node
4
7
5
8
Master Node
Components
6
Backend Node 1
Backend Node 2
Backend Node 3
SQL Instance
SQL DB
SQL Instance
SQL DB
SQL Instance
SQL DB
Scalability
Availability:
Fabric,Failover,
Failover, Replication,
andand
LoadLoad
balancing
Scalability
and and
Availability:
Fabric,
Replication,
balancing
>
>
>
>
7
TDS Gateway
1
Front-end Node
Protocol Parser
TDS Session
6
2
Gateway Logic
Global Partition Map
Master Node
8
3
4
Master Node
Components
5
Backend Node 1
Backend Node 2
Backend Node 3
SQL Instance
SQL DB
SQL Instance
SQL DB
SQL Instance
SQL DB
Scalability
Availability:
Fabric,Failover,
Failover, Replication,
andand
LoadLoad
balancing
Scalability
and and
Availability:
Fabric,
Replication,
balancing
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
channel9.msdn.com/learn
Built by Developers for Developers….
© 2009 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market
conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT
MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.