1 / 47

Welcome to Cloud

Welcome to Cloud. Azure Data & Storage Services. By. Agenda. Importance of Azure Data & Storage Azure SQL Database Services Azure Storage : Blobs, Tables, Queue and Files Azure Cosmos DB ( No SQL Database). Importance of Azure Data & Storage.

axl
Download Presentation

Welcome to 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. Welcome to Cloud

  2. Azure Data & Storage Services By

  3. Agenda • Importance of Azure Data & Storage • Azure SQL Database Services • Azure Storage : Blobs, Tables, Queue and Files • Azure Cosmos DB ( No SQL Database)

  4. Importance of Azure Data & Storage • A different kinds of applications need different kinds of data. • Azure provides several different ways to store and manage data. • Azure provides many storage options, but all are designed for very durable storage

  5. Azure SQL Database Services By

  6. Azure SQL Database

  7. SQL Server on Azure Virtual Machines Azure SQL Database v/s Azure SQL  known as an infrastructure as a service (IaaS) known as a platform as a service (PaaS) database or a database as a service (DBaaS) When using SQL Database, you pay-as-you-go with options to scale up or out for greater power with no interruption. You can also easily scale-up/down and pause/resume the VM as needed. It is optimized for migrating existing applications to Azure or extending existing on-premises applications to the cloud in hybrid deployments It is optimized to reduce overall costs to the minimum Azure SQL Database provides features, such as automated backups, Point-In-Time Restore, geo-restore, and active geo-replication to increase business continuity. SQL Server on Azure VMs lets you set up a high availability and disaster recovery solution for your database’s specific needs. You can test and run failovers by yourself when needed.

  8. Azure SQL Database service tiers

  9. Auditing

  10. Point-in-time restore You can restore an existing database to an earlier point in time as a new database on the same logical server using the Azure portal, PowerShell, or the REST API.

  11. Geo-restore

  12. active geo-replication

  13. Adjust performance and scale without downtime

  14. Elastic pools to maximize resource utilization

  15. Azure Storage :Blobs, Tables, Queue and Files By

  16. Cloud Based Storage Scalable, Durable Highly Available Anywhere at anytime access Cost Effective Storage Options Blobs, Files, Tables, Queues Exposed via RESTful Web Services Use from Windows Azure Compute Use from anywhere on the internet Azure Storage Overview

  17. A general-purpose Storage Account gives you access to Azure Storage services such as Tables, Queues, Files, Blobs and Azure virtual machine disks under a single account. Storage account has two performance tiers: Standard Storage performance tier which allows you to store Tables, Queues, Files, Blobs and Azure virtual machine disks. Premium Storage performance tier which currently only supports Azure virtual machine disks. See Premium Storage: High-Performance Storage for Azure Virtual Machine Workloads for an in-depth overview of Premium storage. General Purpose Storage Account

  18. Geo Redundant Storage (GRS) • Stores 6 replicas of the data across two regions (3 in each region) • Data is only available in the event Microsoft declares a disaster • Provides additional durability to protect data against major regional natural disasters (e.g., tornado. hurricane, fire, etc., destroying a whole region) • Updates across regions are performed asynchronously Geo Redundant Storage with read-only access (RAGRS) • Access secondary data (read only) without disaster declaration • Primary and secondary endpoints • accountname.blob.core.windows.net and accountname-secondary.blob.core.windows.net PremiumStorage • Low latency and high performance SSD based persistent storage Locally redundant •Zone Redundant Storage (ZRS) • Replicas across multiple zones in the same region. Not supported with virtual machines. Storage Account Type

  19. Storage Libraries in Many Languages C#/.NET Python Ruby Perl JavaScript (Node) Java PHP Erlang Common LISP Objective-C C#/VB on Windows Phone 7

  20. Windows Azure Storage provides simple security for calls to storage service HTTPS endpoint Digitally sign requests for privileged operations Two 512bit symmetric keys per storage account Can be regenerated independently More granular security via Shared Access Signatures Storage Security

  21. Windows Azure Storage Abstractions Tables Structured storage. A table is a set of entities; an entity is a set of properties. Blobs Simple named files along with metadata for the file. Queues Reliable storage and delivery of messages for an application. Files SMB access to azure storage.

  22. Blob Storage

  23. Blob Storage Concepts http://<account>.blob.core.windows.net/<container>/<blobname> Blob Pages/ Blocks • Account Container PIC01.JPG images Block/Page PIC02.JPG contoso Block/Page videos VID1.AVI

  24. Fine grain access rights to blobs and containers Sign URL with storage key – permit elevated rights Revocation Use short time periods and re-issue Use container level policy that can be deleted Two broad approaches Ad-hoc Policy based Shared Access Signatures

  25. High-bandwidth global blob content delivery 42 locations globally (US, Europe, Asia, Australia and South America), and growing Same experience for users no matter how far they are from the geo-location where the storage account is hosted Blob service URL vs. CDN URL: Windows Azure Blob URL: http://images.blob.core.windows.net/ Windows Azure CDN URL: http://<id>.vo.msecnd.net/ Custom Domain Name for CDN: http://cdn.contoso.com/ Content Delivery Network (CDN)

  26. File Storage

  27. A File share can have multiple directories All directories and files must be created in a parent file share An account can contain an unlimited number of shares, and a share can store an unlimited number of files, up to the capacity limits of the storage account Files

  28. Table Storage

  29. Table Storage Concepts Account Table Entity Name =… Email = … customers Name =… EMailAdd= sally Photo ID =… Date =… photos Photo ID =… Date =…

  30. No Fixed Schema FAV SPORT Canoeing

  31. PartitionKey and RowKey Server A Table = Products [MinKey - Canoes) Server A Table = Products Server B Table = Products [Canoes - MaxKey)

  32. Queue Storage

  33. z Queue service concepts

  34. Azure Cosmos DB

  35. Azure Cosmos DB • Globally distributed • Multi-model database service • Turnkey global distribution • Elastic scaling of throughput and storage worldwide • Single-digit millisecond latencies • Automatically indexes data • No Database schema

  36. Supported Data Model API • DocumentDB API • MongoDB API • Table API • Graph (Gremlin) API

  37. Resource Model

  38. Horizontal Partitioning

  39. Global Distribution

  40. High availability

  41. Create a database account

  42. Add a collection

  43. Add sample data

  44. Full, automatic, online backups

  45. Query Playground

More Related