CockroachDB

1. Architecture overview

   Layered architecture: SQL, transaction, distribution, replication and storage.

2. SQL layer

   Parsing, planning, optimization and execution of SQL.

3. Transaction layer

   Serializable isolation, MVCC and distributed transactions.

4. Distribution and replication layers

   Ranges, leaseholders, and Raft replication.

5. Storage layer

   Pebble and MVCC storage.

6. Transactions

   Using transactions, retries and contention.

7. SQL feature support

   Supported SQL and PostgreSQL compatibility.

8. Online schema changes

   Non-blocking schema changes.

9. Multi-region capabilities

   Survival goals, table localities and geo-distribution.

10. Performance best practices

    Schema design, indexing, hotspots and query tuning.

11. Authentication and authorization

    Certificates, passwords, SSO, roles and privileges.

12. Backup and restore

    Full, incremental and scheduled backups.

13. Change data capture

    Streaming row changes with changefeeds.

14. Monitoring and alerting

    DB Console, metrics and alerting.

Each section links to the official page. Titles and summaries by Extra Credit; the docs belong to their authors.

Source: endoflife.date