# Recommended loadbalancer? **URL:** \ **Category:** Percona XtraDB Cluster 5.x\ **Tags:** community, mysql, percona\ **Created:** [June 17, 2023, 10:04am UTC](https://forums.percona.com/t/recommended-loadbalancer/22884 "2023-06-17T10:04:04Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Keon](https://avatars.discourse-cdn.com/v4/letter/k/f6c823/32.png) [@Keon](https://forums.percona.com/u/Keon)\ **Post date:** [June 17, 2023, 10:04am UTC](https://forums.percona.com/t/recommended-loadbalancer/22884/1 "2023-06-17T10:04:04Z")
(educational purposes) Hey comm, as my next question is - i’m using the xtraDB Cluster for high available databases for different applications. As when i connect the application to the (for example) node1 and node1 fails, how should it be high available? Sure - a loadbalancer! But whats the recommended loadbalancer and which algorithm? Round Robin? Least Connection? Others? And how much simultaneously connections should it support? (Cause i maybe would use a hetzner cloud loadbalancer). Thanks in advance. ---
**Author:** ![kedarpercona](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kedarpercona/32/809_2.png) [@kedarpercona](https://forums.percona.com/u/kedarpercona)\ **Post date:** [June 17, 2023, 12:10pm UTC](https://forums.percona.com/t/recommended-loadbalancer/22884/2 "2023-06-17T12:10:05Z")
Hello Keon, We have an excellent document for loadbalancing PXC. I encourage you to go through it and you should have your answers. > **[Percona XtraDB Cluster - Load balancing with ProxySQL](https://docs.percona.com/percona-xtradb-cluster/8.0/howtos/proxysql.html)** > > ProxySQL is a high-performance SQL proxy. ProxySQL runs as a daemon watched by > a monitoring process. The process monitors the daemon and restarts it in case > of a crash to minimize downtime. Thanks, K. ---
**Author:** ![Keon](https://avatars.discourse-cdn.com/v4/letter/k/f6c823/32.png) [@Keon](https://forums.percona.com/u/Keon)\ **Post date:** [June 18, 2023, 8:06am UTC](https://forums.percona.com/t/recommended-loadbalancer/22884/3 "2023-06-18T08:06:09Z")
Hey @kedarpercona, so on that documentation ProxySQL will be a SPOF and i just found older documentations from 2017 about ProxySQL HA with keepalived. Is there anything “newer” in connection with xtraDB Cluster where ProxySQL do not will be a SPOF? As its known from the “webhosting” sector, later i will have customers (fictitious) which just want to have a hostname, port, database, database-user and password to access their database with their application. Behind that hostname and port, it should be a HA system and not a SPOF within it. ---
**Author:** ![kedarpercona](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kedarpercona/32/809_2.png) [@kedarpercona](https://forums.percona.com/u/kedarpercona)\ **Post date:** [June 19, 2023, 3:50am UTC](https://forums.percona.com/t/recommended-loadbalancer/22884/4 "2023-06-19T03:50:26Z")
Hello @Keon, I believe you’re talking about [this article by Marco](https://www.percona.com/blog/setup-proxysql-for-high-availability-not-single-point-failure/). I’d also recommend reading the [ProxySQL Cluster](https://proxysql.com/documentation/proxysql-cluster/) from documentation page in addition to that. Finally, here are some more solutions consideration for you to keep in mind: - MySQL Failover for Asynchronous replication with Orchestrator, ProxySQL and Consul (PLive talk by Yunus) [![](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/c/c11feab9218dbbf7644d0915f929a85d60191ee5.jpeg "MySQL Failover for Asynchronous replication with Orchestrator, ProxySQL and Consul") ](https://www.youtube.com/watch?v=x9Emv50XOHI) - [Consul, ProxySQL and MySQL HA](https://www.percona.com/blog/consul-proxysql-mysql-ha/) - [MySQL high availability with ProxySQL, Consul and Orchestrator | Official Pythian®® Blog](https://blog.pythian.com/mysql-high-availability-with-proxysql-consul-and-orchestrator/) Thanks, K. ---
**Author:** ![Leonardo\_Figueroa](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/leonardo_figueroa/32/8187_2.png) [@Leonardo\_Figueroa](https://forums.percona.com/u/Leonardo_Figueroa)\ **Post date:** [July 30, 2023, 6:46pm UTC](https://forums.percona.com/t/recommended-loadbalancer/22884/5 "2023-07-30T18:46:50Z")
Hello @Keon You can also set up a load balancer behind a proxysql farm (or at least 2 proxysql nodes) to enable HA in the proxysql layer. Here’s an example on how it works in AWS [Load Balancing ProxySQL in AWS](https://www.percona.com/blog/load-balancing-proxysql-in-aws/) But there are very alike solutions for Azure and GCP. I’m referring to cloud as to me is a simpler solution than on-premises, however there are also other LB solutions to enable HA for proxysql