Providing Friday Proofs to MySQL Consultants | Scripts Functions Routines
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…
The Low Hanging Fruits of MySQL – Percona Live Community 2022
MySQL is one of the top used database system and with highly active community. Though without proper configuration you may not squeeze the most out of it.This will be a…
Relay log read failure | 2 many dots can break your replication only once
Two or more dots in your relay log or binary log names can break replication; but worry not, it will only do it once. If you request to start again,…
MySQL Backup setup, automation using Holland, mysqldump on Ubuntu
This post will guide you to set up and automate the MySQL logical backups using mysqldump on Ubuntu Linux. We will set-up MySQL backup using mysqldump and automate it with…
Still have MySQL 5.6 variable binlog_error_action as IGNORE_ERROR?
Recently, we were affected by an ignored configuration option introduced in MySQL 5.6. This incident caused us to perform extended planning of downtime and the rebuilding of the slave. In…
ProxySQL Configuration & Startup Process explained
This post covers Proxysql start up process, Layers and configuration file.