proxysql-admin script will configure PXC cluster based on wsrep_incoming_addresses status variable. I think should configure PXC with public IPs. Even if you manually update mysql_server table with public IPs, proxysql-monitoring script will update the IPs from wsrep_incoming_addresses status variable.

Thanks
Ramesh

Thanks.

We have updated blog with script usage information.

CLUSTER_USERNAME variable is used for connecting to the Percona XtraDB Cluster node for ProxySQL configuration. It is important that this user is present in the Cluster and that the super user account is being used to setup the configuration.

CLUSTER_APP_USERNAME is a ProxySQL application username for connecting to the Percona XtraDB Cluster node. proxysql-admin tool will create this user in Percona XtraDB Cluster. If this user is already present proxysql-admin tool will skip the user creation.

#proxysql-admin credentials
export PROXYSQL_USERNAME=”admin”
export PROXYSQL_PASSWORD=”admin”
export PROXYSQL_HOSTNAME=”localhost”
export PROXYSQL_PORT=”6032″
export CLUSTER_USERNAME=”admin”
export CLUSTER_PASSWORD=”admin”
export CLUSTER_HOSTNAME=”localhost”
export CLUSTER_PORT=”3306″
export MONITOR_USERNAME=”monitor”
export MONITOR_PASSWORD=”monit0r”
export CLUSTER_APP_USERNAME=”proxysql_user”
export CLUSTER_APP_PASSWORD=”passw0rd”
export WRITE_HOSTGROUP_ID=”10″
export READ_HOSTGROUP_ID=”11″
export MODE=”singlewrite”

I’ve been having some difficulty connecting to my Percona cluster because it’s not clear the different between the “CLUSTER_APP” account and “CLUSTER_USERNAME”. I see this error in the log file:

2017-02-02T20:17:21.624590Z 50765 [Note] Aborted connection 50765 to db: ‘unconnected’ user: ‘monitor’ host: ‘192.168.1.201’ (Got an error reading communication packets)

Any help or a push in the right direction would be a big help.

thanks!

We have updated the blog.

Thank you very much for the suggestion.