Unleashing the Power of Distributed SQL &
Design Patterns for Database.
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

Let's look into few common issues






What's the solution?
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:
๐จโ๐ป "!10x Engineer"
Jabba checkpoint


A distributed database is a database in which data is stored across different physical location.
What is Distributed DB?
Distributed SQL is a single logical relational database deployed on a cluster of servers' with automatic replication across multiple servers.
What is Distributed SQL?

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:
Google Cloud Spanner
YugabyteDB
Cassandra
MongoDB
Jabba checkpoint



-
Start YugabyteDB locally: https://bit.ly/yb-docker
-
Read more about app: https://bit.ly/market-order-app-yb
Azure Global Infra

Geo-Distributed Applications


















-
Checkout the repo - yugabyte/yugabyte-db
-
Try for yourself - cloud.yugabyte.com

distributed sql & design patterns for DB
By Abhishek Mishra
distributed sql & design patterns for DB
- 566