Skip to main content

Secondary Indexes: Local vs Global

This generated surface maps a learner-facing curriculum unit to its canonical source routes.

Curriculum surface​

  • Open learner-facing unit
  • Curriculum path: content/curriculum/architecture/semester-06-databases-distributed/module-03-replication-partitioning/concepts/cluster-04-partitioning-strategies/11-secondary-indexes-in-partitioned-data-local-versus-global-primary.md
  • App: architecture
  • Semester: semester-06-databases-distributed
  • Module: module-03-replication-partitioning
  • Unit kind: concept
  • Curation level: module_curated

Learning objectives​

  • Explain Secondary Indexes: Local vs Global in terms of topology, failure handling, and scaling tradeoffs instead of feature lists.
  • Use Secondary Indexes: Local vs Global to predict what breaks or changes when data is copied, partitioned, or rebalanced across nodes.
  • Use database-internals, database-system-concepts, ddia to connect the learner page to lag, routing, quorums, hotspots, and operational reality.

Prerequisites​

  • Comfort with storage-engine basics, indexing, and single-node database tradeoffs from the earlier modules.

Source books​

  • database-internals
  • database-system-concepts
  • ddia

Source routes​

Database Internals​

Database System Concepts​

Ddia​

Supporting curriculum routes​

No supporting curriculum routes linked yet.

External enrichment​

  • PostgreSQL Documentation: Replication (official_docs_companion) - Useful when the learner needs an implementation-backed view of leader/follower replication and lag-related tradeoffs.
  • Jepsen Analyses (optional_deep_dive) - Provides concrete failure stories that sharpen the learner’s understanding of replication and partitioning tradeoffs.

AI companion modes​

  • Explain simply
  • Socratic tutor
  • Challenge my understanding
  • Diagnose my confusion
  • Connect forward / backward

Source-of-truth note​

This teaching unit is learner-facing guidance assembled from multiple canonical book routes. Use the listed source books as the primary conceptual spine for Secondary Indexes: Local vs Global, and treat outside material as supporting enrichment only.