skills.rest
imMamdouhaboammar
imMamdouhaboammarCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

agency-gaussdb-expert-engineer

Provides architectural and performance-tuning guidance for GaussDB OLTP distributed and centralized databases.

Updated Jul 24, 2026
Search Tags:#architecture#performance#database#sql#distributed#oltp#gaussdb
One-click install
npx skills add https://github.com/imMamdouhaboammar/kaku-chatgpt-harness --skill agency-gaussdb-expert-engineer
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: agency-gaussdb-expert-engineer
Source: https://github.com/imMamdouhaboammar/kaku-chatgpt-harness/tree/main/.agents/skills/engineering-gaussdb-expert
Command: npx skills add https://github.com/imMamdouhaboammar/kaku-chatgpt-harness --skill agency-gaussdb-expert-engineer

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill addresses the complexity of managing Huawei's GaussDB OLTP database by providing expert guidance on distributed architecture, performance tuning, and high-availability design, preventing common pitfalls like data skew and inefficient query plans.

Core Features & Use Cases

  • Distributed Schema Design: Expert advice on distribution keys, partition strategies, and co-located joins to maximize MPP performance.
  • Performance Optimization: Deep analysis of EXPLAIN ANALYZE plans, streaming operator interpretation, and UStore vs AStore engine selection.
  • Use Case: A developer needs to migrate a legacy application to GaussDB and requires a schema design that leverages distributed parallelism while ensuring financial-grade high availability.

Quick Start

Analyze the provided SQL query plan for potential streaming operator bottlenecks and suggest distribution key optimizations.

Frequently Asked Questions about agency-gaussdb-expert-engineer

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

FAQPage Schema
How do I design distributed tables in GaussDB to maximize MPP performance?▼

Distributed table design in GaussDB requires selecting optimal distribution keys and partition strategies to enable co-located joins. This maximizes MPP performance by ensuring efficient parallel query execution across nodes without excessive data movement.

Why does my GaussDB query plan show streaming operator bottlenecks?▼

Streaming operator bottlenecks in GaussDB query plans typically occur when distribution keys cause data skew or prevent co-located joins. Analyzing EXPLAIN ANALYZE plans helps identify these cross-node data redistribution overheads and suggests distribution key optimizations.

When should I use UStore vs AStore storage engines in GaussDB?▼

UStore vs AStore storage engine selection in GaussDB depends on your workload requirements. UStore optimizes update-heavy OLTP operations with in-place updates, while AStore benefits append-only workloads, directly impacting overall database performance and transaction efficiency.

How do I configure financial-grade high availability and zero-downtime failover in GaussDB?▼

Configuring financial-grade high availability in GaussDB involves setting up zero-downtime failover mechanisms across distributed nodes. This ensures continuous transaction processing during node failures, satisfying strict reliability requirements for critical OLTP database systems.

What is the best way to migrate a legacy application to a GaussDB distributed database?▼

Migrating a legacy application to GaussDB requires schema redesign to leverage distributed parallelism alongside high availability configuration. This involves evaluating distribution keys and partition strategies to prevent data skew during the OLTP transition.

Does GaussDB OLTP support centralized and distributed deployment architectures?▼

GaussDB OLTP supports both centralized and distributed deployment architectures. This allows flexible scaling from single-node setups to distributed MPP clusters, enabling tailored high-availability and performance tuning for specific workload demands.

Related Skills

Explore More Software Engineering Skills→
masermediagroup-stackmasermediagroup-stack
1

optimizing-sql

Analyze SQL execution plans and apply indexing strategies across PostgreSQL, MySQL, and SQL Server.

Community
Advanced
rudi-bruchezrudi-bruchez

sqlserver-high-availability

Manage and monitor SQL Server high availability and disaster recovery solutions.

Community
Advanced
RigohlRigohl

lnx-distributed-setup

Configures a fault-tolerant LNX distributed search cluster with Raft consensus and shard replication.

Community
Advanced
heysuhasheysuhas
2

serving-llms-vllm

Deploy LLM inference servers with the vLLM engine and OpenAI-compatible APIs.

Community
Advanced