OceanBase for production teams
Ship HTAP workloads without rewriting your stack.
Deep guides, runbooks, and tooling for architects migrating to OceanBase, from Paxos internals to cutover checklists.
EXPLAIN ANALYZE SELECT o.order_id, c.name, SUM(l.amount)
FROM orders o
JOIN customers c ON c.id = o.customer_id
JOIN order_lines l ON l.order_id = o.order_id
WHERE o.created_at >= '2026-01-01'
GROUP BY o.order_id, c.name
ORDER BY SUM(l.amount) DESC
LIMIT 20;
+----+-------------+-------+------------+------+
| id | operation | name | est. rows | time |
+----+-------------+-------+------------+------+
| 0 | TABLE SCAN | lines | 2,400,000 | 45ms|
| 1 | HASH JOIN | orders| 48,200 | 12ms|
| 2 | HASH GROUP | | 20 | 3ms|
+----+-------------+-------+------------+------+ sysbench oltp_read_write \
--mysql-host=ob-proxy.internal \
--tables=32 --table-size=5000000 \
--threads=128 --time=300 run
transactions: 1,842,401 (6142.67 per sec.)
queries: 36,848,020 (122853.40 per sec.)
avg latency: 20.84ms
p95 latency: 38.12ms
p99 latency: 62.47ms --- obcluster.yaml (before)
+++ obcluster.yaml (after)
zones:
- name: zone_a
- replica: 2
+ replica: 3
- name: zone_b
replica: 3
memory_limit: 64G
+enable_log_archive: true
+log_archive_dest: s3://ob-backups/prod Content pillars
Ten focused tracks from architecture internals to backup and disaster recovery.
-
Architecture Deep Dives
Storage engine internals, log streams, and distributed topology.
-
Migration Guides
Schema conversion, cutover playbooks, and validation checklists.
-
HTAP & Real-World Use Cases
Hybrid transactional/analytical workloads on OceanBase.
-
Performance Tuning
Query plans, index design, and workload-specific optimizations.
-
High Availability & Paxos Internals
Quorum design, leader election, and failover behavior.
-
Benchmarks & Capacity Planning
TPC-style benchmarks, sizing models, and growth projections.
-
Troubleshooting Runbooks
Diagnostic workflows for common production incidents.
-
Multi-Tenancy & Resource Isolation
Tenant quotas, CPU/memory isolation, and noisy-neighbor mitigation.
-
Compatibility Modes (MySQL & Oracle)
SQL dialect differences, driver settings, and migration gotchas.
-
Operations/Backup/DR
Backup schedules, restore testing, and disaster recovery planning.
Latest guides
-
Log Stream Architecture in OceanBase
How OceanBase partitions data into log streams, elects leaders, and replicates via Paxos across zones.
-
MySQL to OceanBase Migration Checklist
A phased checklist for schema conversion, dual-write validation, and production cutover from MySQL.
-
HTAP Retail Inventory: OLTP + Analytics on One Cluster
How a retail workload combines real-time inventory updates with same-day sales aggregates without ETL.
-
Index Selection for Wide Tables
Practical heuristics for choosing primary, secondary, and covering indexes on wide OceanBase tables.
-
Paxos Quorum Design for Multi-Region
Replica placement, witness nodes, and quorum math for OceanBase across two or three regions.