クラウドネイティブアーキテクチャに適したデータストア活用パターン / clrh13

Slide 1

Slide 1 text

- 2018.3.17 - - 2018.3.17 - - 2018.3.17 - - 2018.3.17 - - 2018.3.17 - - 2018.3.17 - CLR/H in TOKYO #13 CLR/H in TOKYO #13 CLR/H in TOKYO #13 CLR/H in TOKYO #13 CLR/H in TOKYO #13 CLR/H in TOKYO #13 @kazuyukimiyake @kazuyukimiyake @kazuyukimiyake @kazuyukimiyake @kazuyukimiyake @kazuyukimiyake

Slide 2

Slide 2 text

About me About me About me About me About me About me @kazuyukimiyake @kazuyukimiyake @kazuyukimiyake @kazuyukimiyake @kazuyukimiyake @kazuyukimiyake CTO CTO CTO CTO CTO CTO 5 10 Azure 5 10 Azure 5 10 Azure 5 10 Azure 5 10 Azure 5 10 Azure Microsoft MVP for Data Platform Microsoft MVP for Data Platform Microsoft MVP for Data Platform Microsoft MVP for Data Platform Microsoft MVP for Data Platform Microsoft MVP for Data Platform JAZUG, JXUG, Vue.js-jp JAZUG, JXUG, Vue.js-jp JAZUG, JXUG, Vue.js-jp JAZUG, JXUG, Vue.js-jp JAZUG, JXUG, Vue.js-jp JAZUG, JXUG, Vue.js-jp PaaS (Blog): PaaS (Blog): PaaS (Blog): PaaS (Blog): PaaS (Blog): PaaS (Blog): https://k-miyake.github.io/blog/ https://k-miyake.github.io/blog/ https://k-miyake.github.io/blog/ https://k-miyake.github.io/blog/ https://k-miyake.github.io/blog/ https://k-miyake.github.io/blog/ Cosmos DB, Vue.js, RC Cosmos DB, Vue.js, RC Cosmos DB, Vue.js, RC Cosmos DB, Vue.js, RC Cosmos DB, Vue.js, RC Cosmos DB, Vue.js, RC ā ā ā ā ā ā ý ý ý ý ý ý ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā 2 / 36

Slide 3

Slide 3 text

Microsoft Microsoft Microsoft Microsoft Microsoft Microsoft Cloud-Optimized Cloud-Optimized Cloud-Optimized Cloud-Optimized Cloud-Optimized Cloud-Optimized: : : : : : Full PaaS Full PaaS Full PaaS Full PaaS Full PaaS Full PaaS & cloud-native & cloud-native & cloud-native & cloud-native & cloud-native & cloud-native 3 / 36

Slide 4

Slide 4 text

" " " " " " " " " " " " 4 / 36

Slide 5

Slide 5 text

5 / 36

Slide 6

Slide 6 text

1 1 1 1 1 1 Web OSS Web OSS Web OSS Web OSS Web OSS Web OSS RDB OSS ... RDB OSS ... RDB OSS ... RDB OSS ... RDB OSS ... RDB OSS ... 6 / 36

Slide 7

Slide 7 text

"NoOps" PaaS "NoOps" PaaS "NoOps" PaaS "NoOps" PaaS "NoOps" PaaS "NoOps" PaaS App Service App Service App Service App Service App Service App Service DB DB DB DB DB DB Azure DB for MySQL Azure DB for MySQL Azure DB for MySQL Azure DB for MySQL Azure DB for MySQL Azure DB for MySQL NEW NEW NEW NEW NEW NEW ā ā ā ā ā ā ā ā ā ā ā ā ý ý ý ý ý ý 7 / 36

Slide 8

Slide 8 text

[ ] Managed OSS Web App [ ] Managed OSS Web App [ ] Managed OSS Web App [ ] Managed OSS Web App [ ] Managed OSS Web App [ ] Managed OSS Web App 8 / 36

Slide 9

Slide 9 text

NoOps NoOps NoOps NoOps NoOps NoOps NoOps NoOps NoOps NoOps NoOps NoOps : : : : : : Developers Summit 2018 16-B-2 Developers Summit 2018 16-B-2 Developers Summit 2018 16-B-2 Developers Summit 2018 16-B-2 Developers Summit 2018 16-B-2 Developers Summit 2018 16-B-2 P.38 P.38 P.38 P.38 P.38 P.38 PaaS NoOps 3 PaaS NoOps 3 PaaS NoOps 3 PaaS NoOps 3 PaaS NoOps 3 PaaS NoOps 3 Self Healing Self Healing Self Healing Self Healing Self Healing Self Healing: : : : : : In-Flight Renewing In-Flight Renewing In-Flight Renewing In-Flight Renewing In-Flight Renewing In-Flight Renewing: : : : : : Adaptive Scale Adaptive Scale Adaptive Scale Adaptive Scale Adaptive Scale Adaptive Scale: : : : : : ā ā ā ā ā ā ý ý ý ý ý ý ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā 9 / 36

Slide 10

Slide 10 text

App Service NoOps App Service NoOps App Service NoOps App Service NoOps App Service NoOps App Service NoOps NoOps NoOps NoOps NoOps NoOps NoOps Git Git Git Git Git Git Blue/Green Blue/Green Blue/Green Blue/Green Blue/Green Blue/Green MySQL in App DB MySQL in App DB MySQL in App DB MySQL in App DB MySQL in App DB MySQL in App DB Let's Encrypt SSL Let's Encrypt SSL Let's Encrypt SSL Let's Encrypt SSL Let's Encrypt SSL Let's Encrypt SSL TINFOIL Web TINFOIL Web TINFOIL Web TINFOIL Web TINFOIL Web TINFOIL Web ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā 10 / 36

Slide 11

Slide 11 text

Azure DB for MySQL NoOps Azure DB for MySQL NoOps Azure DB for MySQL NoOps Azure DB for MySQL NoOps Azure DB for MySQL NoOps Azure DB for MySQL NoOps LRS GRS LRS GRS LRS GRS LRS GRS LRS GRS LRS GRS 35 35 35 35 35 35 ā ā ā ā ā ā ý ý ý ý ý ý ā ā ā ā ā ā ý ý ý ý ý ý ā ā ā ā ā ā ý ý ý ý ý ý ā ā ā ā ā ā ý ý ý ý ý ý 11 / 36

Slide 12

Slide 12 text

Azure DB for MySQL Azure DB for MySQL Azure DB for MySQL Azure DB for MySQL Azure DB for MySQL Azure DB for MySQL MySQL/PostgreSQL MySQL/PostgreSQL MySQL/PostgreSQL MySQL/PostgreSQL MySQL/PostgreSQL MySQL/PostgreSQL SSL SSL SSL SSL SSL SSL App Service IP App Service IP App Service IP App Service IP App Service IP App Service IP DB (AES256) DB (AES256) DB (AES256) DB (AES256) DB (AES256) DB (AES256) ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ý ý ý ý ý ý ā ā ā ā ā ā 12 / 36

Slide 13

Slide 13 text

[ ] WordPress MySQL SSL [ ] WordPress MySQL SSL [ ] WordPress MySQL SSL [ ] WordPress MySQL SSL [ ] WordPress MySQL SSL [ ] WordPress MySQL SSL wp-con g.php wp-con g.php wp-con g.php wp-con g.php wp-con g.php wp-con g.php /** MySQL SSL **/ /** MySQL SSL **/ define define( ('MYSQL_CLIENT_FLAGS' 'MYSQL_CLIENT_FLAGS', , MYSQLI_CLIENT_SSL MYSQLI_CLIENT_SSL) ); ; define define( ('MYSQL_SSL_CA' 'MYSQL_SSL_CA', , getenv getenv( ('MYSQL_SSL_CA' 'MYSQL_SSL_CA') )) ); ; - - - - - - 13 / 36

Slide 14

Slide 14 text

Managed OSS Web App Managed OSS Web App Managed OSS Web App Managed OSS Web App Managed OSS Web App Managed OSS Web App

Slide 15

Slide 15 text

2 2 2 2 2 2 RDB RDB RDB RDB RDB RDB

Slide 16

Slide 16 text

RDB NoSQL( RDB NoSQL( RDB NoSQL( RDB NoSQL( RDB NoSQL( RDB NoSQL( Azure Cosmos DB Azure Cosmos DB Azure Cosmos DB Azure Cosmos DB Azure Cosmos DB Azure Cosmos DB ) ) ) ) ) ) RDB RDB RDB RDB RDB RDB Azure SQL DB Azure SQL DB Azure SQL DB Azure SQL DB Azure SQL DB Azure SQL DB ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā 16 / 36

Slide 17

Slide 17 text

[ ] RDB + NoSQL [ ] RDB + NoSQL [ ] RDB + NoSQL [ ] RDB + NoSQL [ ] RDB + NoSQL [ ] RDB + NoSQL

Slide 18

Slide 18 text

Cosmos DB Cosmos DB Cosmos DB Cosmos DB Cosmos DB Cosmos DB NoSQL NoSQL NoSQL NoSQL NoSQL NoSQL 1KB 1KB 1KB 1KB 1KB 1KB 50 99 2ms 10ms 6ms 15ms RU RU RU RU RU RU ā ā ā ā ā ā ā ā ā ā ā ā 19 / 36

Slide 19

Slide 19 text

ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā 20 / 36

Slide 20

Slide 20 text

[ ] RDB NoSQL [ ] RDB NoSQL [ ] RDB NoSQL [ ] RDB NoSQL [ ] RDB NoSQL [ ] RDB NoSQL 21 / 36

Slide 21

Slide 21 text

Cosmos DB Cosmos DB Cosmos DB Cosmos DB Cosmos DB Cosmos DB Azure Storage Exproler Azure Storage Exproler Azure Storage Exproler Azure Storage Exproler Azure Storage Exproler Azure Storage Exproler JSON C# Visual Studio JSON C# Visual Studio JSON C# Visual Studio JSON C# Visual Studio JSON C# Visual Studio JSON C# Visual Studio ā ā ā ā ā ā ý ý ý ý ý ý ā ā ā ā ā ā 22 / 36

Slide 22

Slide 22 text

RDB + NoSQL RDB + NoSQL RDB + NoSQL RDB + NoSQL RDB + NoSQL RDB + NoSQL

Slide 23

Slide 23 text

[ ] D/R [ ] D/R [ ] D/R [ ] D/R [ ] D/R [ ] D/R

Slide 24

Slide 24 text

3) 3) 3) 3) 3) 3)

Slide 25

Slide 25 text

DB DB DB DB DB DB ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā

Slide 26

Slide 26 text

[ ] [ ] [ ] [ ] [ ] [ ]

Slide 27

Slide 27 text

Stream Analytics Stream Analytics Stream Analytics Stream Analytics Stream Analytics Stream Analytics Event Hubs Event Hubs Event Hubs Event Hubs Event Hubs Event Hubs IoT Hub IoT Hub IoT Hub IoT Hub IoT Hub IoT Hub ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā 28 / 36

Slide 28

Slide 28 text

[ ] Stream Analytics SQL [ ] Stream Analytics SQL [ ] Stream Analytics SQL [ ] Stream Analytics SQL [ ] Stream Analytics SQL [ ] Stream Analytics SQL EventHub Cosmos DB Blob EventHub Cosmos DB Blob EventHub Cosmos DB Blob EventHub Cosmos DB Blob EventHub Cosmos DB Blob EventHub Cosmos DB Blob -- Cosmos DB -- Cosmos DB SELECT SELECT * * INTO INTO cosmosdb cosmosdb FROM FROM eventhub eventhub WHERE WHERE title title NOT NOT LIKE LIKE 'Test%' 'Test%' -- Blob -- Blob SELECT SELECT * * INTO INTO blob blob FROM FROM eventhub eventhub 29 / 36

Slide 29

Slide 29 text

Cosmos DB Cosmos DB Cosmos DB Cosmos DB Cosmos DB Cosmos DB TTL (Time to Live) TTL (Time to Live) TTL (Time to Live) TTL (Time to Live) TTL (Time to Live) TTL (Time to Live) TTL TTL TTL TTL TTL TTL JSON -> JSON -> JSON -> JSON -> JSON -> JSON -> docs docs docs docs docs docs ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā 30 / 36

Slide 30

Slide 30 text

Azure Functions Cosmos DB Trigger Azure Functions Cosmos DB Trigger Azure Functions Cosmos DB Trigger Azure Functions Cosmos DB Trigger Azure Functions Cosmos DB Trigger Azure Functions Cosmos DB Trigger Azure Functions Azure Functions Azure Functions Azure Functions Azure Functions Azure Functions DB DB DB DB DB DB DB DB DB DB DB DB Azure Search Azure Search Azure Search Azure Search Azure Search Azure Search ā ā ā ā ā ā ā ā ā ā ā ā ý ý ý ý ý ý ý ý ý ý ý ý 31 / 36

Slide 31

Slide 31 text

Azure Search Azure Search Azure Search Azure Search Azure Search Azure Search Cosmos DB (RU) Cosmos DB (RU) Cosmos DB (RU) Cosmos DB (RU) Cosmos DB (RU) Cosmos DB (RU) RU RU RU RU RU RU Search Search Search Search Search Search Cosmos DB Cosmos DB Cosmos DB Cosmos DB Cosmos DB Cosmos DB RU RU RU RU RU RU ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā ā 32 / 36

Slide 32

Slide 32 text

33 / 36

Slide 33

Slide 33 text

34 / 36

Slide 34

Slide 34 text

Global Azure Bootcamp 2018@Tokyo Global Azure Bootcamp 2018@Tokyo Global Azure Bootcamp 2018@Tokyo Global Azure Bootcamp 2018@Tokyo Global Azure Bootcamp 2018@Tokyo Global Azure Bootcamp 2018@Tokyo https://jazug.connpass.com/event/81865/ https://jazug.connpass.com/event/81865/ https://jazug.connpass.com/event/81865/ https://jazug.connpass.com/event/81865/ https://jazug.connpass.com/event/81865/ https://jazug.connpass.com/event/81865/ 35 / 36