A tale of Corrupt InnoDB table, MySQL crash & recovery
Kedar
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…
Browsing Tag
MySQL
77 posts
MySQL to Galera Cluster Migration, Deadlock, Back to basics
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…
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
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…
UMASK & UMASK_DIR – changing default MySQL file dir permissions
UMASK and UMASK_DIR are amongst few MySQL Environment variables which defines directory and file creation modes (file permissions). In this post we will understand using UMASK & UMASK_DIR for changing the database directory and file permissions from it’s default to what we need.
Cannot connect to MySQL server on ‘localhost’: Cacti Error
FATAL: Cannot connect to MySQL server on ‘localhost’: Cacti Error – Solution to the issue while setting-up.