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…
How to Pause (Suspend) a process in Linux with kill signals
In this post we will see how to pause (suspend) and start a linux process using signals (SIGTSTP and SIGCONT) via kill command.
Decoding Siebel Audit Trail with PLSQL
In this post we will understand how to decode Seibel Audit Trail using PLSQL. Siebel Audit Trail is feature in Siebel CRM which allows customer to track changes to important…
Reset root password on Galera Cluster (Percona or MariaDB)
Reset MySQL root password for Galera Cluster ( Percona Xtradb / MariaDB )
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…
MySQL database restore issues using xtrabackup – facepalm moments
Learning from facepalm moments of a MySQL database restore from Percona Xtrabackup.