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…
MySQL Permission denied error 13 and solution
MySQL ERROR 1018 (HY000): Can’t read dir of ‘./sakila/’ (errno: 13 – Permission denied) caused due to moving database to a different partition and using softlink on CentOS and it’s fix for SELinux.
How to monitor MySQL backups
It’s important to monitor the (database) backups after you set-it-up. In this post we will answer a few how to monitor MySQL Database backups solutions – monitoring methods. We should…