Unleashing the Power of Distributed SQL &
Design Patterns for Database.

An artless introduction to distributed SQL database  

SQL isn't Dead 💀, It's Just Getting Distributed!

What this talk is, and is not !

✅ Trip around bird's eye view on Distributed SQL DB

✅ Distributed SQL DB Architecture

🙅‍♂️ DB internals

🙅‍♂️ Not a tutorial

✅ Quick tour on distributed apps

✅ DB design/deployement patterns for distributed apps

(subtitle - "Hey you duped us")

Elephant in the room- PostgreSQL

https://db-engines.com/en/ranking_trend/relational+dbms

Let's look into few common issues

But why to scale? 🤔

• Increase application performance.
   

• Business needs.

• Ability to expand the capacity of system resources in order to support the changing usage of your application.

• This can refer both to increasing and decreasing usage of the application.

How do I scale?

Horizontal Scaling

• Replication

• Sharding/Partitioning

agenda.sql

Abhishek
Mishra

🥑 Developer Advocate @Yugabyte

🐍 Pythonista

👨‍👩‍👧‍👦 Community first person 💛

connect with me:

@stalwartcoder

👨‍💻 "!10x Engineer"

@stalwartcoder

Jabba checkpoint

A distributed database is a database in which data is stored across different physical location.

Distributed SQL is a single logical relational database deployed on a cluster of servers' with automatic replication across multiple servers.

Distributed SQL DB Architecture

Distributed SQL DB has

• A SQL API for accessing and manipulating data and objects.

• Automatic distribution of data across nodes in a cluster.

• Automatic replication of data in a strongly consistent manner.

• Support for distributed query execution so clients do not need to know about the underlying distribution of data.

• Support for distributed ACID transactions.

Examples:

Jabba checkpoint

Cloud Spanner

Cloud Spanner

https://cloud.google.com/spanner/

• Resilient to failures and continuously available
   

• Horizontally scalable 
   

• Geographically distributed 
   

• SQL and RDBMS feature compatible  
   

• Hybrid and Multi-cloud ready

*me after using distributed SQL*

(subtitle- "what a rad thing is this, my whole system is shaken")

*magic of distributed SQL*

• Start YugabyteDB locally: https://bit.ly/yb-docker

• Read more about app:
  https://bit.ly/market-order-app-yb

https://infrastructuremap.microsoft.com/

Azure Global Infra

Geo-Distributed Applications

Talk is cheap, show me the demo!

@stalwartcoder

• Checkout the repo -  yugabyte/yugabyte-db

• Try for yourself - cloud.yugabyte.com

Access Slide: https://slides.com/abhishek-mishra/