41
Christian Nagel CN innovation Windows Azure: Welche Storage Technologie soll ich jetzt verwenden?

Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

  • Upload
    others

  • View
    1

  • Download
    0

Embed Size (px)

Citation preview

Page 1: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Christian Nagel

CN innovation

Windows Azure: Welche Storage

Technologie soll ich jetzt verwenden?

Page 2: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Christian Nagel

Training, Coaching, Consulting

Microsoft Regional Director

Microsoft MVP .NET

XAML + C#

Windows Azure

ASP.NET MVC + Web API

Page 3: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Goals

Einführung in Windows Azure Storage

Technologien (PaaS)

Code Beispiele

Szenario: Multi-Tenant Menu Card

Manager

Page 4: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Agenda – 5 Steps

SQL Database

Storage

DocumentDb

Azure Search

Vergleiche

Page 5: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

SQL Database

Page 6: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Overview SQL Database

Relational Store

"Just like" SQL Server

Page 7: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

APIs

ADO.NET

Entity Framework 7

Code First

Conventions, no Magic

Smaller Packages

Memory Provider

NoSQL

Page 8: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Demo

SQL Database

Visual Studio

Entity Framework

Relations

Resiliency

Page 9: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Unterschiede zu On-Premise

Resiliency

Database Throughput Unit (DTU)

CPU

Physical Data Reads

Log Writes

Page 10: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Limits / Scalability

Premium Tier

800 DTUs

Max DB Size 500 GB

1600 Worker Threads

19200 Sessions

735 Transactions per Second

Page 11: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Azure Storage

Page 12: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Overview Azure Storage

Table Storage

Blob Storage

Page blob

Block blob

Queues

Files

Page 13: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Table Storage

Page 14: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Demo

Table Storage

Server Explorer

Table Design

Add/Update

Fluent & Queryable Queries

Page 15: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Table Storage Eigenschaften

255 Properties

1 MB per Entity

64k per String

Wenig Datentypen

Keine Relationen

Index nur PartitionKey/RowKey

1 KB RowKey

Page 16: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Blob Storage

Page 17: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Demo

Blob Storage

Shared Access Signature

Page 18: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Blob Storage Eigenschaften

Shared Access Signatures

200 GB Block Blob

1 TB Page Blob

500 TB per Account (50 Accounts per

Subscription)

Page 19: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Verfügbarkeit

• 3 Kopien

• In 1 ZoneLocally redundant

Storage (LRS)

• 3 Kopien

• 2 oder 3 ZonenZone-redundant Storage (ZRS)

• 3 + 3 Kopien

• 2 RegionenGeo-redundant Storage (GRS)

• 3 + 3 Kopien

• Read Access 2 Regionen

Read-access geo-redundant (RA-

GRS)

Page 20: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

DocumentDB

Page 21: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Overview DocumentDB

Schema-free data

Queries with SQL Syntax

Stores JSON documents

Consistency levels for performance

Page 22: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

DocumentDB

Page 23: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Demo

DocumentDB

Collections

Index

Documents

Query

Page 24: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Consistency Levels

Strong

Bounded staleness

Session

Eventual

Page 25: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Document Collections

Collection of JSON documents

Boundary for queries and transactions

Users/permissions for databases or

collections

Elastic SSD backed storage

SQL Query Language

Page 26: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Features

Stored Procedures

Triggers

User Defined Functions

using JavaScript

Page 27: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Limits

5 Database Accounts*

100 Collections per Account*

2 GB Attachment Storage per Account

0-10 GB for One Collection

512 KB Max Size for Document and Attachment

1 MB Max Response Size

Max 5 AND per query*

Max 5 OR per query*

*) ask support for more

Page 28: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Azure Search

Page 29: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Overview

People love search

Windows Azure Service

Independent of other Data Stores

Page 30: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Demo

Azure Search

Create Index

Add Elements

Suggestions

Page 31: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Features

Scoring Profiles

Type-ahead suggestions

Faceted navigation

Hit highlighting

Page 32: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Storage Vergleiche

Page 33: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Preis (pro Monat) / Size

1

10

100

1000

2 10 250 500 450000

Pre

is

GB

DocumentDB

Page 34: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Preis (pro Monat) / Size

1

10

100

1000

2 10 250 500 450000

Pre

is

GB

DocumentDB SQL

Page 35: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Preis (pro Monat) / Size

0.01

0.1

1

10

100

1000

10000

2 10 250 500 450000

Pre

is

GBDocumentDB SQL Table

Page 36: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

TPS / Price

0

100

200

300

400

500

600

700

800

4 12 23 56 112 347 693 2771

TPS

Preis

SQL Database

Page 37: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

TPS / Price

0

100

200

300

400

500

600

700

800

4 12 23 56 112 347 693 2771

TPS

Preis

SQL Database

0

2000

4000

6000

8000

10000

12000

33 66 99 132 165

TPS

Preis

DocumentDB

Page 38: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

TPS / Price

0

200

400

600

800

4 12 23 56 112 347 693 2771

TPS

Preis

SQL Database

0

2000

4000

6000

8000

10000

12000

33 66 99 132 165

TPS

Preis

DocumentDB

0

5000

10000

15000

20000

25000

1 10 100 1000 10000 100000 1000000

TPS

Preis

Table Storage

Page 39: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Summary

• Tools

• PreisSQL Azure

• Datenmengen

• PerformanceTable Storage

• JSON

• IndexingDocumentDB

• Full Text SearchAzure Search

Page 40: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

Questions?

Source Code

http://blog.cninnovation.com

Twitter: @christiannagel

http://www.cninnovation.com

Page 41: Christian Nagel CN innovation - Microsoft...Christian Nagel Training, Coaching, Consulting Microsoft Regional Director Microsoft MVP .NET XAML + C# Windows Azure ASP.NET MVC + Web

More Information

http://www.windowsazure.com

Upcoming book: Professional C# 6

Training by Christian Nagel