Ankit Mehta

Founder · Bangkok, Thailand

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

Verified profiles

https://vigileshq.com

Published on OceanDB Pro

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.