starrocks-admin-backup-restore

What problem does it solve?

This Skill helps you create reliable backup and disaster-recovery restore procedures for StarRocks OLAP tables, preventing data loss from accidents, corruption, or migration issues.

Core Features & Use Cases

• Repository setup for S3/HDFS/NFS: Register remote backup storage endpoints and verify access patterns across AWS S3, S3-compatible stores (e.g., MinIO), and Kerberos-secured HDFS.
• Snapshot-based backup & monitoring: Take full database/table backups, back up only selected partitions for practical pseudo-incremental strategies, and track job progress with SHOW BACKUP until completion or failure.
• Targeted restore for recovery and migration: Restore entire databases, specific tables, or chosen partitions into the same or different clusters, with controls such as backup timestamp, replication factor, and restore job monitoring via SHOW RESTORE.

Example: You need to recover a production OLAP table after accidental deletion and restore only the last month’s partitions into a staging cluster for validation before promoting the fix.

Quick Start

Set up a shared S3 repository, take a partition-scoped backup of your critical OLAP tables, and restore the snapshot into a staging database for validation.