Analyzing_real-time-data-with-Azure-Database-for-Postgres_Sharma-Clarke_Ignite2019.pdf

PostgreSQL is the one of most widely used and advanced open source databases in the world. Customers deploy a lot of business critical real-time analytics applications on Azure Database for PostgreSQL and with the introduction of Hyperscale (Citus), you can deploy HTAP applications of any scale on the platform. In this workshop, we discuss best practices and learn how to deploy a real-time analytics and visualization application using Azure Database for PostgreSQL.

Transcript

1. Analyzing real-time data with Azure Database for PostgreSQL sash@microsoft.com iaclarke@microsoft.com
2. Scenario: Real-time Operational Analytics
3. Typical application requirements
4. Why Postgres for real-time operational analytics
5. PostgreSQL is more popular than ever loved wanted https://insights.stackoverflow.com/survey/2019?utm_source=so-owned&utm_medium=blog&utm_campaign=dev-survey-2019&utm_content=launch-blog https://db-engines.com/en/blog_post/76 https://db-engines.com/en/ranking_trend/system/PostgreSQL DBMS of the Year DB-Engines’ ranking of PostgreSQL popularity PostgreSQL is more popular than ever
6. Azure Database for PostgreSQL
7. High performance scale-out with Hyperscale (Citus) The benefits of Azure Database for PostgreSQL Intelligent performance optimization Flexible and open Fully managed and secure Single Server Hyperscale (Citus) NEW Build or migrate your workloads with confidence
8. Azure Database for PostgreSQL is available in two deployment options Single Server Fully-managed, single-node PostgreSQL Example use cases • Apps with JSON, geospatial support, or full-text search • Transactional and operational analytics workloads • Cloud-native apps built with modern frameworks Hyperscale (Citus) High-performance Postgres for scale out Example use cases • Scaling PostgreSQL multi-tenant, SaaS apps • Real-time operational analytics • Building high throughput transactional apps Enterprise-ready, fully managed community PostgreSQL with built-in HA and multi-layered security
9. Shard your Postgres database across multiple nodes to give your application more memory, compute, and disk storage Easily add worker nodes to achieve horizontal scale Scale up to 100s of nodes Scale horizontally across hundreds of cores with Hyperscale (Citus) Coordinator Table metadata Each node PostgreSQL with Citus installed 1 shard = 1 PostgreSQL table Sharding data across multiple nodes
10. Microsoft Windows relies on Citus for mission-critical decisions 6M+ queries per day 95%
11. Enlyft provides faster intelligence to their customers with Hyperscale (Citus)
12. Deploy end to end applications faster with Postgres and Azure Notification Hubs Event Hubs Raw Events In-database rollups Aggregations App Service 1 2 3 4 5 6 4 Hyperscale (Citus) Devices Browser Azure Databricks 7
13. PostgreSQL tips for real-time analytics apps • • • • • • • • •
14. Hands on Lab
15. Scenario: You = Cloud services provider helping businesses monitor their HTTP traffic
16. Hands on Lab
17. Let’s get started! https://aka.ms/ignite-WRK2006R
18. Other sessions you might be interested in… Session ID Day / Time Title Speaker(s) BRK3018 Tue 11/5 11:45 AM Building modern apps that scale to billions of events with Azure Database for PostgreSQL and Hyperscale (Citus) Umur Cubukcu BRK2065 Tue 11/5 1:00 PM Innovations to boost productivity with Azure-managed MySQL, Postgres, and MariaDB databases Sunil Kamath THR2124 Tue 11/5 4:20 PM Running Postgres at scale on-premises and in the cloud Lukas Fittl BRK2064 Wed 11/6 11:45 AM Why developers love Postgres Craig Kerstiens, Shyam Pitchaimuthu THR2120 Wed 11/6 1:50 PM Deploy an app in Azure Kubernetes and App Services with MySQL Manish Kumar THR2123 Wed 11/6 4:20 PM Why enterprises are moving from Oracle to Azure Postgres Saurabh Modi BRK3019 Thu 11/7 2:15-3:00 Migrate or build internet-scale applications using MySQL Jan Engelsberg, Sunil Kamath