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.
The post Debugging Percona Xtradb (Galera) Cluster node startup / SST errors first appeared on Change Is Inevitable.
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…
The post xtrabackup_51: not found & no ‘mysqld’ group in MySQL options first appeared on Change Is Inevitable.
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…
The post MySQL variable innodb_flush_method – summarized first appeared on Change Is Inevitable.
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…
The post Is your backup complete? – backup MySQL users privileges / grants – pt-show-grants first appeared on Change Is Inevitable.
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…
The post Load columnar text file into MySQL table first appeared on Change Is Inevitable.
Schema alteration is a big headache especially when it has already reached to production and things get worse when the relations are involved.Below is a short example for altering tables…
The post MySQL – Alter table-change datatype of column with foreign key first appeared on Change Is Inevitable.
MySQL Stored Routines (functions and procedures) are not only used for improving performance but also they’re handy when it comes to enhancing security and restricting user access. This post briefs…
The post Access Control in MySQL Stored Routines: DEFINER, INVOKER & SQL SECURITY first appeared on Change Is Inevitable.
Do you ever need to transfer databases between servers? Different OSes? Two common ways of data migration:1. Create mysqldump and load it.2. File transfer using SCP. MySQL Case Sensitivity and…
The post Escaping “Lesson Learned” dealing with MySQL Databases & Case Sensitivity first appeared on Change Is Inevitable.
Did you ever need to run LOAD DATA INFILE in a procedure? May be to automate or dynamically perform the large data file load to the MySQL database. In this…
The post MySQL Load Data Infile with Stored Procedure first appeared on Change Is Inevitable.
Nagios is a powerful monitoring system and here we will learn how to monitor MySQL through Nagios. We will be installing Nagios, required plugins and configuring it to monitor MySQL…
The post 10 Steps: MySQL Monitoring through Nagios: Install & Configure first appeared on Change Is Inevitable.