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…
ProxySLQ allows many simultaneous connections and allows the cache of queries in memory but it does not have high availability or scalability natively, only through external tools. HAProxy is not able to perform load balancing in an optimal way.
If you have a cluster of nodes with MariaDB MaxScale and you want all the nodes of the cluster to have a similar load and not to be be penalized for queries or writes to the database, you can mount the MaxScale product in front of the MariaDB cluster. MaxScale will balance the requests based on what is being sent to each node to have an equitable load and will cache the queries that it sends to each one. This optimizes the response time to database queries and spreads the load out among all nodes in a similar way.
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.
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.
MariaDB MaxScale is a powerful tool and easy to use. It has helped us a lot to improve the performance of our database queries. It implements a security layer that acts as a firewall for the databases, masks the data, or limits the results of the queries. It also integrates easily with Kafka.
We have launched several inquiries to MariaDB MaxScale support, and they have always responded very quickly. They also want to hold frequent meetings with the client to get their opinion understand how they can help. I see a very human support that is concerned about the customer.
ProxySLQ allows many simultaneous connections and allows the cache of queries in memory but it does not have high availability or scalability natively, only through external tools. HAProxy is not able to perform load balancing in an optimal way.
Instead, MariaDB MaxScale allows high availability, scalability, and data replication to external systems such as Kafka. In addition, MaxScale has a monitor that allows you to see the status of the set of databases.
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.
Provided a single management interface for a complete MySQL farm in our company. It has helped particularly in managing high availability of MySQL databases thus overall improving the business website reliability. This in turn further enhances the confidence of our customers.