January 24, 2018

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 […]

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 […]

MySQL 8 new features I will be using often

MySQL 8 is incorporated with numerous features which excites all enthusiastic MySQL Database Architects / DBAs / Database Engineers / DBA Managers, I am attracted to few of them which will make my day-to-day MySQL […]

How the DBA job is evolving for future ?

Introduction  Being a Database Technology Specialist for almost 16 years I get to talk in several community conferences, colleges and startups, Recently I was talking about the career prospects of being a DBA in a […]