MySQL database restore issues using xtrabackup – facepalm moments
Learning from facepalm moments of a MySQL database restore from Percona Xtrabackup.
corrupted / crashed MyISAM + mysql_repair_threads = stuck “Repair with N threads”
This post explains on the usage of mysql_repair_threads for repairing myisam table & the processlist status Repair with N threads
Fixing inconsistency on MySQL Slave of Galera Cluster
This blog post explores the syncing options for an inconsistent MySQL slave of Galera cluster node using pt-table-sync
Setting-up second MySQL instance & replication on Linux in 10 steps
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.
pt-table-checksum & Waiting to check replicas for differences: 0% 00:00 remain
This post discuss the pt-table-checksum & error “Waiting to check replicas for differences: 0% 00:00 remain” with a use-case and solution.
How to Add Remote MySQL Server to Nagios Monitoring
We already have seen two articles for setting up MySQL Monitoring with Nagios and Percona Monitoring Tools for Nagios. Those posts covers configuration of nagios on single instance. Though following…