Medium

Manikaran Kathuria

he

In

AWS in Plain English

by

Manikaran Kathuria

·

Jan 12

Understanding MySQL Metadata Locks with Examples

This blog deep dives into MySQL metadata locks to help app developers understand how databases work under the hood, shown with examples.

Understanding MySQL Metadata Locks with Examples

In

AWS in Plain English

by

Manikaran Kathuria

·

Dec 22, 2025

Starrocks deployment using Ansible

Deploying starrocks clusters on ec2 instances using tools- terraform and ansible. Infrastructure as a tool helps manage platform easily.

Starrocks deployment using Ansible

In

Towards Dev

by

Manikaran Kathuria

·

Sep 28, 2025

Apache Iceberg for Data Lakehouse

Iceberg is an open-source table format widely used for modern data lakehouses. It provides ACID guarantees and better analytical…

Apache Iceberg for Data Lakehouse

In

AWS in Plain English

by

Manikaran Kathuria

·

Aug 12, 2025

Mastering Postgres partition management

Postgres partition management with pg partman and adding indexes to all the existing partitions without impacting database running at scale

Mastering Postgres partition management

In

Towards Dev

by

Manikaran Kathuria

·

Jul 26, 2025

MySQL + CDC (without Kafka) to update configs in real-time

Realtime processing of the change events to keep the configurations stored in Redis up-to-date in near real-time.

MySQL + CDC (without Kafka) to update configs in real-time

Manikaran Kathuria

·

May 1, 2025

The Cost of a Bad Plan: Optimizer Misfire in Production

Do not trust query optimiser to always run your query in the best possible way. Always double check the query plan. Be miser in disk reads.

The Cost of a Bad Plan: Optimizer Misfire in Production

In

Towards Dev

by

Manikaran Kathuria

·

Dec 28, 2024

Cross Account Open search Cluster access

A guide to allow access to an open search cluster from a different account, different VPC and same region. A recommended approach to…

Cross Account Open search Cluster access

In

Towards Dev

by

Manikaran Kathuria

·

Dec 16, 2024

Kinesis consumer using KCL in Python

How to write a record processor using Kinesis Consumer Library in Python? Gain an in-depth understanding of AWS Kinesis stream processing.

Kinesis consumer using KCL in Python

In

Towards Dev

by

Manikaran Kathuria

·

Nov 9, 2024

How do you add a constraint to the huge table in Postgres?

Adding a check constraint to a huge production table without blocking reads or writes.

How do you add a constraint to the huge table in Postgres?

In

Towards Dev

by

Manikaran Kathuria

·

Nov 6, 2024

Partitioning in Postgres

Guide to partition a table in Postgres.

Partitioning in Postgres

Manikaran Kathuria

Manikaran Kathuriahe

A startup enthusiast and technologist who loves to solve problems at scale. Solving big data problems is something I'm fascinated about.

Following

Help

Status

About

Careers

Press

Blog

Store

Privacy

Rules

Terms

Text to speech