MariaDB slave restore using GTID & xtrabackup bug
Restoring MariaDB (MySQL) slave using Xtrabackup & GTID.
xtrabackup_51: not found & no ‘mysqld’ group in MySQL options
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…
Why we need a tester / QA – Software testing
“Why Testing”, “Importance of Software testing”, “Scope of testing”, “How to become a tester”, “Training for software quality assurance / software testing” … Stop there… Above are the topics well…
MySQL variable innodb_flush_method – summarized
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…
Is your backup complete? – backup MySQL users privileges / grants – pt-show-grants
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…
MySQL function returns dates of specified day & between date range
This mysql stored function will return you all the dates between given dates having specified day. In short if you say: give me all Sundays in this month. I have…