January 24, 2018

Benchmarking ClickHouse

I have used data from BUREAU OF TRANSPORTATION STATISTICS https://www.transtats.bts.gov  for benchmarking ClickHouse (https://clickhouse.yandex) From their website, here is what the OnTime data covers: Airline on-time data are reported each month to the U.S. Department […]

SHOW ENGINE INNODB STATUS walk through

SHOW ENGINE INNODB STATUS is a very direct and simple SHOW ENGINE statement to display InnoDB Monitor output. The output of this query is quite detailed and exhaustive, It has wealth of information to troubleshoot […]

Step-by-step MySQL Master – Slave Replication on CentOS

Introduction MySQL master-slave replication is quite simple and direct way to scale-out reads optimally. Retaining multiple copies of master across slaves also guarantee reliability and maximum availability, Replication is never an substitute or alternative for […]

Storing numbers wisely in MySQL !

Generally we have two kinds of numbers, Whole numbers and real numbers (numbers with Fractional units). When we are using whole numbers the natural choice is TINYINT, SMALLINT, MEDIUMINT, INT and BIGINT. These datatypes require […]

MySQL Performance Optimization Checklist

I always thought of maintaining the checklist for MySQL Performance Optimization, This actually helps me to draw the first line of action items and developing scope at advanced stages. Optimizing at the Database LevelThe most important […]

Cost of Data Outage

Introduction  I spend most of my professional life consulting for Internet/Mobility/SaaS companies across Southeast Asia, MiddleEast and US as MySQL Architect, I am accountable for MySQL Infrastructure Operations, Site Reliability, Performance, Scalability and High Availability […]

Life of MySQL DBA

Introduction What is it like being a MySQL DBA? It is interesting and challenging!  A MySQL DBA is accountable equally for technology and business operations. Everyone agrees the accountability for technology operations but few asked […]

1 2