Browsing Category

MySQL-Articles

78 posts

MySQL related blog posts

Debugging Percona Xtradb (Galera) Cluster node startup / SST errors

Kedar
January 21, 2015

A Percona Xtradb (Galera) Cluster node may fail to join it due to many possible mistakes causing SST to fail. It could be a configuration item or purely setup requirement. In this article we will be troubleshooting step by step the SST issues faced.

View Post

MariaDB slave restore using GTID & xtrabackup bug

Kedar
December 31, 2014

Restoring MariaDB (MySQL) slave using Xtrabackup & GTID.

View Post

xtrabackup_51: not found & no ‘mysqld’ group in MySQL options

Kedar
May 27, 2013

Recently I happen to setup a new MySQL instance with my tools – a standard MySQL 5.1+, xtrabackup setup and last-hotbackup.tar.gz. To restore from the backup we used xtrabackup binaries…

View Post

One comment

MySQL variable innodb_flush_method – summarized

Kedar
January 10, 2013

innodb_flush_method variable specifies how InnoDB opens and flushes log and data files. In Innodb optimization, setting the variable innodb_flush_method tweaks the performance most of the times but there are cases…

View Post

Is your backup complete? – backup MySQL users privileges / grants – pt-show-grants

Kedar
December 17, 2012

Everybody knows the criticality of backup. You might have had your database dumped, data directory copied, flat files exported and even config and binary log files backed-up. But did you…

View Post

Load columnar text file into MySQL table

Kedar
May 3, 2012

Ever come accoss a situation where you have to load a flat text file into MySQL with data provided in single column! Say, your data to be loaded in table…

View Post