Comment 11 for bug 1326829

Revision history for this message
Sergii Golovatiuk (sgolovatiuk) wrote :

This test should be invalid right now. If block port 3307is blocked galera still gets updates from the neighbors. Even in this case unix socket is responsible and many services will be able to get access to mysql (clustercheck script is a good sample).
In order to perform a proper test
1. Disable galera port in INPUT/OUTPUT chain in filter table
iptables -I OUTPUT 1 -p tcp --dport 4567 -j DROP
iptables -I INPUT 1 -p tcp --dport 4567 -j DROP
2. Check if Galera/MySQL is in sync
/usr/local/bin/clustercheck or telnet localhost 49000
3. Try to create a new database in mysql client. Just run mysql client without any parameters in this case it will connect to local mysql server
4. Try to connect to HAProxy interface
mysql -h192.168.0.1 -P3306 -uUSER -pPASSWORD
5. Unblock port 4567.
See if if created database appeared on local mysql server. Try to delete that database.