Browsing Category

MySQL

113 posts

Articles related to MySQL, Percona Server, MariaDB

MySQL to Galera Cluster Migration, Deadlock, Back to basics

Kedar
March 2, 2017

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…

View Post

MySQL database restore issues using xtrabackup – facepalm moments

Kedar
June 13, 2016

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

View Post

corrupted / crashed MyISAM + mysql_repair_threads = stuck “Repair with N threads”

Kedar
December 7, 2015

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

View Post

No comments

Fixing inconsistency on MySQL Slave of Galera Cluster

Kedar
December 4, 2015

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

View Post

Setting-up second MySQL instance & replication on Linux in 10 steps

Kedar
November 4, 2015

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.

View Post

pt-table-checksum & Waiting to check replicas for differences: 0% 00:00 remain

Kedar
October 19, 2015

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

View Post