Restore A Table / Database From Full Backup – Yet Another Way
Kedar
How to Restore A Table / Database From Full Backup using MySQL Grants & mysqldump.
Browsing Tag
MySQL
72 posts
A tale of Corrupt InnoDB table, MySQL crash & recovery
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…
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.