AM
Ankit Mehta
Founder · VigilesHQ · The complete incident management platform
Ankit Mehta founded OceanDB Pro and Vigiles. His work spans database architecture, cloud infrastructure, and enterprise technology delivery in APAC.
Founder and technical author for OceanDB Pro. Founder of Vigiles (vigileshq.com).
Technical topics
- OceanBase architecture and operations
- Database migration and cutover planning
- High availability and Paxos quorum design
- Performance tuning and capacity planning
- Production runbooks and day-two operations
Profiles
Published on OceanDB Pro
- Concepts
Database Types Explained: From OLTP and OLAP to HTAP, Vector Databases and OceanBase
Understand OLTP, OLAP, HTAP, relational, NoSQL, in-memory, vector and AI databases, plus where OceanBase fits and where it does not.
- Guide
Backup and Point-in-Time Recovery
Backup types, restore validation, and PITR workflows for OceanBase tenants in production.
- Guide
Diagnosing Replication Lag
Find and fix OceanBase replication lag on log streams before it becomes an outage.
- Guide
HTAP Retail Inventory: OLTP + Analytics on One Cluster
How a retail workload combines real-time inventory updates with same-day sales aggregates without ETL.
- Guide
Index Selection for Wide Tables
Practical heuristics for choosing primary, secondary, and covering indexes on wide OceanBase tables.
- Guide
Log Stream Architecture in OceanBase
How OceanBase partitions data into log streams, elects leaders, and replicates via Paxos across zones.
- Guide
MySQL to OceanBase Migration Checklist
A phased checklist for schema conversion, dual-write validation, and production cutover from MySQL.
- Guide
Oracle Mode vs MySQL Mode: SQL Differences
Syntax and function differences when choosing OceanBase MySQL or Oracle compatibility mode.
- Guide
Paxos Quorum Design for Multi-Region
Replica placement, witness nodes, and quorum math for OceanBase across two or three regions.
- Guide
Tenant Resource Isolation with Resource Groups
CPU and memory caps per tenant workload using OceanBase resource group directives.
- Guide
TPC-C Style Benchmark Setup on OceanBase
Reproducible sysbench/TPC-C harness configuration for baseline capacity numbers.
- Runbook
Leader Failover Runbook
Controlled steps to verify and recover from OceanBase log stream leader failure.
- Runbook
MemStore Freeze Incident Runbook
Respond when tenant memstore reaches limit and writes stall.
- Blog
OceanBase 4.x Release Notes for Operators
Operator-facing changes in OceanBase 4.x: log streams, EXPLAIN ANALYZE, and OCP requirements.
- Concepts
What is OceanBase?
OceanBase is a distributed relational database that replicates data in log streams using Paxos. It supports MySQL and Oracle compatibility modes.