# 虚谷数据库高可用与备份恢复

> |

- **Type:** Skill
- **Install:** `agentstack add skill-kourou25-xugudb-dev-skills-xugudb-ha`
- **Verified:** Yes — security-reviewed for prompt injection and unsafe behavior
- **Seller:** [kourou25](https://agentstack.voostack.com/s/kourou25)
- **Installs:** 0
- **Category:** [Agent Skills](https://agentstack.voostack.com/c/agent-skills)
- **Latest version:** 0.1.0
- **License:** Apache-2.0
- **Upstream author:** [kourou25](https://github.com/kourou25)
- **Source:** https://github.com/kourou25/xugudb-dev-skills/tree/master/skills/xugudb-ha

## Install

```sh
agentstack add skill-kourou25-xugudb-dev-skills-xugudb-ha
```

Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent.

## About

# 虚谷数据库高可用与备份恢复

## 概述

虚谷数据库（XuguDB）基于 Shared-Nothing 多副本架构，提供从单机房到两地三中心的多级高可用方案，配合完善的备份恢复机制和日志体系，保障数据安全与业务连续性。

## 高可用架构

XuguDB 支持四种高可用部署方案：

| 方案 | 架构 | RPO | RTO | 适用场景 |
|------|------|-----|-----|----------|
| 数据中心部署 | 存算分离 + 管理双活 | 0 | 秒级 | 单机房高可用 |
| 同城双活 | 对称双中心，实时双向同步 | 0 | 秒级 | 跨机房负载均衡 |
| 同城灾备 | 主备中心，Binlog 增量同步 | 0 |  0）
RESTORE SYSTEM FROM '/BACKUP/SYS.DMP' UNTIL TIME '2025-12-31 23:59:59.999';
```

### 逻辑备份（库/用户/模式/表级）

```sql
-- 库级备份/恢复
BACKUP DATABASE TO '/BACKUP/DB.EXP';
RESTORE DATABASE db_name FROM '/BACKUP/DB.EXP';

-- 用户级备份/恢复
BACKUP USER user_name TO '/BACKUP/USR.EXP';
RESTORE USER user_name FROM '/BACKUP/USR.EXP';

-- 模式级备份/恢复
BACKUP SCHEMA schema_name TO '/BACKUP/SCH.EXP';
RESTORE SCHEMA schema_name FROM '/BACKUP/SCH.EXP';

-- 表级备份/恢复
BACKUP TABLE tab_name TO '/BACKUP/TB.EXP';
RESTORE TABLE tab_name FROM '/BACKUP/TB.EXP';

-- 表级恢复并改名
RESTORE TABLE tab_name RENAME TO new_name FROM '/BACKUP/TB.EXP';
```

## 集群管理快速参考

```sql
-- 查看集群状态
SHOW CLUSTERS;
SELECT * FROM SYS_CLUSTERS;

-- 添加节点
ALTER CLUSTER ADD NODE 4 DESCRIBE 'RACK=0001 PORTS="192.168.2.236:19114" ROLE=SQW LPU=3 STORE_WEIGHT=3 STATE=DETECT';

-- 下线节点（V12+）
ALTER CLUSTER SET NODE 4 OFFLINE;

-- 删除节点（需先下线）
ALTER CLUSTER DROP NODE 4;

-- 检查版本修复状态
SELECT COUNT(*) FROM SYS_GSTORES WHERE store_sta != 41;

-- 清除降级标志
SET CLUSTER_FAULT_LEVEL TO 0;
```

## 日志文件总览

| 日志 | 路径 | 用途 |
|------|------|------|
| ERROR.LOG | /Server/XGLOG/ | 错误和异常信息，故障排查 |
| EVENT.LOG | /Server/XGLOG/ | 关键事件（启停、备份、集群变更） |
| TRACE.LOG | /Server/XGLOG/ | 内部执行路径，深度调试 |
| COMMAND.LOG | /Server/XGLOG/ | 所有 SQL 语句记录 |
| SLOWSQL.LOG | /Server/XGLOG/ | 慢 SQL 分析 |
| stdout.txt | /Server/BIN/ | 标准输出，容器环境日志 |

## 参考文档

- [高可用架构](references/ha-architecture.md) - 数据中心/同城双活/同城灾备/两地三中心部署方案
- [备份恢复](references/backup-recovery.md) - 物理备份、逻辑备份、各级别备份恢复语法与示例
- [集群管理](references/cluster-management.md) - 节点角色、状态查看、扩缩容、降级与故障恢复
- [日志管理](references/log-management.md) - 各类日志文件格式、级别与使用场景
- [回收站](references/recycle-bin.md) - 回收站开关、表恢复与清理操作

## Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

- **Author:** [kourou25](https://github.com/kourou25)
- **Source:** [kourou25/xugudb-dev-skills](https://github.com/kourou25/xugudb-dev-skills)
- **License:** Apache-2.0

Install and usage instructions live in the source repository linked above.

## Pricing

- **Free** — Free

## Security capabilities

Automated source analysis of v0.1.0 — what this tool can access:

- **Network access:** no
- **Filesystem access:** no
- **Shell / process execution:** no
- **Environment & secrets:** no
- **Dynamic code execution:** no

*"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.*


## Versions

- **0.1.0** — security scan: passed — Imported from the upstream source.

## Links

- Listing page: https://agentstack.voostack.com/l/skill-kourou25-xugudb-dev-skills-xugudb-ha
- Seller: https://agentstack.voostack.com/s/kourou25
- Browse the marketplace: https://agentstack.voostack.com/browse

---
Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.