280 likes | 731 Views
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) .
E N D
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)
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
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.
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
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, …
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
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
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/.../