Reset root password on Galera Cluster (Percona or MariaDB)
Kedar
Reset MySQL root password for Galera Cluster ( Percona Xtradb / MariaDB )
Browsing Category
MySQL
114 posts
Articles related to MySQL, Percona Server, 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.
corrupted / crashed MyISAM + mysql_repair_threads = stuck “Repair with N threads”
This post explains on the usage of mysql_repair_threads for repairing myisam table & the processlist status Repair with N threads
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
Setting-up second MySQL instance & replication on Linux in 10 steps
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.