Still have MySQL 5.6 variable binlog_error_action as IGNORE_ERROR?

Kedar
April 10, 2020

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…

View Post

ProxySQL Configuration & Startup Process explained

Kedar
October 8, 2019

This post covers Proxysql start up process, Layers and configuration file.

View Post

MySQL 8 Resource Group – introduction and dynamic allocation

Kedar
September 7, 2018

Introduction to resource groups in MySQL 8 and dynamical allocation to threads

View Post

Restore A Table / Database From Full Backup – Yet Another Way

Kedar
June 29, 2018

How to Restore A Table / Database From Full Backup using MySQL Grants & mysqldump.

View Post

A tale of Corrupt InnoDB table, MySQL crash & recovery

Kedar
January 18, 2018

I’m going to narrate you a story that happened around a crashing MyQL, Corrupted InnoDB table and finally the recovery by table restore. We will see how our database administrator…

View Post

MySQL to Galera Cluster Migration, Deadlock, Back to basics

Kedar
March 2, 2017

This post is a lab experiment learning from migration to the Percona Xtradb Cluster (Galera) and a very unexpected DEADLOCK scenario which took me back to basics. (root@localhost) [test]>insert into…

View Post