Services

Resources

Company

Our Work

Blog

Data Engineering

Back to Tags

Case Studies

Cover image for the case study Backup and recovery solution for SIEM data at Terabyte scale.

Read Case Study

Backup and recovery solution for SIEM data at Terabyte scale.
How One2N built an automated SIEM backup and restore pipeline for 1.5TB of security data per day across 100+ tenants, running under $200 per month.
Cover image for the case study Zero downtime MySQL schema migrations for 400M row table.

Read Case Study

Zero downtime MySQL schema migrations for 400M row table.
Case study: zero downtime MySQL schema migrations on a 400M row table, using gh-ost and pt-osc for seamless data copying and switchover.
Cover image for the case study Migrating 1.3TB of Primary Data from Self-Hosted MySQL to GCP CloudSQL.

Read Case Study

Migrating 1.3TB of Primary Data from Self-Hosted MySQL to GCP CloudSQL.
How One2N migrated Flip's 1.3TB self-hosted MySQL to GCP CloudSQL at 10,000 QPS peak, with under 10 minutes of cutover downtime and full data consistency.

Blogs

Cover illustration for How one parameter stalled Postgres replication with Debezium for 3 weeks

Read Blog

How one parameter stalled Postgres replication with Debezium for 3 weeks
Portrait of Harsh Mishra, SRE

Harsh Mishra

SRE

A story about WAL segments, missing events, and the one line of SQL that should have been there from the start.

Cover illustration for ClickHouse schema optimization for sparse data sets

Read Blog

ClickHouse schema optimization for sparse data sets
Portrait of Amit Sadafule, Lead Software Engineer

Amit Sadafule

Lead Software Engineer

Portrait of Spandan Ghosh, Content at One2N

Spandan Ghosh

Content @One2N

Portrait of Saurabh Hirani, Principal SRE at One2N

Saurabh Hirani

Principal SRE @One2N

Portrait of Chinmay Naik, CEO at One2N

Chinmay Naik

CEO @One2N

Schema designs for storing and querying sparse data sets in ClickHouse, including a sparse matrix and separate tables, and when each one fits.

Cover illustration for Database schema migrations: a practical guide to managing schema changes

Read Blog

Database schema migrations: a practical guide to managing schema changes
Portrait of Spandan Ghosh, Content at One2N

Spandan Ghosh

Content @One2N

Database schema migrations without manual steps: versioned migrations, running them in every deploy, and tools like Flyway, Liquibase and ORM migrations.

Cover illustration for Implementing a real-time analytics engine using big data principles

Read Blog

Implementing a real-time analytics engine using big data principles
Portrait of Jaideep Khandelwal, CTO at One2N

Jaideep Khandelwal

CTO @One2N

A real-time analytics engine for 50 million data points: replacing a MySQL setup with 48-hour query delays with Apache Spark pipelines and data marts.

Talks

Thumbnail for the talk AWS Outage: Real Costs & Disaster Recovery | One2N Bits Ep.4

Watch Talk

AWS Outage: Real Costs & Disaster Recovery | One2N Bits Ep.4
Portrait of Jaideep Khandelwal, CTO at One2N

Jaideep Khandelwal

CTO @One2N

Portrait of Srivatsa RV, SRE at One2N

Srivatsa RV

SRE @One2N

Srivatsa and Jaideep break down disaster recovery after a real AWS outage: RTO, RPO, the economics of DR setups, and what cloud promises don't cover.

Thumbnail for the talk Common pitfalls in Data Analytics: Patterns over Tools | One2N Bits Ep.3

Watch Talk

Common pitfalls in Data Analytics: Patterns over Tools | One2N Bits Ep.3
Portrait of Kshitish Deshpande, Software Engineer at One2N

Kshitish Deshpande

Software Engineer @One2N

Portrait of Jaideep Khandelwal, CTO at One2N

Jaideep Khandelwal

CTO @One2N

Kshitish from One2N breaks down the most common analytics traps startups fall into and why mental models matter more than tool choices.

Thumbnail for the talk Optimizing Kafka Performance with Automated Benchmarks

Watch Talk

Optimizing Kafka Performance with Automated Benchmarks
Portrait of Kalpesh Deo, Staff software engineer-II at One2N

Kalpesh Deo

Staff software engineer-II @One2N

Kalpesh Deo shares how he benchmarked Kafka producers with kafka-producer-perf-test.sh and what the experiments revealed about performance tuning.

Thumbnail for the talk What does It take to build a Software Defined Data Center at scale

Watch Talk

What does It take to build a Software Defined Data Center at scale
Portrait of Srivatsa RV, SRE at One2N

Srivatsa RV

SRE @One2N

Srivatsa RV, SRE at One2N, explains how virtualization, hyperconvergence and distributed systems let a software defined data center scale.

Thumbnail for the talk Mohit Kumar - Billion Rows Walk Into a Go Bar

Watch Talk

Mohit Kumar - Billion Rows Walk Into a Go Bar
Portrait of Mohit Kumar, Software Engineer

Mohit Kumar

Software Engineer

From minutes to seconds: how to tackle the 1 Billion Row Challenge in Go using pprof, mechanical sympathy, and memory allocation optimizations.

Thumbnail for the talk Monitoring the Future: Insights from VictoriaMetrics with Aliaksandr Valialkin

Watch Talk

Monitoring the Future: Insights from VictoriaMetrics with Aliaksandr Valialkin
Portrait of Chinmay Naik, CEO at One2N

Chinmay Naik

CEO @One2N

Chinmay Naik and Aliaksandr Valialkin, co-founder of VictoriaMetrics, discuss scaling monitoring systems and the future of cloud-native observability.

Thumbnail for the talk Just enough queuing theory to be dangerous

Watch Talk

Just enough queuing theory to be dangerous
Portrait of Chinmay Naik, CEO at One2N

Chinmay Naik

CEO @One2N

Just enough queueing theory to build better async systems: monitoring, scaling, and capacity planning for event-driven workloads in practice.

‹ Cost Optimization

Data Migration ›