Table and Region Operations

📄️ Overview

Table and Region operations in GreptimeDB, including basic SQL table operations, table sharding, region migration, region failover, repartition, compaction, and garbage collection.

📄️ Basic Table Operations

Covers basic table operations in GreptimeDB, including creating, describing, showing, altering, and dropping tables, as well as executing SQL statements through the HTTP API and understanding time zone effects.

📄️ Table Sharding

Explains table sharding in GreptimeDB, including when to shard a table, partitioning methods, creating and partitioning distributed tables, inserting data, querying data, and inspecting sharded tables.

📄️ Region Migration

Explanation of how to perform region migration in GreptimeDB, including querying region distribution, selecting a migration destination, executing migration requests, and querying migration states.

📄️ Region Failover

Covers enabling and understanding region failover in GreptimeDB, including prerequisites, WAL-related data loss risks, and the impact of read amplification on recovery time with Kafka WAL.

📄️ Repartition

Explains GreptimeDB repartitioning, including prerequisites, hot partition detection, partition rules, and common Helm Chart configurations.

📄️ Compaction

Explanation of the compaction process in GreptimeDB, including concepts like SST files, time windows, sorted runs, and levels, as well as the Time Windowed Compaction Strategy (TWCS) and Strict Window Compaction Strategy (SWCS).

📄️ Garbage Collection (GC)

GC keeps SST/index files until all references are released, protecting long queries and repartition workflows.