MySQL to Galera Cluster Migration, Deadlock, Back to basics

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

MySQL database restore issues using xtrabackup – facepalm moments

June 13, 2016

Learning from facepalm moments of a MySQL database restore from Percona Xtrabackup.

View Post

corrupted / crashed MyISAM + mysql_repair_threads = stuck “Repair with N threads”

December 7, 2015

This post explains on the usage of mysql_repair_threads for repairing myisam table & the processlist status Repair with N threads

View Post

Fixing inconsistency on MySQL Slave of Galera Cluster

December 4, 2015

This blog post explores the syncing options for an inconsistent MySQL slave of Galera cluster node using pt-table-sync

View Post

Setting-up second MySQL instance & replication on Linux in 10 steps

November 4, 2015

This is a quick setup guide of 10-steps to install and configure (multiple) MySQL instance on 3307 port, and make it slave from MySQL running on port 3306.

View Post

pt-table-checksum & Waiting to check replicas for differences: 0% 00:00 remain

October 19, 2015

This post discuss the pt-table-checksum & error “Waiting to check replicas for differences: 0% 00:00 remain” with a use-case and solution.

View Post