Using YugabyteDB Colocated Tables to Speed Up Joins
Learn how colocated tables keep related rows on the same tablet, removing cross‑shard network hops for joins, with a worked example, limits, and common pitfalls.
Loading…
ReadMeFeed / Community knowledge
Yugabytedb
Real questions. Useful conversations. Find the people who know your stack.
Yugabytedb
Databases & messaging · #yugabytedb
Zero-downtime ALTER TABLE in YugabyteDB and where it stops being online
YugabyteDB 2.12+ can run ADD COLUMN and similar DDL online by keeping dual schema versions and coordinating the change across tablets with two-phase commit, with limits for primary key and data type rewrites.
Diagnosing YugabyteDB SQLSTATE 40001 Read Restart Errors
A diagnostic guide for YugabyteDB SQLSTATE 40001 read restart errors, covering MVCC conflict detection, ordered cluster checks, targeted fixes, and escalation criteria.
YugabyteDB Cross-Tablet Transactions: Raft, HLC, and 2PC Design Boundaries
A cross-tablet transaction in YugabyteDB cannot commit on one disk. This architecture note explains how Raft groups, leaseholders, and a two-phase commit variant preserve atomicity, what to inspect with yb-admin, and when clock skew or hotspotting changes the design.
Geo-Partitioning in YugabyteDB: Keeping Rows Close to the Users Who Own Them
Geo-partitioning in YugabyteDB pins table partitions to regional tablespaces so writes reach consensus locally instead of across oceans — here's the DDL, the verification steps, and the availability trade-off.
YugabyteDB Synchronous Multi-AZ Architecture: Requirements, Minimal Design, and Operational Boundaries
Architecture note for YugabyteDB synchronous multi-AZ deployment: 3-node RF=3 design, Raft quorum boundaries, operational metrics, failure modes, and triggers for design changes (async xCluster, follower reads, placement policies).
Cutting Read Latency in YugabyteDB with Follower Reads
Learn how YugabyteDB’s follower reads let any replica serve reads, cutting multi-region latency while accepting bounded staleness.
Cutting Cross-Region Read Latency with YugabyteDB Follower Reads and Bounded Staleness
YugabyteDB follower reads let nearby replicas serve SELECTs with a bounded staleness guarantee, cutting cross-region read latency. Here's how to configure, verify, and size the trade-off.
Choosing Synchronous vs. Asynchronous Replication in YugabyteDB: A Decision Guide
Learn how to pick the right replication mode for a multi‑node YugabyteDB cluster by weighing durability, latency, and operational impact, then see a concrete xCluster setup and validation.