Related

Product Now Available: Managed MySQL Databases Product
Install MySQL on New Droplet Question Question
How can I solve error "SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)" Question Question

Question

SHUNNED status in proxySQL connect to MySQL Cluster

Posted January 16, 2020 1.2k views
MySQL

I have installed MySQL Cluster that has 6 MySQL Nodes. Client access MySQL Node through ProxySQL. But 2 of 6 MySQL Node in MySQL Cluster has status SHUNNED not ONLINE. I had checked connection from ProxySQL to MySQL Node use “ping” and the result shows the connection is OK. How to fix this status?

Add a comment
suhuachai69
By:
suhuachai69
Add a comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
1 answer
bobbyiliev January 17, 2020

Hello,

That is an interesting question, after some investigation, I think the fact that a server is reported as SHUNNED it just means that during the last check was SHUNNED and no traffic has hit that node yet.

As far as I can see there is an open issue for implementing a mechanism to automatically unshun nodes even if there is no traffic hitting the specific node:

https://github.com/sysown/proxysql/issues/971

Regards,
Bobby

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help