TrustRadius: an HG Insights company

ScaleArc

Score6 out of 10

5 Reviews and Ratings

Reviews

2 Reviews

Scale your business with ScaleArc

Rating: 10 out of 10
Incentivized

Use Cases and Deployment Scope

We are a 24/7 SaaS company that provides a CRM to automotive companies across the globe and our need to be highly available is mission critical. As in most SaaS platforms there is always a single point of failure and that was our design on how we direct customers to there corresponding servers; this is where we need to be able to provide the highest point of availability. Prior to implementing ScaleArc, we had a very unstable environment with quite a bit of global customer impact and with the introduction (Version 1) of Availability Groups in SQL Server 2012; there was a lot of instability in the number of failovers and bottlenecks.

Since implementing ScaleArc over a year ago; we have instantly brought our availability to 99.9999%. The ability to route reads to the secondary replicas without any application changes was a huge advantage in getting ScaleArc deployed rapidly. The strength in the product is the ability to cache connections during a failover (not inflight transactions) meaning the customer would never notice there was a problem whether planned or unplanned. We've already had occasions where we have had experienced failovers and not one customer call came in :) This opened the door for daytime maintenance if necessary which is a godsend if you are DBA; less nights having to be up late the better

Simply put; ScaleArc makes me look good :)

Pros

  • Caching connections to ensure a seamless failover.
  • Automatically route reads to the secondary replicas without application changes.
  • Ability to cache queries for better end-user experiences.
  • Real-time analytics to determine where your bottlenecks are and any queries that could be candidates for caching.
  • Ability to firewall (block) an incoming query to avoid further performance issues and vulnerabilities from attacks such as SQL injections.

Cons

  • 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.

Likelihood to Recommend

It is best suited for SaaS applications where uptime and availability are a priority to the business.

Why we chose ScaleArc for MySQL

Rating: 7 out of 10
Incentivized

Use Cases and Deployment Scope

We are using ScaleArc for MySQL to achieve a high availability solution across multiple clusters of MySQL databases. ScaleArc has helped us in achieving high availability by providing us a seamless interface for auto failover as well as a script based customized solution. While failing over to a slave database, it does take care of syncing the data from a previous master through its binlogs.

Pros

  • 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.

Cons

  • Checkboxes for selection of multiple users to enhance easier management.
  • There should be a rule within the ScaleArc cluster to send traffic to particular slave replica for re-routing of read queries.
  • Logging generation is excessive and causes pressure on disk resources. This should be further improved to log information to not miss the necessary but also not include the unnecessary.

Likelihood to Recommend

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