In this post we will see a case study of a Galera Cluster migration to AWS Aurora and quick solution to the replication issue. A friend received an error in…

The post Galera cluster to AWS Aurora migration & HA_ERR_FOUND_DUPP_KEY first appeared on Change Is Inevitable.

How to Restore A Table / Database From Full Backup using MySQL Grants & mysqldump.

The post Restore A Table / Database From Full Backup – Yet Another Way first appeared on Change Is Inevitable.

Today lets talk a little about converting a MySQL table to CSV (Excel). My friend was looking to export MySQL to Excel, I saw couple of questions for export MySQL…

The post Export MySQL database table to CSV (delimited / Excel) file first appeared on Change Is Inevitable.

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…

The post A tale of Corrupt InnoDB table, MySQL crash & recovery first appeared on Change Is Inevitable.

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…

The post MySQL to Galera Cluster Migration, Deadlock, Back to basics first appeared on Change Is Inevitable.

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

The post MySQL database restore issues using xtrabackup – facepalm moments first appeared on Change Is Inevitable.

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

The post corrupted / crashed MyISAM + mysql_repair_threads = stuck “Repair with N threads” first appeared on Change Is Inevitable.

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

The post Fixing inconsistency on MySQL Slave of Galera Cluster first appeared on Change Is Inevitable.

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.

The post Setting-up second MySQL instance & replication on Linux in 10 steps first appeared on Change Is Inevitable.

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

The post pt-table-checksum & Waiting to check replicas for differences: 0% 00:00 remain first appeared on Change Is Inevitable.