BestHub
Sign in
Tag

OceanBase

0 views collected around this technical thread.

Xiaolei Talks DB
Xiaolei Talks DB
Jun 5, 2025 · Databases

How Zhihu Scaled Its Data Architecture with OceanBase: A Multi‑Database Journey

Zhihu’s evolving data architecture transitioned from a single MySQL setup to a heterogeneous ecosystem of SQL, NoSQL, and graph databases, ultimately adopting OceanBase for its multi‑tenant, high‑compression capabilities, supported by tools like OMS, OCP, and ob‑operator to achieve cost savings, performance gains, and robust operations.

Distributed DatabasesOceanBasePerformance Optimization
0 likes · 12 min read
How Zhihu Scaled Its Data Architecture with OceanBase: A Multi‑Database Journey
Aikesheng Open Source Community
Aikesheng Open Source Community
May 28, 2025 · Databases

Analyzing and Optimizing Slow OceanBase SQL Queries Using TopSQL and Execution Plan Rewrites

This article investigates a slow OceanBase SQL query by examining CPU and TopSQL metrics, dissecting the execution plan, identifying batch join inefficiencies, rewriting the SQL for better performance, and demonstrating a reduction in execution time from over 2600 seconds to under one second.

Batch JoinDatabase PerformanceOceanBase
0 likes · 18 min read
Analyzing and Optimizing Slow OceanBase SQL Queries Using TopSQL and Execution Plan Rewrites
Amap Tech
Amap Tech
May 27, 2025 · Databases

OceanBase Unitization: Building the Next Generation of Online Map Applications

This paper presents the design, implementation, and experimental evaluation of OceanBase's unitization architecture for large‑scale online map services, demonstrating superior disaster‑recovery, high‑throughput OLTP/OLAP performance, and storage efficiency compared with competing distributed databases.

Distributed DatabaseHigh AvailabilityOceanBase
0 likes · 24 min read
OceanBase Unitization: Building the Next Generation of Online Map Applications
Xiaolei Talks DB
Xiaolei Talks DB
May 21, 2025 · Databases

How to Quickly Set Up and Manage OceanBase with the New Desktop Client

This guide walks developers through downloading, installing, and using OceanBase Desktop on macOS, covering dependency setup with OrbStack, GUI features, cluster startup, tenant management, and how the tool simplifies local OceanBase cluster deployment.

Database ManagementDesktopGUI
0 likes · 6 min read
How to Quickly Set Up and Manage OceanBase with the New Desktop Client
Aikesheng Open Source Community
Aikesheng Open Source Community
May 21, 2025 · Databases

Understanding OMS Inmode Validation Anomalies in MySQL‑to‑OceanBase Migration

This article analyzes a puzzling case where data consistency checks between a MySQL source and an OceanBase target report matching results despite visible record differences, explains the OMS ordinary and Inmode validation modes, and outlines scenarios that trigger Inmode verification.

InmodeMySQLOMS
0 likes · 7 min read
Understanding OMS Inmode Validation Anomalies in MySQL‑to‑OceanBase Migration
Xiaolei Talks DB
Xiaolei Talks DB
May 16, 2025 · Databases

How Online DDL Impacts TPS/QPS in OceanBase: A Comprehensive Test

This article details a systematic performance test of OceanBase's online DDL capabilities, measuring TPS and QPS impacts across various DDL operations, describing the test environment, scripts, results, and conclusions for reliable database schema changes.

DatabaseOceanBasePerformance Testing
0 likes · 17 min read
How Online DDL Impacts TPS/QPS in OceanBase: A Comprehensive Test
Aikesheng Open Source Community
Aikesheng Open Source Community
May 7, 2025 · Databases

Differences in Manual Statistics Collection for OceanBase: DBMS_STATS vs ANALYZE Across Versions

This article explains the differences between manual statistics collection methods in OceanBase 3.x and 4.x, compares DBMS_STATS and ANALYZE commands across MySQL and Oracle modes, provides version‑specific tables, detailed code examples for table, partition, and schema level collection, and shows how to verify statistics.

ANALYZEDBMS_STATSOceanBase
0 likes · 9 min read
Differences in Manual Statistics Collection for OceanBase: DBMS_STATS vs ANALYZE Across Versions
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 24, 2025 · Databases

Migrating from PolarDB PostgreSQL to OceanBase (ob_oracle): A Comprehensive Guide

This article presents a step‑by‑step migration plan for moving a PolarDB PostgreSQL 11.9 tenant to an OceanBase 4.2.1.10 Oracle‑compatible tenant, covering background, scope, task distribution, user and permission conversion, table‑structure transformation, DataX data transfer, performance tuning, error handling, monitoring, and final recommendations.

DataXOceanBasePerformance Tuning
0 likes · 14 min read
Migrating from PolarDB PostgreSQL to OceanBase (ob_oracle): A Comprehensive Guide
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 15, 2025 · Databases

Understanding Full-Link Tracing in OceanBase: Concepts, Mechanisms, and Usage

This article explains OceanBase's full‑link tracing feature, covering its definition, internal working principle, trace‑log structure, span and tag details, configuration steps, and how to view trace data via the show‑trace command or the OCP visual interface, helping DBAs quickly diagnose performance issues.

Database PerformanceOCPOceanBase
0 likes · 16 min read
Understanding Full-Link Tracing in OceanBase: Concepts, Mechanisms, and Usage
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 1, 2025 · Databases

Resolving Column Length Expansion Errors in OceanBase: Charset and Collation Considerations

This article explains why altering a column length in OceanBase may trigger an "Alter charset or collation type not supported" error, analyzes the underlying charset and collation settings, and provides a solution that explicitly specifies charset and collation to ensure successful column expansion across versions.

CharsetCollationColumn Expansion
0 likes · 6 min read
Resolving Column Length Expansion Errors in OceanBase: Charset and Collation Considerations
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 26, 2025 · Databases

Analysis of OBLogProxy Failure in Binlog Mode and Its Resolution

This article examines a failure case of OceanBase's OBLogProxy service in Binlog mode, detailing background conditions, status checks, log analysis, the root cause of timestamp mismatches, and provides step‑by‑step remediation procedures to restore normal binlog processing.

DatabaseLogProxyOBLogProxy
0 likes · 10 min read
Analysis of OBLogProxy Failure in Binlog Mode and Its Resolution
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 25, 2025 · Databases

ChatDBA vs DeepSeek: AI‑Driven Diagnosis of OceanBase Backup Cluster Tenant Sync Issue (Case Study)

This case study demonstrates how the AI assistant ChatDBA identifies and resolves a tenant data‑synchronization failure in an OceanBase primary‑backup cluster, detailing four interactive troubleshooting rounds, the final SQL fix, and a comparative analysis with the DeepSeek‑R1 model.

AI AssistantChatDBADatabase Troubleshooting
0 likes · 5 min read
ChatDBA vs DeepSeek: AI‑Driven Diagnosis of OceanBase Backup Cluster Tenant Sync Issue (Case Study)
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 11, 2025 · Operations

Troubleshooting OceanBase No-Leader Alerts Caused by Network Bandwidth Saturation

This article details a step‑by‑step investigation of daily OceanBase no‑leader alerts caused by network bandwidth saturation, covering log analysis, clock synchronization issues, RPC backlog, and provides practical solutions such as bandwidth expansion and backup throttling to restore cluster stability.

Clock SyncNo-LeaderOceanBase
0 likes · 10 min read
Troubleshooting OceanBase No-Leader Alerts Caused by Network Bandwidth Saturation
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 4, 2025 · Databases

Troubleshooting Incremental Data Sync Failure in OceanBase OBLogProxy Binlog Mode

This article details the background, configuration, and step‑by‑step troubleshooting process for a data pipeline that replaces a MySQL source with OceanBase using OBLogProxy in binlog mode, explains why downstream reads missed incremental data, and provides conclusions and optimization measures.

Data SynchronizationDatabase TroubleshootingFlink CDC
0 likes · 12 min read
Troubleshooting Incremental Data Sync Failure in OceanBase OBLogProxy Binlog Mode
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 25, 2025 · Databases

Understanding CPU Allocation Logic in OceanBase 4.x and How to Modify the cpu_count Configuration

This article explains the background of tenant creation failures caused by insufficient CPU resources in OceanBase, details the calculation of usable CPU in version 4.x, shows how to query CPU usage with SQL, describes related configuration parameters, and provides step‑by‑step procedures for modifying cpu_count and testing over‑commit scenarios across different OceanBase versions.

CPUConfigurationDatabase
0 likes · 12 min read
Understanding CPU Allocation Logic in OceanBase 4.x and How to Modify the cpu_count Configuration
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 13, 2025 · Databases

Troubleshooting OceanBase Single‑Node Replica Expansion and Log Disk Size Issues

This article details a step‑by‑step investigation of OceanBase single‑node replica expansion failures, highlighting missing sys‑tenant expansion, deprecated table replica commands, log_disk_size misconfiguration, log‑stream mechanics, and provides concrete SQL and ALTER statements to reproduce and resolve the issue.

Distributed DatabaseOceanBaseTroubleshooting
0 likes · 18 min read
Troubleshooting OceanBase Single‑Node Replica Expansion and Log Disk Size Issues
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 11, 2025 · Databases

OceanBase Timeout During Merge: Diagnosis, Emergency Handling, and Optimization

This article details a timeout incident in an OceanBase cluster during a merge operation, explains the emergency suspension and resumption steps, analyzes log and metric data to identify queue backlog and disk I/O saturation as root causes, and offers practical optimization recommendations.

Database TroubleshootingOceanBasePerformance
0 likes · 6 min read
OceanBase Timeout During Merge: Diagnosis, Emergency Handling, and Optimization
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 16, 2025 · Databases

Diagnosing ORA-06502 "no data found" Errors When Accessing OceanBase LOBs via JDBC

This article explains why JDBC access to OceanBase (Oracle mode) LOB columns can trigger an ORA-06502 "no data found" error, analyzes the driver’s readFromServer implementation, and shows how disabling the useLobLocatorV2 option eliminates the exception.

DBMS_LOBDatabaseJDBC
0 likes · 8 min read
Diagnosing ORA-06502 "no data found" Errors When Accessing OceanBase LOBs via JDBC
Zhihu Tech Column
Zhihu Tech Column
Dec 31, 2024 · Cloud Native

Cloud Native Innovation Forum: AutoMQ Table Topic, OceanBase Integrated Database, and Observability Practices

The article recaps Zhihu's Cloud Native Innovation Forum where experts from AutoMQ, OceanBase, and Flashcat shared practical solutions on streaming data ingestion, unified database architectures, and AI‑driven observability, highlighting real‑world deployments, performance optimizations, and cost‑saving strategies.

AIAutoMQCloud Native
0 likes · 10 min read
Cloud Native Innovation Forum: AutoMQ Table Topic, OceanBase Integrated Database, and Observability Practices