Cannot connect to MySQL server on ‘localhost’: Cacti Error
Kedar
FATAL: Cannot connect to MySQL server on ‘localhost’: Cacti Error – Solution to the issue while setting-up.
Browsing Tag
MySQL
67 posts
MySQL:The user specified as a definer does not exist (error 1449)-Solutions
Explaining and providing solutions of MySQL error 1449: The user specified as a definer does not exist using SQL SECURITY INVOKER and DEFINER.
Restore / point in time recovery using binary logs MySQL
In this post I will share a recovery scenario of a MySQL database restore from the binary logs. This post is also a good example of how we can achieve…
Debugging Percona Xtradb (Galera) Cluster node startup / SST errors
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.
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…
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…
Download MySQL’s Automatic Random Test Data Generator
At times you’ll find yourself responsible for generating test data for newly created tables for testing or sampling purpose. There are tools that will generate random data for you but…
Recent Comments