
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

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


Cloud Spanner
Cloud Spanner
-
Relational database, built for scale.
-
High availability.
Automatic database sharding.



*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
Azure Global Infra

Geo-Distributed Applications



















Talk is cheap, show me the demo!


Β
-
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
- 549