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.