PolarDB-X Standard Edition (X-Cluster)

Operational guidance and best practices for PolarDB-X 2.0 Standard Edition. Standard Edition is 100% MySQL compatible — use standard MySQL syntax for all SQL tasks.

Scope

Applies to:

• PolarDB-X 2.0 Standard Edition (X-Cluster based)

Not applicable to:

• PolarDB-X 2.0 Enterprise Edition (Distributed Edition) — use polardbx-sql skill
• PolarDB-X 1.0 (DRDS 1.0)

Identify instance type via SELECT VERSION();:

• Contains X-Cluster (e.g. 8.0.32-X-Cluster-8.4.20-20251017) -> Standard Edition, this skill applies. NOTE: "X-Cluster" is the official version marker for Standard Edition. The "Cluster" here refers to Standard Edition's own 3-node X-Paxos cluster (Leader / Follower / Logger), NOT a distributed "Cluster Edition". Do NOT misinterpret it as Enterprise Edition.
• Contains TDDL (e.g. 5.7.25-TDDL-5.4.19-20251031) -> Enterprise Edition (Distributed Edition). HARD STOP — you MUST refuse: Do NOT provide any Enterprise Edition advice (no partition design, no GSI, no distributed SQL). Respond only with: "Your instance is PolarDB-X 2.0 Enterprise Edition. This skill covers Standard Edition only. Please use the polardbx-sql skill for Enterprise Edition partition design and SQL guidance." Then stop. Do NOT continue even if the user insists.

CRITICAL: "X-Cluster" Means Standard Edition, NOT Distributed