# ProxySQL2 and PXC Cluster

**URL:** <https://forums.percona.com/t/proxysql2-and-pxc-cluster/9742>\
**Category:** Percona XtraDB Cluster 8.x\
**Created:** [March 22, 2021, 1:10pm UTC](https://forums.percona.com/t/proxysql2-and-pxc-cluster/9742 "2021-03-22T13:10:06Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![staun](https://avatars.discourse-cdn.com/v4/letter/s/58f4c7/32.png) [@staun](https://forums.percona.com/u/staun)\
**Post date:** [March 22, 2021, 1:10pm UTC](https://forums.percona.com/t/proxysql2-and-pxc-cluster/9742/1 "2021-03-22T13:10:06Z")

</div>

I am trying to follow this documention : [Redirecting](https://www.percona.com/doc/percona-xtradb-cluster/LATEST/howtos/proxysql.html)

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?

---

<div class="post-metadata">

**Author:** ![jrivera](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jrivera/32/13_2.png) [@jrivera](https://forums.percona.com/u/jrivera)\
**Post date:** [July 7, 2021, 8:20am UTC](https://forums.percona.com/t/proxysql2-and-pxc-cluster/9742/2 "2021-07-07T08:20:33Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [July 7, 2021, 2:36pm UTC](https://forums.percona.com/t/proxysql2-and-pxc-cluster/9742/3 "2021-07-07T14:36:22Z")

</div>