skills.rest
oceanbase
oceanbaseOFFICIAL
Explore all skills by this author →
Website𝕏@OceanBaseDBGitHub

obproxy-routing-troubleshooting

Diagnose OBProxy routing and connection configuration issues across deployments.

161|40|Updated Nov 22, 2022
Search Tags:#troubleshooting#routing#observer#obproxy#proxyconfig#rs_list#cluster-not-exist
One-click install
npx skills add https://github.com/oceanbase/obdiag --skill obproxy-routing-troubleshooting
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: obproxy-routing-troubleshooting
Source: https://github.com/oceanbase/obdiag/tree/main/plugins/agent/skills/obproxy-routing-troubleshooting
Command: npx skills add https://github.com/oceanbase/obdiag --skill obproxy-routing-troubleshooting

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

OBProxy/ODP routing and connection configuration issues can disrupt traffic, lead to incorrect routing, or cause authentication problems.

Core Features & Use Cases

  • Troubleshoot OBProxy routing, weak-read and read-write separation, tenant/cluster resolution, and proxy configuration issues.
  • Interpret relevant logs and guide corrective actions across OBProxy deployments.
  • Use-case: When clients experience "cluster not exist" or "Unknown thread id" errors, follow SOP to identify root cause and apply changes safely.

Quick Start

Follow the SOP to diagnose and resolve OBProxy routing issues across OBProxy/ODP deployments.

Frequently Asked Questions about obproxy-routing-troubleshooting

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

FAQPage Schema
How do I troubleshoot an OBProxy cluster-not-exist error?▼

To troubleshoot an OBProxy cluster-not-exist error, validate your proxy configurations, verify rs_list accuracy, and check proxyro settings to ensure proper tenant and cluster parsing.

Why does OBProxy return a 2013 error during read/write separation?▼

An OBProxy 2013 error during read/write separation often indicates incorrect routing or connection configuration, requiring you to validate proxy configurations and interpret relevant logs to guide corrective actions.

How do I validate rs_list accuracy for OBProxy routing issues?▼

Validate rs_list accuracy for OBProxy routing by checking proxyro settings and proxyconfig adjustments to ensure the proxy correctly resolves the cluster and routes traffic without disruption.

What is the best way to fix weak read routing failures in OBProxy?▼

Fix weak read routing failures in OBProxy by following the standard SOP to diagnose routing configurations, verify tenant and cluster resolution, and apply proxyconfig changes safely.

Does OBProxy work with SHOW CREATE compatibility troubleshooting?▼

Yes, OBProxy troubleshooting covers SHOW CREATE compatibility issues, delivering concrete steps and checks to resolve common routing and connection configuration problems across deployments.

Related Skills

Explore More Software Engineering Skills→
oceanbaseoceanbase
161

obproxy-log-analysis

Gather, unpack, and analyze OBProxy diagnosis, error, and slow logs.

Official
Intermediate
theslashdojotheslashdojo

reverse-proxy

Configure nginx reverse proxy with upstream groups, headers, and WebSocket support.

Official
Intermediate
changgengluchanggenglu

database-architect

Design scalable database architectures and optimized schemas for MySQL and PostgreSQL.

Community
Advanced
DorianGalloDorianGallo
5

http-host-header-attacks

Test HTTP Host header trust for redirect, cache, SSRF, and vhost bypass.

Community
Advanced