BestHub
Sign in
Tagged articles
235 articles
Page 1 of 3
Java Companion
Java Companion
Apr 26, 2026 · Databases

Is Sharding Ready to Retire? Why the Classic Split‑Database Approach Is Becoming Legacy

The article reviews the rise and decline of traditional database sharding, explains its technical pitfalls such as wrong shard keys, cross‑database joins, and distributed transactions, compares it with emerging NewSQL solutions like TiDB, OceanBase and PolarDB‑X, and offers practical criteria for choosing the right architecture.

NewSQLOceanBasePolarDB-X
0 likes · 14 min read
Is Sharding Ready to Retire? Why the Classic Split‑Database Approach Is Becoming Legacy
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 10, 2025 · Databases

Why OceanBase DDL Expansion Can Crash Your Service and How to Fix It

A production migration from Oracle to OceanBase caused a column‑length change to trigger offline DDL, leading to connection errors, INSERT latency spikes, and complete table blockage; the article reproduces the fault, analyzes the OMS conversion and OceanBase DDL rules, and provides a two‑step remediation and a method to verify online DDL execution.

DDLOceanBaseOffline DDL
0 likes · 11 min read
Why OceanBase DDL Expansion Can Crash Your Service and How to Fix It
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 9, 2025 · Frontend Development

How I Built an AI-Powered OceanBase Parameter Comparison Web App in Under an Hour

The author describes using an AI code‑assistant to quickly create a web page that lists all released OceanBase versions, extracts their default parameter files from the source code, and highlights differences between selected versions, all without writing any manual code and deploying it on GitHub Pages.

GitHub PagesOceanBaseParameter Comparison
0 likes · 5 min read
How I Built an AI-Powered OceanBase Parameter Comparison Web App in Under an Hour
dbaplus Community
dbaplus Community
Dec 2, 2025 · Databases

Adapting goInception for OceanBase MySQL: Full Guide with Python Integration

This article walks through the challenges of using goInception with OceanBase‑MySQL tenants, details the code modifications required to parse OB's Query Plan, shows how to expose the enhanced engine via a Python wrapper, and presents validation results demonstrating accurate, low‑latency SQL auditing.

OB-MySQLOceanBasePython
0 likes · 10 min read
Adapting goInception for OceanBase MySQL: Full Guide with Python Integration
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 26, 2025 · Databases

Why INSERT…SELECT Slows Down on OceanBase and How to Fix It

During an Oracle‑to‑OceanBase migration, a client encountered extremely slow INSERT…SELECT batch jobs due to a global unique non‑partitioned index, and the article walks through extracting logical and physical plans, pinpointing the bottleneck operators, and demonstrates converting the index to a partitioned one to cut execution time from over 30 minutes to 14 minutes.

INSERT SELECTIndex TuningOceanBase
0 likes · 16 min read
Why INSERT…SELECT Slows Down on OceanBase and How to Fix It
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 29, 2025 · Databases

Why Does the Same SQL Run Faster on Oracle Than on OceanBase? Uncovering Execution Plan Discrepancies

A customer observed a SQL statement that runs twice as fast on Oracle as on OceanBase, prompting a detailed analysis of execution plans, leader distribution, and distributed query behavior, followed by practical hint and table‑group optimizations that reduce the runtime from several seconds to sub‑second levels.

OceanBaseSQL OptimizationTable Group
0 likes · 18 min read
Why Does the Same SQL Run Faster on Oracle Than on OceanBase? Uncovering Execution Plan Discrepancies
AntTech
AntTech
Oct 26, 2025 · Databases

How LCL+ Boosts Distributed Database Performance with One‑Victim Deadlock Resolution

The OceanBase team’s LCL+ algorithm, a lock‑chain‑length based distributed deadlock detection and elimination method, eliminates the need for a global wait‑for graph, achieves single‑victim unlocks, and dramatically improves throughput while reducing tail latency in production database clusters.

Deadlock DetectionOceanBasedatabase algorithms
0 likes · 7 min read
How LCL+ Boosts Distributed Database Performance with One‑Victim Deadlock Resolution
ITPUB
ITPUB
Oct 11, 2025 · Databases

How OceanBase Achieves Real‑Time HTAP: Inside Its Unified Storage and Vectorized Engine

This article details OceanBase's evolution from a distributed OLTP system to a unified HTAP database, covering its cost‑based optimizer, vectorized execution, integrated row‑column storage, bypass import, materialized views, external tables, full‑text search, and real‑world use cases for real‑time analytics.

Columnar StorageHTAPOceanBase
0 likes · 12 min read
How OceanBase Achieves Real‑Time HTAP: Inside Its Unified Storage and Vectorized Engine
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 9, 2025 · Databases

Unlocking OceanBase Thread Limits: How min_worker_cnt and max_worker_cnt Are Calculated

This article explains why OceanBase enforces minimum values for min_worker_cnt and max_worker_cnt, shows the source‑code formulas used to compute them, demonstrates how to verify and adjust these parameters, and clarifies the impact of tenant memory and Meta‑tenant reservations on the final values.

Database ConfigurationOceanBaseParameter Tuning
0 likes · 12 min read
Unlocking OceanBase Thread Limits: How min_worker_cnt and max_worker_cnt Are Calculated
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 2, 2025 · Databases

How to Speed Up Slow SQL Queries: Choosing Driver Tables and Join Strategies

This article analyzes a slow SQL query by examining driver tables, execution plans, and table row counts, then demonstrates three optimization approaches—setting a small table as driver, setting a large table as driver, and switching to hash joins—showing their impact on execution time and providing practical guidelines for selecting the best strategy.

Driver TableHash JoinOceanBase
0 likes · 16 min read
How to Speed Up Slow SQL Queries: Choosing Driver Tables and Join Strategies
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 19, 2025 · Databases

How OceanBase CPU Quotas and Large Queries Shape Performance

This article explores OceanBase v4 CPU‑related parameters such as workers_per_cpu_quota, cpu_quota_concurrency, and parallel_servers_target, explains their formulas, demonstrates experimental setups and results on tenant thread limits, large‑query impact, and provides practical tuning recommendations based on observed performance data.

Database ConcurrencyOceanBasecpu quota
0 likes · 17 min read
How OceanBase CPU Quotas and Large Queries Shape Performance
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.

Multi‑TenantOceanBasePerformance 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.

OceanBaseOnline MapsPerformance Evaluation
0 likes · 24 min read
OceanBase Unitization: Building the Next Generation of Online Map Applications
AntTech
AntTech
May 23, 2025 · Databases

OceanBase Breaks Records at ICDE 2025 with Six Papers and a Best Industry Award

At ICDE 2025 in Hong Kong, OceanBase showcased six accepted papers—including a Best Industry and Application Paper Runner‑Up award—while also hosting a technical symposium on AI‑era databases and presenting detailed abstracts on distributed database innovations, secure query processing, federated learning, hypergraph clustering, query equivalence, and cardinality‑estimation workload generation.

AIDatabase ResearchICDE 2025
0 likes · 12 min read
OceanBase Breaks Records at ICDE 2025 with Six Papers and a Best Industry Award
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.

OceanBaseOnline DDLQPS
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.

DataXOceanBasePolardb
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 PerformanceFull‑Link TracingOCP
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.

CharsetColumn ExpansionOceanBase
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 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 SyncNetwork BandwidthNo-Leader
0 likes · 10 min read
Troubleshooting OceanBase No-Leader Alerts Caused by Network Bandwidth Saturation
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.

CPUConfigurationOceanBase
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.

Log ManagementOceanBaselog_disk_size
0 likes · 18 min read
Troubleshooting OceanBase Single‑Node Replica Expansion and Log Disk Size Issues
ITPUB
ITPUB
Jan 7, 2025 · Databases

Cut Costs 25% and Boost Performance 70%: Retail Giant’s OceanBase Migration

The article details how WanJia Shuke, the tech arm of China Resources Vanguard, tackled retail system fragmentation, user‑experience degradation, complex linkages and scalability limits by migrating dozens of projects to the distributed OceanBase database, achieving up to 70% performance improvement, 25% cost reduction and streamlined operations.

FlinkOceanBaseRetail
0 likes · 15 min read
Cut Costs 25% and Boost Performance 70%: Retail Giant’s OceanBase Migration
ITPUB
ITPUB
Jan 2, 2025 · Databases

How OceanBase Partitioning Supercharged KPOS Report Performance

This article details the background, challenges, and technical solutions behind the partitioning redesign of the KPOS reporting system on OceanBase, covering deployment choices, parameter tuning, data migration, phased rollout, performance gains, encountered issues, and future scaling plans.

Data MigrationDeployment StrategiesOceanBase
0 likes · 26 min read
How OceanBase Partitioning Supercharged KPOS Report Performance
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
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 30, 2024 · Databases

Seven-Step Guide to Diagnose OceanBase Cluster Login "Access Denied" Errors

This article presents a systematic seven‑step troubleshooting procedure for the common "Access denied" login error when connecting to an OceanBase cluster, covering password verification, network connectivity, user privileges, client compatibility, tenant parameters, obproxy logs, and configuration checks.

AccessDeniedDatabaseTroubleshootingLoginError
0 likes · 6 min read
Seven-Step Guide to Diagnose OceanBase Cluster Login "Access Denied" Errors
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 10, 2024 · Databases

Random Data Source Selection Issue When Adding Replicas in OceanBase 4.2.1.4 and Its Solutions

An OceanBase 4.2.1.4 deployment experienced random selection of data sources when adding tenant replicas, causing cross‑city bandwidth congestion; the article reproduces the issue, analyzes its cause, and presents three remediation methods—including setting the choose_migration_source_policy parameter, manual replica addition, and temporary network isolation.

DataMigrationDatabaseConfigurationDisasterRecovery
0 likes · 9 min read
Random Data Source Selection Issue When Adding Replicas in OceanBase 4.2.1.4 and Its Solutions
Xiaolei Talks DB
Xiaolei Talks DB
Dec 6, 2024 · Databases

Unlocking OceanBase: How Its Open‑Source Ecosystem Powers Modern Databases

OceanBase’s open‑source ecosystem—spanning data migration tools, developer utilities, a database proxy, and robust operational management—delivers comprehensive, open, and compatible support that enhances development, migration, and maintenance, positioning it as a competitive enterprise‑grade distributed relational database.

Data MigrationDatabase EcosystemHTAP
0 likes · 8 min read
Unlocking OceanBase: How Its Open‑Source Ecosystem Powers Modern Databases
vivo Internet Technology
vivo Internet Technology
Dec 4, 2024 · Databases

OceanBase Implementation and Migration Practices at vivo

vivo migrated five 20‑TB MySQL clusters to OceanBase using OCP, oblogproxy, and OMS, eliminating sharding costs, achieving over 70% storage savings, improving consistency and performance, and leveraging native distributed architecture, tenant isolation, and strong compression to support scalable, reliable operations.

OceanBasedata compressiondatabase migration
0 likes · 16 min read
OceanBase Implementation and Migration Practices at vivo
Xiaolei Talks DB
Xiaolei Talks DB
Nov 22, 2024 · Databases

Master OceanBase and OBproxy Upgrades on Kubernetes and Bare Metal

This guide details the upgrade procedures, prerequisites, and impact considerations for OceanBase, OBproxy, OCP, and OB‑DashBoard across Kubernetes and bare‑metal environments, providing step‑by‑step commands, dashboard actions, and DBA precautions to ensure a smooth transition.

KubernetesOBproxyOceanBase
0 likes · 10 min read
Master OceanBase and OBproxy Upgrades on Kubernetes and Bare Metal
Xiaolei Talks DB
Xiaolei Talks DB
Nov 14, 2024 · Cloud Native

How to Back Up OceanBase 4.2.5 on Kubernetes to Baidu Cloud BOS (S3)

This guide walks you through upgrading the ob‑operator, creating S3 credentials, configuring an OBTenantBackupPolicy YAML, applying the backup, and verifying the backup status to achieve a full data backup of an OceanBase 4.2.5 tenant to Baidu Cloud BOS using Kubernetes.

BOSKubernetesOceanBase
0 likes · 8 min read
How to Back Up OceanBase 4.2.5 on Kubernetes to Baidu Cloud BOS (S3)
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 22, 2024 · Databases

Analyzing OBServer Crash Logs with observer.log and gdb

This article explains how to locate OBServer crash logs, extract stack traces from observer.log, map memory addresses to source code using addr2line and gdb, identify the faulty function ObMPStmtExecute::copy_or_convert_str, and verify the issue through the OceanBase knowledge base, providing a systematic five‑step approach for rapid crash diagnosis.

CrashAnalysisDebuggingOceanBase
0 likes · 9 min read
Analyzing OBServer Crash Logs with observer.log and gdb
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 19, 2024 · Databases

Diagnosing Slow Stored Procedure Execution in OceanBase: Trace ID Analysis and Plan Cache Issues

This article explains how to troubleshoot a slow OceanBase stored procedure by locating its trace_id, analyzing audit logs to identify non‑cached UPDATE statements, revealing that preceding TRUNCATE operations invalidate the plan cache, and finally recommending replacing TRUNCATE with DELETE to restore performance.

OceanBasePlan CacheSQL Optimization
0 likes · 10 min read
Diagnosing Slow Stored Procedure Execution in OceanBase: Trace ID Analysis and Plan Cache Issues
Alibaba Cloud Native
Alibaba Cloud Native
Sep 13, 2024 · Cloud Native

Build a Remote VSCode Environment for OceanBase obdiag and Accelerate Coding with AI

This guide walks through setting up a CentOS virtual machine, configuring a Python 3.8 environment with Miniconda, forking and cloning the OceanBase obdiag repository, using VSCode remote‑SSH for development, and leveraging the Tongyi Lingma AI plugin to generate unit tests and documentation, culminating in a contribution workflow.

AI CodingGitOceanBase
0 likes · 8 min read
Build a Remote VSCode Environment for OceanBase obdiag and Accelerate Coding with AI
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 27, 2024 · Databases

Understanding Repeatable Read in OceanBase Oracle Mode and the Correct JDBC Configuration

This article explains why the OBOracle "set transaction read only" command provides repeatable‑read semantics, evaluates the behavior of the JDBC conn.setReadOnly(true) setting, and shows how to achieve true repeatable‑read isolation by enabling the oracleChangeReadOnlyToRepeatableRead option in the OceanBase client.

JDBCOceanBaseOracle Mode
0 likes · 8 min read
Understanding Repeatable Read in OceanBase Oracle Mode and the Correct JDBC Configuration
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 22, 2024 · Databases

ActionOMS: Intelligent Performance Diagnosis for OceanBase Data Migration

The article introduces ActionOMS, a customized version of OceanBase Migration Service that adds automated performance and fault diagnosis, explains its architecture, showcases a real‑world case of Oracle‑to‑OceanBase synchronization, and demonstrates how the tool improves migration throughput and reduces latency.

ActionOMSData MigrationDatabase Synchronization
0 likes · 11 min read
ActionOMS: Intelligent Performance Diagnosis for OceanBase Data Migration
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 8, 2024 · Databases

Understanding LOG_DISK Resource Limits and Tenant Memory Allocation in OceanBase

This article analyzes why creating a resource pool with 4C12G fails in an OceanBase single‑node cluster despite sufficient CPU and memory, explains the relationship between LOG_DISK size and tenant memory, provides calculation formulas, verification steps, and practical recommendations to avoid LOG_DISK resource shortages.

Database AdministrationLOG_DISKOceanBase
0 likes · 11 min read
Understanding LOG_DISK Resource Limits and Tenant Memory Allocation in OceanBase
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 29, 2024 · Databases

Implementing the ST_PointN GIS Function in OceanBase ActionDB

This article explains how the ActionDB team extended OceanBase by designing, registering, and implementing the ST_PointN function to extract the N‑th point from geometry objects, covering registration metadata, code integration, algorithm details, and the advantages of a custom GIS function for enterprise databases.

ActionDBDatabase FunctionsGIS
0 likes · 11 min read
Implementing the ST_PointN GIS Function in OceanBase ActionDB
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 25, 2024 · Databases

Analyzing and Optimizing Slow Scalar Subqueries in OceanBase 3.2.3.3

This article examines why a scalar subquery in an OceanBase 3.2.3.3 SQL statement takes over 1000 seconds, breaks down the execution plan, identifies the costly nested-loop behavior, and presents a rewrite using WITH and LEFT JOIN that reduces the cost from 788 million to 3.6 million and cuts runtime to about 10 seconds.

OceanBasePerformance OptimizationSQL
0 likes · 12 min read
Analyzing and Optimizing Slow Scalar Subqueries in OceanBase 3.2.3.3
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 27, 2024 · Databases

Evaluation of OceanBase Arbitration Service in a 2F1A Deployment: Fault Injection Experiments and Recovery Procedures

This article presents a detailed experimental study of OceanBase's Arbitration Service in a 2F1A (two full‑function replicas plus one arbitration node) configuration, examining how the system behaves when one or both full‑function replicas fail, how log‑stream degradation and permanent offline mechanisms work, and how normal service is restored after node recovery.

Arbitration ServiceFault InjectionOceanBase
0 likes · 17 min read
Evaluation of OceanBase Arbitration Service in a 2F1A Deployment: Fault Injection Experiments and Recovery Procedures
ITPUB
ITPUB
Jun 24, 2024 · Databases

What Is HTAP? Exploring Architecture Types, Key Technologies, and China’s Leading Databases

This article provides a comprehensive overview of Hybrid Transactional/Analytical Processing (HTAP) databases, detailing the four architectural patterns, five core technologies, and a comparative analysis of major Chinese HTAP products such as TiDB, OceanBase, PolarDB‑X, TDSQL, GaussDB and GreatSQL, while also discussing their characteristics and remaining challenges.

Database ArchitectureHTAPHybrid Transactional Analytical Processing
0 likes · 22 min read
What Is HTAP? Exploring Architecture Types, Key Technologies, and China’s Leading Databases
Aikesheng Open Source Community
Aikesheng Open Source Community
May 30, 2024 · Databases

OceanBase Single-Node Deployment, Configuration, and Performance Comparison with MySQL

This article provides a comprehensive guide to installing and configuring OceanBase single-node (centralized) clusters, explains primary‑standby tenant architectures, details performance benchmarking against MySQL using sysbench and fio, and offers recommended resource settings and diagnostic procedures for optimal operation.

Database ConfigurationMySQL ComparisonOceanBase
0 likes · 22 min read
OceanBase Single-Node Deployment, Configuration, and Performance Comparison with MySQL
Aikesheng Open Source Community
Aikesheng Open Source Community
May 23, 2024 · Databases

Troubleshooting SQL Exception Retries in OceanBase Using Logs and gv$sql_audit

This article demonstrates how to diagnose and resolve repeated UPDATE failures in OceanBase by extracting information from Top SQL, log files, and the gv$sql_audit view, identifying error codes such as 6005, 6003, and 6212, and applying corrective actions like adjusting timeout settings, killing lock‑holding sessions, and checking lock statistics.

ErrorCodesOceanBaseSQL
0 likes · 12 min read
Troubleshooting SQL Exception Retries in OceanBase Using Logs and gv$sql_audit
Aikesheng Open Source Community
Aikesheng Open Source Community
May 8, 2024 · Databases

OceanBase DBA from Beginner to Practice: Comprehensive Tutorial and Learning Path

The OceanBase community offers a detailed, eight‑session DBA tutorial covering the platform’s architecture, deployment, migration, performance tuning, diagnostic tools, and ecosystem components, complemented by live streaming, hands‑on exercises, certification incentives, and real‑world user testimonials to help developers and DBAs master this distributed database.

Database AdministrationOceanBaseSQL
0 likes · 9 min read
OceanBase DBA from Beginner to Practice: Comprehensive Tutorial and Learning Path
AntTech
AntTech
Apr 23, 2024 · Databases

The Cloud Era of Databases: Insights from OceanBase Chief Scientist Yang Zhenkun

In his OceanBase developer conference keynote, chief scientist Yang Zhenkun explains how cloud resource pooling enables distributed databases to achieve elastic compute and storage, discusses the evolution of databases, the challenges of transaction processing, and envisions fully shared, on‑demand cloud database services.

Distributed SystemsOceanBasecloud computing
0 likes · 7 min read
The Cloud Era of Databases: Insights from OceanBase Chief Scientist Yang Zhenkun
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 9, 2024 · Databases

Understanding Why OceanBase Cannot Use HASH ANTI JOIN and Optimizing NOT IN Queries

This article analyzes a slow NOT IN subquery that OceanBase rewrites into a NESTED‑LOOP ANTI JOIN, explains why HASH ANTI JOIN is not chosen due to NULL‑sensitive semantics and missing NOT NULL constraints, compares the behavior with Oracle's Null‑Aware Anti Join, and provides practical rewrite and hint‑based optimization recommendations.

Anti JoinOceanBaseOracle
0 likes · 17 min read
Understanding Why OceanBase Cannot Use HASH ANTI JOIN and Optimizing NOT IN Queries
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 9, 2024 · Databases

OceanBase DBA: From Beginner to Practice – Comprehensive Tutorial Series and E‑Book

OceanBase, a distributed open‑source database, offers a free e‑book and an eight‑session tutorial series covering installation, migration, operation, performance tuning, diagnostics, and ecosystem tools such as OCP, OMS, ODC, and obdiag, aimed at students, developers, and DBAs seeking practical skills and certification.

DBAOceanBaseTutorial
0 likes · 10 min read
OceanBase DBA: From Beginner to Practice – Comprehensive Tutorial Series and E‑Book
Architects' Tech Alliance
Architects' Tech Alliance
Mar 8, 2024 · Databases

What’s Driving the Rise of China’s Home‑grown Databases in 2024?

The article reviews the rapid emergence of high‑performance domestic databases such as OceanBase, TiDB, MaxCompute and TDEngine, outlines their development history, compares strengths and weaknesses, discusses suitable scenarios for TiDB, and forecasts future trends for China’s database ecosystem, while providing a curated list of further readings.

ChinaMaxComputeOceanBase
0 likes · 5 min read
What’s Driving the Rise of China’s Home‑grown Databases in 2024?
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 29, 2024 · Databases

Optimizing Nested-Loop Join Performance in OceanBase: Analysis, Rewrites, and Results

This article analyzes a slow Join query on OceanBase 3.2.3.3, examines execution plans and table statistics, proposes two rewrite methods—adding a filter condition and using a hash‑join hint—and demonstrates how these changes reduce execution time from over 500 seconds to just a few seconds.

Database PerformanceJOIN optimizationNested Loop
0 likes · 12 min read
Optimizing Nested-Loop Join Performance in OceanBase: Analysis, Rewrites, and Results
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 22, 2024 · Databases

Understanding Global vs Local Indexes in OceanBase and Their Impact on Query Performance

This article explains the differences between global and local indexes in OceanBase, analyzes why queries using global unique indexes run significantly faster than those using local indexes during Oracle migration, and provides detailed SQL examples, execution plans, and performance testing results to guide database optimization.

Local IndexOceanBaseOracle
0 likes · 32 min read
Understanding Global vs Local Indexes in OceanBase and Their Impact on Query Performance
Zuoyebang Tech Team
Zuoyebang Tech Team
Feb 19, 2024 · Databases

How OceanBase’s HTAP Architecture Solved Our MySQL Scaling Pain Points

Facing rapid data growth, our team struggled with MySQL scaling, costly distributed refactoring, and inflexible storage; by adopting OceanBase’s native distributed HTAP platform we achieved elastic scaling, strong consistency, over 60% storage savings, and multi‑tenant performance gains for both OLTP and OLAP workloads.

HTAPOceanBasedatabase migration
0 likes · 9 min read
How OceanBase’s HTAP Architecture Solved Our MySQL Scaling Pain Points
ITPUB
ITPUB
Jan 4, 2024 · Databases

Fast CPU Performance Evaluation on Domestic Servers & OceanBase Optimization

This article explains why domestic Haiguang/Kunpeng servers lag behind Intel CPUs, presents a quick stored‑procedure method to benchmark CPU performance, details OceanBase tenant CPU specifications and tuning parameters, and offers concrete optimization techniques for high‑concurrency TP and massive‑data AP scenarios, including queuing tables, sequence cache, and index redesign.

CPU performanceDatabase OptimizationOceanBase
0 likes · 21 min read
Fast CPU Performance Evaluation on Domestic Servers & OceanBase Optimization
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 20, 2023 · Databases

Analyzing and Resolving Slow Query Plan Issues in OceanBase 3.2.3

This article presents a step‑by‑step investigation of a SELECT statement that became 1000× slower in OceanBase 3.2.3 BP8, explains why the optimizer chose an inefficient I5 index, describes the plan‑expiration logic, and provides reproducible scripts and practical recommendations for fixing the problem.

Database IndexOceanBasePlan Cache
0 likes · 19 min read
Analyzing and Resolving Slow Query Plan Issues in OceanBase 3.2.3
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 5, 2023 · Databases

Standard Architecture and Application Practices for Distributed Databases at Industrial Securities

The article details Industrial Securities' implementation of a standardized, high‑availability distributed database architecture using OceanBase, covering core capabilities, resource evaluation, migration, backup, and operational best practices to support financial digital transformation and autonomous controllable IT infrastructure.

OceanBaseresource estimation
0 likes · 14 min read
Standard Architecture and Application Practices for Distributed Databases at Industrial Securities
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 13, 2023 · Databases

AIKOS Open Source Community Weekly Newsletter – Updates, Technical Articles, and Upcoming Events

The AIKOS community weekly newsletter shares the SQLE 3.0 release, recent development work, upcoming plans, curated MySQL and OceanBase technical articles, industry highlights, and announcements for future events, providing valuable insights for database practitioners and open‑source contributors.

OceanBaseSQL qualitycommunity
0 likes · 7 min read
AIKOS Open Source Community Weekly Newsletter – Updates, Technical Articles, and Upcoming Events
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 8, 2023 · Databases

Analyzing OceanBase Freeze Dump Process via Log Parsing

This article explains how to parse OceanBase logs to trace the tenant freeze dump workflow, detailing the roles and log sequences of the freeze check thread, LSFreeze, Flush, DagScheduler, and MiniMerge threads, and illustrating each step with actual log excerpts and code snippets.

DAGFreeze ProcessOceanBase
0 likes · 16 min read
Analyzing OceanBase Freeze Dump Process via Log Parsing
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 30, 2023 · Databases

ActionTech Open Source Community Weekly Newsletter – SQLE Updates, Technical Articles, and Events

The newsletter announces the SQLE 3.0 release with new UI and demo environments, highlights the SQLE 2.2310.0‑pre3 update, reviews technical articles on MySQL cloning, OceanBase indexing, data replication, charset issues, and connection‑pool design, recaps recent conferences, and previews upcoming OB Cloud open class events.

DataReplicationOceanBaseSQL
0 likes · 8 min read
ActionTech Open Source Community Weekly Newsletter – SQLE Updates, Technical Articles, and Events