Skip to main content
TrustRadius
ScaleArc

ScaleArc

Overview

What is ScaleArc?

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…

Read more

Learn from top reviewers

Return to navigation

Product Demos

ScaleArc 3-Minute Demo

YouTube

ScaleArc 3-Minute Demo

YouTube
Return to navigation

Product Details

What is ScaleArc?

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 database as if it were the app.

The software lets organizations leverage modern, scaled out databases with no application changes. It automatically supports scale out, performing read/write split dynamically, so users don't have to code read-intent strings into the application.

It avoids app downtime from database outages, both planned and unplanned. During a database failover, ScaleArc software queues inbound queries, waiting for the secondary to take over as the new primary, and then drains the queue in a FIFO manner, so apps see delay but not errors. Users can invoke the same functionality to force a switchover, enabling them to achieve zero downtime maintenance.

App-transparent caching speeds performance with no app changes, and the software also supports connection management for greater database server efficiency.

ScaleArc Features

  • Supported: app-transparent failover
  • Supported: switchover for zero-downtime maintenance
  • Supported: automatic read/write split
  • Supported: dynamic load balancing
  • Supported: query caching
  • Supported: real-time and historical analytics
  • Supported: query firewall

ScaleArc Screenshots

Screenshot of Rich analytics simplify database troubleshooting, provide a cluster-wide view of stats, and highlight queries that are good candidates for caching.Screenshot of ScaleArc provides rich details about queries, aggregated to make patterns obvious but available for drill down as well.Screenshot of The ScaleArc software supports automatic or manual failover, enabling zero downtime maintenance and avoiding app errors during database failover.

ScaleArc Technical Details

Deployment TypesOn-premise
Operating SystemsLinux
Mobile ApplicationNo

ScaleArc Customer Size Distribution

Consumers0%
Small Businesses (1-50 employees)0%
Mid-Size Companies (51-500 employees)60%
Enterprises (more than 500 employees)40%
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews From Top Reviewers

(1-2 of 2)

Scale your business with ScaleArc

Rating: 10 out of 10
October 05, 2017
MA
Vetted Review
Verified User
ScaleArc
2 years of experience
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 :)
  • 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.
It is best suited for SaaS applications where uptime and availability are a priority to the business.
  • Our ROI is provided simply by keeping the customer up and running; a happy customer is good for business.
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.

Why we chose ScaleArc for MySQL

Rating: 7 out of 10
December 29, 2016
BS
Vetted Review
Verified User
ScaleArc
2 years of experience
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.
  • 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.
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
  • 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.
Return to navigation