Tweet
Tweet

Slide 1

Slide 1 text

Building HTAP Applications with Python & Postgres—in Azure Sai Srirampur | @saisrirampur @AzureDBPostgres @citusdata A Demo

Slide 2

Slide 2 text

Quick “fly by” about me / why am I giving this demo? Postgres team at Microsoft via Citus Data acquisition Creator of `django-multitenant` @saisrirampur

Slide 3

Slide 3 text

Let’s go / HTAP Demo on Azure / in 3 parts 1 2 3 @saisrirampur AZURE PORTAL HTAP APPLICATION AZURE DATA STUDIO

Slide 4

Slide 4 text

Azure Database for PostgreSQL / managed service @saisrirampur

Slide 5

Slide 5 text

APPLICATION SELECT FROM GROUP BY company_id, avg(spend) AS avg_campaign_spend compaigns company_id; METADATA COORDINATOR NODE WORKER NODES W1 W2 W3 … Wn SELECT company_id sum(spend), count(spend) … FROM campaigns_2009 … SELECT company_id sum(spend), count(spend) … FROM campaigns_2001 … SELECT company_id sum(spend), count(spend) … FROM campaigns_2017 … How Hyperscale (Citus) Shards Postgres Across Nodes / DISTRIBUTED AGGREGATE

Slide 6

Slide 6 text

Hybrid Transactional & Analytical Processing So what is an HTAP application anyway? @saisrirampur

Slide 7

Slide 7 text

Today’s Example of an HTAP application App that manages “Marketing/Ad Campaigns” for businesses • Create/Update/Delete Campaigns – Transactional Part • Analyze campaigns/clicks/impressions – Analytics part @saisrirampur

Slide 8

Slide 8 text

The challenge for HTAP applications @saisrirampur

Slide 9

Slide 9 text

Performance benefits of running your HTAP application on a Hyperscale (Citus) cluster on Azure Parallelism of scaled-out Postgres database cluster enables you to reduce costs & use single database for your HTAP workloads What I am going to show you today @saisrirampur

Slide 10

Slide 10 text

Let’s go / HTAP Demo on Azure / in 3 parts 1 2 3 @saisrirampur AZURE PORTAL HTAP APPLICATION AZURE DATA STUDIO

Slide 11

Slide 11 text

Most important takeaway from this Azure demo Citus open source mascot: Elicorn >part elephant, part unicorn >sharded, of course “ https://aka.ms/hyperscale-citus-quickstart @saisrirampur

Slide 12

Slide 12 text

© Copyright Microsoft Corporation. All rights reserved. thank you merci grazie ευχαριστώ gracias ధన్యవాదాలు • Hyperscale (Citus) Quickstart Docs https://aka.ms/hyperscale-citus-quickstart • Multi-tenant Tutorial with Citus http://aka.ms/hyperscale-citus-multi-tenant-tutorial • django-multitenant library from Citus https://aka.ms/django-multitenant-github • Django sample app used in this demo https://aka.ms/django-PG-ad-app • Join Citus technical newsletter https://aka.ms/citus-newsletter Sai Srirampur @saisrirampur @AzureDBPostgres @citusdata​