ProxySQL2 and PXC Cluster

I am trying to follow this documention : Load balancing with ProxySQL

But when it comes to the part : Test with SysBench, it all falls apart. - The script mentioned is not in the path, I found it elsewhere though, but the test gives me time out and it looks like the proxy does not have a working connection to my hosts.

When I try to simulate a failover and stop the mysql-service and expected the ProxySQL to report this, it doesn’t update with what I expected in the mysql_servers to OFFLINE_SOFT, in continue to report ONLINE

mysql> SELECT hostgroup_id,hostname,port,status FROM mysql_servers;
±-------------±-----------±-----±-------+
| hostgroup_id | hostname | port | status |
±-------------±-----------±-----±-------+
| 10 | 10.20.1.20 | 3306 | ONLINE |
| 10 | 10.20.1.21 | 3306 | ONLINE |
| 10 | 10.1.44.20 | 3306 | ONLINE |
±-------------±-----------±-----±-------+
3 rows in set (0.00 sec)

I have been looking at different configuration guides on the Percona site/ blog, all a bit different. But for some reason it looks like I cannot connect to the hosts (even though all users are created and I can get some kind of data.

mysql> SELECT * FROM monitor.mysql_server_connect_log ORDER BY time_start_us DESC LIMIT 6;
±-----------±-----±-----------------±------------------------±--------------+
| hostname | port | time_start_us | connect_success_time_us | connect_error |
±-----------±-----±-----------------±------------------------±--------------+
| 10.20.1.20 | 3306 | 1616418445572680 | 1747 | NULL |
| 10.20.1.20 | 3306 | 1616418443572622 | 2461 | NULL |
| 10.20.1.20 | 3306 | 1616418441572066 | 1869 | NULL |
| 10.20.1.20 | 3306 | 1616418439571980 | 2061 | NULL |
| 10.20.1.20 | 3306 | 1616418437571894 | 1699 | NULL |
| 10.20.1.20 | 3306 | 1616418435571910 | 1957 | NULL |
±-----------±-----±-----------------±------------------------±--------------+

Any ideas what to do now… I have installed percona-release_1.0-26.generic_all.deb on Ubuntu 20.04

The guides I have found so far are for PXC 8.0, so is there a special one for 1.0.26 version?

1 Like

Hi @staun sorry for the delayed response. Do you still need help here or were you able to resolve it?