Yang Shanggang, head of Weibo's database technology, takes a deep dive into Weibo's database architecture upgrade: replacing MySQL sharding with OceanBase partitioned tables, cutting storage usage from 50TB to 27TB and saving 46% in cost, and sharing experience on partitioned table design and statistics gathering, along with plans to explore KV and vector scenarios.
This article compiles the 50 mock questions publicly available on the OBCP V4 official site—covering single-choice, multiple-choice, and true/false questions—and gives an answer analysis for each based on the official tutorial content, covering core topics such as LDC routing, global indexes, compaction, OMS migration, and log streams, to help candidates prepare.
This article traces the evolution of OceanBase auto-increment columns from 4.0.0 to 4.2.3, compares the principles and jump behavior of the ORDER and NOORDER modes, summarizes best practices for bigint/int selection, mode switching, and cache size tuning, and introduces the Sequence extension in MySQL mode.
In this article, OceanBase community contributor Li Ziyi takes a deep dive into the design of okctl-mcp-server, explaining how the MCP protocol lets AI perform complex operations on OceanBase on K8s—such as cluster creation and tenant management—through natural language, and discussing optimizations like dynamic loading and long-task polling along with current limitations.
Zhao Hui, head of Du Xiaoman's Technology Committee, shares their unified storage architecture practice: selecting OceanBase based on four cost advantages (migration, resources, learning, operations), and validating it across five scenarios—low-latency queries over massive data, real-time data warehouse read/write, high-throughput variable writes, vector hybrid queries, and KV read/write—achieving double the delivery efficiency and over 3x cost benefits.
Faced with the challenges of dynamic planning, service discovery, and usage complexity brought by tens of thousands of MCP tools, Ant Group Agent engineer Wang Yihui shares the design and practice of MCP Advisor: built on OceanBase's scalar-vector hybrid search and a multi-Provider architecture, it provides LLMs with MCP recommendation and installation capabilities, and lays out four stages of future development.
Through a hands-on case study, this article shows how to use Dify, OceanBase, and MCP to build a fully functional RAG application from scratch. It covers the complete workflow of deploying OceanBase, configuring Dify, indexing a knowledge base, creating a chat assistant, and turning a Dify application into an MCP Server that external clients can call.
China Unicom shares the journey of building ChatDBA, its intelligent database expert, explaining why it upgraded from MySQL+Milvus to the OceanBase vector database, and publishing the results of a hands-on functional and performance comparison among Milvus, Elasticsearch, and OceanBase.
Zhifeng Yang, General Manager and Chief Architect of the OceanBase product, offers a technical interpretation of the standalone-distributed integrated architecture: reviewing OceanBase's three architectural upgrades and analyzing how dynamic log streams eliminate distributed overhead and enable flexible switching between standalone and distributed forms, supporting the full lifecycle of a business.
This article summarizes hands-on experience from OceanBase AP workload PoCs, centered on business migration strategy and database object design. It covers data clustering, data distribution, compaction strategy, partition management, collation, indexing, the choice between row and column storage, and common problems with incremental data and how to solve them.