Tagged articles
235 articles
Page 2 of 3
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.

Database OptimizationLocal 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.

OceanBasedatabase troubleshootingmemory calculation
0 likes · 11 min read
Resolving ERROR 1499: Too Many Partitions in OceanBase/MySQL
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 23, 2023 · Databases

Collecting and Comparing OceanBase Parameters Using Shell Scripts and Excel VLOOKUP

This article explains how to use Shell scripts together with Excel VLOOKUP to extract OceanBase cluster Parameters, Variables, and ProxyConfig values, compare them against default or DBA‑tuned settings, and generate a report that highlights unexpected configurations for manual verification.

Configuration ManagementDatabase ParametersExcel
0 likes · 6 min read
Collecting and Comparing OceanBase Parameters Using Shell Scripts and Excel VLOOKUP
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 AuditingOceanBaseRelease Notes
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.

OceanBaseReplicationReset 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 NativeOceanBaseScalability
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.

Freeze ThresholdMemory ManagementOceanBase
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 ManagementDocker
0 likes · 25 min read
Replacing OCP Nodes Using the ANTMAN Tool in OceanBase Cloud Platform
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 SecurityOceanBasePrivileges
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.

OceanBaseSQLWeekly Summary
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.

OceanBaseSQLTiDB
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 29, 2023 · Databases

Customizing OBClient Welcome Message by Modifying Source Code

This article explains how to customize the OBClient client’s welcome output by installing dependencies, cloning the OceanBase OBClient source, editing specific source files to replace default strings, recompiling the client, installing the new package, and verifying the changed prompts.

CompilationDatabase clientOBClient
0 likes · 8 min read
Customizing OBClient Welcome Message by Modifying Source Code
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.

Database AdministrationDumpFreeze
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 PowerOceanBase
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.

Local IndexOceanBaseSQL
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 tableOceanBaseSQL
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 AdministrationOceanBaseSQL
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 operationsObserverOceanBase
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.

OceanBasePerformance Diagnosisdatabase migration
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.

OceanBaseResource UnitSQL
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
Jan 16, 2023 · Databases

Deploying OceanBase 4.X as a Minimal Single‑Node Distributed Database

This article demonstrates how to deploy OceanBase 4.X in a minimal single‑node configuration, explains the key resource parameters, provides the necessary YAML configuration and command‑line steps to start the server, create a MySQL‑compatible tenant, and verify resource usage and basic database operations.

Database ConfigurationMySQL compatibilityOceanBase
0 likes · 7 min read
Deploying OceanBase 4.X as a Minimal Single‑Node Distributed Database
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.

OceanBaseSQL auditcommunity newsletter
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 SeparationOceanBaseTiDB
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 ToolsOceanBaseRDS
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 AuditingOceanBasePostgreSQL
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 AuditingOceanBaseRelease Notes
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 proxyTiDB
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 NativeLoad TestingOceanBase
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.

HTAPOceanBaseTechnology Evolution
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 theoremDistributed SystemsHigh TPS
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 theoremDistributed SystemsHigh 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 theoremDistributed SystemsOceanBase
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 theoremDistributed SystemsLDC 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.

EcosystemOceanBasePaxos
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 theoremDistributed SystemsLDC architecture
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 theoremDistributed SystemsLDC 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 theoremDistributed SystemsOceanBase
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 theoremDistributed SystemsHigh TPS
0 likes · 42 min read
Design of Ant Financial's Logical Data Center (LDC) and Unitization for High‑TPS Payments
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 theoremDistributed Systems
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 theoremDistributed SystemsHigh 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.

OceanBaseTPC-Ccloud computing
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 theoremHigh TPSLDC
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 NativeLSM‑TreeOceanBase
0 likes · 12 min read
How OceanBase Delivers Cloud‑Native Distributed Relational Database Performance and Availability
Top Architect
Top Architect
Mar 17, 2020 · Databases

Understanding Ant Financial’s LDC Architecture: Unitization, CAP Analysis, and High‑TPS Design

This article explains how Ant Financial’s massive Double‑11 payment traffic is handled through logical data centers (LDC), unit‑based architecture (RZone, GZone, CZone), traffic routing, disaster‑recovery strategies, and a CAP analysis that highlights the role of OceanBase’s Paxos‑based consensus in achieving high availability and eventual consistency.

CAP theoremDistributed SystemsOceanBase
0 likes · 36 min read
Understanding Ant Financial’s LDC Architecture: Unitization, CAP Analysis, and High‑TPS Design
21CTO
21CTO
Mar 16, 2020 · Backend Development

How Ant Financial Scales Payments with Distributed Architecture and OceanBase

The article summarizes Xu Wenqi's 2019 Alibaba Cloud Summit talk on Ant Financial's distributed architecture, covering the shift from monolithic to microservices, modular development, load‑balancing, database sharding, the distributed TA system, task scheduling, gray‑release, full‑link stress testing, and OceanBase high‑availability solutions.

Backend ArchitectureDistributed SystemsMicroservices
0 likes · 9 min read
How Ant Financial Scales Payments with Distributed Architecture and OceanBase
AntTech
AntTech
Mar 12, 2020 · Databases

Comprehensive Overview of OceanBase 2.2: Architecture, Core Features, and Enterprise Solutions

This article provides an in‑depth technical overview of OceanBase 2.2, covering its distributed architecture, high‑availability design, multi‑tenant resource pool, Oracle/MySQL compatibility, performance benchmarks, ecosystem tools such as OCP, ODC, OMS, and disaster‑recovery solutions for financial‑grade workloads.

OceanBaseSQL Compatibilitydistributed database
0 likes · 14 min read
Comprehensive Overview of OceanBase 2.2: Architecture, Core Features, and Enterprise Solutions
AntTech
AntTech
Feb 24, 2020 · Databases

The Enduring Dominance of Relational Databases and the Rise of Distributed OceanBase

This article reviews the historical evolution, market size, and technical advantages of relational databases, explains the shift from centralized to distributed architectures, and highlights OceanBase's recent breakthroughs and community events as a modern distributed relational solution.

Cloud NativeDatabase MarketOceanBase
0 likes · 8 min read
The Enduring Dominance of Relational Databases and the Rise of Distributed OceanBase
Top Architect
Top Architect
Jan 6, 2020 · Backend Development

Alipay’s LDC Architecture: High‑TPS Design, Unitization, and CAP Analysis

The article explains how Alipay’s Logical Data Center (LDC) architecture, with its RZone, GZone, and CZone unitization, combined with OceanBase’s Paxos‑based consensus, enables massive TPS growth, traffic diversion, and disaster‑recovery while navigating the CAP theorem constraints.

CAP theoremDistributed SystemsHigh TPS
0 likes · 35 min read
Alipay’s LDC Architecture: High‑TPS Design, Unitization, and CAP Analysis
AntTech
AntTech
Nov 28, 2019 · Databases

Enterprise Database Platforms: Trends, Challenges, and OceanBase Innovations

The talk reviews the evolving challenges of enterprise databases, the shift toward distributed and cloud‑native architectures, and how OceanBase addresses high availability, scalability, hardware independence, and performance standards such as TPC‑C to meet modern financial and enterprise workloads.

Enterprise DatabaseOceanBaseTPC-C
0 likes · 15 min read
Enterprise Database Platforms: Trends, Challenges, and OceanBase Innovations
AntTech
AntTech
Nov 27, 2019 · Databases

OceanBase Technical Overview: Distributed Transaction Processing and TPC‑C Benchmark

The article presents a detailed technical overview of OceanBase, explaining why traditional centralized databases cannot meet modern OLTP and OLAP demands, how OceanBase achieves distributed transaction processing with Paxos‑based replication and majority voting for high availability, and how it validates its capabilities through the TPC‑C benchmark.

OceanBaseTPC-Chigh availability
0 likes · 18 min read
OceanBase Technical Overview: Distributed Transaction Processing and TPC‑C Benchmark
Alibaba Cloud Developer
Alibaba Cloud Developer
Nov 11, 2019 · Cloud Computing

How Alibaba Cloud Powered a 2.684 Trillion‑Yuan Double 11 with Self‑Built Technology

Alibaba Cloud’s CTO explains how the company’s fully self‑developed cloud platform—featuring the Feitian operating system, Shenlong servers, OceanBase and PolarDB databases, RDMA networking, and a custom AI chip—handled the record‑breaking 2019 Double 11 traffic of 2.684 trillion yuan, 54.4 k orders per second, and 970 PB of data.

Alibaba CloudDouble 11Feitian OS
0 likes · 7 min read
How Alibaba Cloud Powered a 2.684 Trillion‑Yuan Double 11 with Self‑Built Technology