Reset MySQL root password for Galera Cluster ( Percona Xtradb / MariaDB )

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 app values (1); ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction Little background: We needed to work on migrating the […]

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

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

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

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.

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

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 questions came to me: Do you need to setup Nagios again on all servers that we want to monitor? How do you add another MySQL […]

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.

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 see suggestions for: Monitoring Holland MySQL Backup Monitoring mysqldump backups Monitoring Xtrabackup using log Monitoring Backups using Nagios Usually we can have our backup script […]