HAProxy Community Edition is a free, open source reverse-proxy offering high availability, load balancing, and proxying for TCP and HTTP-based applications. It is presented as suited for very high traffic web sites.
N/A
ScaleArc
Score 6.0 out of 10
Mid-Size Companies (51-1,000 employees)
ScaleArc for MySQL (other versions available for SQL Server and Oracle), developed by DevFactory solution and acquired by Ignite Technologies in January 2018, is database load balancing software that promises to increase uptime, performance, and
scale out for applications leveraging the MySQL database. The software drops in between applications and databases and directs queries into the database on behalf of the app - it looks to the app as if it were the database, and it looks to the…
It prevents a single server failure from being a downtime event by adding redundancy to every layer of your architecture. A load balancer facilitates redundancy for the backend layer (web/app servers), but for a true high availability setup, you need to have redundant load balancers as well. So it is well suited for all production related servers and less suited for individual servers that do not require redundancy.
Well suited for automated failover between Master and Slave Works well with Galera cluster technology Works very well for database load balancing Less suited for CPU and memory related optimization for ScaleArc cluster Prerequisite to run ScaleArc on standalone machine should be avoidable so that customer is not forced to provide dedicated hardware for this software
ScaleArc does provide high availability and during failover it takes care of the master slave lag as well seamless switch between master and slave.
ScaleArc also helps to reduce application traffic on MySQL database server by filtering frequently used commands like AUTOCOMMIT.
ScaleArc provides a single interface for all application and database user management. This helps in strengthening security aspects of user management.
My understanding is a lack of support for UDP traffic
One mistake in the haproxy.cfg prevents the entire thing from starting rather than only affecting the part of the config file that may have a typo of some other syntax problem.
The fact that the analytics is included in the product; it really is hard to recommend this. However; I would recommend the analytics be a little more easier to use and more intuitive for drilling down to the source of the problem.
It is very easy to use. I was able to find a lot of documents for it on the internet. Very good community support. There are lots of examples available to try. We mostly use a command-line user interface to interact with it. The CLI is also super easy to use and very easy to interact with
We haven't used customer support. We mostly used the community version. We build a multi-node HAProxy cluster with HA to the proxy itself using opensource plugins available. With the support available on the internet and the documents available we don't need to use much customer support.
We chose HA Proxy because it is cheaper than a hardware balancer, it is an open-source solution with a large community behind it and with constant updates. It also allows custom scripts according to needs.HA Proxy is a solution used in many internet sites like GitHub, Reddit, Twitter, and Tuenti.
Outside of Microsoft SQL Server 2016 introducing the ability to route reads across the entire availability group; there is no other solution on the market that even comes close, and that's even if they exist.
Significantly lower investment vs competitors. In the case of F5s we have Virtual Editions so we're paying for the hardware to run it on top of the several thousand dollar licenses that are required for each pair and we currently have a pair of F5s per client so there's a huge potential for cost savings there.
Requires our network engineers to learn a new skill or our Systems engineers to take on the responsibility of managing the load balancers. It's not a huge difference either way, but it does impact the way we have done business in the past.
