MySQL 8 – timestamp cannot be null and explicit_defaults_for_timestamp

March 20, 2023

A friend’s application started failing with MySQL causing error about timestamp columns and it needs urgent fixing from the database side. A timestamp column was not accepting the null values…

Restore single MySQL table (ibd) from Xtrabackup (video demo)

December 14, 2022

In this blog we will create MySQL backup and then restore single table from Percona Xtrabackup without doing full restore. This post is basically a work-log in response to a…

MySQL Interview – ChatGPT is not your DBA

December 14, 2022

Given the recent surge of interest in ChatGPT and the AI capabilities it offers, I decided to conduct an interview with it to assess its suitability for a MySQL Consultant…

Securing MySQL: Data Encryption with Percona Server and Vault

December 10, 2022

Percona Tech Days are free, half-day events dedicated to the most popular open source database technologies: PostgreSQL, MongoDB and MySQL. This talk for MySQL was related to MySQL Encryption with…

Can not connect to ProxySQL: reasons and fixtures

October 11, 2022

This ProxySQL post is sourced from an error I faced recently ProxySQL has become one of the popular choice as the “proxy” for MySQL databases. This post is tipping you…

Providing Friday Proofs to MySQL Consultants | Scripts Functions Routines

September 24, 2022

In the MySQL world, I am surrounded by some of the best database consultant, it brings them immense joy about having a “Friday”, so much so that they cannot believe…