1 / 15

Microsoft cloud (Azure) database

Microsoft cloud (Azure) database. Zalak Shah. What is Azure?. Features provided by Azure: Always up. Always on. Available for multiple programming language Scalability. Pay for your usage. Cloud Database Windows Azure Storage. Windows Azure SQL Database. Windows Azure Storage (WAS) .

yon
Download Presentation

Microsoft cloud (Azure) database

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Microsoft cloud (Azure) database Zalak Shah

  2. What is Azure? • Features provided by Azure: • Always up. Always on. • Available for multiple programming language • Scalability. • Pay for your usage. • Cloud Database • Windows Azure Storage. • Windows Azure SQL Database

  3. Windows Azure Storage (WAS)

  4. Introduction • Scalable cloud storage system since November 2008. • Used by internal and external customer by signing up over internet. • Data Storage Types: • Blobs – interface for storing named files along with meta data for the files. • Tables – scalable structured storage • Queues – message delivery • Ability to store large amount of data in Exabyte’s and beyond

  5. Design Features • Provides strong consistency. • Global Scalable Namespace/Storage • Single global Namespace. • URI: http(s)://AccountName.<service>.core.windows.net/PartitionName/ObjectName • Disaster Recovery. • Multi tenancy.

  6. Architecture • WAS runs on top of Fabric Controller of Windows Azure cloud platform. • Fabric Controller provides WAS with network topology information, physical layout of clusters, and hardware configuration of storage nodes. • High Level Components: • Storage Stamps • Location Service

  7. High Level Architecture

  8. Two Replication Engine • Intra-Stamp Replication on Stream Layer • Synchronous replication. • Stream layer replication -> replicating blocks of storage disks. • Durability of data against disk failure, rack failures • Inter-Stamp Replication on Partition Layer. • Asynchronous replication • Partition layer replication -> object level replication • Geo-redundancy against geo-disaster like earthquake, tsunami, …

  9. Stream Layer • Internal interface used by partition server. • Ordered list of pointers to extent maintained by Stream Manager (SM). • Extent -> sequence of appended blocks and unit of replication. • Blocks -> minimum unit of data for reading and writing

  10. Stream Layer Architecture

  11. Dealing with write Failure

  12. Partition Layer Architecture

  13. Windows Azure SQL Database • Extension to SQL server capabilities to the core. • Relational Database Solution on cloud. • Benefits – managed infrastructure, high availability, scalability, familiar development tool and framework. • Fault Tolerance in Windows Azure SQL database: • Multiple copies of databases in different physical node. • Quorum-based commit scheme • Replication, failure detection, and failover mechanism are fully automated

  14. References • http://sigops.org/sosp/sosp11/current/2011-Cascais/printable/11-calder.pdf • http://azure.microsoft.com/blog/2012/07/30/fault-tolerance-in-windows-azure-sql-database/ • http://azure.microsoft.com/en-us/campaigns/azure-vs-aws/ • http://msdn.microsoft.com/en-us/library/jj553018.aspx • http://blogs.msdn.com/b/windowsazurestorage/archive/2010/12/30/windows-azure-storage-architecture-overview.aspx • http://azure.microsoft.com/en-us/overview/what-is-azure/ • http://www-users.cselabs.umn.edu/classes/Fall-2012/csci8980-2/slides/azure.pdf • sigops.org/sosp/sosp11/.../

More Related