Turbocharging Scalability of GraphQL with Distributed SQL Amey Banarse Principal Data Architect, Yugabyte Inc. @ameybanarse

2 © 2019 All rights reserved. Introduction 2  Amey Banarse Principal Data Architect, Yugabyte Inc. ♦ Pivotal ♦ FINRA ♦ NYSE University of Pennsylvania (UPenn) @ameybanarse about.me/amey

Scaling GraphQL: What's the bottleneck today? HASURA App HASURA App HASURA HASURA App App … …

4 Yugabyte Confidential © 2020 All rights reserved. A brief history of Yugabyte Builders of multiple popular DBs Part of Facebook’s Cloud-Native DB Evolution Yugabyte team dealt with this growth first hand Massive geo-distributed deployment given global users Worked with world class infra team to solve these issues Yugabyte founding team ran Facebook’s public-cloud scale DBaaS +1 Trillion ops/day +100 Petabytes data set sizes

5 Yugabyte Confidential © 2020 All rights reserved. What is Distributed SQL? SQL & Transactions SQL Massive Scalability Geo Distribution Ultra Resilience A Revolutionary Database Architecture

6 Yugabyte Confidential © 2020 All rights reserved. Open source, high performance, cloud native, distributed SQL database 100% Apache 2.0 Low Latency (Sub-ms) Kubernetes & Multi-Cloud

7 Yugabyte Confidential © 2020 All rights reserved. Designing the Perfect Distributed SQL DB PostgreSQL more popular than MongoDB Aurora much more popular than Spanner bit.ly/distributed-sql-deconstructed Amazon Aurora Google Spanner A highly available MySQL and PostgreSQL-compatible relational database service Not scalable but HA All RDBMS features PostgreSQL & MySQL The first horizontally scalable, strongly consistent, relational database service Scalable and HA Missing RDBMS features New SQL syntax

8 Yugabyte Confidential © 2020 All rights reserved. o YSQL - Fully relational SQL API that is wire compatible with PostgreSQL o YCQL - Optimized Cassandra Query Language API o DocDB – High-performance distributed Document store – Offers strong consistency and multi row ACID transactions Design Follows a Layered Approach

Scaling out PostgreSQL with YugabyteDB

10 © 2019 All rights reserved. All Nodes are Identical … … YugabyteDB Query Layer YugabyteDB Query Layer YugabyteDB Query Layer DocDB Storage Layer DocDB Storage Layer DocDB Storage Layer Can connect to ANY node Add/remove nodes anytime YugabyteDB Node YugabyteDB Node YugabyteDB Node HASURA

Scaling out GraphQL services: Turbocharged HASURA App HASURA App HASURA HASURA App App r … … YugabyteDB Cluster

12 Yugabyte Confidential © 2019 All rights reserved. Yugabyte Platform Demo

13 Yugabyte Confidential © 2019 All rights reserved. What’s next for Yugabyte + Hasura?

14 Yugabyte Confidential © 2020 All rights reserved. Building Geo-Distributed GraphQL services ● Scalable & Highly Available data tier ● Business Continuity ● Geo-Partitioning & Data Compliance

15 © 2018 All rights reserved. Scaling Without Load Balancers Yugabyte Cluster Awareness for Hasura GraphQL Load Balancers Hasura Hasura Hasura Connection Pool Hasura r YugabyteDB Cluster

Scalable, Distributed GraphQL Subscriptions ● Integrates with YugabyteDB Change Data Capture (CDC) ● Use Cases ○ Fraud Detection ○ Real Time Dashboards ○ Event Driven architectures Distributed DB Log Search Index Kakfa Streams GraphQL subscriptions Realtime Push notifications

17 © 2019 All rights reserved. Join the community yugabyte.com/slack We stars! github.com/yugabyte/yugabyte-db We’re Hiring! bit.ly/yugabyte-careers

18 Yugabyte Confidential © 2020 All rights reserved. The default database for the cloud Thank You!