---
title: "Discussion on \"Distributed databases: partitioning, replication and CAP\" | Hashnode"
description: "Discussion on \"Distributed databases: partitioning, replication and CAP\". Partition, replicate and run two-phase commit in PostgreSQL and MySQL by hand, then see what the CAP theorem really says. Every example tested."
url: "https://hashnode.com/posts/distributed-databases-partitioning-replication-and-cap/6afe2779f4404a90f4daf289"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Distributed databases: partitioning, replication and CAP](https://pedbad.hashnode.dev/distributed-databases-partitioning-replication-and-cap?utm_source=hashnode&utm_medium=feed)

Partition, replicate and run two-phase commit in PostgreSQL and MySQL by hand, then see what the CAP theorem really says. Every example tested.

2d ago · 45 min read · pedbad.hashnode.dev  
Read the article

-   [#databases](https://hashnode.com/tag/databases)
-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#mysql](https://hashnode.com/tag/mysql)
-   [#distributed-systems](https://hashnode.com/tag/distributed-systems)

## Written by

[Pedram Badakhchani](https://hashnode.com/@pedbad)

@pedbad · London, UK

  
[View profile](https://hashnode.com/@pedbad)

Head of eLearning, University of Cambridge Language Centre · Full-stack developer & AI engineer · Online tutor, UoL BSc Computer Science

Head of eLearning at the University of Cambridge Language Centre, full-stack developer and AI engineer, and online tutor on the BSc Computer Science from Goldsmiths, University of London, on Coursera. I started out in neuroscience research before moving into web development, and have spent over twenty years building digital learning at Cambridge. This blog is my supplementary material for students on the BSc: set-up guides, explanations of the ideas that trip people up, and worked examples. New here? Click Website above for my Start here page and module guides.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
