Failed connections to remote proxysql host

MySQL & MariaDB Percona XtraDB Cluster 8.x
1

I have Percona Proxysql and Percona Cluster configured and working. My issue is that I cannot connect a remote application to the proxysql port that should reconcile to the cluster. If I am on the proxysql host it works fine.

This is run from the proxysql host iad-app02
i.e. mysql --user=proxysql_user -p --port=6033 --host=iad-app02 -Works ok.

If I run the same command from a remote application host, it fails as if it was trying to open Mysql on iad-app02.

[root@iad-app01 ~]# mysql --user=proxysql_user -p --port=6033 --host=50.116.41.55
Enter password:
ERROR 2003 (HY000): Can’t connect to MySQL server on ‘50.116.41.55:6033’ (113)
[root@iad-app01 ~]#

1 Like
2

Hi, I’d start by checking if you can reach port 6033 from iad-app01. Also check in proxysql config if you are binding to localhost only.

1 Like