Scale your business with ScaleArc
Rating: 10 out of 10
October 05, 2017
MA
Vetted Review
Verified User
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 :)
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.
- 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.