Monday, November 2, 2009

SQL Azure Architecture Overview

Let’s look into Microsoft’s SQL Azure Architecture. SQL Azure is hosted on servers running SQL Server technologies in Microsoft data centers. From an architectural perspective, there are four distinct layers of abstraction that work together to provide a relational database for your application to use:
  1. The Client Layer
  2. The Services Layer
  3. The Platform Layer
  4. The Infrastructure Layer.

1. The Client Layer
The client layer resides closest to your application, and is used by your application to communicate directly with SQL Azure. The client layer can reside on-premise in your datacenter or be hosted in Windows Azure. Because SQL Azure provides the same tabular data system (TDS) interface as SQL Server, you can use familiar tools and libraries to build client applications for data that is in the cloud.

2.The Services Layer
The services layer functions as a gateway between the client layer and the platform layer, where the data resides. The services layer provides three functions: provisioning, billing and metering, and connection routing.

The services layer provisions the databases that you specify with your Windows Azure Platform account. The billing and metering aspect of the services layer enables multi-tenant support by providing monitoring and billing for database usage based on individual Windows Azure Platform accounts. SQL Azure is built on a scalable platform involving numerous physical servers; this layer handles all the connections routing between your application and the physical servers where your data resides.

3. The Platform Layer
The platform layer includes the physical servers and services that support the services layer. The platform layer consists of many instances of SQL Server, each of which is managed by the SQL Azure fabric.

The SQL Azure fabric is a distributed computing system composed of tightly integrated networks, servers, and storage. It enables automatic failover, load balancing, and automatic replication between physical servers.

Management services monitor the health of individual servers and enable automated installation of service upgrades and software patches.

4.Infrastructure Layer
The infrastructure layer represents the IT administration of the physical hardware and operating systems that support the services layer.

No comments:

Post a Comment