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
Photo by Learn OceanBase (@LearnOceanBase)Photo by Learn OceanBase (@LearnOceanBase)Photo by Learn OceanBase (@LearnOceanBase)Photo by Learn OceanBase (@LearnOceanBase)Photo by Learn OceanBase (@LearnOceanBase)Photo by Learn OceanBase (@LearnOceanBase)Photo by Learn OceanBase (@LearnOceanBase)Photo by Learn OceanBase (@LearnOceanBase)Photo by Learn OceanBase (@LearnOceanBase)Photo by Learn OceanBase (@LearnOceanBase)
🌊 Meet OceanBase: Open-source, distributed, and built for mission-critical apps. On-prem, hybrid, or multi-cloud? We’ve got you covered. 🧑‍🚀 Watch our video to see why it’s the top choice for mission-critical business operations👉youtu.be/qNGHXThYntk #OceanBase #database
2
499
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
Converging operational, analytics, & AI workloads into one engine removes latency. Silos force ETL pipelines that stale data. Unified layers enable real-time decisioning on fresh state. Architecture walkthrough: #DistributedSQL #AI #OceanBase en.oceanbase.com/blog/data-m…
3
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