Galera cluster to AWS Aurora migration & HA_ERR_FOUND_DUPP_KEY
Kedar
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…
Browsing Category
MySQL
124 posts
Articles related to MySQL, Percona Server, MariaDB
Restore A Table / Database From Full Backup – Yet Another Way
How to Restore A Table / Database From Full Backup using MySQL Grants & mysqldump.
Export MySQL database table to CSV (delimited / Excel) file
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…
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…
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…