「Azure Cosmos DB」のキホンと使いドコロ / mcw0006742

Slide 1

Slide 1 text

D A C B

Slide 2

Slide 2 text

n ❃ ❃ Azure Cosmos DB

Slide 3

Slide 3 text

n ❃ ❃ n ❃ ❃ ❃ -/ . / -/ .

Slide 4

Slide 4 text

n 3 0:/ 8 / : :2 /:8 5- 5 -B 1 /: 8: 0. n ❃ 3 /3-991 8 09 /:8 19 0 n ❃ 3 01 3- 1 91 - :9-: 01/:01 0- /: 8: 0.

Slide 5

Slide 5 text

❃ ❃ ❃

Slide 6

Slide 6 text

No content

Slide 7

Slide 7 text

SQL MongoDB Table API Turnkey global distribution Elastic scale out of storage & throughput Guaranteed low latency at the 99th percentile Comprehensive SLAs Five well-defined consistency models Document Column-family Key-value Graph A globally distributed, massively scalable, multi-model database service : / / 33.1 2 3 2 9.3 801

Slide 8

Slide 8 text

n ❃ ❃ ❃ n : A technical overview of Azure Cosmos DB https://azure.microsoft.com/en-us/blog/a-technical-overview-of-azure-cosmos-db/

Slide 9

Slide 9 text

: 1 898 82 Resource M anager Language Runtim e(s) Hosts Q uery Processor RSM Index M anager Bw -tree++/ LLAM A++ Log M anager IO M anager Resource Governor Transport Database engine Adm ission control … … Planet Earth Azure regions Datacenters Stamps Fault domains Cluster Machine Replica Database engine Container Various agents 3 9: /3. 1 :0 /8 1 : 0

Slide 10

Slide 10 text

No content

Slide 11

Slide 11 text

No content

Slide 12

Slide 12 text

CA n ❃ A L L A BL • - ( K A ( • ( • ( • ( ) B A L • ( GIDF

Slide 13

Slide 13 text

n • •

Slide 14

Slide 14 text

n ❃ ❃ n ❃ ❃

Slide 15

Slide 15 text

n ❃ ❃ ❃ ❃ ❃ ❃ ❃ ❃

Slide 16

Slide 16 text

n ❃ n ❃ n ❃ n ❃

Slide 17

Slide 17 text

No content

Slide 18

Slide 18 text

Azure Cosmos DB App Service 1 App Service 2 Azure Traffic Manager $ " $ " # % !

Slide 19

Slide 19 text

Account Database Database Database Database Database Container Database Database Item A C

Slide 20

Slide 20 text

n ❃ ❃ ❃ n ❃ ❃ ❃ // . / / A :B - . / / . % IOPS % CPU % Memory

Slide 21

Slide 21 text

L# :/ BC DA C # . - -: - :/ - . :/ / / / / : /

Slide 22

Slide 22 text

No content

Slide 23

Slide 23 text

No content

Slide 24

Slide 24 text

No content

Slide 25

Slide 25 text

n ❃ ❃ // . . - . / - - / / -

Slide 26

Slide 26 text

No content

Slide 27

Slide 27 text

n ❃ n ❃ ❃

Slide 28

Slide 28 text

n n ❃

Slide 29

Slide 29 text

n n

Slide 30

Slide 30 text

Azure Cosmos DB Azure Database for MySQL Web App Azure Functions Write Read Publish " # $ !

Slide 31

Slide 31 text

n ❃

Slide 32

Slide 32 text

No content

Slide 33

Slide 33 text

n n ❃ n ❃

Slide 34

Slide 34 text

No content

Slide 35

Slide 35 text

n ❃ n ❃

Slide 36

Slide 36 text

n n ❃

Slide 37

Slide 37 text

F C F Azure Cosmos DB Azure Stream Analytics Azure Event Hubs Azure Data Lake Store Power BI Azure Functions + C C Azure Databricks H

Slide 38

Slide 38 text

n ❃ ❃ ❃ Azure Stream Analytics Azure Event Hubs Azure Cosmos DB

Slide 39

Slide 39 text

n ❃

Slide 40

Slide 40 text

n ❃ n ❃ n ❃ -/ / . / - . / / - . n

Slide 41

Slide 41 text

n ❃ n ❃

Slide 42

Slide 42 text

Function App Azure Storage - Queue monitor App Service Cosmos DB Application Insights ςϨϝτϦ Azure Monitor monitor

Slide 43

Slide 43 text

.NET SQL Database App Service Web App / API App / Mobile App Windows ASP.NET Cosmos DB SQL API Documet Node.js App Service Web App / API App / Linux Node.js Express Cosmos DB MongoDB API Documet Azure Database for MySQL

Slide 44

Slide 44 text

No content

Slide 45

Slide 45 text

Easy out-of-the-box bulk operation functionality Supports bulk import and update Auto handles congestion control + transient errors 10x client-side performance improvement Easily scale-out clients across more VMs Available starting with .NET and Java " !# .NET SDK.NET Core

Slide 46

Slide 46 text

Remove friction for OSS NoSQL APIs Provision RU/sec shared across containers Mix containers with dedicated throughput and containers with shared throughput Elastically scale provisioned throughput for a set of containers at any time 50,000RU

Slide 47

Slide 47 text

Perfect for Intelligent Cloud and Intelligent Edge Applications Write scalability around the world Low latency writes around the world 99.999% High Availability around the world Well-defined consistency models Comprehensive conflict management Cosmos DB ! "20185#

Slide 48

Slide 48 text

Try Azure Cosmos DB for free! -/ . . / - . / /

Slide 49

Slide 49 text

No content

Slide 50

Slide 50 text

n ❃ ❃ n ❃ ❃ ❃ n ❃ ❃ Provisioned request / sec Time - Hourly throughput (request/sec) 2 8 C ABD A BN : 1 0 860 0 8 . : . 2 0 8 1/ 2 4 :

Slide 51

Slide 51 text

• • A .= ( = = .= ; ) ; ) A ; C , = A , = ; D : C B D A - . / / . .

Slide 52

Slide 52 text

// u c ls var connectionPolicy = new ConnectionPolicy { ConnectionMode = ConnectionMode.Direct, // eS ConnectionProtocol = Protocol.Tcp // TCP }; // c af r i connectionPolicy.PreferredLocations.Add("Japan West"); connectionPolicy.PreferredLocations.Add("Japan East"); connectionPolicy.PreferredLocations.Add("Southeast Asia"); // DocumentDBSb f ts client = new DocumentClient( new Uri(ConfigurationManager.AppSettings["endpoint"]), ConfigurationManager.AppSettings["authKey"], connectionPolicy ); client.OpenAsync(); // f D g u B u Sb f tsn c af B mk h c af o d Pf C / . /: . - py

Slide 53

Slide 53 text

n ❃ ❃ ❃ ❃ n n ❃ : - : - . : -/

Slide 54

Slide 54 text

- • s ky nc K ba • ky K A - . • dfp s ky S u teoil a K P ba K • K - • izfd r mojy K ba • tg r ( , C • ba K b u teoil a hxou P • K ( bS izfd r S ( a K aK ( S ( ba B A. • • • izfd r a K a EA ( : ) v : : . .EA : / D B • • •

Slide 55

Slide 55 text

n ❃ ❃ / - / / /- / -/ . . / { "automatic": true, "indexingMode": "Consistent", "includedPaths": [{ "path": "/*", "indexes": [{ "kind": "Hash", "dataType": "String", "precision": -1 }, { "kind": "Range", "dataType": "Number", "precision": -1 }, { "kind": "Spatial", "dataType": "Point" }] }], "excludedPaths": [{ "path": "/nonIndexedContent/*" }] }