MariaDB slave restore using GTID & xtrabackup bug
Kedar
Restoring MariaDB (MySQL) slave using Xtrabackup & GTID.
Browsing Category
MySQL
113 posts
Articles related to MySQL, Percona Server, MariaDB
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…
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…
How To Generate Random test Data In MySQL
Are you tired of manually generating test data for your MySQL tables? If you’re looking for random data generator, look no further! Introducing the MySQL Random Data Generator, a powerful…