The DataNinja
About

Posts

  • Nov 3, 2025

    Fixing Prod Query Slowdowns Caused by MySQL open_files_limit

  • Oct 10, 2025

    How pt-heartbeat Log Rotation Caused Disk Space Bloat on Our MySQL Nodes

  • Oct 3, 2025

    Unexpected MySQL Restarts on Ubuntu 24.04: The needrestart Change

  • Aug 18, 2025

    How innodb-flush-log-at-trx-commit saved the day

  • Jun 4, 2025

    MySQL to RDS Replication Script using XtraBackup and S3

  • May 8, 2025

    When a MySQL Replica Became Primary and Blew Up the Disk with Audit Logs

  • May 5, 2025

    Mysql Primary Promotion Using GTID

subscribe via RSS

The DataNinja

  • The DataNinja
  • pankajk1608@gmail.com
  • pankajtw
  • Pankajhbk007

Deep dives into database technologies like MySQL, GTID replication, high availability, and disaster recovery. Also covering OLAP solutions like Snowflake, distributed systems, Kafka-based event-driven architectures, and cloud infrastructure using AWS services like RDS, S3, and CDC pipelines into modern data warehouses.