Learn OceanBase (@LearnOceanBase) header
Learn OceanBase (@LearnOceanBase) profile picture

A resource for developers and sys-admins using #OceanBase database. Maintained by Neeerd - a passionate user of OceanBase | Opinions my own.

Joined May 2022
Hybrid tables serve TP and AP queries against same data. Optimizer chooses access path based on query type. No need to sync separate engines for operational scans. #AI #DevOps #OceanBase
6
Location-aware queries need more than relational filters. MySQL mode supports spatial data types and indexes. Complements transactional state for logistics tracking. #Database #Geo #OceanBase
25
Scale operations shouldn't require manual resharding. Tablets are the smallest balancing unit. System transfers them between log streams as topology changes. #SRE #CloudNative #OceanBase
7
Same natural language query means different things to a CEO vs a branch manager. "Loan disbursements" carries distinct semantics per role. Simple text-to-SQL misses context. A semantic layer interprets intent, not keywords. #LLM #Database #OceanBase
10
Agents will make mistakes. Human confirmation matters. Database branching allows forks for isolated experimentation, committing only if correct or rolling back if not. Safer automation requires this primitive. #AgenticAI #DevOps #OceanBase
4
RAG cost isn't just model inference. It's feeding the model too much context. Narrowing candidates via hybrid search before ingestion reduces tokens & tightens control over what the model sees. #LLM #RAG #OceanBase
2
Technical capability isn't the bottleneck. Organizational comfort with machine autonomy is. Defining acceptable risk thresholds for agent actions is harder than building the agents themselves. Governance sets the speed limit. #OceanBase
1
Infrastructure layers between model & data introduce latency that kills real-time decisions. Performance depends on data proximity, not just compute power. Minimize middleware between intelligence & state. #MLOps #Database #OceanBase
Legacy apps own business logic. Agent-driven systems might shift logic closer to the data layer. If agents act autonomously, embedding rules in the database reduces coordination overhead. Rethink where intelligence lives. #OceanBase
3
We respond to AI by adding layers. Another DB, pipeline, tool. The real opportunity is simplification. Use AI to understand legacy data, reduce migration complexity, & consolidate fragmented architectures. Make infrastructure self-managing. #OceanBase
Logical binlog replay creates overhead. Physical commit logs are smaller & cheaper to replay, helping new nodes catch up faster during replacement. #Database #HighAvailability #OceanBase
Add high-spec node → migrate data → offline old node. This sequence ensures capacity grows before legacy resources retire, preventing availability dips. #CloudNative #DevOps #OceanBase
2
Open explicit transactions must roll back during switchover to prevent split-brain scenarios. Consistency takes precedence over automatic retry logic. #Database #SRE #OceanBase
3
Database proxy layers refresh routing caches immediately when an OBServer reports a role mismatch. Subsequent requests forward to the new leader automatically. #DistributedSQL #DevOps #OceanBase
2
Leader election relies on a lease-based protocol. Old leaders do not step down until committed work is durable on the target replica, ensuring safety. #HighAvailability #CloudNative #OceanBase
1
1
7
Replication happens at log-stream level. A log stream carries logs for specific tablets on a node, not everything on the machine. This allows finer scheduling during sync. #Database #DevOps #OceanBase
1
7
Physical machine = office building. Tenant resource units = leased offices. Scaling up means moving tenants to a bigger building, not just adding desks inside the same structure. #DistributedSQL #SRE #OceanBase
7
Operational data, real-time analytics, and AI workloads converge on one unified database. Removing synchronization boundaries between transactional state & intelligence layers simplifies the stack. #AI #DataEngineering #OceanBase
15
Partition strategy remains a first-class design exercise. A good key keeps dominant request paths local. A poor one turns common ops into distributed transactions. Design for locality. #Architecture #DevOps #OceanBase
13