1 / 30

Design considerations for storing data in the Cloud

Design considerations for storing data in the Cloud. Eric Nelson Microsoft UK http://bit.ly/ericnel http://twitter.com/ericnel http://ukazure.ning.com. Session Objectives. SQL Azure vs /and Windows Azure Storage Drill into Windows Azure Storage

roary-spence
Download Presentation

Design considerations for storing data in the Cloud

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. Design considerations for storing data in the Cloud Eric Nelson Microsoft UK http://bit.ly/ericnelhttp://twitter.com/ericnel http://ukazure.ning.com

  2. Session Objectives • SQL Azure vs/and Windows Azure Storage • Drill into Windows Azure Storage • Next session: Keith Burns drills into SQL Azure

  3. New online communityhttp://ukazure.ning.com/

  4. Windows Azure Platform

  5. Windows Azure Platform • Windows Azure – Your code and data • SQL Azure Database – Your relational data • AppFabric* – Your messages Code Data Relational Data

  6. Azure Application = WebRole + Worker Role + Storage Your Service Web Site (ASPX, ASMX, WCF) Web Site (ASPX, ASMX, WCF) Web Role (ASPX, WCF) Queues LB Internet Worker Service Worker Role Blobs LB Tables SQL Azure

  7. Windows Azure and SQL Azure

  8. Windows Azure and SQL Azure

  9. Windows Azure and SQL Azure

  10. Windows Azure and SQL Azure

  11. Cost impacting Architecture

  12. Windows Azure and SQL Azure

  13. Windows Azure and SQL Azure

  14. Windows Azure and SQL Azure

  15. Windows Azure and SQL Azure

  16. Azure Application = WebRole + Worker Role + Storage Your Service 2 Web Site (ASPX, ASMX, WCF) Web Site (ASPX, ASMX, WCF) Web Role (ASPX, WCF) Queues LB Internet Worker Service Worker Role Blobs LB Tables 1 SQL Azure

  17. SQL Azure

  18. SQL Azure SQL Azure Database + “Next big thing” http://www.sqlazurelabs.com http://www.mygreatsqlazureidea.com

  19. SQL Azure Application Architectures SQL Azure access from outside SQL Azure access from within Datacenter Application / Tools Application/ Browser WCF Data Svcs/REST - EF HTTP/S SOAP/REST HTTP/S Web Role Windows Azure T-SQL (TDS) T-SQL (TDS) SQL Azure SQL Azure Code Far Code Near

  20. Demo

  21. Windows Azure Storage“NoSQL”

  22. Azure Storage Storage Queues http://<account>.queue.core.windows.net/<queue> Blobs Account http://<account>.blob.core.windows.net/<container> Tables http://<account>.table.core.windows.net/<table>

  23. Queues Messages Queues “Body1” “Body2” ThumbnailJobsQ “Body3”

  24. Blobs Blobs Containers Photo1.png Photo2.png Pictures Photo3.png

  25. Content Delivery Network “Near” London “Near” Sydney Blobs Containers Photo1.png Photo1.png Photo1.png Photo1.png Photo1.png CDN Node CDN Node CDN Node CDN Node CDN Node Photo2.png Pictures “Near” Sydney “Near” London Photo3.png Windows Azure Blob service URL: http://ericnel.blob.core.windows.net/pictures/ Windows Azure CDN URL: http://<guid>.vo.msecnd.net/pictures/

  26. Tables - EAV MyAzureTable1 Entity: Shiny red Car PK, RK, TS, att1, att2, att8 Entity: Blue Bird PK, RK, TS, att1, att4 Entity: 2008 Tax Return PK, RK, TS, att1, att2, att8, att9, att23, att46, att40

  27. Windows Azure Tables • Massively Scalable Tables • Billions of entities (rows) and TBs of data • Automatically scales to thousands of servers as traffic grows • Highly Available • Can always access your data • Durable • Data is replicated at least 3 times

  28. Tables - Capabilities What tables don’t do What tables can do              No Group by Store LOTS of stuff  Limited Queries No Transactions No Joins Cheap No Referential Integrity Very Scalable Flexible Durable Not relational No Transactions No Aggregations If these are important to you, use SQL Azure

  29. Demo

  30. Summary • Important: You have SQL Azure and Windows Azure Storage to take advantage of • SQL Azure has a well known API and behavior • Windows Azure Storage has a new API and behavior • UK Site http://bit.ly/landazure • UK Community http://bit.ly/ukazure / http://ukazure.ning.com • My blog http://bit.ly/ericnel

More Related