Fixing inconsistency on MySQL Slave of Galera Cluster
Kedar
This blog post explores the syncing options for an inconsistent MySQL slave of Galera cluster node using pt-table-sync
Browsing Tag
MySQL
81 posts
How to Add Remote MySQL Server to Nagios Monitoring
We already have seen two articles for setting up MySQL Monitoring with Nagios and Percona Monitoring Tools for Nagios. Those posts covers configuration of nagios on single instance. Though following…
UMASK & UMASK_DIR – changing default MySQL file dir permissions
UMASK and UMASK_DIR are amongst few MySQL Environment variables which defines directory and file creation modes (file permissions). In this post we will understand using UMASK & UMASK_DIR for changing the database directory and file permissions from it’s default to what we need.
Cannot connect to MySQL server on ‘localhost’: Cacti Error
FATAL: Cannot connect to MySQL server on ‘localhost’: Cacti Error – Solution to the issue while setting-up.
How to fix definer does not exist error 1449 MySQL
Explaining and providing solutions of MySQL error 1449: The user specified as a definer does not exist using SQL SECURITY INVOKER and DEFINER.
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.
2 responses to “Debugging Percona Xtradb (Galera) Cluster node startup / SST errors”
Another important one – in case the server has multiple IPs and wsrep_sst_receive_address is set to AUTO it may use the wrong one. For instance in a test configuration with Vagrant / OVM you may have two IP address, one internal on the 10.x.x.x range and other on 192.x.x.x and PXC may use the 10.x.x.x rather than the desired 192.x.x.x address.
In this case SST will fail with a message like:
150921 14:09:40 [ERROR] WSREP: gcs/src/gcs_group.cpp:long int gcs_group_handle_join_msg(gcs_group_t*, const gcs_recv_msg_t*)():717: Will never receive state. Need to abort.
Thanks for the update Nik.