BestHub
Sign in
Tagged articles

OceanBase

244 articles · Page 2 of 3
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.

Database MigrationDistributed ArchitectureHTAP
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 performanceOceanBasedatabase optimization
0 likes · 21 min read
Fast CPU Performance Evaluation on Domestic Servers & OceanBase Optimization
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 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.

DAGDatabaseFreeze Process
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.

DataReplicationDatabaseMySQL
0 likes · 8 min read
ActionTech Open Source Community Weekly Newsletter – SQLE Updates, Technical Articles, and Events
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 25, 2023 · Databases

Understanding and Optimizing Indexes in OceanBase

This article explains the concepts of local and global indexes in OceanBase, demonstrates how to create tables and indexes, compares six practical scenarios—including no index, local index, partitioned queries, unique and global indexes—and provides performance metrics to guide database optimization.

IndexingLocal IndexOceanBase
0 likes · 8 min read
Understanding and Optimizing Indexes in OceanBase
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 18, 2023 · Databases

Diagnosing and Resolving USER_TAB_COLUMNS View Inconsistencies Between Oracle and OceanBase

This article investigates why Oracle and OceanBase return different results when querying the USER_TAB_COLUMNS view in stored procedures, demonstrates reproducible tests, analyzes system view behavior, and proposes workarounds such as using ALL_TAB_COLUMNS, creating synonyms, intermediate tables, or materialized views to ensure consistent table name retrieval.

Database ViewsOceanBaseOracle
0 likes · 19 min read
Diagnosing and Resolving USER_TAB_COLUMNS View Inconsistencies Between Oracle and OceanBase
DataFunSummit
DataFunSummit
Oct 6, 2023 · Databases

OceanBase HTAP Capabilities: Architecture, Performance, and Core Technologies

This article provides a comprehensive overview of OceanBase's HTAP capabilities, detailing its core features, technical architecture, execution and storage engines, resource isolation, fast import mechanisms, performance benchmarks, and future enhancements, supported by diagrams and real‑world deployment data.

Execution EngineHTAPOceanBase
0 likes · 22 min read
OceanBase HTAP Capabilities: Architecture, Performance, and Core Technologies
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 13, 2023 · Databases

Verifying OceanBase Transparent Data Encryption Using ob_admin dumpsst

This article demonstrates how to configure transparent encryption in OceanBase 4.1.0.0 Enterprise, create encrypted and non‑encrypted tables, perform major merges, and use the ob_admin dumpsst tool to inspect macro blocks, confirming that encrypted data is not readable while non‑encrypted data is visible.

Database SecurityOceanBaseTransparent Encryption
0 likes · 17 min read
Verifying OceanBase Transparent Data Encryption Using ob_admin dumpsst
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 6, 2023 · Databases

Resolving ERROR 1499: Too Many Partitions in OceanBase/MySQL

This article analyzes the MySQL ERROR 1499 caused by exceeding partition limits in OceanBase, examines server parameters, recycle‑bin settings, and tenant memory usage, and provides calculations and recommendations to expand memory or limit partition counts to prevent the error.

Database TroubleshootingMySQLOceanBase
0 likes · 11 min read
Resolving ERROR 1499: Too Many Partitions in OceanBase/MySQL
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 4, 2023 · Databases

SQLE 2.2308.0-pre1 Release Notes and Feature Overview

The SQLE 2.2308.0-pre1 release introduces community and enterprise enhancements such as intelligent SQL file scanning, per‑instance workflow approver matching, and the ability to abort deployments on OceanBase and TDSQL data sources, accompanied by usage examples, command‑line instructions, and full release information.

Database AuditingMySQLOceanBase
0 likes · 7 min read
SQLE 2.2308.0-pre1 Release Notes and Feature Overview
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 1, 2023 · Databases

Comparison of MySQL stop slave/reset slave Commands with OceanBase Equivalents and Experimental Analysis

This article examines the differences between MySQL's stop slave and reset slave all commands and OceanBase's replication controls, presenting experimental results that show how clog synchronization affects cluster availability, data consistency, and the procedures for decoupling standby clusters.

MySQLOceanBaseReset Slave
0 likes · 8 min read
Comparison of MySQL stop slave/reset slave Commands with OceanBase Equivalents and Experimental Analysis
Amap Tech
Amap Tech
Aug 1, 2023 · Databases

Gaode’s Adoption of OceanBase: Architecture, Practices, and Future Roadmap

Gaode migrated its core navigation, traffic, and financial services to OceanBase, leveraging Paxos‑based multi‑replica consistency, LSM‑Tree storage, and distributed transactions, selecting multi‑point write for massive sync workloads and central‑write for latency‑critical queries, achieving sub‑millisecond latency, significant storage savings, and a roadmap toward broader cost‑effective, serverless deployment.

Cloud NativeOceanBasedistributed database
0 likes · 58 min read
Gaode’s Adoption of OceanBase: Architecture, Practices, and Future Roadmap
DataFunSummit
DataFunSummit
Jul 26, 2023 · Databases

Deep Dive into OceanBase HTAP Capabilities and Architecture

This article provides a comprehensive overview of OceanBase, an open‑source distributed database, detailing its evolution, core HTAP features, multi‑tenant architecture, execution engine optimizations, advanced query optimizer, storage engine design, resource isolation mechanisms, fast import capabilities, and performance benchmarks.

Execution EngineHTAPOceanBase
0 likes · 22 min read
Deep Dive into OceanBase HTAP Capabilities and Architecture
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 20, 2023 · Databases

Understanding the Dynamic Freeze Threshold in OceanBase: Source Code Analysis and Debugging

This article investigates why OceanBase's memory freeze threshold changes during load testing by analyzing monitoring data, inspecting the relevant source code, and demonstrating debugging steps, ultimately revealing that the threshold is computed dynamically based on real‑time memory usage and can be lowered when other memory modules consume space.

DatabaseFreeze ThresholdMemory Management
0 likes · 18 min read
Understanding the Dynamic Freeze Threshold in OceanBase: Source Code Analysis and Debugging
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 11, 2023 · Databases

Investigation of Implicit Type Conversion Issues in OceanBase Update and Select Statements

This article analyzes a puzzling OceanBase data‑type implicit conversion problem where UPDATE statements intermittently fail with SQL syntax errors while SELECT statements return unexpected results, explains the underlying conversion mechanisms, shows diagnostic queries and log excerpts, and provides practical recommendations to avoid such errors.

DatabaseDebuggingImplicitConversionOceanBase
0 likes · 17 min read
Investigation of Implicit Type Conversion Issues in OceanBase Update and Select Statements
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 3, 2023 · Databases

Replacing OCP Nodes Using the ANTMAN Tool in OceanBase Cloud Platform

This article provides a step‑by‑step guide on how to replace OceanBase Cloud Platform (OCP) nodes using the ANTMAN tool, covering environment preparation, configuration adjustments, execution of management scripts, tenant migration, cleanup of old services, and troubleshooting tips for a seamless database cluster upgrade.

ANTMANCluster ManagementDatabase Migration
0 likes · 25 min read
Replacing OCP Nodes Using the ANTMAN Tool in OceanBase Cloud Platform
Past Memory Big Data
Past Memory Big Data
Jun 29, 2023 · Industry Insights

How OceanBase Powered Sichuan Rural Credit Union’s Core System Upgrade and Boosted Customer Efficiency

Sichuan Rural Credit Union, with over 5,000 outlets and 3 billion daily transactions, migrated its core and mobile banking systems to OceanBase's native distributed database, cutting card‑issue time from 30 minutes to 5 minutes, loan processing from 3‑5 days to 1‑33 minutes, and saving more than 40% in infrastructure costs.

Disaster RecoveryOceanBasebanking IT
0 likes · 16 min read
How OceanBase Powered Sichuan Rural Credit Union’s Core System Upgrade and Boosted Customer Efficiency
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 27, 2023 · Information Security

Comparison of User Management and Access Control between OceanBase (MySQL Mode) and MySQL

This article compares OceanBase (MySQL mode) and MySQL in terms of user management, password syntax, user locking, permission levels, grant statements, grant tables, network white‑list access control, row‑level security, and role management, highlighting similarities, differences, and migration considerations.

Database SecurityMySQLOceanBase
0 likes · 18 min read
Comparison of User Management and Access Control between OceanBase (MySQL Mode) and MySQL
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 10, 2023 · Databases

Weekly Tech Share Summary – SQL and Database Highlights

This weekly newsletter curates top industry tech articles covering SQL deployment capabilities, MySQL replication issues, LLM‑to‑SQL benchmarks, connection limit errors, OceanBase tracing, and provides an open‑source SQL quality management platform update with development progress and upcoming plans.

DatabaseMySQLOceanBase
0 likes · 4 min read
Weekly Tech Share Summary – SQL and Database Highlights
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 7, 2023 · Databases

OceanBase vs MySQL/TiDB: Performance Evaluation, Deployment Guide, and Migration Practices

This article presents a comprehensive performance comparison of OceanBase with MySQL and TiDB, details step‑by‑step deployment of OceanBase (both single‑node and cluster), explains configuration and resource‑pool management, and shares practical migration techniques and troubleshooting tips for production workloads.

Database MigrationMySQLOceanBase
0 likes · 23 min read
OceanBase vs MySQL/TiDB: Performance Evaluation, Deployment Guide, and Migration Practices
Aikesheng Open Source Community
Aikesheng Open Source Community
May 15, 2023 · Databases

Performance Degradation After Data Updates in OceanBase and Its Optimization Techniques

The article investigates why pure‑read QPS drops significantly after bulk updates in OceanBase, reproduces the issue with a sysbench workload, analyses flame‑graph and SQL audit data, explains the LSM‑Tree read‑amplification mechanism, and proposes practical mitigation steps such as major freeze, plan binding, index creation, and the queuing‑table feature.

LSM TreeMajor FreezeOceanBase
0 likes · 16 min read
Performance Degradation After Data Updates in OceanBase and Its Optimization Techniques
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 27, 2023 · Databases

Diagnosing Freeze and Dump Issues in OceanBase Memstore

This article explains how to verify whether OceanBase's freeze mechanism and memstore dump processes are functioning correctly by querying internal tables, inspecting logs, and checking related metrics such as active_memstore_used, major_freeze_trigger, and MemTable reference counts.

DUMPDatabase AdministrationFreeze
0 likes · 14 min read
Diagnosing Freeze and Dump Issues in OceanBase Memstore
AntTech
AntTech
Apr 21, 2023 · Databases

Future of Databases in China: Trends, History, and Benchmarking

In a keynote at the first OceanBase Developer Conference, Professor Zhou Aoying outlines the evolution of database technology, its role as a foundational data‑power platform, the importance of benchmarks for distributed databases, and the vision for a unified Data Power Platform in China’s digital economy.

ChinaData PowerDatabases
0 likes · 11 min read
Future of Databases in China: Trends, History, and Benchmarking
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 10, 2023 · Databases

Understanding OceanBase Recycle Bin: Retrieval, Multiple Same‑Name Tables, Visibility, and Flashback Behavior

This article explains how OceanBase's recycle bin works, covering error causes when flashing back tables, methods to obtain a table's database, handling of multiple same‑name tables, visibility across tenants, and the ability to flash back tables or tenants even after the recycle bin is disabled.

Database ManagementFlashbackOceanBase
0 likes · 11 min read
Understanding OceanBase Recycle Bin: Retrieval, Multiple Same‑Name Tables, Visibility, and Flashback Behavior
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 29, 2023 · Databases

Understanding Local and Global Indexes in OceanBase

The article explains the concepts, differences, and practical usage scenarios of local (partition‑aligned) and global indexes in OceanBase, providing SQL examples for queries with and without partition keys and guidance on creating unique indexes using either index type.

DatabaseIndexingLocal Index
0 likes · 7 min read
Understanding Local and Global Indexes in OceanBase
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 22, 2023 · Databases

Understanding and Optimizing BUFFER (Queuing) Tables in OceanBase

The article explains what OceanBase BUFFER (Queuing) tables are, why frequent bulk updates cause performance degradation, and provides three optimization methods—including binding execution plans, manual data transfer, and setting table_mode='queuing'—with concrete MySQL and Oracle examples and query scripts to monitor merges.

BUFFER tableDatabaseMySQL
0 likes · 7 min read
Understanding and Optimizing BUFFER (Queuing) Tables in OceanBase
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 9, 2023 · Databases

In‑Depth Exploration of OceanBase Hierarchical Dump and Compaction Mechanisms

This article explains the LSM‑Tree foundation of OceanBase, details its tiered and leveled compaction strategies, and presents two experiments that observe Mini and Minor compactions under different configuration parameters, revealing how minor freeze and trigger settings affect data movement between L0 and L1 layers.

Database StorageLSM TreeMini Compaction
0 likes · 13 min read
In‑Depth Exploration of OceanBase Hierarchical Dump and Compaction Mechanisms
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 8, 2023 · Databases

OceanBase Tenant Deletion Methods and Syntax

This article explains OceanBase's three tenant deletion approaches—normal, delayed, and immediate—detailing the DROP TENANT syntax, recycle‑bin behavior, and providing step‑by‑step SQL examples for creating, dropping, restoring, and permanently removing tenants.

Database AdministrationMySQLOceanBase
0 likes · 7 min read
OceanBase Tenant Deletion Methods and Syntax
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 1, 2023 · Operations

Guide to Expanding an OceanBase Cluster: Adding Zones and Resources

This article provides a step‑by‑step guide for scaling an OceanBase cluster, covering both white‑screen and black‑screen methods to add zones (replicas) and resources (OBServers), including configuration file preparation, deployment commands, zone addition, verification queries, and procedures for both expansion and contraction.

Database OperationsOceanBaseSQL
0 likes · 12 min read
Guide to Expanding an OceanBase Cluster: Adding Zones and Resources
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 27, 2023 · Databases

Investigation of session_id source and bulk tenant connection termination in OceanBase via observer and obproxy

This article examines how session IDs are derived for the kill command in OceanBase, compares IDs obtained through show processlist, information_schema.processlist, and oceanbase.__all_virtual_processlist, and demonstrates methods to terminate all connections of a specific tenant across different observers and obproxies.

Kill CommandOceanBaseprocesslist
0 likes · 7 min read
Investigation of session_id source and bulk tenant connection termination in OceanBase via observer and obproxy
ITPUB
ITPUB
Feb 24, 2023 · Databases

How Ctrip Migrated MySQL to OceanBase: Tools, Process, and Lessons Learned

Ctrip evaluated and extended OceanBase Migration Assessment tools, built a one‑click migration workflow, implemented comprehensive monitoring and automatic fault‑diagnosis pipelines, and addressed compatibility challenges such as .NET charset issues and Druid parser errors, ultimately achieving a smooth MySQL‑to‑OceanBase transition.

Database MigrationMonitoringMySQL
0 likes · 18 min read
How Ctrip Migrated MySQL to OceanBase: Tools, Process, and Lessons Learned
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 22, 2023 · Databases

OceanBase Single‑Node Deployment and Tenant Management Guide

This article provides a comprehensive step‑by‑step tutorial on deploying OceanBase in a single‑node environment, covering resource unit, resource pool, and MySQL‑type tenant creation, modification, deletion, user management, and relevant system data dictionary tables, with full SQL command examples.

DatabaseOceanBaseResource Unit
0 likes · 10 min read
OceanBase Single‑Node Deployment and Tenant Management Guide
Ctrip Technology
Ctrip Technology
Feb 2, 2023 · Databases

MySQL to OceanBase Migration: Evaluation Tools, Migration Process, Monitoring, and Automated Fault Diagnosis

This article details Ctrip's experience migrating MySQL workloads to the distributed OceanBase database, covering the design of an assessment tool, a one‑click migration workflow, comprehensive monitoring dashboards, automated fault‑diagnosis pipelines, encountered compatibility issues, and future roadmap for the platform.

Database MonitoringFault diagnosisMySQL Migration
0 likes · 17 min read
MySQL to OceanBase Migration: Evaluation Tools, Migration Process, Monitoring, and Automated Fault Diagnosis
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 26, 2022 · Databases

Weekly Tech Community Digest – Database and SQL Updates

This weekly digest curates top industry technical shares, featuring articles on database cloud migration, MySQL hash join evolution, OceanBase distributed query performance, MySQL subquery execution, and the latest SQLE SQL audit tool release, along with community development progress and upcoming plans.

MySQLOceanBaseSQL audit
0 likes · 3 min read
Weekly Tech Community Digest – Database and SQL Updates
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 21, 2022 · Databases

Troubleshooting OBproxy Deployment: Fixing Lost Connection Error Caused by Wrong Root Service List Port

This article details a step‑by‑step troubleshooting process for an OBproxy deployment error where a client loses connection to the OceanBase server due to an incorrect port in the root service list, including environment setup, command examples, log analysis, and the final resolution.

Database ProxyOceanBaseRoot Service List
0 likes · 9 min read
Troubleshooting OBproxy Deployment: Fixing Lost Connection Error Caused by Wrong Root Service List Port
ITPUB
ITPUB
Nov 19, 2022 · Databases

Choosing Between OceanBase and TiDB: Architecture, Performance, and Trade‑offs

This article compares the architectures of OceanBase and TiDB, explaining how their sharding and compute‑storage separation designs affect high availability, latency, and workload suitability, and offers guidance on selecting the right distributed database for complex enterprise applications.

Compute-Storage SeparationOceanBaseSharding
0 likes · 12 min read
Choosing Between OceanBase and TiDB: Architecture, Performance, and Trade‑offs
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 19, 2022 · Operations

Analyzing OceanBase Error Logs to Locate Error Causes

This article explains the types and formats of OceanBase logs, how to identify relevant log files, interpret log fields such as trace_id, lt, and dc, and provides step-by-step methods for using error codes and trace IDs to pinpoint the root cause of errors.

DatabaseOperationsErrorLogOceanBase
0 likes · 16 min read
Analyzing OceanBase Error Logs to Locate Error Causes
AntTech
AntTech
Sep 30, 2022 · Databases

OceanBase: Distributed Architecture, High‑Performance Storage Engine, Paxos‑Based 2PC, and Record‑Breaking TPC‑C Benchmarks

The article reviews OceanBase's distributed relational database design, its integrated architecture, high‑compression LSM‑tree storage engine, Paxos‑enhanced two‑phase commit protocol, and how these innovations enabled the system to set successive world records in the TPC‑C benchmark, illustrating China's growing database capabilities.

Database PerformanceOceanBasePaxos
0 likes · 18 min read
OceanBase: Distributed Architecture, High‑Performance Storage Engine, Paxos‑Based 2PC, and Record‑Breaking TPC‑C Benchmarks
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 21, 2022 · Operations

Understanding MemAvailable and min_free_kbytes in Linux: Why free -m Shows Different Values and How to Adjust for OceanBase Installation

The article explains why the free command reports more memory than the available column, describes how the kernel calculates MemAvailable using min_free_kbytes and watermarks, and provides practical guidance on tuning min_free_kbytes to meet OceanBase's memory requirements.

LinuxMemAvailableMemory Management
0 likes · 6 min read
Understanding MemAvailable and min_free_kbytes in Linux: Why free -m Shows Different Values and How to Adjust for OceanBase Installation
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 9, 2022 · Databases

SQLE 1.2209.0-pre1 Release Notes and Feature Overview

The preview release SQLE 1.2209.0-pre1 introduces OceanBase TopSQL auditing, Alibaba Cloud RDS MySQL audit‑log support, and a sub‑query nesting rule, while providing project background, download links, demo environments, and a detailed list of new features and release notes for database professionals.

Database ToolsMySQLOceanBase
0 likes · 5 min read
SQLE 1.2209.0-pre1 Release Notes and Feature Overview
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 2, 2022 · Databases

SQLE 1.2208.0 Release Notes – New Features, MySQL Audit Rules, OceanBase Support, and Reporting Dashboard

The SQLE 1.2208.0 release introduces intelligent scanning for Alibaba Cloud RDS MySQL slow logs, adds numerous MySQL audit rules, opens enterprise‑level rules to the community, provides new OceanBase for MySQL audit rules, a reporting statistics page, PostgreSQL analysis support, and several scenario‑based audit enhancements along with many optimizations and bug fixes.

Database AuditingMySQLOceanBase
0 likes · 9 min read
SQLE 1.2208.0 Release Notes – New Features, MySQL Audit Rules, OceanBase Support, and Reporting Dashboard
AntTech
AntTech
Aug 23, 2022 · Databases

OceanBase 4.0 Core Technology Overview

The OceanBase 4.0 core technology presentation recounts twelve years of evolution from the early 0.1 version to a single-node distributed integrated database, highlighting breakthroughs such as sub-8-second RTO, RPO = 0, Paxos three-replica high availability, and competitive performance in TPC-C and TPC-H benchmarks.

MySQL CompatibilityOceanBasePaxos
0 likes · 8 min read
OceanBase 4.0 Core Technology Overview
ITPUB
ITPUB
Aug 13, 2022 · Databases

Why HTAP Databases Matter: Inside Oracle HeatWave, Google AlloyDB, TiDB, and OceanBase

The article examines the growing demand for HTAP databases, comparing cloud‑native solutions such as Google AlloyDB, Oracle MySQL HeatWave, Amazon Aurora, and domestic offerings like TiDB and OceanBase, analyzing their architectures, offload mechanisms, performance claims, and trade‑offs for mixed OLTP/OLAP workloads.

Cloud NativeGoogleHTAP
0 likes · 11 min read
Why HTAP Databases Matter: Inside Oracle HeatWave, Google AlloyDB, TiDB, and OceanBase
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 29, 2022 · Databases

SQLE 1.2207.0 Release Notes and Feature Summary

The SQLE 1.2207.0 release introduces a redesigned dashboard, incremental intelligent scanning for slow‑log and TiDB audit logs, OceanBase MySQL‑mode audit plugin, JetBrains IDE audit plugin, along with numerous optimizations, bug fixes, and detailed release information for both community and enterprise editions.

Database AuditingIDE pluginOceanBase
0 likes · 7 min read
SQLE 1.2207.0 Release Notes and Feature Summary
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 15, 2022 · Databases

SQLE 1.2207.0‑pre1 Release Notes: New OceanBase MySQL Support, Feature Updates, and Bug Fixes

The SQLE 1.2207.0‑pre1 pre‑release introduces OceanBase MySQL‑mode audit plugins, exclusive OceanBase rules, enhanced table‑name case checks, count(*) recommendations, adds TiDB audit‑log support, fixes several MySQL‑related bugs, and outlines future plans for more OceanBase and Oracle‑mode auditing capabilities.

Database AuditingMySQLOceanBase
0 likes · 5 min read
SQLE 1.2207.0‑pre1 Release Notes: New OceanBase MySQL Support, Feature Updates, and Bug Fixes
ITPUB
ITPUB
Jul 8, 2022 · Databases

Uncovering the Flaws: Why No Distributed Database Architecture Is Perfect

This article examines the most common Chinese distributed database architectures, comparing integrated SHARDING designs like OceanBase with separated compute‑storage models such as TiDB and SQL‑proxy based systems, highlighting their inherent trade‑offs, performance challenges, and practical considerations for choosing the right solution.

OceanBaseSQL proxySharding
0 likes · 11 min read
Uncovering the Flaws: Why No Distributed Database Architecture Is Perfect
AntTech
AntTech
Apr 29, 2022 · Operations

Alipay Double‑11 System Stability Practices: Distributed Architecture, Elastic Scaling, Service Mesh, Full‑Chain Load Testing, Intelligent Monitoring, and OceanBase

The presentation details Alipay's evolution through three stability phases—capacity, elastic cloud‑native architecture, and green computing—covering unit‑based deployment, elastic scaling, ServiceMesh, full‑chain load testing, intelligent monitoring, and the OceanBase distributed database, illustrating how these techniques achieved 99.99% availability during the 2021 Double‑11 peak.

Cloud NativeDistributed ArchitectureLoad Testing
0 likes · 11 min read
Alipay Double‑11 System Stability Practices: Distributed Architecture, Elastic Scaling, Service Mesh, Full‑Chain Load Testing, Intelligent Monitoring, and OceanBase
AntTech
AntTech
Feb 18, 2022 · Databases

Parallel Evolution of Electric Vehicles and Distributed Databases: A Comparative Analysis

The article examines the strikingly similar development trajectories of electric vehicles and distributed databases, tracing their historical origins, technological challenges, market dynamics, and recent breakthroughs such as Tesla's autonomous electric cars and OceanBase's native HTAP capabilities, while highlighting the role of open‑source and scaling strategies.

Distributed DatabasesHTAPOceanBase
0 likes · 15 min read
Parallel Evolution of Electric Vehicles and Distributed Databases: A Comparative Analysis
Laravel Tech Community
Laravel Tech Community
Oct 26, 2021 · Databases

Understanding Ant Financial’s LDC Architecture: Unitization, CAP Analysis, and OceanBase Design

The article explains how Ant Financial scales Double‑11 payment traffic to hundreds of thousands of TPS by employing logical data centers (LDC), unit‑based system design (RZone, GZone, CZone), database sharding, CAP theorem analysis, Paxos‑based consensus, and the OceanBase distributed database, while also detailing disaster‑recovery and traffic‑shifting mechanisms.

CAP theoremHigh TPSOceanBase
0 likes · 35 min read
Understanding Ant Financial’s LDC Architecture: Unitization, CAP Analysis, and OceanBase Design
Programmer DD
Programmer DD
Oct 24, 2021 · Databases

OceanBase Star Buying Scandal: Is China’s Top Database Purchasing GitHub Stars?

The article outlines OceanBase’s evolution into an open‑source, HTAP‑capable distributed database, then details allegations that its community engaged in purchasing GitHub stars, including screenshots of incentive messages, sparking debate over the ethics of star‑inflation in Chinese open‑source projects.

GitHub StarsOceanBasedistributed database
0 likes · 5 min read
OceanBase Star Buying Scandal: Is China’s Top Database Purchasing GitHub Stars?
Architecture Digest
Architecture Digest
Sep 16, 2021 · Databases

Designing High‑Throughput Payment Systems: Ant Group’s LDC Architecture, CRG Zones, and CAP Analysis

The article explains how Ant Group’s Alipay handles massive double‑11 payment traffic by using logical data centers (LDC), unit‑based architecture with RZone, GZone and CZone, traffic routing, disaster‑recovery strategies, and a CAP‑aware design built on the OceanBase distributed database.

CAP theoremDatabase ScalingHigh TPS
0 likes · 35 min read
Designing High‑Throughput Payment Systems: Ant Group’s LDC Architecture, CRG Zones, and CAP Analysis
Alibaba Cloud Developer
Alibaba Cloud Developer
May 27, 2021 · Databases

How OceanBase Set a New TPC‑H Record and the Future of HTAP Databases

OceanBase achieved a world‑record TPC‑H performance of 15.26 million QphH, illustrating its HTAP capabilities and detailing the technical evolution, challenges, and future direction of hybrid transactional/analytical processing in modern distributed databases.

Database PerformanceHTAPHybrid Transactional Analytical Processing
0 likes · 18 min read
How OceanBase Set a New TPC‑H Record and the Future of HTAP Databases
AntTech
AntTech
May 21, 2021 · Databases

OceanBase HTAP: Technical Insights Behind the TPC‑H World Record

This article explains how OceanBase, a distributed relational database, achieved a new TPC‑H world record, discusses the evolution of HTAP technology, the architectural challenges of combining transactional and analytical workloads, and the future direction of the product.

HTAPHybrid Transactional Analytical ProcessingOceanBase
0 likes · 17 min read
OceanBase HTAP: Technical Insights Behind the TPC‑H World Record
Alibaba Cloud Developer
Alibaba Cloud Developer
May 21, 2021 · Databases

How OceanBase Crushed the TPC‑H Benchmark with HTAP Innovation

OceanBase, the distributed relational database from Ant Group, set a new TPC‑H world record by leveraging its HTAP architecture, blending transaction and analytical processing, and the article details the technical evolution, challenges, and future direction of this hybrid database technology.

HTAPHybrid ProcessingOceanBase
0 likes · 17 min read
How OceanBase Crushed the TPC‑H Benchmark with HTAP Innovation
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Feb 21, 2021 · Databases

How Ant Financial Scales to 540k TPS: Inside LDC Architecture, Unitization, and CAP Analysis

This article explains how Ant Financial’s payment system grew from 20,000 transactions per minute in 2010 to 540,000 TPS in 2019 by adopting logical data centers (LDC), unitized architecture (RZone, GZone, CZone), OceanBase’s Paxos‑based consensus, and sophisticated traffic steering and disaster‑recovery strategies.

CAP theoremHigh AvailabilityOceanBase
0 likes · 41 min read
How Ant Financial Scales to 540k TPS: Inside LDC Architecture, Unitization, and CAP Analysis
Architects' Tech Alliance
Architects' Tech Alliance
Feb 17, 2021 · Databases

How Alipay Handles 540k TPS: Inside the LDC Architecture, Unitization and CAP Analysis

This article dissects Alipay's massive Double‑11 payment surge, explaining how its Logical Data Center (LDC) and unit‑based architecture—RZone, GZone, and CZone—scale to hundreds of thousands of transactions per second, manage traffic routing, implement disaster‑recovery, and navigate the CAP theorem using OceanBase and Paxos.

CAP theoremDisaster RecoveryLDC architecture
0 likes · 39 min read
How Alipay Handles 540k TPS: Inside the LDC Architecture, Unitization and CAP Analysis
AntTech
AntTech
Feb 5, 2021 · Databases

OceanBase 2020 Review: Record‑Breaking Performance, Independent Operation, Ecosystem Expansion, and Advanced Disaster‑Recovery

In 2020 OceanBase achieved a world‑record TPC‑C benchmark of 7.07 billion tpmC, spun off as an independent company, attracted dozens of marquee customers, built a four‑layer ecosystem, delivered ultra‑high performance for enterprises, and introduced Paxos‑based disaster‑recovery that guarantees RPO = 0 and minute‑level RTO.

Disaster RecoveryEcosystemOceanBase
0 likes · 13 min read
OceanBase 2020 Review: Record‑Breaking Performance, Independent Operation, Ecosystem Expansion, and Advanced Disaster‑Recovery
Java Architect Essentials
Java Architect Essentials
Jan 3, 2021 · Databases

Understanding Ant Financial’s LDC Architecture: Partitioning, CAP Analysis, and Multi‑Active Disaster Recovery

This article explains how Ant Financial’s logical data center (LDC) architecture uses unitization, database sharding, and CAP‑aware design—including RZone, GZone, and CZone—to achieve tens of millions of TPS during Double‑11, while providing multi‑active disaster recovery and high availability.

CAP theoremLDC architectureOceanBase
0 likes · 38 min read
Understanding Ant Financial’s LDC Architecture: Partitioning, CAP Analysis, and Multi‑Active Disaster Recovery
IT Architects Alliance
IT Architects Alliance
Dec 10, 2020 · Industry Insights

How Alipay Handles 540K TPS: Inside LDC’s Unit‑Based Architecture and CAP Strategies

This article analyzes the massive traffic handling of Alipay during Double 11, explaining the LDC (Logical Data Center) unit‑based design, the RZone‑GZone‑CZone hierarchy, traffic steering, disaster‑recovery mechanisms, and how OceanBase and Paxos enable CAP compliance for ultra‑high‑availability payments.

CAP theoremHigh AvailabilityLDC architecture
0 likes · 38 min read
How Alipay Handles 540K TPS: Inside LDC’s Unit‑Based Architecture and CAP Strategies
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Dec 10, 2020 · Databases

How Ant Financial’s LDC Architecture Scales to 540k TPS on Double‑11

This article explains how Ant Financial’s logical data center (LDC) architecture, based on user‑sharded RZones, GZones, and CZones, combined with OceanBase’s Paxos‑based consensus, enables massive horizontal scaling, high availability, and disaster‑tolerant processing of over half a million payment transactions per second during Double‑11.

CAP theoremHigh AvailabilityOceanBase
0 likes · 35 min read
How Ant Financial’s LDC Architecture Scales to 540k TPS on Double‑11
Practical DevOps Architecture
Practical DevOps Architecture
Nov 10, 2020 · Databases

Design of Ant Financial's Logical Data Center (LDC) and Unitization for High‑TPS Payments

The article explains how Ant Financial’s Logical Data Center (LDC) and unit‑based architecture, combined with sharding, CAP analysis, and OceanBase’s Paxos‑based consensus, enable the payment platform to sustain tens of millions of transactions per second during Double‑11 events while ensuring high availability and disaster recovery.

CAP theoremHigh TPSOceanBase
0 likes · 42 min read
Design of Ant Financial's Logical Data Center (LDC) and Unitization for High‑TPS Payments
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 5, 2020 · Databases

Domestic Databases: TiDB, OceanBase, and Others – Insights from MySQL冲冲冲 Episode 8

In the eighth episode of the MySQL冲冲冲 live series, experts discuss the rise of Chinese domestic databases such as TiDB, OceanBase, and Jusheng, comparing their architectures, ecosystems, and market prospects while reflecting on the broader implications for MySQL‑based distributed systems.

Database ComparisonDomestic DBMSMySQL
0 likes · 11 min read
Domestic Databases: TiDB, OceanBase, and Others – Insights from MySQL冲冲冲 Episode 8
AntTech
AntTech
Oct 21, 2020 · Databases

Database Industry Collaboration Forum at CNCC 2020 Featuring OceanBase

The CNCC 2020 Database Industry Collaboration Forum in Beijing brings together leading experts and academics to discuss OceanBase’s distributed relational database successes, industry‑academia partnership models, and strategies for cultivating database talent through joint research, training, and ecosystem development.

OceanBaseTalent Development
0 likes · 8 min read
Database Industry Collaboration Forum at CNCC 2020 Featuring OceanBase
AntTech
AntTech
Sep 2, 2020 · Databases

OceanBase Distributed Relational Database Enables Insurance Business Innovation

The presentation outlines OceanBase's evolution, technical advantages such as high availability, scalability, performance, multi‑tenant HTAP capabilities, and its successful deployment in the insurance industry, demonstrating how a self‑developed distributed relational database can transform core financial services.

FinTechHTAPInsurance
0 likes · 12 min read
OceanBase Distributed Relational Database Enables Insurance Business Innovation
IT Architects Alliance
IT Architects Alliance
Aug 11, 2020 · Industry Insights

How Alibaba and Tencent Cloud Databases Compete in the Chinese Market

This article analyzes the features, performance benchmarks, market share growth, and use‑case scenarios of Alibaba Cloud's PolarDB, OceanBase and other services alongside Tencent Cloud's MySQL, CynosDB and related offerings, highlighting how each provider positions its cloud database portfolio in China’s fast‑growing market.

Alibaba CloudCloud databasesCynosDB
0 likes · 11 min read
How Alibaba and Tencent Cloud Databases Compete in the Chinese Market
Programmer DD
Programmer DD
Aug 1, 2020 · Databases

Inside Ant Financial’s LDC Architecture: Scaling Double‑11 Payments with OceanBase and CAP Theory

This article explains how Ant Financial’s logical data center (LDC) and unitized architecture, combined with OceanBase’s Paxos‑based consensus, enable the massive TPS growth for Double‑11 payments while addressing sharding, CAP trade‑offs, traffic diversion, and multi‑site disaster recovery.

Ant FinancialCAP theoremDisaster Recovery
0 likes · 37 min read
Inside Ant Financial’s LDC Architecture: Scaling Double‑11 Payments with OceanBase and CAP Theory
Top Architect
Top Architect
Jul 14, 2020 · Databases

Understanding Alipay’s LDC Architecture, Unitization, and CAP Analysis

The article explains how Alipay achieves massive payment throughput during Double‑11 by using logical data centers (LDC), unit‑based system design, multi‑active disaster‑recovery, and CAP‑theorem analysis, highlighting the role of OceanBase and PAXOS in ensuring consistency and availability.

CAP theoremDisaster RecoveryHigh TPS
0 likes · 37 min read
Understanding Alipay’s LDC Architecture, Unitization, and CAP Analysis
AntTech
AntTech
May 21, 2020 · Databases

OceanBase Sets New TPC‑C Record with 707 Million tpmC, Showcasing Linear Scalability and Cost Efficiency

OceanBase achieved a new TPC‑C world record of 707 million tpmC using 1,557 cloud servers, demonstrating near‑linear horizontal scalability, significant single‑node performance gains, efficient parallel query processing, and a markedly lower cost per transaction compared with traditional high‑end hardware solutions.

Cloud ComputingOceanBaseTPC-C
0 likes · 9 min read
OceanBase Sets New TPC‑C Record with 707 Million tpmC, Showcasing Linear Scalability and Cost Efficiency
ITPUB
ITPUB
Apr 13, 2020 · Databases

How Ant Financial Scales to Hundreds of Thousands TPS with LDC, Unitization, and CAP Mastery

This article explains how Ant Financial’s LDC (Logical Data Center) architecture, unitized RZone/GZone/CZone design, OceanBase database, and CAP-aware strategies enable the payment platform to handle double‑11 traffic peaks of over 540,000 transactions per second while ensuring high availability, disaster recovery, and eventual consistency.

CAP theoremDisaster RecoveryHigh TPS
0 likes · 37 min read
How Ant Financial Scales to Hundreds of Thousands TPS with LDC, Unitization, and CAP Mastery
Alibaba Cloud Developer
Alibaba Cloud Developer
Mar 27, 2020 · Databases

How OceanBase Delivers Cloud‑Native Distributed Relational Database Performance and Availability

This article explains OceanBase's public‑cloud deployment, its unique architecture without a central controller, horizontal scaling via partition groups, LSM‑Tree storage design, advanced SQL engine features, ACID‑plus‑Availability guarantees, and real‑world performance records, illustrating why it suits high‑availability financial workloads.

Cloud NativeHigh AvailabilityLSM Tree
0 likes · 12 min read
How OceanBase Delivers Cloud‑Native Distributed Relational Database Performance and Availability