skills.rest
ivanshamaev
ivanshamaevCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

starrocks-admin-backup-restore

Automate StarRocks snapshot backups and restores across clusters.

14|1|Updated May 5, 2026
Search Tags:#disaster recovery#restore#backup#s3#snapshot#starrocks#hdfs
One-click install
npx skills add https://github.com/ivanshamaev/de-agent-skills --skill starrocks-admin-backup-restore
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: starrocks-admin-backup-restore
Source: https://github.com/ivanshamaev/de-agent-skills/tree/main/group_skills/starrocks_group_skills/starrocks_admin_backup_restore
Command: npx skills add https://github.com/ivanshamaev/de-agent-skills --skill starrocks-admin-backup-restore

SYSTEM DOCUMENTATION & REQUIREMENTS

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.

Frequently Asked Questions about starrocks-admin-backup-restore

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I back up StarRocks OLAP tables to S3 for disaster recovery?▼

Back up StarRocks OLAP tables to S3 by registering a remote repository and executing the BACKUP SNAPSHOT command. You can take full database or partition-scoped backups and monitor progress with SHOW BACKUP until completion.

Can I restore specific partitions from a StarRocks snapshot into a different cluster?▼

You can restore specific partitions from a StarRocks snapshot into a different cluster using the RESTORE command. This cross-cluster restore requires the correct backup_timestamp and repository access for validation or migration scenarios.

How does snapshot-based backup work in StarRocks for pseudo-incremental strategies?▼

Snapshot-based backup in StarRocks works by capturing full database or table states at a specific timestamp. For pseudo-incremental strategies, you can back up only selected partitions instead of the entire dataset to save storage and time.

Does StarRocks backup and restore support Kerberos-secured HDFS repositories?▼

StarRocks backup and restore supports Kerberos-secured HDFS repositories for remote storage. You can register these endpoints via CREATE REPOSITORY and verify access patterns before executing snapshot creation or restore workflows.

What is the required backup_timestamp used for during a StarRocks restore job?▼

The required backup_timestamp identifies the exact snapshot state to recover during a StarRocks restore job. Enforcing this constraint ensures you restore the correct data version into the target database or cluster environment.

How do I monitor async StarRocks backup and restore job progress?▼

Monitor async StarRocks backup and restore job progress using the SHOW BACKUP and SHOW RESTORE commands. These polling queries track job states until completion or failure, ensuring your disaster recovery workflow finishes successfully.

Related Skills

Explore More Software Engineering Skills→
partme-aipartme-ai
610

cloud-aws-s3

Create and configure AWS S3 buckets with access control policies.

Official
Intermediate
jeremylongshorejeremylongshore
2.6k

fairdb-backup-manager

Automate FairDB PostgreSQL backup and recovery with pgBackRest and Wasabi S3.

Community
Advanced
williamzujkowskiwilliamzujkowski
6

PostgreSQL Database Architect

Plan and optimize PostgreSQL architectures for OLTP and OLAP workloads.

Community
Advanced
ivanshamaevivanshamaev
14

starrocks-data-quality-guardian

Run SQL-based freshness, duplicate, null, volume drift, integrity, and completeness checks on StarRocks tables.

Community
Advanced