ProxySQL VS Haproxy

ProxySQL

ProxySQL: high-performance, GPL licensed MySQL proxy. It supports hundreds of thousands of concurrent connections and can be multiplexed to hundreds of servers.

Haproxy

Reliable, High Performance TCP/HTTP Load Balancer

Landing page //
2023-05-23

Landing page //
2023-03-19

#ProxySQL Use Case Scenarios - #ProxySQL #Database Tutorial - René Cannaò - #Percona Live 2017

Haproxy videos

+ Add

HAProxy Crash Course (TLS 1.3, HTTPS, HTTP/2 and more)

Category Popularity

0-100% (relative to ProxySQL and Haproxy)

Haproxy

MySQL Tools

100 100%

MySQL Tools

0% 0

Web Servers

0 0%

Web Servers

100% 100

Databases

100 100%

Databases

0% 0

Web And Application Servers

0 0%

Web And Application Servers

100% 100

User comments

Share your experience with using ProxySQL and Haproxy. For example, how are they different and which one is better?

Reviews

These are some of the external sources and on-site user reviews we've used to compare ProxySQL and Haproxy

ProxySQL Reviews

We have no reviews of ProxySQL yet.
Be the first one to post

Haproxy Reviews

10 Awesome Open Source Load Balancers

HAProxy is an L4 and L7 load balancer supporting TCP and UDP traffic. It’s a well-established, open source solution used by companies such as Airbnb and GitHub. HAProxy is also a very capable L7 load balancer, supporting HTTP/2 and gRPC backends. Thanks to its long history, large community, and reliable nature, HAProxy has become the de facto open source load balancer—it...

Source: www.containiq.com

10 Open Source Load Balancer for HA and Improved Performance

One of the popular ones out there in the market is to provide high availability, proxy, TCP/HTTP load-balancing. HAProxy is used by some of the reputed brands in the world, like below.

Source: geekflare.com

Top 5 Open-Source Load Balancers 2021

HAProxy provides many distinct features such as it processes an enormous number of tasks in a millisecond, offers minimal cost for context switch and memory usage, ability to instantly detect a threat or event on tens of thousands of connections, efficient use of the CPU cycles, and memory bandwidth, optimized timer queue, optimized HTTP header analysis, GZip Compression,...

Source: linuxways.net

The 5 Best Open Source Load Balancers

HAProxy is another common name in the web ecosystem. HAProxy offers reverse proxying and load balancing of TCP and HTTP traffic. When you choose HAProxy, you’re choosing a high-performance, well-established solution.

Source: logz.io

Social recommendations and mentions

Based on our record, ProxySQL should be more popular than Haproxy. It has been mentiond 10 times since March 2021. We are tracking product recommendations and mentions on various public social media platforms and blogs. They can help you identify which product is more popular and what people think of it.

ProxySQL mentions (10)

Save Cost on RDS Data Transfer - Internet - Out
Another option could be ProxySQL, where you can cache queries on the ProxySQL server. Source: about 1 year ago
Is replication between v5.1 and v8 possible?
Also, if you're not using it yet, I can recommend looking at ProxySQL to do your read-write/read-only failover controls. Source: over 1 year ago
SSL Termination for SQL
What are the recommendations here? I took a look into ProxySQL and it looks like since v2, it can do frontend and backend SSL connections. I have it locally working on a docker setup. Source: over 1 year ago
Business complexity with performance
DB: Split you write-read operations. You may scale read as needed. Write operations can be slow if you have too many indices, so make sure to use only the ones you really need. Your DBMS may have some configuration to optimise, for example in MySQL if you do NOT need ACID compliance you can set innodb_flush_log_at_trx_commit = 2 to achieve better write speed. For MySQL you should also look into https://proxysql.com/. Source: over 1 year ago
Advanced caching mechanisms using distributed locks and async pub/sub systems.
A Layer-7 Database Load Balancer is optional here. An L7-DBLB can be used for various use cases (eg: ProxySQL). One or more database instances handle queries from the web server. A Client-side DB query/connection load balancing can also be used instead of an L7-DBLB according to the use case of the application. - Source: dev.to / over 1 year ago

Haproxy mentions (2)

HA Proxy For MySQL Master – Slave
Root@haproxy01:~# haproxy -v HA-Proxy version 2.0.13-2ubuntu0.3 2021/08/27 - https://haproxy.org/ How to Install it? You simply use yum or apt commands to install it Sudo apt install -y haproxy. - Source: dev.to / almost 2 years ago
cannot get haproxy / mjpeg streamer to play nice together
HA-Proxy version 2.2.9-2+deb11u3 2022/03/10 - https://haproxy.org/ maxconn 4096 user haproxy group haproxy daemon log 127.0.0.1 local0 debug Defaults log global mode http option httplog option dontlognull retries 3 option redispatch option http-server-close option forwardfor maxconn 2000 ... Source: almost 2 years ago